-47%

Advanced Excel Course

admin
Last Update October 3, 2022
0 already enrolled

About This Course

Advanced Excel Course

Financial Planning & Analysis: Building a Company’s Budget from Scratch guides you through the core principles of Financial Planning and helps you to understand how a company prepares its budget. The video lessons touch on several technical topics such as revenue forecasting, cost planning, working capital development, fixed assets roll-forward, and cash flow calculation.

Besides that, we will discuss why firms need budgets, which are the financial statements that a company uses to create its budget, what types of budgets are there, which are the main techniques used in financial planning, who is involved in the preparation of a budget, and who is interested in the final numbers that are signed-off in the budget. Specializing in these topics will turn you into a valuable, indispensable member of any company’s Finance team.

Course participants will learn all the key Excel functions and features using Advanced Microsoft Excel tools from basic to mastery level of excel expertise, after completing the course participants would be able to perform their day-to-day job in more productive and professional way to improve organizational performance. 

Learning Objectives

Learn how to analyze the financial statements using different metrics
Dissect a company's health and profitability.

Material Includes

  • Videos
  • Booklets

Requirements

  • Absolutely no experience is required.
  • Microsoft Excel 2010, 2013, or 2016

Target Audience

  • People Who Want a Successful Career in Finance
  • Anyone Who Wants to Learn How to Create a Corporate Budget

Curriculum

21 Lessons31h 15m

Excel Foundation

Getting Started with Excel
Data Entry, Data Editing, and Number Formatting
Data Formatting00:00:00
Working with Cells and Ranges in Excel00:00:00
Managing Worksheets00:00:00

Formula / Data / Charts Concepts

Using Advanced Functions

Working with Macros & Custom Functions

Reporting & Dashboards