Lead Training Services

MS Excel Advanced: MS Excel Advanced Techniques

MQF Level 5 CPD Award
Starting Date To Be Announced

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

The accreditation status of this programme is a ‘‘Higher Education Programme’’. A CPD Award accredited with 1 ECTS credits (MQF Level 5) by the Malta Further & Higher Education Authority (MFHEA), the Award in MS Excel Intermediate: The Use of Formulae & Intermediate Data Operations will be awarded.

Course Dates & Duration

Modules Dates Time
Session 1 TBC 9:00 – 12:30
Session 2 TBC 9:00 – 13:00

Please note that as per terms and conditions, LEAD Training Services reserves the right to alter course dates, times and venue in exceptional circumstances beyond its control.

A 10-15 minute break will be allowed every hour during which students can also take this opportunity to submit further questions or comments to the trainer.

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.

Course Delivery Mode – Live Webinars

This course will be delivered via live online webinars.  The course trainers will be visible on screen via a professional webinar platform through which students can follow the trainer presenting live whilst also using a powerpoint presentation and sharing other resources as necessary.  Students will be able to interact with the trainer by sending questions or comments through the same webinar platform.  Our student support team will assist all students with simple instructions on how to access the webinar online.  A support line will also be made available to communicate with a student support officer in case of technical difficulties encountered during the live webinar.

All webinars will also be recorded and uploaded on the student online resources portal for future reference during home study.  Trainers will also dedicate very regular Q & A times during the webinar to ensure all students can have the chance to ask questions and reach the intended learning objectives.  The email and contact details of the trainer will also be made available in case students would wish to get in touch with the trainer throughout the course period.

Trainer

Andrew Catania

Andrew Catania is a Senior Marketing Analyst working for Tipico. He obtained his B.Sc. in Statistics, Operational Research and Mathematics at the University of Malta. He has been working in the online industry for the past 13 years in various positions which were mainly in Data Warehousing and Analytics. He is confident in handling large datasets and transform the data in actionable dashboards for the wider business. Furthermore, he is able to translate the data into insight to be used by stakeholders. His excel knowledge helps him do so in an easy and efficient manner.

 

Course Funding Options

For Individuals

  • GET QUALIFIED SCHEME
    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 »
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: Thursday, March 17th, 2022

Here are 11 reasons why you should enroll in LEAD Training Services’ Corporate Series courses:

1.     They are accredited courses. Our Corporate Series courses are fully accredited by the MFHEA, at MQF Level 5, 2 ECTS. This means that the courses have employment and academic value. So our courses will help you to get the very best out of your investment and time.

2.     They are short courses. Sometimes, the best way to learn, is by getting to the gist of it. These courses are 7 to 10 hours long but well informative, split over 3 mornings, in order to give you enough time to balance your work schedule, while investing in your continuous professional development.

…read more »