Excel Master Class - Day 20/30 - Sanjay Kumar

У вашего броузера проблема в совместимости с HTML5

If You Haven’t Register for this Excel Event till now, Register Now: https://forms.gle/9a6YjfwqZTWsAozz8
————————————————————————————————————-
4 in 1 Combo = Python + Excel + D.A + M.L - https://pages.razorpay.com/Excellaunchoffer
4 in 1 Combo ( international payment link) - https://buy.stripe.com/4gwaGY8jb3ugdfG6oA

Internship on Excel @RS.499 - https://rzp.io/l/Excelecertificate
For International Payment : https://buy.stripe.com/00gaGY9nfgh26RicMW
————————————————————————————————————-
Connect with Your Speaker: https://www.linkedin.com/in/sanjay-kumar-a-p-4447801a5/
—————————————————————————————————————
????Event Venue: Youtube
????Event Date : 13th July to 16th August
⏰Event Timing : 7.30 P.M - 8.30 P.M

What you will Learn on This 30 Days Master Class Series:

The Objective of this Webinar Series is to facilitate the participants to Learn the indepth knowledge on All in one Business / Data analysis tool - Excel to solve more data problems in a simple way

⭐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

Note: No. of Date for lectures might be changed a bit.
—————————————————————————————————————
????‍????‍????‍????Community:
????Join in Telegram: https://telegram.me/+rVQjE02xUPthMjU1
????Pantech Solutions Youtube Channel: https://www.youtube.com/user/pantechsolutions
—————————————————————————————————————
Happy Learning
M.K Jeevarajan
DIRECTOR
PANTECH PROLABS INDIA