Advanced Excel
Categories: Microsoft Excel
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
 
Course Dates
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
1-15 of 15
Tip: Click column names to sort. Click start dates to see scheduled days
LocationDistance (approx)Course Start DateNo. DaysWeb price ex.VATCourse Status 
London - New Broad Street3 miles Wed 21 Jan 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Birmingham - Victoria Square118 miles Wed 28 Jan 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Thu 12 Feb 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Thu 05 Mar 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Thu 19 Mar 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Birmingham - Victoria Square118 miles Wed 01 Apr 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Mon 20 Apr 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Leeds194 miles Tue 21 Apr 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Tue 28 Apr 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Birmingham - Victoria Square118 miles Tue 12 May 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Mon 18 May 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Thu 28 May 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Thu 18 Jun 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
London - New Broad Street3 miles Tue 07 Jul 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Manchester 198 miles Mon 20 Jul 09 2£495      CLICK TO ENQUIRE
    CLICK TO BOOK
Tools
 
Key Details
Duration2 days
 
£495
per delegate