Advance Excel by Mr Vikas

Course Discontinued

This course is no longer available and has been discontinued

Topic Name	Topic Length
Indroduction to Ribbons: Basic Functions: Find, Replace, Formatting, Alignment, Sorting, Filter, Cell Referencing, Range Concept, Define Name, Sum(), Average, Count(), Counta(), Countblank()	2 Hours
Mathematical Functions: sumif(), sumifs(), Countif(), Countifs(), Averageif(), Averageifs(), Vlookup(), Hlookup(), row(), column(), Max(), Min(), Large(), Small(), sqrt(), power(), round(), If (), nested if(), proper(), Upper(), lower(), left(), right(), mid(), trim, len(), find(), search(), repeat(), Concatenate()	2 Hours
Text Functions & Data Validation: Datediff(), yearfrac(), day(), month(), year(), now(), today(), weekday(), hour(), minute(), second(), Sparklines, Charts (Line, Bar, column, Pie, Doughnut, Waterfall, sunburst, tree & combo), Data Validation	2 Hours
Pivot Table & Charts	2 Hours
Misc: Security/Protection, Grouping & Ungrouping, Subtotal, Hyperlink, Flashfill, Text to column, Paste special	2 Hours

For GST Plus Subscribers**

Platinum Members: 599

Gold members: 799

Silver Members: 999

** Call to avail this offer.

Recordings will be available within 24 hours.

Meet Your Instructor

Mr Vikas

Vikas is a Business Analyst in a well renowned company. He has done a Masters in Computer Application from IGNOU University.
He has been providing Data Visualization, Advance Excel, Storytelling through data and Power BI classes for the last 14 years on various platforms (online, corporate training, institutes, personal coaching etc). He has an expert in Process Optimization and Data Analysis.