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
QuizzesStatus