Hello!
Welcome To Microsoft Excel 2016
Course Content
Projects
Status
3
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
4
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
5
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
6
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
7
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
8
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