Vimal Gupta

Years of Experience in Microsoft Excel Training classes

11

Teaching Experience in detail in Microsoft Excel Training classes

11 Years of Corporate Experience with 6+ Years of Training experience. I have trained more than 100 Students for MS Excel In different Industries at different levels. MS Excel Basics and Advanced Excel Advance Formulas e.g. Index, Match, Vlookup, Hlookup, Sumifs, Offset, Arrays etc. Pivot Table and Analysis Excel Analysis tools e.g. SubTotal, Scenario Manager, Goal Seek etc. Advance Charting and Dashboards development Dynamic Chart and Dynamic Dashboards Excel Macro Excel VBA MS Excel for Supply Chain Management, Pricing Analysis, Date & Time, Project Management etc. Automation Projects in MS Excel.

Years of Experience in Tableau Training

4

Teaching Experience in detail in Tableau Training

11+ Years experience in Excel VBA and Macro • Pivot table Basics and Advance • Inserting calculated field in Pivot table and working with slicer • Pivot Charts (Creation of Chart, Altering of Chart, Filtering A Pivot Chart) • Group and Subtotal Analysis in Excel • Data Sorting and Filter techniques Basics and Advance • Text Functions e.g. Mid, Len, Left, Right, Concatenate etc. • Date and Time Functions e.g. Date, Time, DatedIF, Networkdays and Workday etc. • Uses of Advance Excel Functions . • Goal Seek and Scenarios Manager. • Data Analysis techniques using more than one features of MS Excel. • Excel Charts e.g. Creating, Formatting and Modifying Charts etc. • Tips and Magic Tricks of Advance Excel with Advance Shortcut Keys. • Creating Dynamic charts and Dashboards (including one project of KPI Dashboard) • Conditional Formatting (including one project on live procurement and sales data) • Excel Macro Basics and Advance (Macro Recording, Execution and Scope)