Microsoft Office Training
Excel 2007 Advanced
Hours: 2.
Cost: $59.00
Available Dates:
{module }
Short Descriptionexcel intro class

The Excel 2007 advanced course is two hours in total length. However, the class is split up into two, one hour sessions. Each session is on a separate day.

How it works
The Excel 2007 advanced course is two hours in total length. However, the class is split up into two, one hour sessions. Each session is on a separate day.

Example: Tuesday, Thursday


Course Outline


Hour 1:

Lesson 1: Macro's & Streamlining

Create a Macro
Edit a Macro
Use Conditional Formatting
Use Data Validation
Customize Excel's Default Settings

Lesson 2: Collaboration

Protect Files
Share Workbooks
Revision Tracking
Review Tracked Revisions
Restrict Access

Lesson 3:Troubleshooting worksheets

Trace Cells
Troubleshoot Errors in Formulas
Troubleshoot Formulas
Using the watch feature

 

Hour 2:

Lesson 4: Analyzing data

Using a Trendline
Create Scenarios
What-If Analysis

Lesson 5: Multiple Workbook organization

Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Lesson 6: Importing and Exporting

Export data
Import data

 

 

 
Join Our Email List
Email: