Advanced Excel 2007
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
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

 
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).