Master Excel the Smart Way
An advanced excel program to train you on the most needed excel skills like using Vlookup, Pivot Tables, Power Query etc. Up-skill your Excel game.
10+ Hrs Content
20+ Modules
50+ Exercises
Community Forum
Excel Certification
Why Master Excel?
- Right now about ~60% of all jobs listed on Glassdoor require Microsoft Excel as a skill.
- According to BHEF & PWC, 69% of U.S Executives say they’ll prefer candidates with data skills by 2021. Source: BHEF & PWC
- Nearly 89% jobs on Glassdoor have the word “data” in their job descriptions.
- On average, certified Excel skills are found to increase likelihood of promotions & life earning by 12%. Source: goskills
It’s time to work harder smarter.
Master Excel with simple, smarter & better tutorials regardless of your Excel knowledge. From basics to advanced concepts, we’ve got you covered.
Topics Covered
Basic Functions
Data Validation
Conditional Formatting
Charts & Reports
What IF Analysis
Vlookup & Index Match
Pivot Tables
Macros & Automation
Power Query Automation
The Learning Roadmap
Mastering the Basics
- Working with formulas & functions
- Modifying Excel sheets
- Formatting data in Excel
- Working on Excel lists
- Data organisation & cleaning techniques
Building Efficiency
- Building Excel Tables
- Using Data Validation
- Date Formulas
- Using Conditional Formatting
- Mastering What IF Analysis
- Excel Charts & Dashboard
Working Smarter
- Excel VLOOKUP
- INDEX & MATCH
- Pivot Tables & Interactive Dashboards
- Automation with Macros
- Power Query & Automation
- Excel Cases & Tips (Bonus Modules)
A Complete Training Program
Not just video lectures but much more…
100+ Video Lessons
Over 10+ Hrs of learning content
Community Forum
Get doubts answered by trainers & the community
Certification
Certificate to highlight Excel skills on resume & LinkedIn
50+ Exercises
Download & practice all concepts on Excel files
Learning Library
An ever growing library with new content every month
Excel Pro is for everyone
Data Analyst
Auditors
MBA’s
College Students
Accountants & CPA’s
Tax Consultant
Financial Analyst
Operations Managers
IT Engineers
Project Managers
Data Processing
HR Managers
Admin & Assistants
Compliance Managers
Sales & Account Executives
QA Managers
Entrepreneurs
Bank Executives & Managers
Event Planners
Research Professionals
and for every industry
- Finance
- IT & Tech
- Healthcare
- Consulting
- Research
- Ops & Supply Chain
- Business Management
- Food & Beverages
Our students work in organizations like
What our students have to say...
Pricing
Excel Pro
- 8 Hrs of Video Lessons
- 50+ Practical Exercises
- 20 Modules of Adv. Excel Lessons
- Vlookup, Pivot Tables, IF Functions
-
Excel Automation Lessons -
Power Query Lessons - 1 Year Online Access
- Doubt Forum Access
- Certificate of Completion
Abhinav, Category Manager - PayTm
" I wasn’t sure if I should take up this course. But now looking back, I can say it has been one of the best courses I’ve taken. The instructor was really helpful during the entire duration of the program and helped me personally wherever I got stuck. "
Curriculum
- Basics of Microsoft Excel from opening Excel to navigating the User Interface.
- Basic mathematical operations in Excel and the order of mathematical operations.
- The basics mathematical functions Average, Count, Min, Max along with how relative & absolute references work.
Also, we’ll touch upon handling #DIV/0! error.
- Insert, delete, manage, hide, rename and move sheets as well as columns & rows in Excel
- Different data types in Excel- numbers, accounting, dates, percentages, text, boolean etc.
- Cell formatting- (font, color, styles, background, border, format painter) & alignment options.
- Inserting shapes & images in Excel.
- Using conditional formatting to analyze data
- Understanding list structures and filtering data.
- Excel functions (DSUM, DAVERAGE, DCOUNT, AND & SUBTOTAL)
- Sorting data in Excel using single-level, multi-level & custom level sort
- Cleaning & organizing data
- Using Find & Replace option in Excel
- Highlighting & removing duplicate data
- Building tables & using table formulas
- Using Freeze Pane option
- Creating data validation checks & building dynamic drop down lists
- Combining & consolidating data from multiple sheets
- Printing large sets of data
Yes, you’ll receive a certificate of completion after you attend the workshop & finish the Excel assignment
- Date, week, day, today & now function
- Text functions (LEN, SEARCH, TRIM, CONCATENATE)
- Using named data ranges in Excel
- Using IF function with normal data range & named range
- Nesting multiple functions in Excel
- Using AND & IF function together
- COUNTIF & SUBMIF function
- Using Goal Seek tool
- Creating scenarios in Excel to automate calculations & work
- Date, week, day, today & now function
- Text functions (LEN, SEARCH, TRIM, CONCATENATE)
- Basics of Vlookup
- Lookup Errors & using IFERROR
- Hlookup function
- INDEX & MATCH Function
- Using INDEX & MATCH instead of VLOOKUP
- Using closet match in Vlookup
- Building an effective data layout
- Inserting Pivot tables
- Building Pivot tables
- Using Filters & Slicers in Pivot tables
- Building dashboards & reports from Pivot tables
- Basics of Macro
- Activating developer tab in Excel
- Creating a Macro using Macro Recorder
- Editing Macro using VBA
- Linking buttons to run Macro(Automation) at a click of a button
- Protecting data in specific cells
- Protecting workbook structure
- Adding passwords to Excel files
- Installing Power Query
- Importing data from Excel, CSV, Text files & from internet
- Combing & working with data using Append method
- Combing & working with data using Merge method
- Format data in Power Query
- Merging & filtering data in Power Query
- Working with date & time data
- Creating custom columns in Power Query
- Automating steps by building conditional columns in Power Query
- Using M language in Power Query
- Unpivot data in Excel
- Automating work using Power Query
FAQ's
This is a completely self-paced program. You can watch it anytime from anywhere. You don’t have to dedicate a fixed number of hours every week.
Plus if you skip to the modules/lessons which you wanna learn, for example if your basics are already clear you can jump to intermediate & advanced lessons.
This is not a traditional program but is designed for working professionals & college students focusing extensively on practical Excel concepts which are used the most along with the advanced concepts which are often overlooked & underutilized.
Our focus is to bring your Excel skills up-to-date via detailed lessons, practice exercises & relevant cases to help you work smarter & not harder in Excel
If you’re unsatisfied with the program for any reason, you can contact us within 30 days of purchase to get a full refund.
You’ll be part of the community forum where you can easily post your doubts & questions. Which will be answered by the program trainers & even other members
Absolutely! Once you have completed the program & passed the quizzes, you’ll get a certificate of completion.
You can add that certification in your resume as well as showcase your Excel skills on LinkedIn
It’s time to work harder smarter.
Master Excel with simple, smarter & better tutorials regardless of your Excel knowledge. From basics to advanced concepts, we’ve got you covered.
Master Excel The Smart Way
Learn Ad. concepts like Vlookup, Pivot Tables, Power Query etc. Up-skill your Excel game.
- 10+ Hrs Content
- 20+ Modules
- 50+ Exercises
- Community
- Certification
Why Master Excel?
- According to BHEF & PWC, 69% of U.S Executives say they’ll prefer candidates with data skills by 2021.
It’s time to work harder smarter.
Master Excel with simple, smarter & better tutorials regardless of your Excel knowledge.
Topics Covered
- Data Validation
- Conditional Formatting
- What IF Analysis
- Charts & Reports
- Vlookup & Hlookup
- Pivot Tables
- Macros & Automation
- Power Query
The Learning Roadmap
Mastering the Basics
- Working with formulas & functions
- Modifying Excel sheets
- Formatting data in Excel
- Working on Excel lists
- Data organisation & cleaning techniques
Building Efficiency
- Building Excel Tables
- Using Data Validation
- Date Formulas
- Using Conditional Formatting
- Mastering What IF Analysis
- Excel Charts & Dashboard
Working Smarter
- Excel VLOOKUP
- INDEX & MATCH
- Pivot Tables & Interactive Dashboards
- Automation with Macros
- Power Query & Automation
- Excel Cases & Tips (Bonus Modules)
A Complete Training Program
Not just video lectures but much more…
- 100+ Video Lessons
Over 10+ Hours of learning content - Community Forum Get doubts answered by trainers & the community
- Certification Certificate to highlight Excel skills on resume & LinkedIn
- 50+ Exercises Download & practice all concepts on Excel files
- Learning Library An ever growing library with new content every month
Excel Pro is for everyone
| Accountants & CPA's | Sales & Account Executives |
|---|---|
Data Analyst | Data Processing |
MBA's | Admin & Assistants |
Compliance Managers | College Students |
Auditors | HR Managers |
| Tax Consultants | QA Managers |
|---|---|
IT Engineers | Event Planner |
Financial Analyst | Entrepreneurs |
Operations Managers | Bank Executives & Managers |
Research Professionals | Project Managers |
and for every industry
Our students work in organizations like
What our students have to say...
Pricing
Excel Pro
- 8 Hrs of Video Lessons
- 50+ Practical Exercises
- 20 Modules of Adv. Excel Lessons
- Vlookup, Pivot Tables, IF Functions
-
Excel Automation Lessons -
Power Query Automation Lessons - 1 Year Online Access
- Doubt Forum Access
- Certificate of Completion
Abhinav, Category Manager
" I wasn’t sure if I should take up this course. But looking back, I can say it has been one of the best courses. The instructor helped me at every step wherever I got stuck."
Curriculum
- Basics of Microsoft Excel from opening Excel to navigating the User Interface.
- Basic mathematical operations in Excel and the order of mathematical operations.
- The basics mathematical functions Average, Count, Min, Max along with how relative & absolute references work.
Also, we’ll touch upon handling #DIV/0! error.
- Insert, delete, manage, hide, rename and move sheets as well as columns & rows in Excel
- Different data types in Excel- numbers, accounting, dates, percentages, text, boolean etc.
- Cell formatting- (font, color, styles, background, border, format painter) & alignment options.
- Inserting shapes & images in Excel.
- Using conditional formatting to analyze data
- Understanding list structures and filtering data.
- Excel functions (DSUM, DAVERAGE, DCOUNT, AND & SUBTOTAL)
- Sorting data in Excel using single-level, multi-level & custom level sort
- Cleaning & organizing data
- Using Find & Replace option in Excel
- Highlighting & removing duplicate data
- Building tables & using table formulas
- Using Freeze Pane option
- Creating data validation checks & building dynamic drop down lists
- Combining & consolidating data from multiple sheets
- Printing large sets of data
Yes, you’ll receive a certificate of completion after you attend the workshop & finish the Excel assignment
- Date, week, day, today & now function
- Text functions (LEN, SEARCH, TRIM, CONCATENATE)
- Using named data ranges in Excel
- Using IF function with normal data range & named range
- Nesting multiple functions in Excel
- Using AND & IF function together
- COUNTIF & SUBMIF function
- Using Goal Seek tool
- Creating scenarios in Excel to automate calculations & work
- Date, week, day, today & now function
- Text functions (LEN, SEARCH, TRIM, CONCATENATE)
- Basics of Vlookup
- Lookup Errors & using IFERROR
- Hlookup function
- INDEX & MATCH Function
- Using INDEX & MATCH instead of VLOOKUP
- Using closet match in Vlookup
- Building an effective data layout
- Inserting Pivot tables
- Building Pivot tables
- Using Filters & Slicers in Pivot tables
- Building dashboards & reports from Pivot tables
- Basics of Macro
- Activating developer tab in Excel
- Creating a Macro using Macro Recorder
- Editing Macro using VBA
- Linking buttons to run Macro(Automation) at a click of a button
- Protecting data in specific cells
- Protecting workbook structure
- Adding passwords to Excel files
- Installing Power Query
- Importing data from Excel, CSV, Text files & from internet
- Combing & working with data using Append method
- Combing & working with data using Merge method
- Format data in Power Query
- Merging & filtering data in Power Query
- Working with date & time data
- Creating custom columns in Power Query
- Automating steps by building conditional columns in Power Query
- Using M language in Power Query
- Unpivot data in Excel
- Automating work using Power Query
FAQ's
This is a completely self-paced program. You can watch it anytime from anywhere. You don’t have to dedicate a fixed number of hours every week.
Plus if you skip to the modules/lessons which you wanna learn, for example if your basics are already clear you can jump to intermediate & advanced lessons.
This is not a traditional program but is designed for working professionals & college students focusing extensively on practical Excel concepts which are used the most along with the advanced concepts which are often overlooked & underutilized.
Our focus is to bring your Excel skills up-to-date via detailed lessons, practice exercises & relevant cases to help you work smarter & not harder in Excel
If you’re unsatisfied with the program for any reason, you can contact us within 30 days of purchase to get a full refund.
You’ll be part of the community forum where you can easily post your doubts & questions. Which will be answered by the program trainers & even other members
Absolutely! Once you have completed the program & passed the quizzes, you’ll get a certificate of completion.
You can add that certification in your resume as well as showcase your Excel skills on LinkedIn
It’s time to work harder smarter.
Master Excel with simple, smarter & better tutorials regardless of your Excel knowledge.
