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.

It’s time to work harder smarter
Eduolio Excel Course Section 1.1.1

10+ Hrs Content

Eduolio Excel Course Section 1.1.2

20+ Modules

Eduolio Excel Course Section 1.1.3

50+ Exercises

Eduolio Excel Course Section 1.1.4

Community Forum

Eduolio Excel Course Section 1.1.5

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

Eduolio Excel Course Basic Functions SVG

Basic
Functions

Eduolio Excel Course Data Validation SVG

Data
Validation

Eduolio Excel Course Conditional Formatting SVG

Conditional
Formatting

Eduolio Excel Course Charts & Reports SVG

Charts &
Reports

Eduolio Excel Course What IF SVG

What
IF Analysis

Eduolio Excel Course Vlookup SVG

Vlookup &
Index Match

Eduolio Excel Course Pivot Tables SVG

Pivot
Tables

Eduolio Excel Course Macro Automation SVG

Macros &
Automation

Eduolio Excel Course Automation

Power
Query Automation

The Learning Roadmap

Mastering the Basics

Building a strong foundation. Learning how to use formulas, to understating references to working with large sets of data we cover everything.
Eduolio Excel Course Section 5.2
Eduolio Excel Course Section 5.1

Building Efficiency

After basics, we’ll focus on analyzing big sets of data & making Excel find insights, trends & gaps for us.

Working Smarter

Learning how to automate manual work and let Excel do the hard work for us. Deep diving into the advanced concepts.
Eduolio Excel Course Section 5.3

A Complete Training Program

Not just video lectures but much more…

Eduolio Excel Course Section 6.1

100+ Video Lessons

Over 10+ Hrs of learning content

Eduolio Excel Course Section 6.2

Community Forum

Get doubts answered by trainers & the community

Eduolio Excel Course Section 6.3

Certification

Certificate to highlight Excel skills on resume & LinkedIn

Eduolio Excel Course Section 6.4

50+ Exercises

Download & practice all concepts on Excel files

Eduolio Excel Course Section 6.5

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

Our students work in organizations like

What our students have to say...

Anirudh
AnirudhTax Consultant @ Deloitte
Read More
Most of my work revolves around Excel. Learning concepts like Pivot, Vlookup, What IF has helped me work more effectively in Excel. Will definitely recommend the course to anyone looking to learn Microsoft excel & master it.
Abhinav
AbhinavCategory Manager @ PayTm
Read More
I wasn’t sure if I should take up the course. But now I can say it has been one of the best workshops I’ve taken. Gaurav covered all major topics which I wanted to learn. The practice files were great!
Deepika
DeepikaMarketing Manager @ Galleri5
Read More
Glad I took up the course. Finally I was able to use pivot tables & basic automation to save a ton of my time
Abhinav
AbhinavFounder @ Abhimaa
Read More
Never knew learning Excel could be this easy. Gaurav gave good pointers on using Excel for managing and tracking sales for our retail operations.
Trilochan Mohanty
Trilochan MohantyITC
Read More
Excellent way of explanation and real practical examples helped for grasping the contents easily.
Mayuri Malviya
Mayuri MalviyaStudent @ Norwegian School of Economics
Read More
The course was very well designed and taught. Highly recommend for college students who want to skill up for jobs. Looking forward to more courses.
Previous
Next

Pricing

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

  1. Basics of Microsoft Excel from opening Excel to navigating the User Interface.
  2. Basic mathematical operations in Excel and the order of mathematical operations.
  3. The basics mathematical functions Average, Count, Min, Max along with how relative & absolute references work.
    Also, we’ll touch upon handling #DIV/0! error.
  1. Insert, delete, manage, hide, rename and move sheets as well as columns & rows in Excel
  2. Different data types in Excel- numbers, accounting, dates, percentages, text, boolean etc.
  3. Cell formatting- (font, color, styles, background, border, format painter) & alignment options.
  4. Inserting shapes & images in Excel.
  5. Using conditional formatting to analyze data
  1. Understanding list structures and filtering data.
  2. Excel functions (DSUM, DAVERAGE, DCOUNT, AND & SUBTOTAL)
  3. Sorting data in Excel using single-level, multi-level & custom level sort
  4. Cleaning & organizing data
  5. Using Find & Replace option in Excel
  6. Highlighting & removing duplicate data
  1. Building tables & using table formulas
  2. Using Freeze Pane option
  3. Creating data validation checks & building dynamic drop down lists
  4. Combining & consolidating data from multiple sheets
  5. Printing large sets of data

Yes, you’ll receive a certificate of completion after you attend the workshop & finish the Excel assignment

  1. Date, week, day, today & now function
  2. Text functions (LEN, SEARCH, TRIM, CONCATENATE)
  1. Using named data ranges in Excel
  2. Using IF function with normal data range & named range
  3. Nesting multiple functions in Excel
  4. Using AND & IF function together
  5. COUNTIF & SUBMIF function
  6. Using Goal Seek tool
  7. Creating scenarios in Excel to automate calculations & work
  1. Date, week, day, today & now function
  2. Text functions (LEN, SEARCH, TRIM, CONCATENATE)
  1. Basics of Vlookup
  2. Lookup Errors & using IFERROR
  3. Hlookup function
  4. INDEX & MATCH Function
  5. Using INDEX & MATCH instead of VLOOKUP
  6. Using closet match in Vlookup
  7. Building an effective data layout
  8. Inserting Pivot tables
  9. Building Pivot tables
  10. Using Filters & Slicers in Pivot tables
  11. Building dashboards & reports from Pivot tables
  1. Basics of Macro
  2. Activating developer tab in Excel
  3. Creating a Macro using Macro Recorder
  4. Editing Macro using VBA
  5. Linking buttons to run Macro(Automation) at a click of a button
  1. Protecting data in specific cells
  2. Protecting workbook structure
  3. Adding passwords to Excel files
  1. Installing Power Query
  2. Importing data from Excel, CSV, Text files & from internet
  3. Combing & working with data using Append method
  4. Combing & working with data using Merge method
  5. Format data in Power Query
  6. Merging & filtering data in Power Query
  7. Working with date & time data
  8. Creating custom columns in Power Query
  9. Automating steps by building conditional columns in Power Query
  10. Using M language in Power Query
  11. Unpivot data in Excel
  12. 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.

