Microsoft Excel Level 1-3 With Financial Modeling

Course Overview

On this Microsoft Excel training, students will learn how to create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Target Audience

Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course in the new interface.

Course Outline

Chapter 01 – Getting Started with Microsoft Office Excel 2016

Chapter 02 – Performing Calculations

Chapter 03 – Modifying a Worksheet

Chapter 04 – Formatting a Worksheet

Chapter 05 – Printing Workbooks

Chapter 06 – Managing Workbooks

Chapter 01 – Working with Functions

Chapter 02 – Working with Lists

Chapter 03 – Analyzing Data

Chapter 04 – Visualizing Data with Charts

Chapter 05 – Using PivotTables and PivotCharts

Chapter 06 – Working with Graphical Objects

Chapter 07 – Using Array Formulas

Chapter 01 – Working with Multiple Worksheets and Workbooks

Chapter 02 – Using Lookup Functions and Formula Auditing

Chapter 03 – Sharing and Protecting Workbooks

Chapter 04 – Automating Workbook Functionality

Chapter 05 – Creating Sparklines and Mapping Data

Chapter 06 – Forecasting Data

Chapter 1 – Understanding unlevered free cash flow.

Chapter 2 – Forecasting free cash flow.

Chapter 3 – Forecasting terminal value.

Chapter 4 – Present value and discounting.

Chapter 5 – Understanding stub periods.

Chapter 6 – Performing sensitivity analysis.

₦ 20,000

  • Days: Tue & Thur
  • Time: 6pm (3hrs)
  • Start Date: 2nd Nov, 2021
  • Duration: 5 weeks
× How can we help you?