Lead Training Services

MS Excel Advanced: MS Excel Advanced Techniques

MQF Level 5 CPD Award
Starting: 19th November 2019

In the Award for MS Excel Advanced: MS Excel Advanced Techniques, attendees will be taken to a higher and expert level in the mastery of Excel. Employees who attend this course find it quite useful as it saves time and increases their efficiency, productivity but above all, eliminates room for miscalculations.

By the end of the course, attendees would have been exposed to and have become more confident in Conditional Formatting, Workbook Automation Techniques amongst other techniques. Students will also be able to perform higher complex mathematical calculations, while being able to create their own calculations.

Learning Outcomes

Manage and Share Workbooks

  • Manage multiple workbooks
  • Modifying workbook templates
  • Managing workbook versions
  • Copying styles between templates
  • Copying macros between workbooks
  • Connecting to external data
  • About the Excel Data Model
  • Tracking changes
  • Protecting workbooks for sharing
  • Properties vs. metadata
  • Manage workbook changes
  • Displaying & Reviewing changes
  • Merging workbooks
  • Identifying errors & Tracing formulas in separate worksheets

Apply Custom Formats and layouts

  • Creating custom formats (number, time, date)
  • Using advanced Fill Series options
  • Apply advanced conditional formatting and filtering
  • Using functions to format cells
  • Creating advanced filters
  • Managing conditional formatting rules
  • Apply custom styles and templates
  • Creating custom templates
  • Creating and modifying cell styles
  • Creating themes
  • Creating form fields
  • Prepare workbooks for internationalization and accessibility

Create Advanced Formulas

  • Apply functions in formulas
  • Using nested functions
  • Using the SUMIFS, AVERAGEIFS, and COUNTIFS functions
  • Using financial functions
  • Using the TRANSPOSE function
  • Apply advanced date and time functions
  • Using functions to serialize dates and times
  • Create scenarios
  • Using what-if analysis tools
  • Using the Scenario Manager
  • Merging scenarios
  • Consolidating data

Create Advanced Charts and Tables

  • Create advanced chart elements
  • Adding trendlines to charts
  • Creating dual-axis charts
  • Creating custom chart templates
  • Create and manage PivotTables
  • Modifying field selections and options n Creating slicers
  • Using PowerPivot
  • Create and manage Pivot Charts
  • Manipulating options in existing Pivot Charts n Applying styles to Pivot Charts

Accreditation and MQF level

NCFHE Logo - Lead Training Services MaltaA CPD Award accredited with 1 ECTS credits (MQF Level 5) by the National Commission for Further and Higher Education (NCFHE), the Award in MS Excel Intermediate: The Use of Formulae & Intermediate Data Operations will be awarded.

Course Duration

This course is made up of 2 half-day sessions on the 19th and 26th November .

Entry requirements

A foundation in basic Excel techniques is advised. This course will prepare students for a more advanced course, helping them to learn new tools and functions to make their work in the office more precise and efficient.


BOV Training Centre
Triq ix-Xatt, Gzira


Dr. Vincent Marmara

Vincent Marmarà is a Statistician and Researcher by profession. He obtained his first degree in Statistics, Operational Research and Mathematics at the University of Malta. He later advanced his studies by obtaining Masters of Science in Statistics at Sheffield University, UK. Furthermore, he has obtained his PhD in Mathematics (Statistics) from the University of Stirling, Scotland. He was entrusted with numerous research projects both at a national and international level. He led research groups and analyzed data to a high-level scientific extent.

Vincent has over 11 years of experience in the Remote Gaming Industry as a Business Intelligence Analyst and Consultant. He occupied several key important roles in various organisations such as: Student Representative of the Faculty Board of Science (University of Malta), President of the Science Student Society, President of the Malta Statistics and Operations Research Organisation (MSTOR), Financial Officer of the National Youth Council, Deputy CEO and Chief Regulatory Officer within the Malta Lotteries and Gaming Authority.

Dr. Vincent Marmarà lectures statistics at the Department of Management (FEMA) at the University of Malta. Vincent is a fellow member (FRSS) of the Royal Statistical Society (UK). Dr. Marmarà provided research consultancy services to various organisations and supervised / is currently supervising BSc, BCom, MBA and MSc research students at the University of Malta. Vincent published several academic articles on international journals and other scientific surveys in Malta. At present he is one of the partners and co-owner of the statistics research company, Sagalytics.

Course Funding Options

For Companies

    Through this scheme, employers have the opportunity to get back a significant percentage of the costs that would have been incurred in any employee’s professional development via training. The ‘Investing in Skills’ scheme was launched to promote the training of persons actively participating in the Maltese Labour Market, with the aim to increase productivity and enhance adaptability.

    Learn more about this scheme »

For Individuals

    Candidates can benefit from a 70% rebate of the course fee via tax credit. Get Qualified is an initiative that supports the personal development of individuals for the achievement of qualifications and certifications required by industry.

    Learn more about this scheme »
    Eligible candidates satisyfing a list of criteria can benefit from a 75% rebate on direct training cost.

    Learn more about this scheme »
Course Funding Options

Frequently Asked Questions

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 »