Microsoft Excel 2007 Level 3 Aberdeen (F1plus): Classroom or E-Learning
Sponsored links
This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with automation and productivity features. It includes areas such as conditional formatting, validation and consolidation methods, data analysis tools, such as data tables, summarising, goal seeking and PivotTables, and ways of annotating worksheets to help when sharing information with others.
At the completion of Microsoft Excel 2007 Level 3 you should be able to:
•use a range of find and replace techniques
•analyse your data and visually enhance your findings using Conditional Formatting techniques
•use Advanced Filters to view or extract matching records from a list of data
•use the Formula Auditing tools to find and fix formula errors
•use goal seeking to determine the values required to reach a desired result
•perform What-If Analysis on a range of data using Data Tables
•summarise and present information in a PivotTable report
•create summary worksheets based on consolidated data from other individual worksheets
•create and work with customised views
•use comments to provide additional context to your worksheet data
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.
Delegates should be familiar with Excel 2007 and how to build basic workbooks. It is assumed that the user will know how to create and save a workbook, create formulas and use functions, and perform simple formatting of the data.
This Training Course is available at the following locations:
Aberdeen
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
