Monday-
Importing data from an Excel File
Tuesday-
Sorting and Filtering
Wednesday-
Creating relationships
Thursday-
Project: Creating a customer information database
Friday-
Review
Monday-
Importing data from an Excel File
Tuesday-
Sorting and Filtering
Wednesday-
Creating relationships
Thursday-
Project: Creating a customer information database
Friday-
Review
Monday-
Working in the Navigation Pane
Tuesday-
Save Options and compact and repair
Wednesday-
Project: Managing the Access Environment; Quiz: Managing the Access Environment
Thursday-
Creating an Access Database and Table
Friday-
Entering data
Monday-
Project: Recording a Macro
Tuesday-
Merge to create letters
Wednesday-Thursday
Project: Creating a merge
Friday-
Quiz: Word Advanced Skills
Monday-
Quiz 2: Enhancing Microsoft Excel Charts; creating picture charts
Tuesday-
Sparklines
Wednesday-
Stock Market Project part 6- Creating Advanced charts
Thursday-
Quiz 3: Advanced charting options; Review
Friday-
Test
Monday-
Creating charts
Tuesday-
Quiz 1- Creating charts in Microsoft Excel
Wednesday-
Formatting charts; enhancing charts with illustrations
Thursday-
Formatting Illustrations
Friday-
Project: Stock market part 5- creating and enhancing charts
Monday-
Function wizard and linking formulas
Tuesday-
Analyzing data by sorting and filtering; project: Stock market project Part 4- Entering functions
Wednesday-
Quiz 4: Utilizing functions and data commands
Thursday-
Review
Friday-
Test
Monday-
Order of operations
Tuesday-
Microsoft Excel formulas
Wednesday-
Types of cell references in formulas
Thursday-
Project: Stock Market Project Part 3- entering formulas; Quiz 3: creating formulas
Friday-
Functions in Microsoft Excel
Monday-
Project 5: Stock Market Project Part 1- Researching and Recording stock prices
Tuesday-
Quiz 1: Data Entry
Wednesday-
Cell Formats; editing cells, rows, and columns
Thursday-
Managing worksheets
Friday-
Project: Stock market project part 2- Formatting a spreadsheet
Monday-
Quiz 3: Managing File settings
Tuesday-
Lesson 26 Review and Test
Wednesday-
Microsoft Excel Data Types
Thursday-
Entering and Editing Cell data
Friday-
Selecting, filling, moving and copying cell data; auto fill
Monday-
Quiz 2: Spreadsheet basics; workbook properties
Tuesday-
Saving and File formats
Wednesday-
Sharing worksheet data
Thursday-
Managing comments, printing worksheets and workbooks
Friday-
Begin project- Saving and printing Microsoft Excel Files