Financial Calculations & Excel Made Easy

Intermediate
English
379130 Learners
Validity: 3 Years

Request A Call 4.4 Rating

Instructed By

Anirudh Saraf

Request a Call

Course Highlights

90+ Videos
13+ Hours of Content
30+ Supplementary Study Materials
Self Evaluation Tests
Certificate of Completion

Introduction

Excel is one of the most widely and extensively used applications around the world. From offices to homes, from professionals to students, from homemakers to artists, everybody needs Excel for professional or personal work. But unfortunately, most people who use Excel, do it in a very limited way because most people are not aware of the full spectrum of tools and functionalities provided by Excel. These tools and features are very easy to learn and will multiply the utility of Excel for you several times. It will also make you very efficient and effective in using Excel.

This advanced excel course covers both fundamental as well as advanced excel topics. It ensures that the participants not only understand these concepts with the help of well-designed examples but also develop the thought process so that they can apply the learning in their day-to-day education or professional life.

About the Trainer

Anirudh Saraf

A practicing Chartered Accountant with about 15 years of post-qualification experience. Founder and Proprietor at Saraf A & Associates, Chartered Accountants, Kolkata. Audit, taxation and F&A consulting and outsourcing, teaching and training.

Objective

The focus of this advanced excel course is to equip the participants with all the knowledge, understanding, and practice they need to use MS Excel easily, effectively, and efficiently. In this course, we cover the entire range of topics, from the very basics to the advanced topics.

Benefits

No prior knowledge of Excel is required.
From most basics to the advanced topics covered in a single course.
Detailed explanations with an adequate practical demonstration for best understanding.
Assignment sheets are provided for each topic for a better understanding.

Topics Covered

Basics of Excel
Formatting tools and options
Various functions – mathematical, statistical, text, date and time, logical, lookup, financial, etc.
Various tools in Excel for managing and manipulating data
Power query and power pivot
Charts and pivot charts
Interactive dashboards
Handling errors and other useful features of Excel

Intended Participants

This course is useful for anybody who wants to use Microsoft Excel for any kind of work, personal or professional
No prior knowledge of Excel is required at all and therefore, this course is perfectly suitable for absolute beginners also.

Get Certified

Enhance your career prospects with a Elearnmarkets certification!

Section {{$index + 1}}: {{section.name}}

Chapter {{$index + 1}}: {{chapter.name}}

Unit {{$index + 1}}: {{unit.name}} Preview

Under this course “Advanced Excel & Financial Calculations” the participant will be required to appear for the online examination hosted on the website of Elearnmarkets.com. Please note that the participant will get the Certificate of Completion for the course, only after passing the Certification Test provided in the course.

Procedure:

The student has to appear for the Certification Test hosted on the website itself under “Self-Evaluation Test >> Certification Test”
In case, the student does not clear the Certification Test, he/she can re-appear the same after 8 hours
In case of any further assistance, drop in an email to support@kredentacademy.com or call: 9051622255

Other Details:

Duration: 40 minutes.
Pattern of questions: Multiple choice based questions of 2 marks each.
No Negative Marking
Qualifying marks: 60%

Certificate of Completion:

After successful completion of the online examination, participants need to go to the "My Certificate" tab in Student Dashboard to download the certificate for the respective course.

Loading....

{{totalComment}} Discussions

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

Reply View {{data.child_course_comments.length}} replies Hide {{data.child_course_comments.length}} replies ({{data.total_up_vote}}) ({{data.total_down_vote}})

{{data.create_date| date:'mediumDate'}}

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

({{childdata.total_up_vote}}) ({{childdata.total_down_vote}})

{{childdata.create_date| date:'mediumDate'}}

Instructed By

Anirudh Saraf

999

*incl. of Taxes

Request a Call

Enroll Now

{{totalavg}}/5

{{totalUserReview}} {{totalUserReview==1 ? 'user': 'users'}} reviewed

My Review

Share your feedback

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

{{review_data.create_date|date}}

Edit

{{review_data.user_answer}}

{{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.create_date|date}}

{{review_data.total_like}}

{{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}}