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

08 - 10 Sep, 2021  3 days

Follow Event

  

NGN 125,000

Venue: The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos.

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, Lagos. Sep 08 - 10 Sep, 2021

Registration: 10:00:am - 04:00:am

NGN 125,000.00
(Convert Currency)

Blessing Aguta 09080022449, 08058805333

Related Courses

Strategic Thinking and Planning Workshop Strategic Thinking and Planning Workshop

3 days, 28 - 30 Oct, 2021 

2021-10-28 12:10:00 2021-10-28 12:10:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

An organization without a strategy is like a ship without a rudder. How can organizations continue to provide exceptional value to stakeholders and customers if they are not clear on where they are ...

Intermediate Tableau Business Intelligence Course Intermediate Tableau Business Intelligence Course

2 day, 28 - 29 Sep, 2021 

2021-09-28 12:09:00 2021-09-28 12:09:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Tableau has emerged as one of the most popular Business Intelligence solutions in recent times, thanks to its powerful and interactive data visualization capabilities. You will embark on this ...

Becoming Highly Productive and Effective Administrator Course Becoming Highly Productive and Effective Administrator Course

3 days, 18 - 20 Aug, 2021 

2021-08-18 12:08:00 2021-08-18 12:08:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Organizations are experiencing rapid changes which are creating several challenges to modern administrators. Most notably is the need for administrators to absorb more workload and improve the ...

Introduction to Python Programming Training Introduction to Python Programming Training

3 days, 22 - 24 Jul, 2021 

2021-07-22 12:07:00 2021-07-22 12:07:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

In this instructor-led Python training course, students learn to program in Python. The course is aimed at students new to the language and who may, or may not, have experience with other programming ...