# Workshop: Advance Excel 2007

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)

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

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

Contact me- 95353-28913

Event from : 22 July 2012
Event to : 22 July 2012
Events Venue : Koramangla, Bangalore

Submitted By :

Subscribe to Events Feed