Microsoft Excel 2007 Level 2

Requirements:
A basic knowledge of using a PC and experience in working within the Microsoft Windows environment is essential as well as some experience in working with Excel. In particular, you should be able to:
-Start and exit from Excel
-Open, save and close a workbook
-Create and print a worksheet
-Perform basic worksheet editing operations
-Perform basic worksheet formatting operations
-Use basic Excel functions
Course objectives:
On completion of this programme you will be able to:
-Use advanced functions, such as IF, COUNTIF, SUMIF, TODAY, NOW, MATCH, INDEX, VLOOKUP and HLOOKUP
-Use Excel's list management tools
-Rearrange and generate summary information for worksheet data
-Create pivot table reports, pivot chart reports and scenarios
-Set up a 'three-dimensional' worksheet structure
-Link two or more workbooks
-Set up and use a custom workbook template
-Audit a worksheet
-Import external data into Excel and export Excel data to external applications
Course content:
Formulas
-Recap on formula concepts
-Statistical function
-Logical functions
-Lookup functions
Naming ranges
-Defining/selecting a range name
-Using a range in formulas
Auditing a worksheet
-Tracing precedents and dependents
-Tracing errors in the worksheet
Linking worksheets and workbooks
-Setting up related worksheets within a workbook
-Entering a formula to link related worksheets
-Entering a formula to link external workbooks
-Creating a workspace
-Consolidate worksheets/workbooks
Additional features
-Goal seek
-Worksheet validation
-Protecting a worksheet and workbook
-Group and outlining the worksheet
-Removing duplicate entries
-Overvie- on creating a PDF from a spreadsheet
Further Formatting
-Create a custom number and date format
-Using conditional formatting
Working with a template
-Creating a ne- workbook template
Importing and exporting data
-Importing data from a text or web based file
-Working with other database applications such as Access
Working with other Excel users
-Create a shared workbook
-Tracking changes in a shared workbook
-Responding to proposed changes and comments in a shared workbook
Filtering and summarising worksheet data
-Auto filter and advanced filter
-Adding a criteria range with advanced filter
-Database functions
-Using subtotals and nested subtotals
-Create a workbook from a template
-Applying a database query
Pivot Tables
-What is a pivot table?
-Best practice on setting up pivot tables
-Creating a pivot table
-Resetting the summary function in a pivot table report
-Grouping pivot table data
-Formatting a pivot table
-Charting a pivot table
-Printing the pivot table
-Using other Microsoft data sources with pivot tables
Recording simple macros
-Why use macros?
-Macro guidelines
-Macro security settings
-Recording/deleting macros
-Running macros
-Assign a macro to an icon and shortcut keys
-Identify the difference between relative and absolute macros
Revie- of Programme
Other Recommended Programmes
-Microsoft Excel VBA Programming
-Accounting Budgeting and Forecasting
-Introduction to Strategic Financial Management