This course is no longer available

In Excel and MS Office

Become a MS Excel Wizard

  • Basic
  • English
  • 1686 Learners
  • Validity: 1 years
yellow color star5.0 Rating

Course Highlights

  • 44 Videos
  • 2+ Hours of Content
  • 5+ Supplementary Study Materials
  • Full Length Test

Introduction

MS Excel Tutorial 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 this online tutorial in excel as precise as possible. There are many courses which are of higher duration, but fail to drive home the point.

What Will You Learn?

  • 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 

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

Get Certified

Enhance your career prospects with a Elearnmarkets certification!

Certificate image

No preview video is available at this moment

Discussions

    Become a MS Excel Wizard
    Cians Academy

    Instructed By

    Cians Academy

    2,006

    *incl. of Taxes

    This course is no longer available
    loading
    loading