Course Location:
Public Courses are Online. Bespoke Groups can be booked for on-premise training. Please enquire via information@peoplelearning.edu.mt
11 Evening sessions: 5:30 pm – 8:00 pm Our trainer is an experienced MS EXCEL professional Course Notes included. Valid towards CPE hours
|
What is it about?
The Fundamentals course will take you from a review of the basics to a solid foundation to enable you to confidently manage worksheets and workbooks, enter data and be able to perform calculations by creating basic formulae. You will also be able to manipulate cell content, edit it, modify, and format worksheets and workbooks. The Intermediate level training will enable you to work with advanced formulas, lists, illustrations, and work with charts and advanced formatting including styles. The Advanced course is a continuation of the Fundamentals and intermediate courses. 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 and lesson objectives are being achieved.
Who is it for?
The MS Excel 2016 Fundamentals to Advanced course is ideal for individuals, whether students or professionals, who use Excel regularly in their work and would like to get the most out of this versatile program. The course is aimed at all age groups and categories who wish to acquire new skills or improve their efficiency in the use of Excel.
What will I gain?
You will gain confidence in the efficient use of Excel features including learning to use formulas and functions, creating and modifying charts, converting, sorting, filtering and managing lists, inserting and modifying illustrations in a worksheet, and using conditional formatting and styles.
Course Overview
Fundamentals (From the Basics to a solid foundation) Excel 2016 - Class Outline
Getting Started with Excel 2016
Microsoft Excel 2016 Fundamentals
Editing Worksheets
Formatting Worksheets
Intermediate & Advanced Excel 2016 - Class Outline
You may choose the following options:
Fundamentals - 8 sessions
Intermediate & Advanced - 7 sessions
Advanced - 3 sessions
Fundamentals to Advanced - 11 sessions
Course Funding:
For Employers and Self-Employed people!
Registration
Click the following links to register for:
MS Excel 2016 Intermediate & Advanced
Use the 'REGISTER' button below to register for the FULL course.
Similar Courses
Introduction to IBM SPSS Statistics V25
Our public courses are held online, fully interactive with the possibility of screen sharing privately with the trainer. We are highly experienced in running online courses now and MS Excel training has proven to be efficient, safe and great for time management (avoiding the horrendous traffic and parking/ transport issues ). For corporate/bespoke training we run sessions both online, on-premise and hybrid
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: Information@peoplelearning.edu.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 |
---|