Create a Financial Statement using Microsoft Excel

Microsoft Excel is the tool of choice for most accountants and financial professionals, and possessing advanced Excel skills can make a real difference to your career prospects. However, many bookkeepers and financial officers lack the fundamental Excel skills required to carry out daily tasks efficiently and accurately. These abilities include the use of logical tests and ‘IF’ statements, lookups and pivot tables.

Course Overview

This course has been designed and developed by an accountant and focuses on the Excel skills used daily in the industry. Some of these skills are basic, such as summing with criteria and using logical tests. However, some are advanced, like the use of dynamic arrays. Each of our topics represents a necessary ability for the job and familiarity with some of the newer features of Excel 365 can put you ahead of the curve. This training program will enable participants to acquire the practical knowledge required to build reliable financial models that can be applied to corporate planning and evaluation. Participants will learn best practice design concepts for designing adaptable models using a variety of financial modelling in excel techniques and functions that are used when creating a complete financial model from scratch.

What you’ll learn
  • Understand the role of Microsoft Excel in financial statement preparation and analysis..
  • Develop proficiency in using Excel’s features and functions specific to financial statements.
  • Learn techniques for organizing and manipulating financial data effectively.
  • Master the creation of income statements, balance sheets, and cash flow statements in Excel.
  • Gain skills in performing financial statement analysis using Excel’s formulas and tools.
  • Build dynamic financial models for forecasting and scenario analysis.
  • Enhance data visualization and reporting capabilities for financial statements.
  • Acquire practical tips and tricks for improving efficiency and accuracy in financial statement tasks.
Requirements

Candidates must;

  • Be proficient in English Language.
  • Have access to either a computer or smartphone with internet connectivity.
  • Be equipped with quality webcam and headphones.
Duration & Fees
  • Regular – 10 Weeks – ₦170,000
  • Fast-Track – 8 Weeks – ₦255,000
Program Dates
  • December, 2023 – February, 2024
  • March – May, 2024
  • June – August, 2024
  • September – November, 2024

User Avatar

EDUREX Academy

0.0
40 Students
331 Courses
Main Content