Microsoft Excel For All – Students + Professionals

Excel in Excel

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.

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

  • Basics of Excel –> 7 lectures • 24min.
  • Fill Series: –> 2 lectures • 5min.
  • References –> 3 lectures • 10min.
  • Conditional Formatting: –> 3 lectures • 12min.
  • 3D SUM: –> 1 lecture • 3min.
  • Hyperlink –> 1 lecture • 4min.
  • Drop-Down List: –> 2 lectures • 7min.
  • Date Functions –> 5 lectures • 11min.
  • Subtotal –> 2 lectures • 10min.
  • MOD QUOTIENT: –> 1 lecture • 2min.
  • ERRORS –> 2 lectures • 8min.
  • LOOKUPS –> 7 lectures • 18min.
  • Time Calculation in Excel –> 1 lecture • 2min.
  • Financial Functions –> 5 lectures • 17min.
  • Freeze Panes –> 1 lecture • 8min.
  • IF Function –> 7 lectures • 23min.
  • WhatifAnalysis: –> 5 lectures • 17min.
  • An example of the manner & method with which I have taught in the course. –> 1 lecture • 3min.
  • INDEX & MATCH FUNCTIONS –> 2 lectures • 4min.
  • Macros & Relative Reference –> 4 lectures • 14min.
  • Protect Sheet –> 1 lecture • 5min.
  • Formula Auditing –> 1 lecture • 6min.
  • Some Good to Know Features –> 1 lecture • 3min.
  • Charts –> 3 lectures • 8min.
  • Pivot Table & Charts –> 2 lectures • 6min.
  • Simple & Dependent Drop-Down List –> 2 lectures • 7min.
  • Short Cuts in Excel –> 3 lectures • 7min.
  • Introduction –> 1 lecture • 3min.

Microsoft Excel For All – Students + Professionals

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

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.