Advanced Excel 2003 training course (2 days)
If you have been using Microsoft Excel for a while now, maybe it is time to move on a bit. This two-day course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions in Excel and much more besides! Why not spend two days finding out just what Excel can do?
Advanced Excel 2003 training - Course Contents
The contents of our Advanced Excel 2003 course are as follows (any items marked with a * will be covered if time allows):
Number formatting
- Conditional number formats
- The four parts of a format
- Creating custom formats
- Formatting dates and times
Range names and absolute references
- Absolute references ($ symbol)
- Fixing only the row/column
- Creating range names
- Labelling ranges automatically
- The amazing 40% rule
Styles (*)
- Creating formatting styles
- Using the style drop-down box
- The NORMAL style
Validation and protection
- Setting cell validation
- Protecting cells/worksheets
- Cell comments
Multiple worksheets
- Copying, moving and renaming sheets
- The dangerous group mode
- Summing across worksheets
- 3-D range names
IF and LOOKUP functions
- The conditional (IF) function
- Nested IFs are evil
- Lookup tables
- The mysterious fourth lookup argument
|
Consolidation (*)
- Using formulae
- Using arrays
- Using data consolidation
- Using pivot tables
Lists
- Sorting lists
- Filtering lists
- Extracting subtotals
- The definition of a list
Pivot tables
- Creating pivot tables
- Swapping rows, columns and pages
- Grouping fields
- Drill-down
Charts
- Selecting data
- Formatting your chart
Advanced charts
- Combination charts
- Picture charts
- Custom chart types
- Regression and trendlines
Recording Macros
- Absolute/relative recording
- Where macros are stored
- Assigning macros to buttons
|
Click on any link above to show free exercises for the topic in question. Delegates should already have a good working knowledge of Excel. There will be a maximum of 6 people on each course, and each person will have their own computer.
