Microsoft Excel - Excel from Basics to Advance

About Microsoft Excel - Excel from Basics to Advance

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.