Embedded Files
Assignments for Day One (February 22, 2021) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance Guide book.
Classroom:
Syllabus, Reference Guide, Microsoft Excel 2016 Advance Guide book (chapter one 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)
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, AverageIFs and CountIFs , Choose, Offset and Indirect ,
Assignments for Day Two (February 23, 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 two only)
Lab:
Complete (Company Balance Workbook)
Homework:
Read (Multiple subtotaling, Sum If() Helpercolumn, Sum If() and Wildcards)
Watch Instructional Video:
Company Balance Part four , Company Balance Part five )
Review videos:
VLookup , HLookup , Index and Match , Goal Seek , Data Table , Dashboards )
Assignments for Day Three (February 24, 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:
Create (Home Budget)
Homework:
Read (Sum If() and neg val)
Review videos:
Assignments for Day Four (June 25, 2020) - 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 four only)
Lab:
Create (Equipment List)
Homework:
Read (Transposing Data Fixed, auto-fill shortcuts)
Watch Instructional Video:
Review videos:
Assignments for Day Five (February 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 five only)
Lab:
Create (Team's Project PowerPoint Slides)
Planning for Final Project:
Team project should include fifteen (15) PowerPoint slides (equipment inventory, organization
charts, company graphs, employee work schedule, company budgeting worksheets, business
history, feedback letters, company map and location, company business plan, employee duties
and responsibilities, sound recording, video, pictures, etc.)
Group's Project:
Group A - create a Supply Company
Group B - create a Transportation Company
Homework:
None
Watch Instructional Video:
Review videos:
Page updated
Google Sites
Report abuse