Excel 2007 Upgrade
Categories: Microsoft Excel
Excel 2007 Upgrade.

About the Course:
Rather than spend a month finding out gradually about all the features and foibles of this major upgrade, why not do it all in a day? Learn how lists have metamorphosed into tables, what structured references are, how the new page layout view can help you, what new conditional formatting features there are, how charts have evolve and much more!

Course Contents:
The contents of our Excel 2007 Upgrade course are as follows (any items marked with a * will be covered if time allows).
- Office 2007 interface
- Using the ribbon
- Customising the quick access toolbar
- Customising the status bar
- The zoom bar
- File formats
- The new file formats
- Compatibility mode
- Formatting your work
- Inserting/deleting rows/columns
- Changing fonts
- Colours and borders
- Merging and aligning cells
- Printing
- Headers and footers
- Freezing print titles
- Page break preview
- Using page layout view
- 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
- Styles and themes
- How themes work
- Using the default styles
- Creating custom styles
- Conditional formatting
- Creating/using cell rules
- Data bars and colour sets
 
Course Dates
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Tools
 
Key Details
Duration1 day
 
£225
per delegate