Microsoft Excel For All – Students + Professionals

Excel in Excel

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.

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, accurate & most comprehensible examples for all. This course explains what are rows & columns how to hide/unhide & delete them, cell & range of cells & how to drag cells, who 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. The application of BODMAS in Excel, learn when it will be applicable & when not.

In this course, you will get to learn the basics & advance usage of functions like LEFT, RIGHT, MID, CONCATENATE, NOW, TODAY, EOMONTH, NETWORKDAYS, NETWORKDAYSINTL, WORKDAY, SUBTOTAL, MOD & QUOTIENT, IFERROR, LOOKUP, HLOOKUP, HLOOKUP

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 & many more with a combination of two or more functions.

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