Chat on WhatsApp

Advanced Excel Masterclass



Price: 1,500 INR

About Course

More than 90% of professionals use MS Excel in their day-to-day life. Excel is a powerful tool that has become entrenched in business processes worldwide—whether for analyzing stocks or issuers, budgeting, or organizing client sales lists.

This course is specially designed by keeping the CA, CS, CFA, FRM, CAIA, CIPM in mind BUT it's equally useful to others also.

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As a Trainer, I will use my 10+ years of training experience to guide you step by step through the beginner to advanced level in this journey.

Starting with the fundamentals will offer you a strong foundation and more understanding as you continue to topics at the intermediate and advanced levels. We have also tried to focus on the small small things while dealing with excel which can make daily tasks easier.

At completion of this course, you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Introduction to Excel Basic 
  • Mathematical Functions 
  • Absolute and Relative References 
  • Conditional Formatting 
  • Group and Ungroup 
  • Text Functions 
  • Advanced Text Functions 
  • Date Functions 
  • Logical Functions 
  • Data Validation 
  • Lookup Functions 
  • Is Functions 
  • Round Functions 
  • Sorting 
  • Pivot Tables 
  • Different Charts 
  • Dashboards

Material Includes

  •  7+ Hours of High-quality Videos
  •  Exercise Files
  •  Handouts
  •  e-Books
  •  Unlimited Watch Time for 1 Year
  •  Verifiable e-Certificate

Requirements

 MS Excel installed

 Appetite to Learn

Audience

 All Professionals

 CA, CS, CFA, FRM, CAIA, CIPM, MBA, Others

What Will You Learn?

  •  Master Microsoft Excel from Beginner to Advanced
  •  Maintain large sets of Excel data in a list or table
  •  Create dynamic reports by mastering one of the most popular tools, PivotTables
  •  Learn the most common Excel functions used in the Office
  •  Apply dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  •  Access to a Professional Trainer with 10+ years of Excel Training

Meet your Instructor

Hiren Kakkad

CEO & Founder

Stat Modeller

  •  More than 10 years of industrial experience
  •  Awardee of the Training Quality Excellence Award by IQAC and ISTD
  •  Certified Trainer by NSDC & Skill India
  •  Certified by Google Analytics Academy for Data Studio
  •  Certified Lean Six Sigma Black Belt
  •  Trained 11000+ participants
  •  Guided 150+ Improvement projects
  •  Assisted 50+ Research Projects
  •  Trainer for in Data Analysis, R, Python, SPSS, Minitab, Power BI, Excel, Advanced Excel, Six Sigma, TPM, Kaizen, 5-S, Kanban etc.

Get your Verifiable Certificate

Strengthen Your Professional Profile with a Verifiable Certificate

Course Curriculum

Basic Mathematical Functions
  • Welcome to the Course and Downloadable Material
  • Download Material
  • Min, Max, Sum, Average
  • Count, CountA, CountBlank
  • SumIF AverageIF, CountIF, SumProduct
  • Large, Small
  • Rank - Use Case
  • Absolute
  • Aggregate
Absolute and Relative References
  • Relative Reference
  • Absolute Reference
  • Mixed Reference
Conditional Formatting
  • Highlight Cell Rules
  • Top/ Bottom Rules
  • Data Bars
  • Color Scale
  • Icon Set
Group and Ungroup
  • Column Grouping
  • Row Grouping
  • Row and Columns Grouping
Text Functions
  • Text Cleaning
  • Text Cases
  • Text Join
  • Text to Column-Delimited
  • Text to Column-Fixed width
Advanced Text Functions
  • Left, Right, Middle
  • Len (Length Function)
  • Find, Search, Replace, Substitute
Date Functions
  • Date function Overview
  • Today and Now Function
  • Day, Month, Year Function
  • Adding and Subtracting from Date
  • Net Working Days
Paste Special
  • Paste Special
Logical Functions
  • Logical Operators Part 1
  • Logical Operators Part 2
  • IF Function
  • Nested IF Function
  • IF with AND Function
  • IF with OR Function
Data Validation
  • Whole Number
  • Decimal Number
  • Dropdown List
  • Date and Time
  • Text Length
Lookup Functions
  • VLOOKUP Concept
  • VLOOKUP - Exact Match Part 1
  • VLOOKUP - Exact Match Part 2
  • VLOOKUP - Approximate Match
  • HLOOKUP - Exact Match
  • HLOOKUP - Approximate Match
  • INDEX MATCH Function
IS Functions
  • IS Functions
Round Functions
  • ROUND, ROUNDUP, ROUNDDOWN
  • CEILING and FLOOR
  • MROUND
Sorting
  • Sort by Numeric Data
  • Sort by Text Data
  • Sort by Date Data
NEW - Financial Functions
  • Calculate EMI using PMT, IPMT and PPMT Function
  • Calculate Future Value of Investment using FV Function
Pivot Tables
  • Importance of Pivot Table
  • Convert Normal Table into Excel Table
  • Use of Filter in Pivot Table
  • Slicer in Pivot Table
Data Visualization
  • Importance of Visualization
  • Visualization Game
  • Use of Different Charts
Dashboards
  • Basics of Dashboard
  • Case Study
  • Blueprint of Dashboard
  • Prepare Cards using Pivot Table
  • Summary and Line Chart
  • Bar Chart and Pie Chart
  • Geo Map
  • Formatting of Chart
  • Geo Map Formatting and Summary Table
  • Title Logo and Cards
  • Final Dashboard
Feedback
  • Your Feedback
FINAL EXAM
  • Exam Instructions
  • Final Exam
Chat on WhatsApp