CORONA VIRUS COVID -19 PANDEMIC - UPDATE- OUR TRAINING COURSES, HR CONSULTANCY AND OTHER SERVICES ARE OPERATING SAFELY AND EFFECTIVELY ON-LINE VIA SECURE VIDEO CONFERENCING - OUR PREMISES ARE FOR NOW CLOSED FOR PUBLIC ACCESS. PLEASE DO APPLY ONLINE OR SEND AN E-MAIL TO learning@people.com.mt . You can also call on +356 27322314 0900 to 1730 MALTA TIME (CET)

  1. Course Schedule
  2. MS EXCEL 2016 Basic - Advanced
MS Excel

MS EXCEL 2016 Basic - Advanced

REGISTER
Start Date
Instructors
Kenneth Bartolo
Duration
11 evenings
Course Level
Basic - Advanced
Certification
Certificate of Attendance

 

Course Location: 

New Online Arrangement due to Covid-19. Classes limited to 8 participants.

 

 

11 Evening sessions:  5.30pm – 8.00pm

Our trainer is an experienced MS EXCEL professional 

Refreshments and Course Notes included.

Valid towards CPE hours

 

 

 

 

 

 

 

 

 

 

What is it about?

The basic course will enable you to confidently manage worksheets and workbooks, enter data and be able to perform calculations by creating basic formulas. You will also be able to manipulate cell content, edit it, modify, format worksheets and workbooks. The Intermediate level training will enable you to work with advanced formulas, lists and illustrations and work with charts and advanced formatting including styles.  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?

The MS Excel 2016 Basic 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

 

Basic Excel 2016 - Class Outline

Getting started with Excel 2016

Microsoft Excel 2016 Fundamentals

  • Exploring Microsoft Excel
  • Creating Workbook Files
  • Viewing Worksheets
  • Navigating Worksheets and Workbooks

Editing Worksheets

  • Creating Basic Formulas
  • Editing Text and Values    
  • Clearing, Moving, and Copying Cell Content
  • Modifying Worksheet Structure
  • Understanding Functions
  • Using Functions
  • Using Statistical Functions
  • Using Date and Time Functions

Formatting Worksheets

  • Formatting Cells and Cell Content
  • Formatting Worksheets
  • Preparing Worksheets for Printing
  • Using Find and Replace
  • Previewing and Printing Worksheets

 

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

 

 

You may choose the following options:

Fundamentals - 8 sessions - 320 Euros

Intermediate & Advanced - 7 sessions - 300 Euros

Basic to Advanced - 11 sessions - 400 Euros

 

Course Funding:

eu funds jobsplus

 

Registration

Click the following links to register for:

MS Excel 2016 Fundamentals

MS Excel 2016 Intermediate & Advanced

 

Use the 'REGISTER' button below to register for the FULL course.

 

Similar Courses

Introduction to IBM SPSS Statistics V25

 

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
REGISTER

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


Your choice for Training and Development, Careers Advice and Opportunities , Psychometrics and Data Analysis.