Big Savings Offers will expire in 2 days. Get up-to 35% Off on the courses & webinars. Hurry! Tap to GET COURSE NOW

1,500

*inclusive of taxes

Enroll Now

Advanced Excel & Financial Calculations

1,769

1,500

*inclusive of taxes

Enroll Now

1,769

1,500

*inclusive of taxes

Enroll Now

Course Details

359963 students enrolled

Request A Call

About Course

  • Listed In : Excel and MS Office
  • Language : English
  • Difficulty : Intermediate
  • Validity : 3 Years
  • Program : Self-Paced Recorded
  • Instructor : Anirudh Saraf

Enroll Now

Course Highlights

  • 27 Videos
  • 10+ Hours of Content
  • 10+ Supplementary Study Materials

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.

Advanced  Excel Tutorial  covers both fundamental as well as advanced  excel concepts. 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 course is to equip the participants with all the knowledge, understanding, and practice that they need to be able 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.

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.

{{free_unit.CourseUnits.name}}

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.

Student Reviews

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|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.child_user_feedbacks[0].user.first_name}} {{review_data.child_user_feedbacks[0].user.last_name}} {{review_data.child_user_feedbacks[0].user_answer}}

{{ reviewloadmore}} {{ reviewloadmore}}

OPEN DEMAT AND TRADING ACCOUNT & Get 100% Cashback on Brokerage for 3 Months on purchase of courses above ₹999*

Buy any course or webinar or webinar plans above 1000 to avail this offer.

View Details