 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2002 (XP) Advanced
Course Aims
This course will give readers the ability to create advanced spreadsheets using the full range of Microsoft Excel 2002's tools and features. Readers will learn to apply custom formatting and use templates; to import and export data in different formats; to use LOOKUP functions; and to create customized charts. Readers will also learn how to customize and automate Excel using macros and toolbars. |
Assumed Knowledge
Readers should have a good working knowledge of Excel and must be able to create, format and print workbooks that incorporate basic mathematical, financial and logical functions, multiple worksheets, charts and data lists. |
Course Audience
Users with a basic understanding of Excel 2002 who want to consolidate and expand on their knowledge of the basic features in a short space of time. |
|
Table of Contents
|
Custom number and conditional formatting
|
Apply number formats (accounting, currency, number)
|
|
Create a custom number or date format
|
|
Use conditional formatting
|
|
|
|
Using named ranges
|
Add and delete a named range
|
|
Use a named range in a formula
|
|
|
|
Importing and exporting data in Excel
|
Use Paste Special to import and manipulate data
|
|
Export worksheet data to other applications
|
|
Import data from a text file
|
|
Import a table from an HTML web page
|
|
Round trip HTML data in Excel
|
|
|
|
Workbook templates and Add-Ins
|
Create a template file for frequently used worksheet layouts
|
|
Edit and apply a template file
|
|
|
|
Working with multiple workbooks
|
Save different views of a workbook
|
|
Use Consolidate to perform arithmetic on multiple ranges automatically
|
|
|
|
Printing workbooks and reports
|
Print and preview multiple worksheets
|
|
|
|
Lookup and reference functions
|
Use VLOOKUP and HLOOKUP to get values from multi-column tables
|
|
Sort values in rows or from left-to-right
|
|
|
Customizing Excel toolbars
|
Hide and display a toolbar
|
|
|
|
Using macros in Excel
|
Run a macro from the menu or the keyboard
|
|
Assign a macro to a toolbar button or a menu
|
|
Implement macro virus file protection
|
|
|
|
Customising Excel charts
|
Reposition chart elements (titles, legend and labels)
|
|
Format chart axes (number format, text and line width)
|
|
Format data series (shading, spacing and width)
|
|
Explode segments of a pie chart
|
|
Modify the chart type for a data series
|
|
Delete a data series in a chart
|
|
Add a trendline to a chart
|
|
Create a combination chart
|
|
Insert an image into a chart
|
|
Store a custom chart as a chart template
|
|
|
|
|
Glossary
|
|
|
|
|
