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

LP Section 1.1.1

10+ Hrs Content

LP Section 1.1.2

20+ Modules

LP Section 1.1.3

50+ Exercises

LP Section 1.1.4

Community Forum

LP 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

Basic Functions SVG

Basic
Functions

Data Validation SVG

Data
Validation

Conditional Formatting SVG

Conditional Formatting

Charts & Reports SVG

Charts &
Reports

What IF SVG

What
IF

Vlookup SVG

Vlookup &
Hlookup

Pivot Tables SVG

Pivot
Tables

Macro Automation SVG

Macros &
Automation

Automation SVG

Power
Query Auomation

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.
LP Section 5.2
LP 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.
LP Section 5.3

A Complete Training Program

Not just video lectures but much more…

LP Section 6.1

100+ Video Lessons

Over 10+ Hrs of learning content

LP Section 6.2

Community Forum

Get doubts answered by trainers & the community

LP Section 6.3

Certification

Certificate to highlight Excel skills on resume & LinkedIn

LP Section 6.4

50+ Exercises

Download & practice all concepts on Excel files

LP 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

MBA’s

Compliance Managers

Sales & Account Executives

QA Managers

Entrepreneurs

Bank Executives & Managers

Event Planners

Research Professionals

and for every industry

What our students have to say...

Anirudh testimonial

Anirudh
Tax Consultant, Deloitte

“Most of my work revolves around Excel. Learning concepts like Pivot, Vlookup, Power Query sharpened my data analysis skills and helped me work more effectively in Excel. Will definitely recommend the course to anyone looking to learn Microsoft excel & master it.”

Deepika Testimonial

Deepika
Marketing Manager, Galleri

“At first I thought learning advanced functions would be a nightmare. But I am glad I took up the course. Earlier data analysis used to take up a lot of time but now using advance techniques & basic automation it has helped me save hours of work. “

Our students work in organizations like

About Us Page Students Section Image

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

Learn Army Logo
Learnarmy.com Copyright © 2020 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?

LP 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. From basics to advanced concepts, we’ve got you covered.

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.
LP Section 5.2

Building Efficiency

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

Working Smarter

Learning how to automate manual work and let Excel do the hard work for us. Deep diving into the advanced concepts.
LP 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
Financial Analyst
Entrepreneurs
Operations Managers
Bank Executives & Managers
IT Engineers
Event Planners
Research Professionals
Project Managers

and for every industry

What our students have to say...

Anirudh testimonial

Anirudh
Tax Consultant, Deloitte

“Most of my work revolves around Excel. Learning concepts like Pivot, Vlookup, Power Query sharpened my data analysis skills and helped me work more effectively in Excel.”

Our Students work in organisations like:

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

Learn Army Logo
Learnarmy.com Copyright © 2020 All Rights Reserved