Embedded Files
Assignments for Day One (September 20, 2021) - Please complete all Assignments.
Classroom:
Syllabus, Windows 10 reference guide, Working with workbooks and files,
Using Formatting Options
Reminders:
As a friendly reminder this is not a hybrid class. Students are required to be in an classroom environment to successfully pass this course. There will be no exceptions to this rule!
Lab:
Generate a list of filenames and sheet names
Homework:
Download to your computer and review the 3D reference, 10 Subtotals, Auto-fill,
Excel Relationships document files, prior to the next class.
Quiz:
Project:
Team A - Supply Business
Team B - MT Business
Team A
Business Name -
Location -
Hours of operation -
Support -
Team B
Business Name -
Location -
Hours of operation -
Support -
Instructor's Videos:
Lab:
Generate list of filenames
Review videos:
Assignments for Day Two (September 21, 2021) - Please complete all Assignments.
Classroom:
Syllabus Recap, Working with Formulas in MS Excel
Instructor's Videos:
Lab:
Perform a Lookup function (VLOOKUP and HLookup) to display data
Homework:
Download to your computer and review the Finding Duplicates, Flash-fill, Multiple sub-totaling
document files, prior to the next class.
Quiz:
Review videos:
Assignments for Day Three (September 22, 2021) - Please complete all Assignments.
Classroom:
Syllabus Recap, Working with Excel Data
Instructor Videos:
Instructor's Exercise:
Lab:
Use Conditional formatting to display data
Homework:
Download to your computer and review the Sum () and helper, Sum ( ) and negative values
document files, prior to the next class.
Quiz:
Review videos:
Assignments for Day Four (September 23, 2021) - Please complete all Assignments.
Classroom:
Syllabus Recap, Using Tables and Pivot Tables
Lab:
Create Pivot Tables and Pivot Charts to display data
Homework:
Sum () Wild Cards, and Transposing Data document files, prior to the next class.
Quiz:
Review videos:
Assignments for Day Five (September 24, 2021) - Please complete all Assignments.
Classroom:
Syllabus, Configuring charts and graphics
Lab:
Create charts, Create Macros, Create Consolidate.
Homework:
None
Review videos:
Page updated
Google Sites
Report abuse