Microsoft Excel is a powerful tool essential for managing and presenting data in today’s working environment. In this Microsoft Office training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually and present summary information in a consumable and professional format.

We use secure Video Conferencing with interactive features such as live polling, screen sharing, whiteboards, live chat and breakout sessions. Please discuss your preferred platform, most commonly we use Microsoft Teams, Skype for Business, Webex or Zoom upon request.

These courses are facilitated in English, and are open to people from different industries across the USA, Australia, New Zealand, Singapore, Malaysia and Hong Kong - this is a short but powerful learning experience that gives you global collaboration opportunities. Our trainers and processes have been refined to give you a personalised learning experience.

**Please note, these classes run to a very tight schedule, please follow the invitation and join the class 10-minutes prior to commencement so you are ready to participate and don't miss a minute!

Please click the In-House Training tab to receive a free quote for courses delivered at your preferred location.


Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training
Training courses for Live Online MS Office
Course name Length Outline Next class
Effective Time Management Using Outlook 2016 - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 5
Microsoft Excel 2016 Advanced - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 7
Microsoft Excel 2016 Intermediate - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 6
Microsoft Excel 2016 Introduction - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 5
Microsoft Office 365 Excel Essentials - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 8
Microsoft Office 365 OneNote Essentials Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 9
Microsoft Office 365 Outlook Essentials Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 21
Microsoft Office 365 PowerPoint Essentials Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 21
Microsoft Office 365 Training Part 1 - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 22
Microsoft Office 365 Training Part 2 - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 23
Microsoft Office 365 Word Essentials - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 22
Microsoft Office OneNote 2016 Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 23
Microsoft Office Upgrade 2016 Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 24
Microsoft Outlook 2016 Advanced Training Course - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 7
Microsoft Outlook 2016 Introduction Training Course - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 6
Microsoft PowerPoint 2016 Advanced Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 9
Microsoft PowerPoint 2016 Introduction Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon October 8
Microsoft Project 2016 Advanced Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 25
Microsoft Project 2016 Intermediate - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 24
Microsoft Project 2016 Introduction - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 23
Microsoft Visio 2016 Advanced Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 24
Microsoft Visio 2016 Introduction Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 23
Microsoft Word 2016 Advanced Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 25
Microsoft Word 2016 Intermediate Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 24
Microsoft Word 2016 Introduction Training - Online Instructor-led Training 1.0 day course Course Outline PDF icon September 23

Your Learning Outcomes
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training

The PD Training Microsoft Excel 2016 Introduction Training Course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets.

After completing this course, participants will have learned to:

  • Create a Basic Worksheet
  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet
  • Modify Fonts
  • Add Borders and Colours to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options
  • Manage the View of Worksheets and Workbooks
  • Customise General and Language Options
  • Customise Formula Options
  • Customise Proofing and Save Options
  • Customise the Ribbon and Quick Access Toolbar
  • Customise the Functionality of Excel by Enabling Add-Ins
  • Customise Advanced and Trust Centre Options
 


 

Duration: 1.0 day course



Reviews

Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training Reviews:

"I thought Steve was a great trainer - very enthusiastic and engaging. Made the day seem like fun, and we learnt quite a few excel tricks. Thanks for an informative and fun day."

The Kraft Heinz Company

 

"Course and trainer was great. I have learnt new functions which would be useful to my job."

The Kraft Heinz Company

 

"Steven was great. I wasn't expecting to learn as much as I did. Steven explained it very well, which made it easy."

National Stroke Foundation

 

"Very well presented, Trainer showed great enthusiasm in the way she presented the course."

Metcash

 

"I did not see a student manual but the training was very clear and I really enjoyed the day ! I had a basic understanding of Excel but felt much more comfortable and confident with the program after completing the day."

Parramatta

 




Course Outline
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training

Download Microsoft Excel 2016 Introduction - Online Instructor-led Training Course Outline

Foreword:

This course is designed to give users a good introduction to the basic concepts of Excel. It explores the structure of the Excel workbook and demonstrates basic techniques required for working with spreadsheets.


Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training - Lesson 1
Getting Started with Microsoft Excel 2016
  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training - Lesson 2
Performing Calculations
  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training - Lesson 3
Modifying a Worksheet
  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training - Lesson 4
Formatting a Worksheet
  • Modify Fonts
  • Add Borders and Colours to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training - Lesson 5
Printing Workbook Contents
  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training - Lesson 6
Managing Large Workbooks
  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training - Lesson 7
Customising the Excel Environment
  • Customise General and Language Options
  • Customise Formula Options
  • Customise Proofing and Save Options
  • Customise the Ribbon and Quick Access Toolbar
  • Customise the Functionality of Excel by Enabling Add-Ins
  • Customise Advanced and Trust Centre Options

In-House Training We’ll focus on what matters most to you and tailor to your context


