By Mayank Chaturvedi

Advance Excel, Excel with AI & Power BI Course

·        Excel Basic

o  Formatting, Conditional Formatting, Rows, Columns, Tables, Sorting

·        Excel Functions

o  Sum, Average, Sumif, Count, Countif, etc.

o  Text Functions

·        Excel Statistics & Logical Functions

o  Mean, Median, Mode, Rank, Small, Large, AND, OR, IF, IF-ELSE

·        Excel Lookup functions

o  V-lookup, Hlookup, Xlookup, Index, Match, Index-Match etc.

·        Excel Charts

o  Pie, Chart, Bar Chart, Tree Map, Line Chart

·        Excel Pivot Table

o  Intro to Excel Pivot Tables, Formatting the Pivot Tables, Grouping in an Excel Pivots,

o  Calculated Fields, Pivot Table Slicers, Pivot Charts.

·        Data Cleaning in Excel

o  Data Validation, Cleaning in Excel, Types of Errors in Excel, Date functions.

·        Dashboard in Excel

o  Sales, Finance, Supply Chain, Marketing Dashboards in Excel

·        Exploratory Data Analysis(EDA) in Excel

·        Financial Analysis in Excel

o  Balance sheet, Cashflow statement, Portfolio Analysis, Business Valuation

·        Excel Macros

o  Understanding Excel Macros, Automating Repetitive task, Macro Recorder.

·        Excel Interview Questions

·        Excel with AI

o  Excel with ChatGPT, ChatGPT for automating repetitive tasks in MS Excel, AI Tools in Excel, Using ChatGPT with Excel Formulas, Data Cleaning and Transformation with ChatGPT, Data Analysis with ChatGPT

      Power BI

o Overview of PowerBI

o DAX Commands and Functions

o Reports and Dashboards

o Data Model Performance Optimization