Lead Training Services

MS Excel Data Analysis and Business Modelling Course


In-depth practical official courseware will be used and provided to delegates; Hands-On exercises; extra practice exercises handed to delegates.

Programme description

Learn the best ways to use Microsoft Excel for data analyses, modeling and decision making using real-world business scenarios.

Designed for supervisors, Managers or team members who need to summarize, report and analyse data, this course will present helpful tools to evaluate investments and financial decisions, ensure accurate data entry by creating a list of values, summarize data using histograms and PivotTables, estimate business variables using trend curves and present the data.

  • Advanced Functions – INDEX, MATCH, SUMIFs, Array Formulas
  • Optimization – Using Excel Solver
  • Business Modeling – Estimating Straight Line Relationships
  • Data Analysis and Presentation – Data Analysis Tool Pack, Goal Seek, Summarizing Data by using Histograms, Pivot Tables and Slicers to Describe and Analyze Data
  • Regression Analysis – What it is and how to use it


  • Many thanks once again for an extremely well run course.

    I and the rest of the group were hugely impressed with the trainer’s ability to couple complete professionalism with the creation of a fun learning atmosphere.

    The course was run at a perfect pace. It allowed everyone to reach a similar level quite quickly, and then drove us to soak-up as much information as possible for the duration.

    As an ex trainer myself, I found the level of prior preparation for the course exemplary. All of the data/tables created prior to the course for our use showed the level of thought and commitment that has gone into wireframing the course, and importantly, allowed us to get the most benefit possible from the time available.

    I will absolutely be recommending this course to all of my customers and colleagues.

    I’m excited for the rest of my guys who will be attending next week!

    Shane Cotter
    Head of Product Management, Malta
    NetEnt | Better Gaming™

Who We Are

We are a team of specialists passionate about our work and with a common ambition to share learning experiences with people in the business community and civil society.

Under the brand name LEAD Training Services, our team has attracted an impressive pool of professional trainers from different areas of business.

This makes us the only professional training organisation in Malta that can offer cutting edge training programmes across a broad spectrum of topics. We do not believe in one-size-fits-all training programmes and in line with our belief we customise our programmes to our individual customer’s needs.

Let's Keep In Touch

Stay adjourned with our latest courses, news and events by subscribing to our newsletter. We will send you an email newsletter from time to time, and we promise to never sell your details to any third parties!

Our LatestNews

Posted on: Monday, February 25th, 2019

On the 7th February 2019, LEAD Training Services organised its annual award ceremony. This annual event was held at the Xara Lodge in Rabat.

A total of 343 students who successfully completed an accredited CPD Award course during the year 2018 were invited for this ceremony in order to be officially presented with the CPD Award Certificate.

…read more »