info@ciansacademy.com +91 9818955001

Free Online MS Excel Course

KEY FEATURES


  • Completely free
  • Designed for industry requirements
  • 2.5 hours of world-class content
  • Videos and supporting Excel files
  • Certification: optional
  • Made by experts

COURSE DESCRIPTION


MS Excel is the most widely used spreadsheet program across organizations around the globe. Though MS Excel may seem useful only for number-crunching jobs such as accounting or financial analysis, proficiency in MS Excel is required for working effectively in any business domain (Sales, Operations, HR, etc.). Our structured online course 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 in using MS Excel. Proficiency in MS Excel provides the following benefits: Makes it easier to organize and interpret data Showcases the creativity and analytical capability of an individual (through the use of dynamic charts, tables, etc.) Makes a candidate employable in the eyes of recruiters
  • Working professionals looking for a shift to a Finance profile
  • College students looking for a career in Finance
  • Four lectures and 2.20 hours of quality content
  • Short and crisp videos that drive home the key points
  • Assignments to test what you have learnt
  • Made by our in-house Financial Modeling Team
  • Downloadable MS Excel files (unsolved/solved) to work on while watching the videos online
  • Three months of online access to watch the videos
  • Online Course with no Certification: FREE!!!
  • Certification Course: INR 1,700 plus GST
  • Easy online payment options

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 an 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


The following modules will be covered over 10 days:

  1. Introduction – Basic Overview of the Course
  2. Understand the Basic Layout and Setup of Excel
  3. Excel Interface
  1. Navigation & Anchoring Cells
  2. Adding/Deleting Rows and Columns
  3. Hiding/Unhiding Rows and Columns
  4. Group/Ungroup Rows and Columns
  5. Merge & Center
  6. Copying Values, Formats, Comments… (Paste Special)
  1. Basic, Number, Currency, Date and Custom formatting
  2. Fills, Fonts, Border and Alignment
  3. Conditional Formatting
  1. Filters and Sorting
  2. Drop Downs
  1. Line Chart, Bar Chart, and Combination Chart
  2. Pie Chart
  1. Autosum Shortcut Key
  2. AND
  3. AVERAGE
  4. AVERAGEIF
  5. CHOOSE
  6. CONCATENATE
  7. COUNT
  8. COUNTIF
  9. DATE, EOMONTH, TODAY, YEAR & MONTH
  10. Vlookup and Hlookup
  11. IF
  12. IRR (Internal Rate of Return)
  13. Index, Match & Index Match
  14. Max, Min and Median
  15. NPV (Net Present Value)
  16. OR
  17. IF (OR and AND)
  18. PROPER
  19. ROUND
  20. SUM
  21. SUMIF
  22. SUMPRODUCT
  23. TRIM
  24. PMT
  1. Pivot Tables
  2. Goal Seek
  1. Practice Test 1
  2. Practice Test 2

Certificate Fees (Optional)


  • Online Course with no Certification: FREE!
  • Certification Course: INR 1,700 + GST
  • Easy online payment options
  • Hard copy of the course certificate will be provided after completing the online course and paying the fees

How to access course material


  • If you are logged in, place your mouse cursor on the “My Courses” button on the right side
  • Click on MS – Excel Free button
  • You will be taken to the course dashboard that will display all the modules unit wise.
  • Click on the module units and start seeing the videos
  • Download the excel files required for the course by clicking on the blue button under the Content Download section
  • Please note that you need to mark a module as complete to see the next one