ADVANEC EXCEL TRAINING
Summing Techniques
IF, Cell References, Formula Linking,etc
New Formulas of Excel 2007 Sumifs, Countifs, Iferror
Database Formulas
Subtotal (Formulae & Procedure)
Table
Pivot Table
Macros
Lookup References (Vlookup, Hlookup,etc)
Data Validation
Conditional Formatting
Date & Time Formulas
Charts & Graphs
Protection & Security
Some Common Functions:
Print Page Setup, Print Titles, Filter, Advance Filter, Sorting, Name Manager, Freeze Panes, Auto Fill, Shapes, Text to Columns, Text Alignment, Transpose, Wrap Text, Merge & Center, Format Painter, etc
Further Details
Summing Techniques
IF, Cell References, Formula Linking,etc
New Formulas of Excel 2007 Sumifs, Countifs, Iferror
Database Formulas
Subtotal (Formulae & Procedure)
Table
Pivot Table
Macros
Lookup References (Vlookup, Hlookup,etc)
Data Validation
Conditional Formatting
Date & Time Formulas
Charts & Graphs
Protection & Security
Some Common Functions:
Print Page Setup, Print Titles, Filter, Advance Filter, Sorting, Name Manager, Freeze Panes, Auto Fill, Shapes, Text to Columns, Text Alignment, Transpose, Wrap Text, Merge & Center, Format Painter, etc
This Training Course is taught in classrooms in the following locations:
Guide Price: £250
| Delivery: | Classroom |
| Regions: |
|
| Category: | Advanced Microsoft Excel |
| Duration: | 2 DAYS |
| Qualification: | ADVANCE EXCEL |
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 - 2013. All rights reserved.
