Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Training on Business Analytics with Excel

By: McTimothy Associates Consulting LLC  

Lagos State, Nigeria

24 - 26 Aug, 2022  3 days

Follow Event

  

NGN 125,000

Venue: The Professional Place 12B, Olumoroti Street, Gbagada Phase 2 Estate, Gbagada Lagos

Other Dates

Venue Date Fee  
The Professional Place 12B, Olumoroti Street, Gbagada Phase 2 Estate, Gbagada Lagos, Lagos State, Nigeria 07 - 09 Dec, 2022 NGN125000

The training is a compilation of the most important methods used for financial analysis in business. The first part is an introduction to financial modelling (from selecting tools to conceptual model building). The next part is the practical applicability in which we deal with a great number of examples discovering new techniques and advanced features of Excel needed in business analysis. The last part is dedicated to building financial models and tackling popular problems of financial analysis with the help of the trainer.

The training is highly practical; participants work on solutions of business problems with a trainer’s assistance. Due to this approach, participants discover a great number of applicable solutions which may be later used in a lot of situations.

Who is this training for?

The training is aimed at people who deal with preparing analyses and financial models in Excel.

What will I learn?

  • Create effective financial models in Excel
  • Verify and bulletproof financial calculations
  • Use advanced Excel functions such as Vlookup or Index
  • Create appropriate references and control calculations stages
  • Use Excel functions to format your models
  • Learn to model interests, ROI, depreciation
  • Use pivot tables to aggregate data and present the output
  • Use VBA to automatize repetitive tasks
  • Create scenarios and model-based simulations
  • Create presentations with Excel

Course outline

  • Introduction to business modelling with Excel
  • Building financial model
  • Modelling techniques
  • Financial modelling with Excel
  • Financial modelling functions
  • Formatting tools in Excel
  • Financial modelling tools
  • Financial model examples
  • Stress testing, Scenario modelling, Sensitivity risk analysis
  • Graphical model presentation

Prerequisites:

Basic MS Excel

The Professional Place 12B, Olumoroti Street, Gbagada Phase 2 Estate, Gbagada Lagos Aug 24 - 26 Aug, 2022
The Professional Place 12B, Olumoroti Street, Gbagada Phase 2 Estate, Gbagada Lagos, Lagos State, Nigeria 07 - 09 Dec, 2022
NGN 125,000.00
(Convert Currency)

Blessing Aguta 09080022449, 08058805333

5% Group Discount for 3-5 participants, or 10% Group Discount for 6 and above participants

Related Courses

The Strategic Marketing Plan Course The Strategic Marketing Plan Course

3 days, 13 - 15 Jul, 2022 

2022-07-13 12:07:00 2022-07-13 12:07:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

A marketing plan clarifies the key marketing elements of a business and maps out directions, objectives, and activities for the business and its employees. This course tackles several aspects of a ...

Advanced Customer Service Skills and Relationship Management Advanced Customer Service Skills and Relationship Management

3 days, 12 - 14 Sep, 2022 

2022-09-12 12:09:00 2022-09-12 12:09:00
Rivers State, Nigeria

McTimothy Associates Consulting LLC

This training will help you keep customers, build market share and improve the performance of the entire workforce with a superior customer service strategy.  Learn how you can increase your ...

Developing Purchasing Policies, Processes and SLAs Course Developing Purchasing Policies, Processes and SLAs Course

2 day, 23 - 24 Jun, 2022 

2022-06-23 12:06:00 2022-06-23 12:06:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Purchasing policies, processes and Service Level Agreements (SLAs) guide the activities of purchasing professionals and their business partners, and provide a functional and moral compass. To ensure ...

Corporate Travels and Protocol Management Course Corporate Travels and Protocol Management Course

3 days, 12 - 14 Oct, 2022 

2022-10-12 12:10:00 2022-10-12 12:10:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

 For most companies, travel is the second largest controllable expense. In order to control the expense, you must know how to manage travel spend. The Fundamentals of Business Travel Management. ...