About the Course:
How to deal with numerical data, to convert data into Business Specific information. To get right result, one should know what can be done with the data.
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.
Let's explore the beauty of 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, Sumif and 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"
Module 4: Named Ranges
Named Ranges
Application of Named Ranges
Preferring Named Ranges over other
Module 5: Handling Errors
Types of Error
Ways of handling Errors
Module 6: Data Validations
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations
Setting Input and Error Messages
Module 7: Sorting
Sorting tables
Using multiple-level sorting
Using custom sorting
Module 8: Data filter
Filtering data for selected view (AutoFilter)
Using Advanced filter
Different option available for Filtering the data.
Module 9: Conditional Formatting
Setting new Rules
Editing and Clearing Rules
Using different Kind of Conditional Formatting
Managing the Rules
Module 10: Data Consolidation
Data Consolidation need
Types of Data Consolidation
Using Data Consolidation in real time environment
Module 11: Macro Basics
How to record a Macro
How to Save, Run Macro
Editing the existing Macro.
Who should attend:
Management Professionals dealing with Data
MIS personnel
Business person
Commerce field, C.A./Would be CA
Managers
What you need to bring:
Laptop-if you have one.
(If you are looking for Computer facility, would like to be informed well in advance.)
USB
Key Takeaways:
Ability to manage your data.
Knowledge specific to Business Solution no matter which field you are in.
Opportunity to meet people from varied fields with same interest
Training Timing:
Timing: 9:30 AM- 6:00 PM
Seats: only 20
Venue: Koramangla, Bangalore
Date: July 22, 2012
For details mail me techie.excel@gmail.com
About Me: I am experienced and well qualified professional with 9.5 Years of Experience in Total. I am MS-Information Technology and MS-BI. I have joined the IT industry as a Trainee Programmer and left the full time job of Technical Consultant in 2011. Since then, I am rendering my services as Technical Consultant(Business Solution & Analysis) & Trainer.
Training Assignment I undertake are as follows:
Expertise Area: MS-Excel, Excel with VBA(Macro), MS-Word, MS-Access, MS-Power Point
Level: Beginners, Mid and Expert Level
Thanks for your time.
Regards
Rashmi Sachdeva
MS-Information Technology, M.Sc(BI)
Freelance Technical Consultant (Business Solution & Analysis) & Trainer
techieexcel.blogspot.in
http://in.linkedin.com/pub/rashmi-sachdeva/51/252/888
Contact me- 95353-28913
