Excel Expresso Online course in Hindi

  • 5-Day Advanced Excel Course

  • Around 450+ Minutes Will Be Provided For The Course

  • The Complete Course Will Be Taught In Hindi

  • Classes Will Be Live & Live Interaction With The Teacher. You Will Get Opportunity To Clear Your Doubts In Real-Time From The Teachers.

  • You Will Also Get The Access Of The Recorded Classes.

  • Platform: Google Meet | Course Timing: 08:30 – 10:00 PM / Weekend Batch.

Excel Brush Up

(As Wrap Text, Marg Centre, Insert Row & Column, Format Painter)

Custom Formatting

Add Zero Before Number, Add Text Before Name, How to Create Pattern Like Aadhar Card Etc

Text Function

As Trim, lower, Upper, Proper, Concatenate, Substitute, Filter & Adv. Filter

Conditional Formatting

Highlight Value, Text, Date, Add Symbol with Custom Condition

Some Function Like

Sum, Counta, Average, Max, Min and IF, Countifs and Sumifs

Pivot Table & Chart

How to Create Report by Data Wise & Chart wise

Macros

Macros With Advanced Filter and VLOOKUP

VLOOKUP

How to Search Data, Data Compile and Report Create

MIS & Dashboard

MIS process, MIS Report preparation Dashboard preparation Match Function.

Data validation

How To Create Dynamic Drop Down list?

How To Restrict Duplicate Value?

How to Restrict Age ?

How to Use Multiple Condition In Data Validation?

how to restrict weekend days in excel ?

(Read more)