Limited Seats 28th November, 2022
Special offer for GST PLUS Subscribers**
Platinum Members : 599.00
Gold Members : 799.00
Silver Members : 999.00
Starting Date: 28-11-2022
Timing: 8:15 PM - 10:15 PM (Monday to Friday)
Ending Date: 02-12-2022
Language: Hinglish
Faculty: Mr Vikas
S.No | Date | Topic | Duration | Detailed Coverage |
---|---|---|---|---|
1 | Monday, 28 November, 2022 | Indroduction to Ribbons | 2 Hours | Basic Functions: Find, Replace, Formatting, Alignment, Sorting, Filter Cell Referencing, Range Concept, Define Name, Sum(), Average, Count(), Counta(), Countblank() |
2 | Tuesday, 29 November, 2022 | Mathematical Functions | 2 Hours | 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() |
3 | Wednesday, 30 November, 2022 | Text Functions & Data Validation | 2 Hours | Datediff(), yearfrac(), day(), month(), year(), now(), today(), weekday(), hour(), minute(), second(), Sparklines, Charts (Line, Bar, column, Pie, Doughnut, Waterfall, sunburst, tree & combo), Data Validation |
4 | Thursday, 1 December, 2022 | Pivot Table & Charts | 2 Hours | Pivot Table/Chart |
5 | Friday, 2 December, 2022 | Misc | 2 Hours | Security/Protection, Grouping & Ungrouping, Subtotal, Hyperlink, Flashfill, Text to column, Paste special |
Mr 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.