Excel Expresso Online course in Bengali

  • 5-day Advanced Excel course

  • Around 450+ Minutes will be provided for the course

  • The complete course will be taught in Bengali

  • 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)