Welcome to People Learning offering both public and bespoke courses online, blended and on-premise, in the EU, UK and EMEA (Europe, Middle East and Africa) regions. If you have any difficulties using this site or any queries please email information@peoplelearning.edu.mt

MS Excel 2016 Intermediate & Advanced

Start Date
Instructors
Kenneth Bartolo
Duration
7 Evening Sessions
Course Level
Intermediate & Advanced
Requirements
Sound Knowledge of Topics covered in Basic Course Outline (see the Fudamentals to Advanced course first four sessions)
Certification
Certificate of Attendance and Completion

 

Course Location: 

Online Classes limited to a maximum of 10  participants.

  

7 Evening sessions:  5.30pm – 8.00pm

Our trainer is an experienced MS EXCEL professional 

 

 

 

 

 

 

 

 

 

 

What is it about?

The Intermediate level training will enable you to work with advanced formulas, lists and illustrations and work with charts and advanced formatting including styles. At the end of each lesson, there will be a practical exercise to ensure that the course objectives have been reached. 

The Advanced course is a continuation of the basic and intermediate course. It will enable you to confidently manage worksheets and workbooks, enter data and be able to perform calculations by creating advanced formulas. You will also be able to use Apply Functions in formulas including the IF function in conjunction with other functions, utilizing the AND/OR functions. You will learn to create and manage Pivot Tables and create advanced chart elements. You will also get the feel of basic Macros. At the end of each lesson, there will be a practical exercise to ensure that the course objectives have been reached. 

 

Who is it for?

This course is aimed at individuals seeking to gain extensive understanding of MS Excel 2016 functions that will enable them to fully utilise the program's potential.

 

What will I gain?

This course will provide you with extensive knowledge on how to use lookup utilise what if analysis and apply advanced date and time functions among others. You will learn how to create and manage pivot tables as well as basic macros. This course enables you to take full advantage of the versatility MS Excel 2016 offers.

 

 

Course Overview

 

Intermediate & Advanced Excel 2016 - Class Outline

  • Advanced Formulas
  • Working with Lists   
  • Working with Illustrations
  • Visualizing Your Data
  • Working with Tables
  • Advanced Formatting   
  • Validation
  • Manage Workbook Changes
  • Prepare a Workbook for Review
  • Look Up Data with Functions: utilizing the LOOKUP function, utilizing the VLOOKUP function, utilizing the HLOOKUP function, utilizing the TRANSPOSE function AND/OR functions, utilizing nested functions, utilizing SUMIFS, AVERAGEIFS, and COUNTIFS functions
  • Apply Advanced Date and Time Functions
  • Create Advanced Chart Elements including adding trendlines to charts, creating dual axis charts,  creating custom chart templates, viewing chart animations
  • Utilising what If analysis tools including Goal Seek, utilizing the Scenario Manager, enabling iterative calculations,
  • Create and Manage PivotTables including creating new PivotTables, modifying field selections and options, creating a slicer, grouping records, utilizing calculated fields, formatting data
  • Applying Dynamic Validation lists, ToolTip and Error Messages
  • Create Scenarios including utilizing the watch window, consolidating data
  • Introduction to Macros - Record a Marco/Stop Recording

 

 

Course Fee: Intermediate & Advanced - 7 sessions - €300

 

Course Funding:

For Employed and Self Employed people!

eu funds jobsplus

 

PS: For the Intermediate-Advanced course to be fruitful, kindly check that you are well-acquainted with the basic features, formulas and functions of Excel. If this is not the case, we strongly suggest you apply for the Full Course.

 

Similar Courses

MS Excel 2016 Fundamentals

MS Excel 2016 Basic - Advanced

 

Schedule:

Due to Covid-19, we have arranged for the upcoming sessions to be held online to ensure the welfare of both trainer and participants. This has been done in the past and has worked very well.

Please register here as per normal procedure; we will take care of the rest.

Classes are limited to a maximum of 8 participants.

 

Please send us your queries to: learning@people.com.mt

*Disclaimer: Kindly note scheduled dates and times are subject to change. We will do our best to avoid re-scheduling, however, in the unlikely event that this occurs, new dates/times will be discussed with applicants.

Course Schedules

© 2024 People Learning. All rights reserved.
Website Designed & Developed by Innovative Codes


Please note that completion of a course Registration is considered to be a *booking* and a *commitment*. If you just want to enquire please send an email toinformation@peoplelearning.edu.mtand/or WhatsApp +356 79787892. People Learning - Your choice for Training and Development, Careers Advice and Opportunities, Psychometrics and Data Analysis.