Course code: 2E2ExcelA - call 0845 071 2801
Overview
Course duration: 1 day.
By the end of this course you will be able to confidently use the analysis tools to analyse data and make projections. As well as confidently importing and querying data from other sources and create, run, edit and assign macros, using the provided manual if required.
This course is run in partnership with 2e2 Training.
Is it right for me?
This course is designed for students who have completed the Excel Intermediate or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
This course can be run in versions 2000 / 2002 / 2003 and 2007.
What will it cover?
Advanced Formulas
- Using Names
- Decision-Making
- Nesting
- Financial Functions
Data Tables
- MATCH And INDEX
- Data Tables
Advanced List Management
- Subtotals
- Data Validation
- Database Functions
- Data Forms
Analytical Options
- Goal Seek And Solver
- Scenarios
- Views
- Reports
Pivot Tables
- Creating A Pivot Table
- Rearranging Pivot Tables
- Formatting Pivot Tables
- Pivot Charts
Exporting And Importing
- Exporting & Importing Data
- Querying External Databases
Working With Multiple Worksheets
- Using Multiple Worksheets
- Linking Worksheets By Using 3-D Formulas
- Managing Workbooks
Macros
- Recording And Running A Macro
- Editing VBA Code
- Function Procedures
Advanced Web Topics
- Creating Interactive Web Spreadsheets
- Pivot Tables On The Web