Notify Me When Page is Updated
Login To SchoolRackSign Up for an Account

Course 8 - MS Excel Expert ← Back to All Pages

Mr Lord. M.Ed.

Chapter 9

Learning Objectives:
Apply accounting, fraction, and scientific formats.
Create a custom format.
Use AutoFormats
Apply conditional formats
Use styles and data validation
Enhance the appearance of worksheet charts.

Complete:
Step by Step

Chapter 10

Learning Objectives:
Use Print Preview
Change page setup options
Create your own page breaks
Apply various printing features
Print formulas instead of totals
Troubleshoot printing.

Complete:
Step by step
True / False
Activity 10-1

Chapter 11

Learning Objectives:
Create a list
Add records to a list
Edit records in a list
Delete list records
Sort a list
Search for records that meet certain criteria

Complete:
Step by Step

Chapter 12

Learning Objectives:
Search a list using AutoFilter
Search for records using the Top 10 feature
Display records using custom filters and search operators.
Display records using advanced filters.

Complete:
Step by Step
True / False
Project 12-1
Project 12-2

Chapter 13

Learning Objectives:
Create Scenarios
Use Excel's auditing Feature
Create a PivotList and PivotTable report
Create a PivotChart
Use Goal Seek
Use Solver

Complete:
Step by Step
True / False
Project 13-1
Project 13-2

Chapter 14

Learning Objectives:
Discuss the purpose of macros.
Create, record and run a macro.
Edit a macro.
Customize a toolbar by adding macro buttons.
Assign a macro to a command button.
Create a custom menu.

Complete:
Step by Step
Matching

Chapter 15

Learning Objectives:
Import data into Excel
Import data from other data sources
Export Excel data
Export structured data
Publish Excel worksheets and workbooks in HTML format.

Complete:
Step by Step
True / False

Chapter 16

Learning Objectives:
Create a template
Save a template
Open and use a template
Edit a template
View additional templates
Add protection options to a cell, worksheet, and workbook.

Complete:
Step by step
True / False
Project 16-1
Project 16-2
Activity 16-1

Chapter 17 and 18

Chap 17 - Learning Objectives:
Name a range
Copy and move data between worksheets
Copy an entire worksheet
Consolidate data from multiple worksheets
Move between open workboods
Save a workspace

Complete:
Step by Step
True / False

Chapter 18 - Learning Objectives:
Create and use a shared workbook
Merge shared workbooks
Track changes
Add password protection to a workbook

Complete:
Step by Step
True / False
Project 18-1

 

Chapter 19+20+Unit Review

Chap 19 - Learning Objectives:
Created and remove an outline from worksheet data.
Create and remove subtotals from worksheet data.
Group structured data.
Use the COUNT function.

Complete:
Chapter 19 Step by Step
T/F

Chapter 20 - Learning Objectives:
Create HLOOKUP and VLOOKUP functions
Use XML to share data on the web
Add trendlines

Complete:
Chapter 20 Step by Step
T/F

Unit Review
Complete:
T/F
Fill in the blanks
Project 1