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