info@ciansacademy.com +91 9818955001

Finance for Non-Finance Professionals

Duration: 12 Hours Fees: INR 7,000 + GST* Weekday Batch Starts: May 10 and 11, 2017

7,000 Enroll Now

KEY FEATURES


  • Ideal for people from non-finance background
  • Learn to make and analyze financial statements
  • Certificate of Completion
  • CA/CFA Faculty
  • Customized training for corporates

COURSE DESCRIPTION


Financial Accounting is an esoteric subject for professionals from a non-finance background. In the real world, professionals have to deal with all sorts of financial data as they grow in their careers. Consequently, they are expected to take decisions on business operations and finance and understand their implications on the performance of a company. Our Finance for Non-Finance Course will help them to learn the important aspects. The business reports its results in the form of accounting language; hence, it is imperative to understand how various transactions are recorded. This course serves as a comprehensive accounting overview for non-finance professionals and a good refresher course for finance professionals who often struggle to read and interpret financial statements. The course will provide an understanding of financial accounting and financial statement analyses.
  • The course is relevant for anyone with little or no knowledge of finance
  • Customers with commerce/accounting backgrounds can also sign up, as a refresher course
  • Corporates looking to make their employees get the right financial knowledge to excel at workplace
  • 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 9818-955-001
  • You an also send any query by filling Contact Us Form
  • Program fee: INR 7,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 the 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: May 10–11, 2017 (10:30 AM–5.00 PM)
  • The classes will be conducted at our Gurgaon center