Microsoft Excel
Microsoft Excel 2010 Advanced Training Course
| 29/06/2012 | Manchester City Centre-64 Bridge Street,M3 3BN | £167*+VAT | |
|
Or Call
0161 408 0435
|
|||
|
* Prices discounted until 30/07/2012. Normal price £195+VAT |
|||
This Excel Advanced course is for individuals who have the knowledge and experience to create complex spreadsheets and want to become familiar with more advanced tools & techniques as well as automating repetitive tasks.
On this Microsoft Excel 2010 Advanced training course you will work with advanced formulas. You will create lookups with VLOOKUP, MATCH, and INDEX. In addition, you will learn about database functions such as DSUM and data validation & protection.
You will learn how to work with PivotTables and PivotCharts, use the analytical features of Excel and how to record & run Macros to automate repetitive tasks
| Review Introduction & Intermediate Topics Advanced List Management Database Functions Data Forms and Validation Group and Outline Listed Data Analytical Options Goal Seek And Scenario Manager Data Tables Scenarios Exporting And Importing Notation and Auditing Comments and Text Boxes Auditing Features Workgroup Collaboration |
Pivot Tables Creating A Pivot Table Rearranging Pivot Tables Formatting Pivot Tables Pivot Charts Group and Outline Pivots Apply Table Options Slicers Sparklines Macros Recording And Running A Macro Editing VBA Code |
Last Updated (Friday, 18 May 2012 04:42)
Our mission is to ensure that every delegate benefits from a training experience that meets their personal requirements and learning objectives. If you feel that the learning objectives have not been satisfactorily attained, we will offer a full refund of course fees.
We also aim to provide our training at a very competitive price. If you are quoted a more competitive price for a similar course from any another training provider, you should contact us or call 0161 408 0435 and we will provide a matching or better quote so you will still benefit from our mamy years of experience and personal service.
