Advanced Excel Modelling Training

/Advanced Excel Modelling Training
Advanced Excel Modelling Training 2018-03-22T01:32:23+00:00

Welcome to our Advanced Excel Modelling Training Information Page. Please feel free to navigate the tabs on the left for all the information you need about our training. If you do not get what you are looking for, please feel free to contact us today.

Please note that if you have reached this page as a result of an advert or any communication by Quantrix Zambia Limited, you are not lost! Quantrix Zambia Limited is the Zambian branch of Celsoft Corporation. We also advise that Celsoft Corporation and its subsidiary Quantrix Zambia Limited have no association with Celsoft Zambia Limited (Trading as Celsoft Global).

Five reasons why you must consider Advanced Excel Modelling (“AEM”) Training

  • We know that many professionals who use Microsoft Excel in accomplishing their job tasks have never been formally trained in the use of Excel. The little they know is self-taught on the job, what about you?

  • We are also aware that most users of Excel only use less than 5% of what Excel has to offer, is this your story?

  • We know that many users of Excel struggle to use it effectively, especially in the area of formulas resulting in work that can be accomplished in minutes being done in hours or days, maybe this is not your case, is it?

  • Most Excel users especially Accountants, spend most of their time in the evenings, weekends and holidays at work because of the nightmares they face with Excel, do you confirm this?

  • We know that most decision-making in many company’s lacks the use of what-if analysis and other modelling tools as a result of the absence of dynamic and robust models, maybe not where you work, right?

  • The above statements are the reason why we offer solutions to our clients in two forms:

    • Advanced Excel Modelling Training focusing on Data Analysis and Reporting as well as Budgeting and Forecasting.

    • Developing dynamic, robust and customized financial models using the world’s leading financial modelling software, Quantrix Modeler and Quantrix Qloud.

IF ANY OF THE ABOVE STATEMENTS IS TRUE TO YOU, WE RECOMMEND THAT YOU CONSIDER BOOKING FOR ONE OF OUR COURSES TODAY OR CALL US FOR A PRESENTATION OF QUANTRIX MODELER SOFTWARE.

Important details about our Advanced Excel Modelling Training

  • Our courses are offered in two forms: Masterclass courses and In-house Courses.

  • Masterclass Courses are courses that we organize and invite through advertising, people from various organizations at a central training venue. Please visit our upcoming courses calendar to book for the next course.

  • In-house courses are courses that you can organize as an organization and our facilitators will come to your chosen venue for training. We require a minimum group size of 5 participants to constitute a class.

  • In a masterclass course, we take care of venue costs as well as lunches and refreshments that is why the fees are higher than those of an in-house course. The organization calling for an in-house course will take care of the costs of the venue, lunches and refreshments.

  • Our courses are two: The Advanced Excel Modelling (Data Analysis & Reporting) Course and the Advanced Excel Modelling (Budgeting & Forecasting) Course.

  • The Data Analysis Course covers the key Data Management techniques and Key Excel Formulas and Functions and gives participants an opportunity to learn how to put these techniques together to develop a robust and dynamic Data Analysis and Reporting model according to International Best Practice Standards of financial modelling.

  • The Budgeting & Forecasting Course explores more Advanced Excel functions and apply them in the development and linking of various departmental and functional budgets to produce a budgeted income statement, budgeted balance sheet and a budgeted cash flow statement. It takes participants further by showing them how to derive value from a planning model through use of various techniques such as goal seeking, what-if analysis, scenario management and optimization.

  • We recommend that you take the Data analysis course before you take the budgeting course as this will give you a solid understanding of Excel modelling.

  • Both the Data Analysis and the Budgeting Masterclass Courses are 3-day courses. However if taken on an in-house basis, the client can choose between a 3-day, 4-day or 5-day course.

  • Contact us if you want a customized course or a much more basic or beginner course and we will be glad to organize one for your group.

Advanced Excel Modelling (Data Analysis & Reporting)

  • Are you involved in analysis data and producing management reports in Excel? If the answer is “Yes”, then make up your mind to book for this course today. You can book for our upcoming masterclass courses by visiting our upcoming workshops page or contact us to organize an in-house course for you and your team.

  • The course covers key Data Management techniques and Key Excel Formulas and Functions and gives participants an opportunity to learn how to put these techniques together to develop a robust and dynamic Data Analysis and Reporting model according to International Best Practice Standards of financial modelling.

  • Below is the standard programme for the 3-day masterclass version of the data analysis course. This programme can be stretched to 4 days or 5 days with more extensive practice exercises if you opt for more number of days in an in-house course arrangement.

