Embedded Files
Assignments for Day One (August 5, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance Guide book.
Classroom:
Syllabus, Reference Guide, Microsoft Excel 2016 Intermediate Guide book (chapter one and two only)
Lab:
Create (Address Book, Company Balance Workbook)
Homework:
Read (10 Subtotal Tips, 3D Reference Summary, Excel Relationships, Finding Duplicates, Flash Fill, Formulas and VLookup), Microsoft Excel 2016 Intermediate Guide book (chapter three only)
Planning for Final Project:
As a reminder each individual is required to do advanced research on their respective project. Information on your project should include at least fifteen (15) PowerPoint slides (equipment inventory, organization charts, graphs, employee work schedule, budgeting worksheets, business history, business plan, employee responsibilities, sound recording, video, pictures)
Instructor
Watch Instructional Video:
PowerPoint Presentation Example , Address Book , Company Balance Part One ,
Company Balance Part two Company Balance Part three
Review videos:
Formulas , Excel Tips and Tricks , SumIFs and SumProduct , Choose, Offset and Indirect ,
Assignments for Day Two (August 12, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Intermediate Guide book.
Classroom:
Syllabus Recap, and Microsoft Excel 2016 Intermediate Guide book (chapter four only)
Lab:
Complete (Company Balance Workbook)
Create CountIF, AverageIF and Lookup formulas
Homework:
Read (Multiple subtotaling, Sum If() Helper column, Sum If() and Wildcards,
Sum If() and neg val), Microsoft Excel 2016 Advanced Guide book (chapter one only)
Watch Instructional Video:
Company Balance Part four , Company Balance Part five
Review videos:
VLookup , HLookup , Index and Match , AverageIFs and CountIFs
Assignments for Day Three (August 19, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Intermediate Guide book.
Classroom:
Syllabus Recap, and Microsoft Excel 2016 Intermediate Guide book (chapter five only),
Microsoft Excel 2016 Advanced Guide book (chapter one)
Lab:
Create (Home Budget and Equipment List)
Use maps in Power View to create multiple pie charts
Homework:
Read (Transposing Data Fixed, auto-fill shortcuts), Microsoft Excel 2016 Advanced
Guide book (chapter two only)
Watch Instructional Video:
Review videos:
Assignments for Day Four (August 26, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance Guide book.
Classroom:
Syllabus Recap, and Microsoft Excel 2016 Advanced Guide book (chapter three only)
Lab:
PivotTables, VLOOKUP and HLookup
Homework:
Microsoft Excel 2016 Advanced Guide book (chapter four)
Review videos:
Assignments for Day Five (September 2, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance Guide9book.
Classroom:
Syllabus Recap, and Microsoft Excel 2016 Advanced Guide book (chapter five only)
Lab:
Create Excel Power Pivot and Power View Dashboards
Create (PowerPoint Slides)
Homework:
None
Planning for Final Project:
Individual Project should include (15) PowerPoint slides (equipment inventory, organization
charts, graphs, employee work schedule, budgeting worksheets, business history, business plan, employee responsibilities, sound recording, video, pictures)
Project:
Row A - create MT
Row B - create Supply
Review videos:
Dashboards , Goal Seek , Scenario
Assignments for Day Six (September 2, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance Guide9book.
Classroom:
Syllabus Recap, and Microsoft Excel 2016 Advanced Guide book (chapter five only)
Lab:
Create Excel Power Pivot and Power View Dashboards
Create (PowerPoint Slides)
Homework:
None
Planning for Final Project:
Individual Project should include (15) PowerPoint slides (equipment inventory, organization
charts, graphs, employee work schedule, budgeting worksheets, business history, business plan, employee responsibilities, sound recording, video, pictures)
Project:
Row A - create MT
Row B - create Supply
Review videos:
Dashboards , Goal Seek , Scenario
Assignments for Day Seven (September 9, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance Guide9book.
Classroom:
Syllabus Recap, and Microsoft Excel 2016 Advanced Guide book (chapter five only)
Lab:
Create Excel Power Pivot and Power View Dashboards
Create (PowerPoint Slides)
Homework:
None
Planning for Final Project:
Individual Project should include (15) PowerPoint slides (equipment inventory, organization
charts, graphs, employee work schedule, budgeting worksheets, business history, business plan, employee responsibilities, sound recording, video, pictures)
Project:
Row A - create MT
Row B - create Supply
Review videos:
Dashboards , Goal Seek , Scenario
Assignments for Day Eight (September 16, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance Guide9book.
Classroom:
Syllabus Recap, and Microsoft Excel 2016 Advanced Guide book (chapter five only)
Lab:
Create Excel Power Pivot and Power View Dashboards
Create (PowerPoint Slides)
Homework:
None
Planning for Final Project:
Individual Project should include (15) PowerPoint slides (equipment inventory, organization
charts, graphs, employee work schedule, budgeting worksheets, business history, business plan, employee responsibilities, sound recording, video, pictures)
Project:
Row A - create MT
Row B - create Supply
Review videos:
Page updated
Google Sites
Report abuse