info@ciansacademy.com +91 9818955001

Advanced MS Excel Training

Duration: 12 Hours Fees: INR 3,000 + GST* , Weekday Batch Starts: Oct 31,2017

3,000 Enroll Now

KEY FEATURES


  • 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

COURSE DESCRIPTION


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
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
  • Click on the “Enroll Now” button and complete the payment via CC Avenues payment gateway
  • In case of any query, please write to us at info@ciansacademy.com or call us at 9818955001
  • You an also send any query by filling Contact Us Form
  • Program fee: INR 3,000 plus GST

CIANS ACADEMY


  • 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

CIANS ANALYTICS


  • 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


  • Weekday: Oct 31 and Nov 7
  • The classes will be conducted at our Gurgaon center