Master in Excel: Become A Smart Professional


(inclusive of taxes)
12 students enrolled

Listed In
Excel and MS Office
45 days
Self-Paced Recorded
White Knight Ventures
This course is no longer available *EMI option also available


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.



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.


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


{{}} Preview


{{totalComment}} Discussion

Student Feedback



Be the first one to leave your feedback to help fellow learners.

My Review

Share your feedback

  • {{review_data.user.first_name|capitalize}}{{review_data.user.first_name}} {{review_data.user.last_name}}



    {{review_data.child_user_feedbacks[0].user.first_name}} {{review_data.child_user_feedbacks[0].user.first_name}} {{review_data.child_user_feedbacks[0].user_answer}}

All Reviews

  • {{review_data.user.first_name|capitalize}}

  • {{review_data.user.first_name|capitalize}}{{review_data.user.first_name}} {{review_data.user.last_name}}


    {{review_data.child_user_feedbacks[0].user.first_name}} {{review_data.child_user_feedbacks[0].user.last_name}} {{review_data.child_user_feedbacks[0].user_answer}}