
Explore the fundamentals of Excel, including workbooks, worksheets, cells, and the two-dimensional grid of columns and rows, and how the formula bar supports calculations in financial modeling.
Explore the home ribbon in Excel, mastering clipboard, format painter, font, borders, alignment, wrap text, merge and center, number formats, styles, and sheet protection for finance models.
Explore the other ribbons in Excel for finance, including insert, pivot table, charts, maps, slicer, add-ins, and the data analysis toolpak, with emphasis on financial modeling.
Learn how relative referencing in Excel tracks cell distances when copying formulas, using F4 to fix columns or rows, enabling scenario analysis with absolute, column-fixed, and row-fixed references.
Learn to create a one dimensional data table to test profit under varying cost or revenue assumptions and validate results.
Master essential Excel functions like sum and sum product, average, count, counta, max, and min to compute totals, analyze data, verify number formats, and support basic financial modeling.
Learn how financial modelling uses a formula with logical operators to determine when profit post tax is positive, considering negative profit before tax and tax loss carry forwards.
Explains the if function in Excel, using a logical test to return a value if true or false, and shows a buy or sell recommendation based on the PE ratio.
Explains how to implement a nested if function in Excel to assign grades A, B, C, or D based on the overall average, using criteria 60, 50, and 36.
Explore Excel operators with sum if, sum ifs, average ifs, and countifs. Learn to set criteria ranges and sum ranges, applying greater than and less than conditions to sales data.
Explore how pivot tables organize sales data by year, city, and product to reveal turnover and units sold; learn to use filters, slicers, and pivot charts for dynamic, multi-dimensional analysis.
Learn how to use vlookup to retrieve customer names and profits from Nash Software Private Limited sales data, with exact-match and leftmost-column table concepts, plus index and match alternatives.
Discover the limits of vlookup’s leftmost lookup and master index and match to retrieve revenue by order number and, with a single formula, return the corresponding customer number.
Learn to communicate finance data with Excel charts by building axis charts, radar, waterfall, underwater drawdown curves, and the whammy index to visualize performance.
Master data visualization using Excel by selecting charts that communicate the intended message to the audience. Apply best practices to balance clarity, color sobriety, and effective communication.
Are you looking to learn Excel, but finding it very difficult with all the technical jargons and concepts been thrown around?
Are you looking to make your life easier and make Excel work for you and save time?
Are you giving interviews but are not able to clear because of your Excel skills?
Don’t worry, we have got you covered here. We will teach you Excel right from beginners level, (Really, we will start right from what is Excel), and go on all the way till advance level.
This course does not require you to have any pre-requisite knowledge or skills. This course will teach everything from beginning. This course has got you covered for everything.
In this course, you will learn the following:
Excel Introduction: Here you will learn how excel is structured. You will learn about Excel Worksheets, cells, and tabs. You will learn about Cell Referencing and its importance.
Excel Operators: In this section, how to write a function in Excel and make use of different functions and operators, such as logical operators and conditional operators, which are available in Excel.
Excel Data Analysis: Excel is widely used to analyse data and build models. Here you will learn how you can analyse data using Pivot, VlookUp and create various charts and dashboards for Data Visualization.
Time Value of Money: Here we will delve into Finance concept of Time Value of Money. We will learn its importance and we will apply it in Excel.
Financial Statement Analysis: Finally, in this section we will learn about Financial Statements, and we will create these financial statements and build a 3-statement Financial Model in Excel.
Learn from the best:
The Trainer of this course is an Ex-fund manager, Equity research analyst and CFA charter holder
· Extensive experience with fund management in alternative investments
· Lead Trainer at – Mentor Me Careers
· Vast 11 Years of Experience in Fund Management, Product Management & Entrepreneurship.
· Trained 3000+ students in premier institutions
· Renowned Visiting Faculty in top tier 1 MBA colleges
· Ex-Partner- Ennovate Research Investment and Capital, Hedge Fund
What do you get:
· Well-designed focussed content on explaining concepts and building skills
· Extensive question bank and case studies for practice
· Downloadable course materials
· Regular course updates
· Forum doubt-solving answers quickly
After this course, you will be able to:
· Master Microsoft Excel for daily work
· Make your own personal Financial Plan
· Analyse Finances of a company from their Financial Statements
· Build 3 statements Financial Model and forecast values
About this Course
· This course has 30-day Money Back guarantee. We believe in providing value to the student. So, you get to explore the course and make an informed choice.
· You will get 24x7 doubt solving access.
· All concepts covered with practical application
We always strive to put student’s learning experience over everything else. So, we do look-out for your feedback on how we can improve our course and give our students a better learning experience. So, any suggestions for improving the learning experience is always welcomed.