Lala Lajpatrai Institute of Management

Lorem ipsum dolor sit amet, consectetur adipiscing elit.            Donec nec enim eu purus rutrum placerat viverra eu elit.            Etiam eu scelerisque enim.

Lorem ipsum dolor sit amet, consectetur adipiscing elit.            Donec nec enim eu purus rutrum placerat viverra eu elit.            Etiam eu scelerisque enim.

Advance Excel Training & Workshop

 

College Name

 

 

LALA LAJPATRAI INSTITUTE OF MANAGEMENT

Name of the Event / workshop

 

“Advance Excel Training & Workshop”–Batch 2025-2027 (AY-2025-2026)

 

Resource Person

 

Mr. Pranav Shah

 

Qualification:  

MBA from N. L. Dalmia Institute of Management

B.E. (Computer Science) from Somaiya Institute of Management

Mr. Pranav Shah is working as a Fund Manager with SBI Mutual Fund.

 

He has prior work experience with Darashaw & Co. and TCS.

 

He is passionate about training and holds extensive knowledge in his domain.

 

Subject expertise:

Advance Excel

Excel Macros

Excel VBA

MS Access

Advance PowerPoint

Prezi

Visio, Open Office and MS Office

 

Date

 

 

4 Days (2nd, 5th, 8th and 9th November 2025)

12 Hours (8.00 AM  to 11:00 AM)  

Faculty In charge

Dr. Suresh Suvarna  and Prof. Pravin Narang

 

 

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Topics Covered in 4 Days

 

1. Using Excel Interface
Use the Quick Access Toolbar
Customize the Quick Access Toolbar
Use Ribbons and Tabs

Shortcut keys 

 

2. Using References in Excel
Relative cell reference

Absolute cell reference

Mixed cell reference

Using Name Manger (Define, Search, Edit and Delete Names)

 

3. Using various types of Functions in Excel
Summary (Sumif, Sumifs, Countif, Countifs, Averageif, Averageifs, Subtotal etc.)

Date (Today, Now, Month, Year, Datedif, Weeknum, Networkdays etc.)

Text (Left, Right, Mid, Concatenate, Trim, Upper, Lower, Proper etc.)

Financial (Disc, Intrate, Ipmt, Fv, Irr, Nper, Npv, Pmt, Ppmt, Price, Pricedisc, Pv, Rate, Yield, Yielddisc)

 

4. Using Lookup and Conditional Functions in Excel
Conditional Functions (If, And, Or, Nested If etc.)

Lookup Functions (Vlookup, Hlookup, Match, Index etc.)

 

5. Validating and Protecting your work
Data Validation

Hiding formulas

Protect sheet

Protect workbook

Encrypt document

 

6. Extracting useful info
Auto Filter

Advanced Filter

Remove duplicate data

Consolidate

Remove Duplicates

Formula auditing tools

Printing techniques

 

7. Arranging your data
Single column sort (Quick sort)

Multiple column sort (Data sort)

Color and custom sort

 

8. Format Data conditionally to stand out
Format data using fixed value

Format data using Absolute cell reference

Format data using Mixed cell reference (Comparison)

Format data using Formula

Format data using Data Bars

Format data using Color Scale

Format data using Icon Set

Modify and Remove CF

 

9. Using Tables to Summarize and Visualize your data
Creating Table to add dynamism to your data (Auto update) 

Creating Pivot Table

Use of sections and Layout (Row, Column, Filter and Values)

Using Predefine functions and values format

Insert Slicer

Insert Timeline

Add design to make reports attractive

Add charts to make summary visual base

 

10. Analyzing Data using predefine tools
Goal seek

Data Table 

Scenarios (Optional)

 

11. Macros

Record macros

Add button to run a macro

Edit existing macros

Delete existing macros

Macro security

 

Participants

 

MMS- SEM-I-Students, Batch-2025-27