Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Skills for Success: From Novice to Advanced
Rating: 4.3 out of 5(19 ratings)
71 students

Excel Skills for Success: From Novice to Advanced

Microsoft Excel, Excel Course, Excel Short Cuts, Excel Functions & Formulas
Created byAamir Shaikh
Last updated 11/2025
English

What you'll learn

  • Learn functions & formulas with the easiest & the most comprehensible examples.
  • Learn to prepare for the most Excel practical examinations.
  • Learn to master usage of Excel in an office environment.
  • Learn various charts & Pivot Table with the easiest examples.
  • Learn practically MS Excel from basic to advance.
  • Learn unique & difficult combination of different functions in Excel.
  • Students who want to learn Excel. Professionals who want to improve in Excel & bring more clarity to various options.

Course content

27 sections • 93 lectures • 5h 34m total length

  • Introduction to the Course5:08

Requirements

  • Need to have a Notebook, Laptop, Mac Book or a Personal Computer.
  • Need to have MS Office installed with any of the versions 2003, 2007, 2010, 2013, 2016, 2019.
  • It is preferable to have the recent versions of MS Office for the optimum tasks.
  • You will learn the basic & some advance uses of Excel after the end of this course.

Description

This course contains the basics to advance the learning of Excel. The quick explanation technique in video saves a lot of time, it has various functions & formulas explained in the easiest, most accurate & most comprehensible examples.

This course explains what are rows & columns how to hide/unhide & delete them, cell & range of cells & how to drag cells, how many spreadsheets in one Excel workbook, different Tabs & Ribbons, what is the Quick Access Toolbar, Name Box & Formula Bar, how to navigate Excel & how to save & save As. Applying BODMAS in Excel, learn when it will be applicable & when not.

In this course, you will get to learn the basics & advanced usage of functions like LEFT, RIGHT, MID, CONCATENATE, NOW, TODAY, EOMONTH, NETWORKDAYS, NETWORKDAYSINTL, WORKDAY, SUBTOTAL, MOD & QUOTIENT, IFERROR, List of Errors & Various Error Alerts, LOOKUP, HLOOKUP, HLOOKUP, SUMPRODUCT, SUM(Array)

VLOOKUP, PMT, PPMT, IPMT, FV, NPV & IRR, XNPV & XIRR, SUM, AVERAGE, MIN, MAX, COUNT, IF, IF AND, IF OR, IF NOT, NESTED IF, INDEX & MATCH with Vlookup, MAX, Array (Ctrl + Shift + Enter) & many more with a combination of two or more functions. I also explained how to calculate your income tax liability, considering the slab rates for USA, India & UK.

This course will explain variously charts available in Excel, it also explains the distinction between normal table/chart & Pivot table/chart. The explanation of various shortcuts available in Excel will speed up our day to day work. I am looking forward to you, subscribing to the course.

Who this course is for:

  • This course is designed for the beginner, intermediate & advanced users of Excel.
  • This course is best for students wanting to practically learn Excel.
  • This course is best for professionals wanting to bring more clarity in Excel & learn new methods.
  • This course can help various business owners & employees to get hands-on Excel.
  • Beginner

Report abuse