Advanced Excel Master Class
₹1,499.00
Description
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
Reviews
There are no reviews yet.