## 2,949

(inclusive of taxes)
12 students enrolled

Listed In
Excel and MS Office
Language
English
Difficulty
Intermediate
Validity
45 days
Program
Self-Paced Recorded
Instructor
White Knight Ventures
This course is no longer available *EMI option also available

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

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

### {{free_unit.CourseUnits.name}} Preview

#### {{totalComment}} Discussion

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

{{data.user.first_name}} {{data.user.last_name}} {{data.comment_display_time}}

{{childdata.user.first_name|capitalize}}

{{childdata.user.first_name}} {{childdata.user.last_name}} {{childdata.comment_display_time}}

#### Student Feedback

{{totalavg}}

{{all_rating.star}}
{{all_rating.value}}

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

My Review

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

{{review_data.create_date|date}}