Assignments for Day One (April 13, 2020) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Syllabus, Excel 2016 Quick Reference Card, and Chapters One through Two of the Excel 2016 Intermediate Custom Guide Book
Hands On Exercise:
Create a Address Book and Monthly Budget Report Workbook
Homework:
Please read the following:
10 Ways to show off your data in Excel 2013, Microsoft Excel 2010 Introduces
some solid enhancements, and Pivot Table
Review videos:
Protecting worksheets or workbook
Assignments for Day Two (April 14, 2020) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Chapters Three through Four of the Excel 2016 Intermediate Custom
Guide Book
Homework:
Please read the following:
Simple Data Validation to display cell content info to user, Conditional Formatting
Review videos:
Assignments for Day Three (April 15, 2020) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Chapter One through Two Excel 2016 Advanced Custom Guide Book
Homework:
Please read the following:
Marketing Balance Sheet, Goal Seek, Personal Information, Data Validation,
and Total Row
Watch Instructional Video:
Review videos:
Drop Downs and Data Validation
Assignments for Day Four (April 16, 2020) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Pivot Table Data, Home Inventory, Inventory and Chapter Three through Four
Excel 2016 Advanced Custom Guide Book
Watch Instructional Video:
Homework:
Please read the following:
Review videos:
Linking data between worksheets
PMT function for Cash flow, and Balloon Payment
Assignments for Day Five (April 17, 2020) - Please complete all Assignments, Quiz and Test.
Classroom:
Read the following:
Chapter Five Excel 2016 Advanced Custom Guide Book
Presentations:
Each group will have 15 minutes to conduct their presentation in front of
the audience.
Please watch the videos below on PowerPoint and Access tutorial, to assist your group on their respective project.
PowerPoint - PowerPoint Tutorial
Access - Access tutorial
Group A - Build a Accounting Industry / Company
Group B - Build a Supply Industry / Company
Group C - Build a Administrative Industry / Company
Group D - Build a Human Resources Industry / Company
Homework:
Please read the following:
None
Review videos: