Course Details

Below are the main features of this Advanecd excel programme:

Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

Sum, Count, Conta, Count blank, Average, Max, Large Min, Abs, Sum if, Count if, Sum ifs, Count ifs, Lowers, Upper, Proper, Trim, Len, Left, Right, Mid,

Concatenate, Subtotal, And, Or, Day, Year, Eo month, E date, Net workdays, Today, Weekday, Week number, Workday, Find, Search, V-lookup, H-lookup, Match, Ifferror, Ifna, If, Index, Offset

Filters (Basic, Advanced , Conditional), Sort ( Ascending, Descending, Cell/ Font Colour), Single and Multiple Charts/Graphs, Conditional Formatting, Data validation, Group & ungroup, Data split.

Pivot Table and Chart, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display

Report Development - (Live Project)

Placement Assistance