Assignments for Week One (April 2, 2019) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Introduction book.
Classroom:
Syllabus, Creating and Mange Worksheets and Workbooks
Lab:
Create worksheets and workbooks, navigate in worksheets and workbooks, format worksheets and workbooks, customize options and views for worksheets and workbooks, moving the cell pointer, selecting a range of cells, creating a new workbook, inserting, renaming and deleting workbooks, entering constant values, using auto-fill to enter data, saving a workbook.
Homework:
Download the 3D Reference and Summarize file on your personal computer. Print and Review the document prior to the next class.
Review videos:
Assignments for Week Two (April 9, 2019) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Introduction book.
Classroom:
Syllabus recap, Tracking customer data
Lab:
Editing cell contents, clearing cell contents, working with undo and redo, advanced workbook formatting, configure worksheets and workbooks for distribution, tracking customer data, recording students grades, data visualization and images, organizing large amount of data.
Homework:
Download the Auto-fill and Excel Relationship file on your personal computer. Print and Review the document prior to the next class.
Review videos:
share workbook and track changes
Assignments for Week Three (April 16, 2019) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Intermediate book.
Classroom:
Syllabus Recap, Manage Data cells and ranges
Lab:
Manage data cells and ranges, insert date in cells and ranges, summarize and organize data, date functions and conditional formatting, financial functions and what-if analysis, advanced functions for text and analysis, lookup functions and outlines, insert sparklines.
Homework:
Download the Finding Duplicates file on your personal computer. Print and Review the document prior to the next class.
Review videos:
Assignments for Week Four (April 23, 2019) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Intermediate book.
Classroom:
Syllabus recap, Date functions, and conditional formatting
Lab:
Create a Customer.txt file using notepad and import into Excel 2016, create tables, create and manage tables, manage table styles and options, filter and sort a table, entering formulas, using the sum function, summing columns and rows automatically, using statistical functions.
Homework:
Download the Flash-fill and Multiple subtotaling file on your personal computer. Print and Review the document prior to the next class.
Review videos:
Assignments for Week Five (April 30, 2019) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Intermediate book.
Classroom:
Syllabus recap, Create Tables
Lab:
Working with the range finder, using formula error checking, perform operations with formulas and functions, using the IF Function, nesting functions, using multiple conditions with the IF Function.
Homework:
Download the Sum ( ) and helper file on your personal computer. Print and Review the document prior to the next class.
Review videos:
Assignments for Week Six (May 7, 2019) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance book.
Classroom:
Syllabus recap, Entering formulas, Summarizing Data by using Functions
Lab:
Nesting IF Functions, summarizing data by functions, perform conditional operations by using Functions, format and modify text by using functions.
Homework:
Download the Sum ( ) and Negative value file on your personal computer. Print and Review the document prior to the next class.
Review videos:
Assignments for Week Seven (May 14, 2019) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance book.
Classroom:
Recap syllabus, Perform conditional operations by using functions, format and modify text by using functions
Lab:
Understanding chart types, creating a chart, changing the chart location and size, changing the chart type, modifying chart elements, formatting chart elements, adding and removing a data series, applying a chart filter, printing charts, creating charts and objects, create charts, format charts, insert and format objects.
Homework:
Download the Sum ( ) and Wild Cards, and Transposing Data file on your personal computer. Print and Review the document prior to the next class.
Review videos:
Assignments for Week Eight (May 21, 2019) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Advance book.
Classroom:
Syllabus recap, PivotTables and Pivot Charts
Lab:
PivotTables and Pivot Charts, MOS Exam Prep, Course Overview, administer the MS Excel (MOS) Final Exam
Homework:
None
Project:
Team B - Create a Administration/Supply Business
Each team is required to produce 15 PowerPoint slides for their respective presentation. Presentation will include Business Name, Business Location, Cost to startup the business, Organizational Chart, Equipment List, Personnel List, Customer List, Contact List, Hours of Operation, Videos, Graphics or Pictures, Sound Bits, Music, etc. Both teams will have 15 minutes to discuss their business in front of the audience with special guess and instructor for evaluation purposes only.
Review videos: