Embedded Files
Assignments for Day One (June 7, 2021) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Syllabus, Excel 2016 Quick Reference Card, and Windows 10 Quick Reference
Card, Chapter One and Two Excel 2016 Introduction Custom Guidebook
Session One: The Fundamentals, Worksheet Basics, Enter Formulas and Format
a Worksheet.
Hands On Exercise:
Create a Address Book and Monthly Budget Report Workbook
Homework:
Please read the following:
3D References and 10 Subtotal Tips
Review videos:
Formulas Inputs Number or Cell References
Protecting worksheets or workbook
Assignments for Day Two (June 8, 2021) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Chapters Three and Four of the Excel 2016 Introduction Custom Guidebook
Session Two: Work with Cell Alignment, Functions and Formulas.
Homework:
Please read the following:
Auto-fill shortcuts and Excel relationships
Review videos:
Drop Downs and Data Validation
Assignments for Day Three (June 9, 2021) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Chapter One and Two Excel 2016 of the Excel 2016 Intermediate Custom Guidebook
Session Three: Working with Data Ranges, Managing Workbooks, Creating and Working with Charts.
Homework:
Please read the following:
Finding Duplicates and flash-fill
Review videos:
Assignments for Day Four (June 10 2021) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Pivot Table Data, Home Inventory, Inventory and Chapter Three Excel 2016
Intermediate Custom Guide Book
Session Four: Print Worksheets, Named Range, Creating a Custom Auto-filter,
Working with Tables.
Homework:
Please read the following:
Multiple Subtotaling, SumIF () and Helper Column, SumIF () and Negative Values
Review videos:
Linking data between worksheets
PMT function for Cash flow, and Balloon Payment
Assignments for Day Five (June 11, 2021) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Consolidation, Scenario report, Equipment Lists, Text to Column, Chapter
Four Excel 2016 Intermediate Custom Guide Book.
Session Five: Create Pivot Tables (format, add, change calculations and filter), VLOOKUP function, Pivot Tables and Conditioning Formatting.
Homework:
Please read the following:
SumIF () and Wildcards and Transposing Data Fixed
Presentations:
Each team will have 15 minutes to conduct their presentation in front of the
audience.
Please watch the videos below on PowerPoint tutorial, to assist your Team on their respective project.
PowerPoint - PowerPoint Tutorial
Team A - Build a MT Industry / Company
Team B - Build a Supply Industry / Company
Review videos:
VLOOKUP
Page updated
Google Sites
Report abuse