+91 9818955001

Advanced MS Excel Training

Duration: 12 Hours Fees: INR 3,000 + GST*,  Weekday Batch Starts: Dec 12, 2017,  Weekend Batch Starts: July 1, 2018


  • Must for Sales/HR/Operations Professionals
  • Customization for Corporates on Request
  • Certificate of Completion
  • CA/CFA Faculty
  • Focus on learning with real-life examples
  • Small batch size for focused attention


MS Excel is the most widely used spreadsheet program across organizations around the globe. Though MS Excel may seem useful only for a number-crunching job like accountant or financial analyst, proficiency in MS Excel is required for working effectively in any business domain (Sales, Operations, HR, etc.). Proficiency in MS Excel provides the following benefits:
  • Makes organizing and interpreting information robust
  • Showcases the creativity of an individual (through the use of dynamic charts, tables, etc.)
  • Makes a candidate more employable in the eyes of the recruiters
lieu rencontre 03 Our past students have been placed in companies such as Fidelity, KPMG, BlackRock, Axis Bank, EY, Finvista, and REquity. Many have also been absorbed internally in Cians Analytics.
  • 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
  • 2-day classroom training spread over 12 hours
  • Program fee: INR 3,000 plus GST


  • Cians Academy is the training vertical of Cians Analytics (based out in Gurgaon)
  • The courses are especially relevant for people who want to work in the financial services industry or become conversant with financial analysis
  • Our students have been placed in many reputed finance companies apart from getting absorbed in Cians Analytics as Analyst


  • click Cians Analytics is a financial research and consulting firm that works primarily with global private equity firms, hedge funds, and investment banks
  • The range of work at Cians Analytics includes studies focused on analyzing and valuing companies using best financial modeling practices, helping with due diligence and various other analyses

COURSE CONTENT After completing MS Excel training course, students will be able to address the following questions:

  1. Understand the basic layout and setup
  2. Familiarize themselves with important shortcuts
  3. Comprehend how to Cut, Copy, Paste, Hide, and Unhide data in rows, columns, and sheets
  4. Overview of Merge & Center
  5. Understand Text Alignment and Text Indent
  6. Learn Custom Formatting and Conditional Formatting
  7. Learn Basic/Advanced Charting
  8. Understand how to make Pivot tables
  9. Understand Data Validation and Filters
  10. Utilize Goal Seek to validate assumptions
  11. Protecting and Sharing – Cells, Worksheets, and Workbooks
  12. Learn basic functions, including Sum, Sumif, And, Average, Choose, Vlookup, Hlookup, Count, Countif, Max, Median, Sumproduct, Today, Eomonth, NPV, PMT, and IRR
  1. Learn Advanced Charting – Dynamic charts, Waterfall charts, Gantt charts, etc.
  2. Learn Advanced functions, including Offset, Array, Yield, Transpose, Forecast, Text, Mod, Db, Sln, Imptm, Ppmt, Find, Len, Right, Mid, and Mirr
  3. Analyze Advanced Pivot Tables
  4. Learn Advanced Conditional Formatting

Batch Dates