A comprehensive training course with up to date material to practice at home and during your class. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills.
Why Advance Excel Skills are important?
Excel spread sheets are the most powerful tool, extensively used for reporting and analysis. There is a way to make it an even more powerful tool in the management of your business. The benefit of additional Microsoft Excel training will give you a more efficient vision of your operation as well as improve your analytical and reporting skills.
Whether you're looking for a beginner, intermediate or advanced Excel training program, you won't be disappointed in the end result. You will learn valuable tips and tricks to improve your excel skills. Course contents:
Summing Techniques
IF, Cell References, Formula Linking,etc
New Formulas of Excel 2007 Sumifs, Countifs, Iferror
Database Formulas
Subtotal (Formulae & Procedure)
Tables
Macros
Look up References (Vlookup, Hlookup,etc)
Data Validation
Conditional Formatting
Date & Time Formulas
Charts & Graphs
Protection & Security
Goal Seek
Groupings
Pivot Table
Pivot Table Charts
Hyperlinks
Scenario
Hlook ups
Vlookups
Web workbooks
Sharing Workbooks