Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced MS Excel - Become a pro
Rating: 4.0 out of 5(28 ratings)
119 students

Advanced MS Excel - Become a pro

Take your productivity to the next level
Created byAnurag Singal
Last updated 1/2025
English
English [Auto],

What you'll learn

  • MS Excel

Course content

3 sections • 17 lectures • 3h 53m total length

  • Lesson 1_Warming Up31:08

    Master absolute and relative references with the address function; validate data with drop-downs, protect sheets, and leverage basics like sum, max, min, and date calculations.

  • Lecture 2_Data Analytics9:53

    Master sorting data by buyer and amount, applying filters by value, color, and text, and using subtotals to compute per-buyer totals and grand totals for practical data analytics in Excel.

  • Lesson 3_Data Lookup24:26

    Explore data lookup in Excel using vlookup and hlookup, including exact and approximate matches, absolute references, and how to combine criteria with index and match for robust lookups.

  • Lesson 4_Pivot Table23:35

    Learn to build pivot tables from data, design dynamic dashboards with slicers and charts, and perform aging and invoice analysis using lookups, absolute references, and unique identifiers.

  • Lesson 5_Logical Functions10:23
  • Lesson 6_MIS Reporting8:46
  • Lesson 7_Data Cleaning25:23
  • Lesson 8_Scenario Building6:30
  • Lesson 9_Financial Functions6:24

    Explore Excel financial and statistical functions, focusing on the EMT function to calculate loan payments, present value, and future value, and split payments into interest and principal.

  • Lesson 10_Charting14:55
  • Lesson 11_Formula Auditing3:18

    Lesson 11_Formula Auditing

  • Lesson 12_Keyboard Shortcuts3:18

Requirements

  • Nil

Description

Advanced MS Excel

Join us on this journey to become a proficient Excel user. Enroll now and empower yourself with the skills that are essential in today's data-driven world!

The operational efficiency of any knowledge professional can improve significantly with an up gradation of his/her skills of MS Excel. With every additional function that you learn, life can become a lot easier.

Have structured the course as follows:

1) Warming Up

2) Data Analytics

3) Data Lookup

4) Pivot Table

5) Logical Functions

6) MIS Reporting

7) Data Cleaning

8) Scenario Building

9) Financial Functions

10) Charting

11) Formula Auditing

12) Keyboard Shortcuts

I hope this will significantly enhance your efficiency on the workfront

Don’t just read this book like a novel. Practice it and the learning curve will be the steepest

‘The proof of the pudding lies in the eating’. So let the videos make their sales pitch themselves


Why Take This Course?

  • Practical Learning: Learn by doing with hands-on exercises and real-world examples.

  • Lifetime Access: Get unlimited access to course materials, updates, and resources.

  • Expert Guidance: Benefit from the expertise of our experienced instructor, who will guide you through each concept with clarity and detail.

  • Community Support: Connect with fellow learners in our dedicated community forums, sharing insights and solving challenges together.

Who this course is for:

  • Advanced Excel students

Report abuse