Excel 2007 - Advanced

Overview

About this course

Self-paced lessons on advanced Excel 2007: advanced functions, formula auditing, data analysis, advanced formatting and data management.

Curriculum

Curriculum

10 modules

Introduction

Financial Functions
Logical Functions
Text Functions
Statistical and Math Functions
Lookup Functions

Displaying Formulas
Tracing Cell Precedents and Dependents
Using the Formula Evaluator
Error Checking

Using Subtotals
Using Goal Seek
Using the Scenario Manager

Understanding Custom Formats
Applying a Custom Format
Using Conditional Formatting
Adding Data Bars, Color Scales, and Icon Sets
Managing Formatting Rules

Planning a Database and Understanding Database Terms
Formatting and Sorting Tables
Filtering a Table
Using an Advanced Filter

Creating a Simple PivotTable
Using the PivotTable Field List Pane
Working with PivotTable Options
Sorting in a PivotTable
Formatting a PivotTable
Creating a PivotChart
Formatting a PivotChart

Importing from Access
Importing a Text File
Managing Updates
Exporting Data

Recording a Macro
Running a Macro
Running a Macro from a Custom Button

Course Recap

Who it's for

Who it's for

Users of Excel 2007.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.