search our courses:
Quick Navigation
Microsoft Excel 2007 Advanced (Level 2) course
Download PDF version of Excel 2007 Advanced Level 2 course outline
Overview
This course provides delegates with an understanding of a number of advanced data management features including data analysis tools, customisation and automation.
Audience
Users who need to enhance their existing knowledge and explore the more advanced features of Excel.
Course Objectives
At the end of this course, delegates will be aware of many of the “power user” features.
Prerequisites
Delegates must have attended the Excel Advanced Level 1 course (or have equivalent experience).
Course Contents (1 day)
- Templates
- Creating, using and editing a template
- Read Only files
- Workspace Files
- Creating and Using workspace files
- Creating custom views
- Workbook Protection
- Forecasting Tools
- Goal seek
- Scenario Manager
- Data Tables (1 and 2 way)
- Solver
- Hyperlinks and Web Pages
- Create hyperlinks to link a cell to another
worksheet, document or web page - Save as a web page
- Create hyperlinks to link a cell to another
- Array formulae - Frequency
- Create a custom form using:
- check boxes, option buttons,
combo boxes, lists and spinners
- check boxes, option buttons,
- Formula
- tracing precedents and dependents
- tracing errors
- evaluating formulas
- using the Watch Window
- Summarising data using outlining tools
- Advanced database functions
- Filtering using the database functions
DSUM and DAVERAGE - The Query Wizard with an external data source
- Use MSQuery to extract data from
an Access database
- Filtering using the database functions
- Macro Basics
(Macros are covered fully on the Excel VBA course)- What is a macro?
- Security levels
- Record a simple macro
- Assign shortcut keys
- Create a macro toolbar
- Add a button to it
- assign a macro to a button
- deleting macros and toolbar buttons