Advanced Excel
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Advanced Excel.

About the Course:
This course is for Microsoft Excel versions up to 2003. 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?

Course Contents:
- Recording Macros
- Absolute/relative recording
- Where macros are stored
- Assigning macros to buttons
- Charts
- Selecting data
- Formatting your chart
- Advanced charts
- Combination charts
- Picture charts
- Custom chart types
- Regression and trendlines
- 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
- Multiple worksheets
- Copying, moving and renaming sheets
- The dangerous group mode
- Summing across worksheets
- 3-D range names
- Consolidation
- Using formulae
- Using arrays
- Using data consolidation
- Using pivot tables
- Range names and absolute references
- Absolute references ($ symbol)
- Fixing only the row/column
- Creating range names
- Labelling ranges automatically
- The amazing 40% rule
- IF and LOOKUP functions
- The conditional (IF) function
- Nested IFs are evil
- Lookup tables
- The mysterious fourth lookup argument
- Number formatting
- Conditional number formats
- The four parts of a format
- Creating custom formats
- Formatting dates and times
- Styles
- Creating formatting styles
- Using the style drop-down box
- The NORMAL style
- Validation and protection
- Setting cell validation
- Protecting cells/worksheets
- Cell comments
- Other techniques
- Goal-seeking
- Creating scenarios
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration2 days
 
£495
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).