Advanced Excel Master Class



What will you Learn?

⭐Getting started with Excel, Data & Tables|Day-1,2,3

✅Intro to Excel

✅Creating Tables

✅Filter & Sort Data

Power Query

✅Data Cleaning

✅Merging multiple sheets into one

⭐Formulas | Day-4,5,6,7

✅IF condition

✅Lookup Formulas

✅Array Formulas

✅Conditional Formulas

✅Text analysis

✅Sentiment analysis

✅Exploratory data analysis

✅Date formulas

✅Error Handling

⭐Pivot Table | Day-8,9,10

✅Creating Pivot table

✅Multiple Pivot relationships

✅Calculations in Pivot

✅Data Slicing

✅Adv. Pivot table

⭐Graphs & Charts | Day-11,12,13

✅Choosing charts

✅Formatting charts

✅Conditional Charts

✅Interactive charts

⭐Validation & Publishing | Day-14,15

✅Data validation

✅Creating templates

✅Publishing to the web

✅Form controls

✅Custom ribbons

⭐VBA Macros | Day-16,17,18,19,20

✅Excel VBA Object Model

✅Why Collections are a VBA Essential

✅VBA versus Worksheet Functions

✅Table of Contents(TOC) in one click

✅Sales regional reporting Tool

✅Invoice generation tool

⭐Dashboards | Day-21,22,23,24

✅Introduction to Dashboard

✅Process of

✅Different Dashboards for all types of data {Sales Dashboard, Employee Dashboard, etc.}

✅Web-enabled dashboard

⭐Solving some Real-time Problems in a company using Excel| Day-25,26,27

✅Pivot table for consolidation of bulk data with some conditions

✅Multiple Google Forms data to Single Master Sheet for bulk data

✅Displaying Sheet data on the website with filers & Search

⭐Advanced | Day-28,29,30

✅Overview of BI Tools to analyze data effectively

✅How to handle sheets from the Python program

✅Integration of Excel for various business purposes


There are no reviews yet.

Be the first to review “Advanced Excel Master Class”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.