About the Course
Learn From Industry Expert.
If you want to excel in MS-Excel, then you should know Formula and Functions are basic building block to MS-Excel.
In this training session, I am going to cover, how you can improve work performance by using numerous formulas and functions in MS- Excel.
How to use formula with other formulas?
What component can be replaced with other components?
How to write formulas to avoid error?
Evaluation of formula.
And 20 MOST IMPORTANT SHORTCUT KEYS IN EXCEL 2007 and EXCEL 2010.
Excel Training is all about hands-on session.
Post Training Support.
Don't hesitate to clear your queries.
Topics CoveredModule 1: Overview of the Basics
Difference between Excel 2003 and Excel 2007 Screen
Interacting with Excel(2007) screen
Special feature in MS-Excel that can help you excel.
Module 2: Cell Reference and its usage in formulas
Absolute and Relative and Mixed cells reference
Preferred References in Formula
Module 3 A: Working with Functions
Writing conditional expressions (using IF, NESTED IF)
Using logical functions (AND, OR, NOT, COMPOUND IF)
Date and time functions:
VLOOKUP, HLOOKUP, NESTED VLOOKUP, VLOOKUP WITH APPROX MATCH & EXACT MATCH
Module 3 B: Evaluation of Formula
Understanding Formula Evaluation concept
Using "Evaluate Formula"
Module 4: Handling Errors
Types of Error
Ways of handling Errors
Module 5: 20 Shortcut keys combination for professionals
Who should attendManagement Professional
HR, MIS personnel
Commerce field, Would be C.A.
What you need to bringLaptop
Key TakeawaysKnowledge to manage your data.
Knowledge specific to Business Solution no matter which field you are in.