Introduction to Microsoft Excel 2007™

Learn how to maximise the new features in Excel 2007 to produce professional looking spreadsheets

New for 2012

Microsoft Office Excel 2007 has many changes from the previous versions. The new tabs and ribbon form the basis of a new user interface. Learn the difference between text data, numerical data, and formulas and functions. Learn to set up your own spreadsheets without relying on anyone else. Develop your skills to present your work clearly by learning how to create purchase orders, bank statements and compile sales figures.

This course is for anyone who needs to understand the way Excel works. It's suitable for complete beginners, or those who have a little self taught knowledge but want to know how to use Excel more efficiently for day to day tasks.

You will learn how to create spreadsheets from new, enter data, basic formulas and functions. Learn to manipulate data by inserting rows, columns and sheets as well as move, copy and delete data. As printing in Excel is somewhat different from the other components of Microsoft Office you will learn how to set up data for printing and produce charts.

This course is run by Reed Learning.

• Explore the various new user interface elements
• How to master the ribbon
• Learn the new keyboard shortcuts
• Working with contextual tabs
• Use the Excel galleries
• Customise the interface
• Creating, opening and saving a workbook
• Inserting tables
• Formatting tables
• Creating forms with Excel 2007
• Utilising Excel help
• Understanding basic formulas
• Entering Excel 2007 functions
• Replicate formulas and functions
• Create an absolute reference
• Setting up data for printing
• Adding headers and footers
• Recording the current date and time on the printed spreadsheet
• Turning your figures into charts
• Formatting charts

This course, which is run by Reed Learning, is endorsed by CIMA as suitable for members and their colleagues.

6 CPD hours for non members.