Excel and Advance Excel

LIVE

72 Hours

₹ 3,000 per month.

₹ 3,000 1-on-1 Class

Just Pay ₹1,000 to Register

- OR -

Course offered by Payel Motilal

0 review

🔹 BASIC EXCEL

1. Introduction to Excel

Microsoft Excel overview
Spreadsheet concept
How to open MS Excel
Workbook & Worksheet
Rows, Columns, Cells
Cell address & cell pointer

2. Worksheet Management

Insert, delete, rename worksheet
Move & copy worksheet
Protect worksheet
Shortcut keys in Excel

3. Data Entry & Cell Formatting

Data entry techniques
Number, date & text formatting
Wrap text
Merge cells
Currency symbols
Increase & decrease decimals
Cell styles
Row height & column width
Insert / delete / hide / unhide rows & columns

4. Editing & Utility Tools

Find & Replace
Shapes
Hyperlinks
Format as table

5. Basic Formulas & Functions

AutoSum
SUM
SUBTRACTION
MULTIPLICATION
DIVISION
AVERAGE
MAX
MIN
COUNT

6. Data Management

Sorting data
Filtering data

7. Cell Referencing

Relative referencing
Absolute referencing
Mixed referencing

8. Charts & Printing

Insert charts
Page setup
Printing options

🔹 ADVANCED EXCEL

9. Text Functions

CONCATENATE
LEN
LOWER
UPPER
TRIM
SUBSTITUTE
LEFT
RIGHT
EXACT

10. Math & Statistical Functions

SQRT
PRODUCT
ABS
SUBTOTAL
COUNTIF
SUMIF
MAXIF
MINIF
AVERAGEIF

11. Date & Time Functions

NOW
TODAY
NETWORKDAYS

12. Logical & Error Handling Functions

IF
IF with AND
IF with OR
IFERROR
MOD

13. Advanced Data Tools

Advanced Filter (AND / OR)
Text to Columns
Remove Duplicates
Data Validation
- Whole number
- Text length
- List validation
- Circle invalid data

14. External Data Handling

Import data from Access
Import data from Text files

15. Pivot Table & Data Analysis

Pivot table creation
Pivot table fields & areas
Grouping & nesting
Filters & slicers
Pivot charts
Value field settings
Pivot table design & analysis tools
Multiple table analysis

16. Consolidation & Database Functions

Consolidate data
Database functions:
- DAVERAGE
- DPRODUCT
- DCOUNT

17. Conditional Formatting

Highlight cell rules
Data bars
Color scales
Icon sets

18. View & Sheet Utilities

Comments
New window
Arrange all
Freeze panes

19. What-If Analysis

Scenario Manager
Goal Seek
Data Tables
Solver

20. Financial Functions

21. Lookup & Reference Functions

VLOOKUP
HLOOKUP
XLOOKUP
MATCH
INDEX
CHOOSE
TRANSPOSE

22. Formula Auditing & Visualization

Trace precedents
Trace dependents
Show formulas
Sparklines

23. Excel Integration

Linking Excel with MS Word

24. Macros & VBA (Introduction)

Macro recording
Developer tab
Basic VBA concepts
Command button
Message box
Simple calculations using VBA

25. Advanced Reporting & Dashboard

Advanced reporting concepts
Pivot-based reporting
Conditional formatting for reports
Charts for analysis
Interactive reports (filters, slicers)
Dashboard creation
Dashboard design principles

About the Trainer

Avg Rating

0 Reviews

0 Students

4 Courses

Payel Motilal

Bachelor of Commerce (B.Com.) from Calcutta University in 2019

3 Years of Experience

I started my professional journey in 2021, working in a CA firm for one year, where I gained hands-on experience in accounting work, documentation, and practical Excel usage. After that, I worked for two years in a tax consultancy firm, handling taxation-related tasks, data management, and Excel-based reports used in daily office work.

Later, I joined an educational institute, where I taught Excel, Advanced Excel, MS Word, and Tally for more than 6 months. This role helped me develop strong teaching skills and understand how to explain technical concepts clearly to students of different levels.

After that, I started teaching at Youth Computer Training Center, where I have been teaching Excel, Advanced Excel, and Tally for more than 9 months. Along with teaching, I focus on practical, job-oriented training that reflects real office and professional requirements.

With both industry experience and teaching experience, my goal is to help students build real skills they can confidently use in office and job environments.