Master in Excel: Become A Smart Professional

Introduction

Excel is a powerful tool which helps professionals in tackling data. It helps in presenting, analysing, summarising and sorting data like no other tool. Professionals in all streams use this tool to enhance their application and analysis skills of the information at their disposal. With the increasing amount of data being used by companies, use of tools like Excel has become mandatory for all professionals to be effective and efficient.

 

Objective

This course aims at giving detailed knowledge on Excel and it is suitable both students and working professionals. This programme  is divided into  3 levels thus making it suitable for both beginners and advanced level. This course is a must for the students of financial modelling and equity valuation.

Benefits

The wide coverage and simplicity in explanation of various topics makes this programme  extremely popular among the masses. The detailed explanation with the help of relevant practical illustrations makes your learning easier. 

After successful completion of the course students will receive a certificate facilitated by White Knight Ventures. To see a sample of the certificate Click here

Topics Covered

Level 1:

  • Excel Basics
  • Excel as a Calculator
  • Error
  • Sort and Filter
  • Charts
  • Formatting

Level 2:

  • Aggregrate
  • Function Wizard
  • Cell Referencing
  • Logical Functions
  • LOOKUP Functions
  • INDEX MATCH Functions
  • Data Time text Functions
  • Nested Functions
  • Annoating Functions
  • Conditional Formatting
  • Custom Number Formatting
  • Hyperlink

Level 3:

  • Auto Filter
  • Subtotal
  • Data Consoldiation
  • Data Validation
  • Sumif and Countif Functions
  • Age Calculator
  • Nested IF
  • Pivot Tables and Charts
  • Goal Seek
  • What If-Scenario Manager
  • Password Protection
  • Import and Export Data
  • Amortization of Loans
  • Sparkline, Trendline, Candlestick Charts
  • Macros
  • VBA
  • SUMIF and COUNTIF Functions 

Once taken, you can access this course for a period of 1 month.

Intended Participants

  • Students
  • Working professionals
  • Financial modelling and equity valuation students
  • Computer application students

Section {{section.sequence_number}} : {{section.name}}

Chapter {{chapter.sequence_number}} : {{chapter.name}}

  • Register and Sign In

sign in

{{errmsg}}
please enter a valid password.

New Member

{{errmsgsignup}}
{{successmsgsignup}}

What's My Password?

If you have forgotten your password you can reset it here.