Advanced Excel 2007
Categories: Microsoft Excel
Advanced Excel 2007.

About the Course:
This course is for Microsoft Excel 2007. 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:
- Number formatting
- Scaling numbers
- The four parts of a format
- Creating custom formats
- Dates and times (*)
- How dates are stored
- How times are stored
- Useful date/time functions
- Formatting dates and times
- Conditional formatting
- Creating/using cell rules
- Data bars and colour sets
- Styles and themes 
- How themes work
- Using the default styles
- Creating custom styles
- Validation and protection
- Cell comments
- Grouping and outlining
- Setting cell validation
- Protecting cells/worksheets
- Protecting a workbook
- Range names and absolute references
- Absolute references ($ symbol)
- Fixing only the row/column
- Creating range names
- Labelling ranges automatically
- Using name manager
- 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 fourth lookup argument
- Advanced lookup functions (*)
- Using MATCH to find values
- Combining MATCH and INDEX
- Using OFFSET
- The feared INDIRECT function
- Linking to other data (*)
- Linking to Access
- Linking to web sites
- Basic tables
- Table styles
- Using calculated columns
- Header rows and total rows
- Sorting data
- Simple filters
- Advanced Tables
- Removing duplicates
- Creating table styles
- Advanced filters
- Structured references (*)
- The parts of a table
- Syntax rules
- Examples of structured references
- Pivot tables
- Creating pivot tables
- Swapping rows, columns and pages
- Grouping fields
- Drill-down
- Charts
- Quick ways to create charts
- Selecting data
- Formatting your chart
- Advanced charts
- Creating chart templates
- Combination charts
- Picture charts
- Custom chart types
- Regression and trendlines
- Consolidation
- Using formulae
- Using arrays
- Using data consolidation
- Using pivot tables
- Recording Macros
- Absolute/relative recording
- Where macros are stored
- Assigning macros to buttons
- Scenarios 
- The scenario drop-down tool
- Adding scenarios
- What-if analysis
- Creating a scenario report

 
Course Dates
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
1-13 of 13
Tip: Click column names to sort. Click start dates to see scheduled days
LocationDistance (approx)Course Start DateNo. DaysWeb price ex.VATCourse Status 
Birmingham - Victoria Square118 miles Thu 15 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 Wed 11 Mar 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
Manchester 198 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
Manchester 198 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