Intermediate Microsoft Excel 2007 / 2010

This intermediate course is designed for users who have attended an introductory level course or are already confident in the basic features of Microsoft Excel. Your existing Excel knowledge can be from any version, but Office 2007/10 is preferable.

In addition to a completely new user interface Microsoft have improved and added a range of features in Excel 2007/2010. This course follows on from our Introduction to Excel course and will guide you through all the new features. It covers more complex formulas and functions, such as the improved conditional formatting features, lookup functions and new filtering options.

There is a recap session at the start for delegates who may have completed the introduction in a previous version.

• The skills to utilise database functionality

• How to create look-ups to obtain range and precise data

• An understanding of how to add 'IF' statements and using validation to restrict access to cells, rows and columns

• Knowledge to use the new an improved conditional formatting

• Useful practical exercises

• Free attendance on a refresher course within a year

• The confidence and knowledge to move on to the next level - Advanced Microsoft Excel 2007

• Recap on user interface, environment and shortcuts

• Absolute references

• Naming cells and ranges

• Referring to named cells and ranges in formulae

• Editing named cells and ranges

• Setting up entire workbooks with group editing

• Using vlookup & hlookup statements to retrieve data

• Editing lookups and ensuring accuracy in returned data

• Linking spreadsheets and workbooks together with formulas and functions

• Utilising If statements to assist decision making

• If statements and calculations

• Analysing data with the all new conditional formatting features

• Databases in Excel understanding fields and records

• Sorting data numerically and alphabetically

• Filtering data for range and precision analysis

• Setting up data validation to ensure integrity of the data

• Attaching security to a spreadsheet

• Selective protection i.e. protecting formulas while allowing data entry

• Setting up and utilising templates

• Creating and formatting charts

• Adding trend lines to the chart

• Utilising custom chart types

• Adding Sparklines to view trends in the data (2010)

All of our courses are worth 6 hours of CPD per day.