MS Excel Champion - Level 2

Agenda of the program:

Module 1: New Features in the recent versions of Excel

• Functions: lambda, let, xlookup, xmatch, sort, sortby, filter, unique, textjoin, trimmean, randarray, sequence, concat, ifs, maxifs, minifs, switch, formulatext
• Data Types
• Clipboard Collection
• Forecast Sheet
• Dynamic Array and Spilling
• Find and Select Objects
• Mysterious SumProduct function and its uses
• Elastic formulas
• Locking and security features in Excel

Module 2: Data analysis and Modelling

• What if Analysis: Goal seeking, Scenario Manager, Data Table and Solver
• Data Analysis Toolpack: Correlation, Multi Linear Regression and Fourier Analysis
  
• Statistical Analysis
  
• Trend Analysis
• Forecasting (Time series and new functions)
• Normal Distribution/Normal Standard Distribution
• P Value
• Montecarlo Simulation

Module 3: Data Analysis – Continued:

• Various kinds of Charts – Column, Bar, Pie, Line, ScatterXY, Stock, Radar, Surface, Doughnut, Bubble, Waterfall Model, Box and Whisker, Pareto, Histogram, Sunburst, Treemap, Map, Funnel, Combo etc.
• Dashboard and Infographics in Excel by using images, iconsets etc.,
• Creative use of Emojis. Excel Camera features.

Module 4: Introduction to Power Query/Power Pivot

• Extracting data from different sources like text, csv, xml, pdf, json, odbc etc.,
• Cleaning and Transforming Data
• Loading the data-to-data model
• M Language
• DAX functions
• Measures
• Concept of Context Transition

Module 5 : Macros and Advanced VBA:

• Macros – Relative and Absolute with case studies
• Using Excel User Interface in Developers area
• Introduction to VBA – User defined Functions, Macros, Conditions, Looping
• Referring ranges and other excel objects
• Creating simple User forms

Special Highlights of the Course:

• The courses are fully live instructor led programs
• Recordings of the classes to be provided
• Class files, working notes and dashboards created in the classes are provided
• Practical assignments + Live Projects
• Certificate of completion
• Post training support through whatsapp/email/calls

For more details, please call or whatsapp Biplab SenGupta on 8130826342