Live Online or Hybrid Class Tailored to Your Needs

When you want a tailored learning experience targeting exactly what you want without bringing everyone physically together, the best choice is a Live Online Class run by PDT.

We tailor the content and activities to be specific to your current needs and the needs of the people and run the course in our usual activity-based workshop style training, however, the participants can all be offsite, or some can be in the room with others offsite.

Unless you have a preferred tools we use 'Zoom for Education' that includes enhanced collaboration features such as One-click content sharing, real-time co-annotation (people can work together in activity files), and digital whiteboarding, we also include things like live polls and group chats so you virtually have the same collaborative learning experience of attending a course in a room with other people.

live online & hybrid

We have delivered these 100's (if not 1000's) of times, and get great outcomes. We achieve great outcomes because we keep our learner centric approach - just because it’s delivered through a screen to some or all participants doesn’t mean it needs to be less tailored or less personalised.

You still have an expert trainer who talks to you prior to the session and tailors the delivery to use your terminology, ensure activities are relevant and directly applicable and ensures an engaging learning experience that provide people with skills and techniques they can apply the very next day.

A hybrid class is with some people dialling in, and some people physically together in the same room.

Live Online Participant Feedback:

90% Overall Trainer Rating

88% Delivery was Adapted to me Personally

75% I Would Recommend this Course to Someone Else

Face to Face Options With Everyone in the same room

1-hour Motivator
one hour motivator
3-hour Power Sessions
3 hour power session
Full-day training
full day training
Conferences
Conferences
At your workplace At your workplace
In our Training Rooms In our Training Rooms
 In our Online Training  Room - the HIVE In our Online Training Room

We’ll make things easier so you can focus on adding more value

We provide the Training Management Centre which is an information hub before, during and after training.
(Let us know if there’s parts you don’t want to use)

Invites people to training

(So you don’t have to)

Invite People icon

Generates Sign in Sheet

(So you don’t have to)

Generate Sign In Sheet Icon

Generates Branded Flyer

If you if you want to ‘promote’ internally

Generate Branded Flyer Example

PDF’s of Certificates

(can be co-branded with your logo)

Completion Certificate Included

Collects and Reports feedback

(So you don’t have to)

Feedback Report Example

Complete Results Dashboard

(including trainer insights)

Results Dashboard Example

What are people going to do differently?

At the completion of training participants are encouraged to create an action plan, and invite an accountability buddy via their Orgmenta App.

In your Training Management Centre you have transparency to the action plans so you can see what people are going to do differently.

My Action Plan
Participants encouraged to create

Want to get clear on impacts and measure success? Our system and expert consultants support you.


Our systems and people make it easy to identify how you’ll be able to measure impacts,
and then report on the success in the weeks or months after training.

Measure metrics your way

Do you already have a training management system and wish they were automatically up to date?

Training APIs

It’s surprisingly easy to make it so that your system can automatically be up to date with all the training record details you need.

More than just a training provider - we are your Learning and Development Partner, we look forward to working with you, talk to one of our friendly expert consultants today.

Public Class Dates for
Microsoft Excel 2016 Introduction Training Course - Online Instructor-led Training

Details:

  • Time: 07:00 AM - 02:30 PM
  • Small classes, average 5 people, max 16
  • Pay on Invoice or by Credit Card

Questions:

  • Certificate of Completion (always available in the App)
  • Comprehensive courseware as books (& available in the App)

UNLIMITED TRAINING FOR AN
ENTIRE YEAR FOR LESS THAN THE
COST OF 3 DAYS OF TRAINING

learn more

Location Date 1 Date 2 Date 3 Date 4
The Cloud
Login, Worldwide The Cloud WWW 0000
October 5
1.0 day course
MYR1250.00
Filling fast
October 26
1.0 day course
MYR1250.00
Filling fast
November 16
1.0 day course
MYR1250.00
Filling fast
December 7
1.0 day course
MYR1250.00
Filling fast

When you book a Public Class with PD Training you can expect:

PDT Activities and discussion

To Be Engaged All Day

Activities and discussion for engaged learning all day.

Real world trainer

An outstanding trainer

On average PDT trainers have 15 years industry experience and 7 years training experience.

Tailored training

Focussed on you

We always tailor activities and scenarios to be relevant to you.

Transfer policy

100% Transfer Policy

If an unforseen event prevents public class attendance, no problem. Transfer to new person, course, date or city.

Refresher course

Refresher Course $0

In-House and Public Class participants are welcome to join a public class in the same topic for 12 months.

Confidence of booking

Acclaimed Provider

The confidence of booking with an acclaimed multi national training company.

eLearning and video

Multi-modal Reinforcement

Support, reinforcement & extension eLearning and videos in the App.

Not exactly what you needed? Try other courses in the Live Online MS Office Courses Category

 
shadow