Microsoft Excel Expert
Course Duration: 1 Day
 Printer-friendly
version
Course Objective
By the end of the course, delegates will be able to:
- Create and use
worksheet templates
- Define and use custom lists
- Audit worksheets
- Customise Excel defaults
- Use Goal-seek and Solver to find answers
- Customise Excel toolbars
- Specify, sort, filter and extract more complex
data using list management functions
- Use the Look-up Wizard
- Use chart templates
- Import and export data from other sources
- Record a macro for automating
tasks
- Attach a macro to a command button and a toolbar button
Delegate Profile
Existing Excel users who have a strong working knowledge of the
product and wish to further develop their spreadsheet skills by using
the more complex features of the application.
Pre-Requisites
Attendance on our Excel Advanced course or equivalent
knowledge is assumed.
Structure
Each delegate has the exclusive use of a
PC and training includes extensive hands-on activity.
Course Content
Review of advanced skills
Consolidation exercise
Templates & Wizards
Creating and using worksheet
templates
Using Wizards to create templates
Custom lists
Defining and using your own custom
lists with Auto-Fill
Sort data in a custom list sequence
Worksheet auditing
Tracing precedents, dependants and errors
Customising Excel defaults
Using options to
change the system settings
Toolbars
Customising the toolbars in Excel
List management (databasing)
Specifying complex criteria
Use the Look-up Wizard
Extracting to alternative output ranges
Data analysis
Goal seek
Solver
Making charts work
Using multiple chart types
Adding data labels and trendlines
Creating chart templates
Importing and exporting data
Using the query wizard
to query data from external sources
Exporting data to text files - mail merge with Word etc.
Simple automation
Using the macro recorder to automate tasks
Attach a macro to a toolbar button
Put a button on a worksheet and attach a macro to it
 Back
to the top
|
