Microsoft Excel

Work confidently and efficiently with Microsoft® Excel 2007, from data entry and worksheet manipulation to working with formulas and creating charts to analyze your data.

• Know quick methods of navigation and data entry
• Be able to use the fill handle and create custom lists
• Learn how to use the table management feature to quickly sort and filter data
• Know how to simultaneously create, format and link multiple worksheets within the workbook
• Find out how to attach notes to a spreadsheet using the comments feature
• Understand how to construct and display formulae including logical functions
• Understand how to open and navigate multiple files and dynamically link them to produce a consolidation workbook
• Be able to use the chart wizard to represent your data graphically in your spreadsheet
• Be familiar with applying page breaks and other print settings

Learn complex features in Microsoft® Excel 2007. From advanced formulae and analysing large quantities of data with pivot tables, to creating templates and using macros.

• Know how to create and edit named ranges
• Be able to use advanced formulae, such as SUMIF,VLOOKUP and INDEX, as well as nest different functions together
• Learn about data validation and conditional formatting
• Know how to spot errors in your workbooks using the auditing tool
• Be able to create pivot tables from raw data and then edit and reformat
• Learn about protecting your work and share your files with colleagues
• Know how to automate tasks to ensure accuracy and save time using macros