33% OFF on all Financial Market Recorded courses. Use Coupon: FREEDOM33 View Courses Now
Request A Call

Advanced Excel Tutorial Online

1,250  

3.9 | 3274 students enrolled.

Listed In
Excel and MS Office
Language
English
Difficulty
Beginners
Validity
3 Years
Program
Expert-led Recorded Program
Instructor
Kredent Academy
Enroll Now

Course Highlights

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

Introduction

Microsoft Excel is perhaps the most important software programme being used today.It has become a neccessity in both business and professional life, irrespective of the role the hierachy, the business function or the industry.This course has been designed in such a way so as to enable the students to gain  a complete understanding on the advanced excel concepts  and apply such concepts to their relevant role and business.

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.

Objective

This programme will enable the students:
  • To gain knowledge on basic as well as advanced excel concepts and functions
  • To  understand the practical application of the basic as well as advanced excel concepts 
  • To develop their thought process in such a way  so as to apply their learnings in their educational or professional life

Benefits

Excel is all about increasing productivity and efficiency.

There are many things which are currently done either manually or using basic excel feature. But there are more efficient and smart ways to do it, which will save time but also increase productivity.

This course aims to provide the learners with a comprehensive knowledge bank on the basic as well as advanced excel concepts as well as their practical applications with the help of  examples.

This series of  recorded  video lectures will allow the students ansd other professionals to learn at their own pace.

After successful completion of the course , the students will receive a  “Certificate of Completion”

Topics Covered

  • An introduction to MS Excel
  • Basic Formatting
  • Numeric, Logical , Text,Data , Date and Finance Function
  • Lookup,Array and Pivot Table
  • Circ Ref&Formatting, Naming Cells or Array and Paste Special
  • Go To Excel Linkage ,Custom Format  and Excel Protection
  • Charts

 

Intended Participants

  • Anyone using or planning to use calculators or other calculating devices
  • Graduate or Post Graduate Students from any streams
  • Working Professionals from any department specially Finance, HR,Marketing ,Operations, Supply Chain
  • Business people or self-employed professionals especially CAs, Consultsants or any other stream where data is inevitable

 

Preview

{{free_unit.CourseUnits.name}} Preview

After successful completion of the course, the students will need to appear for an online examination, hosted on the website of www.elearnmarkets.com.

Procedure:

  • The student has to appear for an examination hosted on the website itself under “Test section >> Certification Test."
  • Once the student successfully clears the examination, the certificate of completition will be genrated.

Other Details:

  • Duration: 1.5 Hours
  • Pattern of Questions: Multiple Choice Questions
  • Qualifying Marks: 40% . No negative marking for this course.

Procedure for download of Certificate:

After successful completition of the examination , students can download soft copy of the certificate from the website: www.elearnmarkets.com itslef.

To download the Certificate, follow the following steps:

  • Login to www.elearnmarkets.com
  • Go to My-Courses Tab
  • Click on the Get Certificate Tab and download the certificate

Loading....

{{totalComment}} Discussion

{{loadmore}}

Student feedback ({{total_reviews}})

{{ review_data.user.first_name | capitalize}}

{{ review_data.user.first_name}} {{ review_data.user.last_name}}

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

{{ review_data.user.first_name | capitalize}}

{{ review_data.user.first_name}} {{ review_data.user.last_name}}

{{ review_data.create_date | date:'mediumDate'}}
{{ reviewloadmore}}