One Day Workshop on Advance
Excel 2007 (July 22, 2012)
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:
Topics Covered:
Module 1:
Overview of the Basics
Interacting with Excel(2007) screen
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
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)
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
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
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
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
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
USB
Key Takeaways:
Ability to manage your data.
Knowledge specific to Business Solution no matter which field you are in.
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.5Years of experience.
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
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
Online training available.
For details mail me techie.excel@gmail.com
Online training available.
For details mail me techie.excel@gmail.com