Advance excel crash workshop for professionals(Bangalore)- July 22

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!

 

Replies (1)

thanks ...realy nice info

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details