Hello!
Welcome To Microsoft Excel 2016
Course Content
Projects
Status
2
Project 1 – TTSC Club Expenses Worksheet
-
Project 1 “TTSC Club Expenses Worksheet” Pre-Assessment
-
1.01 – Introduction and Welcome to the Traveling Scholars Club
-
1.02 – Excel 101
-
1.03 – Font, Color, and Fill
-
1.04 – Text Alignment, Merge
-
1.05 – Formula 101
-
1.06 – Saving Options, File Formats, and Folders
-
Project 1 “TTSC Club Expenses Worksheet” Assessment
- Project 1 “TTSC Club Expenses Worksheet” Pre-Assessment
- 1.01 – Introduction and Welcome to the Traveling Scholars Club
- 1.02 – Excel 101
- 1.03 – Font, Color, and Fill
- 1.04 – Text Alignment, Merge
- 1.05 – Formula 101
- 1.06 – Saving Options, File Formats, and Folders
- Project 1 “TTSC Club Expenses Worksheet” Assessment
3
Project 2 – TTSC Quarterly Expenses
-
Project 2 “TTSC Quarterly Expenses” Pre-Assessment
-
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
-
Project 2 “TTSC Quarterly Expenses” Assessment
- Project 2 “TTSC Quarterly Expenses” Pre-Assessment
- 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
- Project 2 “TTSC Quarterly Expenses” Assessment
4
Project 3 – TTSC City Comparisons Worksheet
-
Project 3 “TTSC City Comparisons Worksheet” Pre-Assessment
-
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
-
Project 3 “TTSC City Comparisons Worksheet” Assessment
- Project 3 “TTSC City Comparisons Worksheet” Pre-Assessment
- 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
- Project 3 “TTSC City Comparisons Worksheet” Assessment
5
Project 4 – TTSC Fundraiser
-
Project 4 “TTSC Fundraiser” Pre-Assessment
-
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
-
Project 4 “TTSC Fundraiser” Assessment
- Project 4 “TTSC Fundraiser” Pre-Assessment
- 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
- Project 4 “TTSC Fundraiser” Assessment
6
Project 5 – TTSC Study Abroad Expenses
-
Project 5 “TTSC Study Abroad Expenses” Pre-Assessment
-
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
-
Project 5 “TTSC Study Abroad Expenses” Assessment
- Project 5 “TTSC Study Abroad Expenses” Pre-Assessment
- 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
- Project 5 “TTSC Study Abroad Expenses” Assessment
7
Project 6 – HMC Expenses Chart
-
Project 6 “HMC Expenses Chart” Pre-Assessment
-
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
-
Project 6 “HMC Expenses Chart” Assessment
- Project 6 “HMC Expenses Chart” Pre-Assessment
- 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
- Project 6 “HMC Expenses Chart” Assessment
8
Project 7 – TTSC Social Media Platforms
-
Project 7 “TTSC Social Media Platforms” Pre-Assessment
-
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
-
Project 7 “TTSC Social Media Platforms” Assessment
- Project 7 “TTSC Social Media Platforms” Pre-Assessment
- 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
- Project 7 “TTSC Social Media Platforms” Assessment
9
Project 8 – TTSC Member Passwords and ID Codes
-
Project 8 “TTSC Member Passwords and ID Codes” Pre-Assessment
-
8.01 – Insert SmartArt Graphics
-
8.02 – CONCATENATE Function
-
8.03 – LOWER, UPPER, AND PROPER Functions, Zoom to Selection
-
8.04 – LEFT, RIGHT, AND MID Functions
-
8.05 – IF Logic Function
-
8.06 – Formula Bar, Grids, Protect Worksheets
-
8.07 – Bonus Challenge on IF Functions
-
Project 8 “TTSC Member Passwords and ID Codes” Assessment
- Project 8 “TTSC Member Passwords and ID Codes” Pre-Assessment
- 8.01 – Insert SmartArt Graphics
- 8.02 – CONCATENATE Function
- 8.03 – LOWER, UPPER, AND PROPER Functions, Zoom to Selection
- 8.04 – LEFT, RIGHT, AND MID Functions
- 8.05 – IF Logic Function
- 8.06 – Formula Bar, Grids, Protect Worksheets
- 8.07 – Bonus Challenge on IF Functions
- Project 8 “TTSC Member Passwords and ID Codes” Assessment
11
Project 10 – TTSC Cruise Ship Data
-
Project 10 “TTSC Cruise Ship Data” Pre-Assessment
-
10.01 – Spell Check, Flash Fill
-
10.02 – Cell Borders, Text to Columns
-
10.03 – SUMIF, AVERAGEIF Function
-
10.04 – Name Manager
-
10.05 – Outline Data, Add Subtotals, Data Validation Settings
-
10.06 – COUNTIF Function
-
Project 10 “TTSC Cruise Ship Data” Assessment
- Project 10 “TTSC Cruise Ship Data” Pre-Assessment
- 10.01 – Spell Check, Flash Fill
- 10.02 – Cell Borders, Text to Columns
- 10.03 – SUMIF, AVERAGEIF Function
- 10.04 – Name Manager
- 10.05 – Outline Data, Add Subtotals, Data Validation Settings
- 10.06 – COUNTIF Function
- Project 10 “TTSC Cruise Ship Data” Assessment
QuizzesStatus