Microsoft Excel Level 3

Course Length

1 Day (Typically 9AM - 4PM with a 1 hour lunch)

Course Objective

You will learn how to change Excel's defaults, different ways to protect data, methods to improve efficiency, analyze data, and create and play macro, add it to a button, edit and delete a macro.

Target Student

This course is intended for a student who has experience working with Excel and would like to learn how to change Excel's defaults, different ways to protect data, methods to improve efficiency, analyze data, and create and play macro, add it to a button, edit and delete a macro.

Prerequisites

To ensure your success, we recommend that you first take Excel Level 1 or have equivalent knowledge.

Delivery Model

Hands-on, instructor led, group-paced, classroom learning. The pace of class is based on the participants' previous computer experience and class expectations. Questions are welcome and encouraged!

Course Outline

Customize Excel
Change Excel Default Options
Customize the Quick Access Toolbar
AutoCorrect
Custom Number Formats
Protecting Data
Using Data Validation
Protecting Workbook Structure and Windows
Protecting Worksheets and Worksheet Elements
Increasing Productivity
Custom Views
Flash Fill
Auto Recover
Analyzing Data
Display & Trace Formulas
Conditional Formatting
Managing Conditional Formatting
Using Goal Seek
Using Solver
Macros
Record a Macro
Play & Delete a Macro
Add a Macro to the Quick Access Toolbar
Edit Macro Visual Basic Code
Additional Macro Exercise
Important Macro Considerations

Also Includes

  • Detailed class/reference book
  • Certificate of completion.