Microsoft Office Excel – Advanced

1 Day Duration

Overview

This advanced course is aimed at users who have a number of year’s experience creating and working with complex data sets within Microsoft Office Excel. This course will introduce the security features of Excel, as well as its automating capabilities using Macros.

Data Analysis Tools

Goal seek
Scenarios
Solver

Spreadsheet Auditing

Precedents
Dependants
Formula error checking
Watch window

Protecting Spreadsheets

Preparing spreadsheets for protection
Locking cells
Hiding formulae
Protecting worksheets
Protecting workbooks
Password protection

Advanced Functions

Nesting functions within functions
PMT
CONCATENATE
FORECAST

Data Imports and Exports

Importing data into Excel from
Access
Text files
Web sites
Exporting data from Excel
Saving data source files
Refreshing data within Excel

Macros within Excel

Planning macros
Plotting steps of macros
Recording macros
Editing macros
Deleting macros
Macro workshop