Business person, Management Professionals, Sales, Chartered Accountant, we all deal with numerical data. To assist you with all of your data and provide you business solution MIS related needs there is beautiful application MS-Excel.
Topics Covered:
Module 1: Overview of the Basics
Interacting with Excel(2007) screen
Difference between Excel 2003 and Excel 2007 Screen
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)
Other Functions:
Date and time functions
Text functions: Right, left, trim, Ltrim, Rtrim, Mid, instr, substr etc.
Database functions: Dsum, Daverage etc.
Mathematical Functions: Sum, Sumif Count, CountA, Count blank etc.
Difference Between Sum, Sumifand count, CountA functions
Using lookup and reference functions (VLOOKUP, HLOOKUP, NESTED VLOOKUP, VLOOKUP WITH APPROX MATCH & EXACT MATCH)
Module 3 B: Evaluation of Formula
Understanding Formula Evaluation concept
Using "Evaluate Formula"
In Total 11 modules are covered. For complete details of Course Outline, Venue deatils, Fee details contact at following techie.excel @ gmail.com
For Corporate Training Assignment and ConsuItancy freelance work, contact at: techie.excel @ gmail.com
Expertise Area: MS-Excel, Excel with VBA(Macro), MS-Word, MS-Access, MS-Power Point
Level: Beginners, Mid and Expert Level
When you call, plz mention that you found my contact info on Quikr!
CAclubindia