Day 1 Day 2 Day 3
08:00
Introductions
Introducing Celsoft, Participants, Course Programme, Course Material and The Financial modelling concept.
08:00 - 10:30

Introductions
Introducing Data Analysis, the concept and methods
10:00 - 10:30
08:30
09:00
09:30
10:00
10:30
Break
Tea Break
10:30 - 11:00
Break
Tea Break
10:30 - 11:00
Break
Tea Break
10:30 - 11:00
11:00
Key formula concepts
Relative, Mixed and Absolute Referencing.
11:00 - 11:45

Key formula concepts
Golden rules of Excel Functions
11:45 - 12:15

Key formula concepts
Excel Key errors, their causes, how to prevent them and how to fix them.
12:15 - 13:00
11:30
12:00
12:30
15:30
Break
Short Break
15:30 - 15:45
Break
Short Break
15:30 - 15:45
Break
Short Break
15:30 - 15:45

Day 1

  • Introductions
    08:00 - 10:30
  • Introductions
    10:00 - 10:30
  • Break
    10:30 - 11:00
  • Key formula concepts
    11:00 - 11:45
  • Key formula concepts
    11:45 - 12:15
  • Key formula concepts
    12:15 - 13:00
  • Break
    15:30 - 15:45

Day 2

  • Break
    10:30 - 11:00
  • Break
    15:30 - 15:45

Day 3

  • Break
    10:30 - 11:00
  • Break
    15:30 - 15:45
Day 1 Day 2 Day 3
11:00
Key formula concepts
Relative, Mixed and Absolute Referencing.
11:00 - 11:45

Key formula concepts
Golden rules of Excel Functions
11:45 - 12:15

Key formula concepts
Excel Key errors, their causes, how to prevent them and how to fix them.
12:15 - 13:00
11:30
12:00
12:30

Day 1

  • Key formula concepts
    11:00 - 11:45
  • Key formula concepts
    11:45 - 12:15
  • Key formula concepts
    12:15 - 13:00
Day 1 Day 2 Day 3
11:00
Key formula concepts
Relative, Mixed and Absolute Referencing.
11:00 - 11:45

Key formula concepts
Golden rules of Excel Functions
11:45 - 12:15

Key formula concepts
Excel Key errors, their causes, how to prevent them and how to fix them.
12:15 - 13:00
11:30
12:00
12:30

Day 1

  • Key formula concepts
    11:00 - 11:45
  • Key formula concepts
    11:45 - 12:15
  • Key formula concepts
    12:15 - 13:00
Day 1 Day 2 Day 3
08:00
Introductions
Introducing Celsoft, Participants, Course Programme, Course Material and The Financial modelling concept.
08:00 - 10:30

Introductions
Introducing Data Analysis, the concept and methods
10:00 - 10:30
08:30
09:00
09:30
10:00
10:30
Break
Tea Break
10:30 - 11:00
Break
Tea Break
10:30 - 11:00
Break
Tea Break
10:30 - 11:00
15:30
Break
Short Break
15:30 - 15:45
Break
Short Break
15:30 - 15:45
Break
Short Break
15:30 - 15:45

Day 1

  • Introductions
    08:00 - 10:30
  • Introductions
    10:00 - 10:30
  • Break
    10:30 - 11:00
  • Break
    15:30 - 15:45

Day 2

  • Break
    10:30 - 11:00
  • Break
    15:30 - 15:45

Day 3

  • Break
    10:30 - 11:00
  • Break
    15:30 - 15:45
No topics available!

Advanced Excel Modelling (Budgeting & Forecasting)

  • If you are involved in the production of budgets and their presentation to management including performance of what if analysis and scenario management, then please make up your mind to take this course. You can book for our upcoming masterclass courses by visiting our upcoming workshops page or contact us to organize an in-house course for you and your team.

  • The Budgeting & Forecasting Course explores more Advanced Excel functions and apply them in the development and linking of various departmental and functional budgets to produce a budgeted income statement, budgeted balance sheet and a budgeted cash flow statement. It takes participants further by showing them how to derive value from a planning model through use of various techniques such as goal seeking, what-if analysis, scenario management and optimization

  • Below is the standard programme for the 3-day masterclass version of the budgeting and forecasting course. This programme can be stretched to 4 days or 5 days with more extensive practice exercises if you opt for more number of days in an in-house course arrangement.

