Learn Basic to Advance Excel from Scratch – Master Course

Mastering the art of MS Excel from Basics to Advance Level

This is a 100 % practical course specially designed for Finance Professionals, Beginners, School Students, MBA Professionals, Graduate Students to master the art of MS Excel. In this course, almost all necessary tools, functions, commands are included which will make you a real professional. After learning this course students shall be able to work in excel at a lighting speed. This course will enhance your speed, office productivity and will add skill to your professional life.

What you’ll learn

  • Hands on all Basic to Advance shortcuts required in Ms Excel.
  • All Advance Functions like Lookup Functions, If related all functions, Time Value of Money Functions, Data Analysis Functions etc..
  • All kind of Charts like Tree Chart, Columunar Chart, Sparkling Charts, Bar Chart, Bridge Chart etc..
  • All functionalities related to Goal Seek, Ranking Sensitivity Analysis, Pivot Tables, Loan Schedule etc..
  • All functionalities related to Errors, Text, Basic & Advance Formatting, Filtering, Sorting etc..

Course Content

  • Introduction to Ms Excel –> 2 lectures • 9min.
  • Introduction to Basic Functions of Ms Excel and Regular Shortcuts –> 2 lectures • 10min.
  • Basics of Formatting in Excel –> 2 lectures • 13min.
  • Introduction to Formulas in Excel –> 5 lectures • 55min.
  • Introduction to Advance Functions –> 7 lectures • 1hr 27min.
  • Date Functions –> 2 lectures • 10min.
  • Pivot Tables –> 1 lecture • 12min.
  • Introduction to Charts –> 5 lectures • 23min.
  • Other Advanced Functions –> 4 lectures • 18min.
  • Lookup Functions –> 2 lectures • 8min.
  • Ranking & Sensitivity Analysis –> 2 lectures • 18min.

Auto Draft

Requirements

  • You need a Laptop with MS Excel, PDF Viewer and a Good Internet Connection.
  • Second and the foremost thing you need is : “YOUR WILL to practice along side the class”.

This is a 100 % practical course specially designed for Finance Professionals, Beginners, School Students, MBA Professionals, Graduate Students to master the art of MS Excel. In this course, almost all necessary tools, functions, commands are included which will make you a real professional. After learning this course students shall be able to work in excel at a lighting speed. This course will enhance your speed, office productivity and will add skill to your professional life.

This course includes the following functions: 1) Basics of Excel 2) Home Tab Function 3) Mathematical operators 4) Lookup Functions 5) Time Value of Money Functions 6) Date Functions 7) Text Functions 8) Logical Functions 9) Error Functions 10) Basic Formatting 11) Advance level formatting 12) Goal Seek Function 13) Ranking & Sensitivity Analysis etc.

This is a 100 % practica course specially designed for Finance Professionals, Beginners, School Students, MBA Professionals, Graduate Students to master the art of MS Excel. In this course, almost all necessary tools, functions, commands are included which will make you a real professional. After learning this course students shall be able to work in excel at a lighting speed. This course will enhance your speed, office productivity and will add skill to your professional life.

This course includes the following functions: 1) Basics of Excel 2) Home Tab Function 3) Mathematical operators 4) Lookup Functions 5) Time Value of Money Functions 6) Date Functions 7) Text Functions 8) Logical Functions 9) Error Functions 10) Basic Formatting 11) Advance level formatting 12) Goal Seek Function 13) Ranking & Sensitivity Analysis etc.

Get Tutorial