Become a MS Excel Wizard

Elearnmarkets
Rating: 5 5 Total Reviews: 1 Reviews
Original Price: Rs. 0 Rs. 0

Introduction
Please enter correct answer
Would you like to register yourself to get free financial courses, webinars, regular updates or to participate in quizzes, games and more?Yes
{{successmsgsignup}}

This course is a structured online training program which aims to make beginners proficient in MS Excel. By the end of the course you will be able to work efficiently on MS Excel and be productive at workplace.

Our parent firm – Cians Analytics – provides financial research (Financial Modeling, Data Analytics, etc. ) for clients extensively on MS Excel. Hence, a lot of attention has been given on covering all the important topics in Excel which are used in the corporate world. 

We believe that time is money, and hence, kept the course as precise as possible. There are many courses which are of higher duration, but fail to drive home the point.

Objective

  • To make students proficient in MS - Excel
  • The focus is on imparting learning via real life examples instead of just mugging formulas
  • Bolster your chances in getting a start in the corporate world
  • Increase efficiency of professionals working in the corporate arena

Benefits

  • 44 lectures and 2.2 hours of quality content
  • The videos are short and crisp and drive home the key points
  • Downloadable MS Excel files (unsolved/solved) to work on while watching the videos  online

Certification

You can also collect a 'Certificate of Completion' from CIANS Academy at the end of your course (optional). To avail of the certificate, you need to make an online payment of Rs. 1700+Service Tax, and your certificate will be couriered at your mentioned address.

For more details related to certificate, feel free to contact info@ciansacademy.com or call at +91 981 895 5001.

Topics Covered

  • Understand the basic layout and setup
  • Get familiar with important shortcuts
  • Comprehend how to Cut, Copy, Paste, Hide, and Unhide data in rows, columns, and sheets
  • Learn Paste Special
  • Overview of Merge & Center
  • Understand Text Alignment and Text Indent
  • Learn Conditional Formatting
  • Learn Basic Charting – Pie Charts, Line Charts, Bar Charts, and Combo Charts
  • Understand Data Validation and Filters
  • Learn more than 30 basic/intermediate functions, including Sum, Sumif, And, Average, Choose, If, Vlookup, Hlookup, Count, Countif, Max, Median, Sumproduct, Today, Eomonth, NPV, PMT, IRR, Match, Index, and Proper

Intended Participants

  • Working professionals looking for accelerated growth in their current organizations
  • Working professionals looking for a shift to a Finance profile
  • College students looking for a career in Finance

Summary

2+ hours of content

8 Worksheets

Section {{section.sequence_number}} : {{section.name}}

Chapter {{chapter.sequence_number}} : {{chapter.name}}

1 Reviews

    It was a very focussed and time saving course. Learnt lots of new functions and shortcuts. The certification at nominal cost is icing on the cake
    It was a very focussed and time saving course. Learnt lots of new functions and shortcuts. The certification at nominal cost is icing on the cake
    Become a MS Excel Wizard
    Date published: 2016-06-22
    5 out of 5
  • Yobisoft Informatics Yobisoft Informatics

    10 months, 4 days ago

    It was a very focussed and time saving course. Learnt lots of new functions and shortcuts. The certification at nominal cost is icing on the cake

  • Register and Sign In

sign in

{{errmsg}}
please enter a valid password.

New Member

{{errmsgsignup}}
{{successmsgsignup}}

What's My Password?

If you have forgotten your password you can reset it here.