Course Fees

  • Course fees depend on the level of the course (Data Analysis & Reporting is the first level, while the budgeting and forecasting course is the second level). The fees also depend on whether it is an in-house course (whereby costs of refreshments, venue and lunches are borne the client) or masterclass course (where we bear all the costs of the workshop). In an in-house arrangement where the client has a choice between a 3-day, 4-day or 5-day workshop, the number of days will also determine the fees.

  • The fees are per person or per participant but group discounts can be given as the group size increases. Please contact us if you want to book as a group.

Zimbabwe Course Fees

Course Masterclass 3 Days In-house 3 Days In-house 4 Days In-house 5 Days
AEM – Data Analysis & Reporting $350.00 $250.00 $300.00 $350.00
AEM – Budgeting & Forecasting $400.00 $300.00 $350.00 $400.00

For Zimbabwe Booking: Please deposit your payment or do a transfer to:  Stanbic Bank Zimbabwe, Parklane Branch, Account Name: Celsoft Investments (Pvt) Limited, USD Account Number: 9140002255757. Please send us an email to celsoft@celsoftcorporation.com with details of your booking.

Zambia Course Fees

Course Masterclass 3 Days In-house 3 Days In-house 4 Days In-house 5 Days
AEM – Data Analysis & Reporting ZK4,500.00 ZK3,500.00 ZK3,900.00 ZK4,900.00
AEM – Budgeting & Forecasting ZK4,900.00 ZK3,900.00 ZK4,500.00 ZK5,500.00

For Zambia Booking: Please deposit your payment or do a transfer to:  United Bank for Africa (Z) Limited, Arcacia Branch, Account Name: Quantrix Investments (Pvt) Limited, Kwacha Account Number: 9010160035034. Please send us an email to celsoft@celsoftcorporation.com with details of your booking.

Upcoming Workshops

Please click on a workshop for details and for booking.

Who should attend these courses?

  • Any person involved in data analysis and production of management reports.

  • Any person who wishes to have a sound knowledge of Excel data management tools and formulas.

  • Anyone who desires to know how to build a robust and dynamic financial model.

  • Anyone who is involved in the production of budgets and forecasts.

  • Financial Accountants

  • Management Accountants

  • Accounts Personnel

  • Bankers

  • Risk Managers

  • Finance Directors

  • Corporate Finance Analysts

  • Treasurers

  • Credit Managers

  • Auditors

  • Operational Managers

  • Credit Controllers

  • Purchasing Managers

  • Financial Analysts

  • Economists

  • Stock Brokers

  • Insurers

  • And anyone who uses Excel in data analysis and reporting and budgeting.

Why choose Celsoft

  • We are the leading financial modelling services company in Africa with over 6,000 professionals in Africa having attended Celsoft workshops.

  • We have several years experience of in building robust financial models both in Excel and Quantrix.

  • We are the only financial modelling services company that builds models in Africa, giving us deeper knowledge of what we teach. This is in contrast with other players that train what they do not practically do.

  • We are the only company that has exclusive partnership with Quantrix of USA, the global leader in Financial modelling software.

  • We have in-house facilitators (we do not hire them) with several decades of experience working in various industries giving them the ability to understand all the facets of Excel modelling.

  • Our company is a registered CPD partner of ACCA global, therefore after attending our courses you will receive a certificate with CPD hours that are recognized by professional institutions.

  • Our course material is carefully designed with comprehensive exercises that help participants to grasp the subject matter with ease and to have a deeper understanding.

  • We are the only company that offers after-training support to participants free of charge!

  • We are the partners of UNICEF and the Ministry of Local Government in Zimbabwe in modelling projects for the budgeting and forecasting software for Zimbabwe’s 92 Local Authorities. 

  • We are the trainer of choice for some of the big institutions in Zimbabwe and Zambia such as The Reserve Bank of Zimbabwe, CBZ, United Nations (UNDP & UNFP), Steward Bank, MTN, Barclays Bank Zambia, Atlasmara, Stanbic Bank Zambia etc. Please see some of our clients below.

Send an Inquiry

If you need more information and wish to talk to us, call us as follows:

Linda Lupankwa                                                                                        Elizabeth Daka

Celsoft Corporation                                                                                   Quantrix Zambia

Head Office (Zimbabwe)                                                                          Lusaka Branch

+263 8677 107 481                                                                                    +260 977 230 908

You may click the button below to create a support (or inquiry) ticket.

Send Us An Inquiry
Support