Hello!
Welcome To Microsoft Excel 2016
Course Content
Projects Status
2
Project 2 - TTSC Quarterly Expenses- 2.01 - Sorting and Data Arrangement
- 2.02 - AutoSum and Average Functions
- 2.03 - Page Setup, Orientation, Gridlines, and Headings, Margins
- 2.04 - Inserting/Deleting 101, Symbols
- 2.05 - Width and Height 101, Cell Styles
- 2.06 - Insert and Remove Hyperlinks
- 2.07 - Quick Access Toolbar, Custom Views, Zoom Tools
- 2.08 - Rename Worksheets, Change Worksheets Tabs, Move/Copy Worksheets
- Enrichment Activity - Projects 1-2
- 2.01 - Sorting and Data Arrangement
- 2.02 - AutoSum and Average Functions
- 2.03 - Page Setup, Orientation, Gridlines, and Headings, Margins
- 2.04 - Inserting/Deleting 101, Symbols
- 2.05 - Width and Height 101, Cell Styles
- 2.06 - Insert and Remove Hyperlinks
- 2.07 - Quick Access Toolbar, Custom Views, Zoom Tools
- 2.08 - Rename Worksheets, Change Worksheets Tabs, Move/Copy Worksheets
- Enrichment Activity - Projects 1-2
3
Project 3 - TTSC City Comparisons Worksheet- 3.01 - Cell Alignment, Merge, and Cell Styles, Format Painter
- 3.02 - Graphics 101
- 3.03 - Cell Borders, Text Boxes, Grouping
- 3.04 - Hide/Unhide Data and Worksheets, Remove Background and Crop Graphics
- 3.05 - Average and Count Functions, Currency/Accounting Format
- 3.06 - Alternative Text Added to Objects and Object Properties, Page Setup
- 3.07 - Inspect Documents for Hidden Data, Check for Accessibility/Compatibility, Backstage, Autosave, Document Properties
- 3.01 - Cell Alignment, Merge, and Cell Styles, Format Painter
- 3.02 - Graphics 101
- 3.03 - Cell Borders, Text Boxes, Grouping
- 3.04 - Hide/Unhide Data and Worksheets, Remove Background and Crop Graphics
- 3.05 - Average and Count Functions, Currency/Accounting Format
- 3.06 - Alternative Text Added to Objects and Object Properties, Page Setup
- 3.07 - Inspect Documents for Hidden Data, Check for Accessibility/Compatibility, Backstage, Autosave, Document Properties
4
Project 4 - TTSC Fundraiser- 4.01 - Comments and Worksheet Navigation/Find
- 4.02 - Themes and Group/Ungroup
- 4.03 - Conditional Formatting
- 4.04 - Search for Conditional Formatting, Remove Duplicates
- 4.05 - Freeze Panes and Split Screen
- 4.06 - MAX/MIN Functions, AutoSum Options, Calculation Options
- 4.07 - Advanced Sorting and Filtering, Name Ranges
- 4.08 - COUNTIF Function
- 4.09 - Set Print Area and Printing 101
- 4.01 - Comments and Worksheet Navigation/Find
- 4.02 - Themes and Group/Ungroup
- 4.03 - Conditional Formatting
- 4.04 - Search for Conditional Formatting, Remove Duplicates
- 4.05 - Freeze Panes and Split Screen
- 4.06 - MAX/MIN Functions, AutoSum Options, Calculation Options
- 4.07 - Advanced Sorting and Filtering, Name Ranges
- 4.08 - COUNTIF Function
- 4.09 - Set Print Area and Printing 101
5
Project 5 - TTSC Study Abroad Expenses- 5.01 - Absolute Reference Formula
- 5.02 - Cell Reference Formula and Themes
- 5.03 - Text Boxes and Shapes, Cut/Paste
- 5.04 - Format Text as Tables, Table Options/Styles, Table Filtering, and Table Converting
- 5.05 - Resizing Tables, GoTo Table, and Displaying Formulas
- 5.06 - Sparkline 101
- 5.07 - Header and Footer 101
- Enrichment Activity - Projects 1-5
- 5.01 - Absolute Reference Formula
- 5.02 - Cell Reference Formula and Themes
- 5.03 - Text Boxes and Shapes, Cut/Paste
- 5.04 - Format Text as Tables, Table Options/Styles, Table Filtering, and Table Converting
- 5.05 - Resizing Tables, GoTo Table, and Displaying Formulas
- 5.06 - Sparkline 101
- 5.07 - Header and Footer 101
- Enrichment Activity - Projects 1-5
6
Project 6 - HMC Expenses Chart- 6.01 - Chart 101
- 6.02 - Chart Layout, Styles, Design, Color
- 6.03 - Editing Charts, Changing Chart Types, and Adding Chart Elements
- 6.04 - Edit Chart Elements
- 6.05 - Editing Chart Data/Selection, Moving Charts, Add Alt. Text to Objects
- 6.06 - Naming Ranges and Using them in Formulas
- 6.07 - Sparklines, Printing Options
- 6.08 - File Sharing/Exporting in Various Formats
- 6.01 - Chart 101
- 6.02 - Chart Layout, Styles, Design, Color
- 6.03 - Editing Charts, Changing Chart Types, and Adding Chart Elements
- 6.04 - Edit Chart Elements
- 6.05 - Editing Chart Data/Selection, Moving Charts, Add Alt. Text to Objects
- 6.06 - Naming Ranges and Using them in Formulas
- 6.07 - Sparklines, Printing Options
- 6.08 - File Sharing/Exporting in Various Formats
7
Project 7 - TTSC Social Media Platforms- 7.01 - Import Data from External Files
- 7.02 - Insert/Copy/Move Worksheets
- 7.03 - Format Numbers, Number Group
- 7.04 - Cut/Copy/Paste/Paste Special
- 7.05 - Fill Cells Automatically
- 7.06 - Insert Total Rows, Use AVERAGE/MAX/MIN Functions
- 7.07 - Use Quick Analysis Options
- 7.08 - Protect Data, Worksheets, and Workbooks
- 7.01 - Import Data from External Files
- 7.02 - Insert/Copy/Move Worksheets
- 7.03 - Format Numbers, Number Group
- 7.04 - Cut/Copy/Paste/Paste Special
- 7.05 - Fill Cells Automatically
- 7.06 - Insert Total Rows, Use AVERAGE/MAX/MIN Functions
- 7.07 - Use Quick Analysis Options
- 7.08 - Protect Data, Worksheets, and Workbooks