Eduolio.com | Copyright © 2021 | All Rights Reserved

Master Excel
The Smart Way

Learn Ad. concepts like Vlookup, Pivot Tables, Power Query etc. Up-skill your Excel game.

It’s time to work harder smarter

Why Master Excel?

Eduolio Excel Course Section 2.1
  • 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

The Learning Roadmap

Mastering the Basics

Building a strong foundation. Learning how to use formulas, to understating references to working with large sets of data we cover everything.
Eduolio Excel Course Section 5.2
Eduolio Excel Course Section 5.1

Building Efficiency

After basics, we’ll focus on analyzing big sets of data & making Excel find insights, trends & gaps for us.

Working Smarter

Learning how to automate manual work and let Excel do the hard work for us. Deep diving into the advanced concepts.
Eduolio Excel Course Section 5.3

A Complete Training Program

Not just video lectures but much more…

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...

Anirudh
AnirudhTax Consultant @ Deloitte
Read More
Most of my work revolves around Excel. Learning concepts like Pivot, Vlookup, What IF has helped me work more effectively in Excel. Will definitely recommend the course to anyone looking to learn Microsoft excel & master it.
Deepika
DeepikaMarketing Manager @ Galleri5
Read More
Glad I took up the course. Finally I was able to use pivot tables & basic automation to save a ton of my time
Abhinav
AbhinavFounder @ Abhimaa
Read More
Never knew learning Excel could be this easy. Gaurav gave good pointers on using Excel for managing and tracking sales for our retail operations.
Abhinav
AbhinavCategory Manager @ PayTm
Read More
I wasn’t sure if I should take up the course. But now I can say it has been one of the best courses I’ve taken. Gaurav covered all major topics which I wanted to learn. The practice files were great!
Trilochan Mohanty
Trilochan MohantyITC
Read More
Excellent way of explanation and real practical examples helped for grasping the contents easily.
Mayuri Malviya
Mayuri MalviyaStudent @ Norwegian School of Economics
Read More
The course was very well designed and taught. Highly recommend for college students who want to skill up for jobs. Looking forward to more sessions.

Pricing

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

  1. Basics of Microsoft Excel from opening Excel to navigating the User Interface.
  2. Basic mathematical operations in Excel and the order of mathematical operations.
  3. The basics mathematical functions Average, Count, Min, Max along with how relative & absolute references work.
    Also, we’ll touch upon handling #DIV/0! error.
  1. Insert, delete, manage, hide, rename and move sheets as well as columns & rows in Excel
  2. Different data types in Excel- numbers, accounting, dates, percentages, text, boolean etc.
  3. Cell formatting- (font, color, styles, background, border, format painter) & alignment options.
  4. Inserting shapes & images in Excel.
  5. Using conditional formatting to analyze data
  1. Understanding list structures and filtering data.
  2. Excel functions (DSUM, DAVERAGE, DCOUNT, AND & SUBTOTAL)
  3. Sorting data in Excel using single-level, multi-level & custom level sort
  4. Cleaning & organizing data
  5. Using Find & Replace option in Excel
  6. Highlighting & removing duplicate data
  1. Building tables & using table formulas
  2. Using Freeze Pane option
  3. Creating data validation checks & building dynamic drop down lists
  4. Combining & consolidating data from multiple sheets
  5. Printing large sets of data

Yes, you’ll receive a certificate of completion after you attend the workshop & finish the Excel assignment

  1. Date, week, day, today & now function
  2. Text functions (LEN, SEARCH, TRIM, CONCATENATE)
  1. Using named data ranges in Excel
  2. Using IF function with normal data range & named range
  3. Nesting multiple functions in Excel
  4. Using AND & IF function together
  5. COUNTIF & SUBMIF function
  6. Using Goal Seek tool
  7. Creating scenarios in Excel to automate calculations & work
  1. Date, week, day, today & now function
  2. Text functions (LEN, SEARCH, TRIM, CONCATENATE)
  1. Basics of Vlookup
  2. Lookup Errors & using IFERROR
  3. Hlookup function
  4. INDEX & MATCH Function
  5. Using INDEX & MATCH instead of VLOOKUP
  6. Using closet match in Vlookup
  7. Building an effective data layout
  8. Inserting Pivot tables
  9. Building Pivot tables
  10. Using Filters & Slicers in Pivot tables
  11. Building dashboards & reports from Pivot tables
  1. Basics of Macro
  2. Activating developer tab in Excel
  3. Creating a Macro using Macro Recorder
  4. Editing Macro using VBA
  5. Linking buttons to run Macro(Automation) at a click of a button
  1. Protecting data in specific cells
  2. Protecting workbook structure
  3. Adding passwords to Excel files
  1. Installing Power Query
  2. Importing data from Excel, CSV, Text files & from internet
  3. Combing & working with data using Append method
  4. Combing & working with data using Merge method
  5. Format data in Power Query
  6. Merging & filtering data in Power Query
  7. Working with date & time data
  8. Creating custom columns in Power Query
  9. Automating steps by building conditional columns in Power Query
  10. Using M language in Power Query
  11. Unpivot data in Excel
  12. 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.

Eduolio Excel Course Green Logo
Eduolio.com | Copyright © 2021 | All Rights Reserved