Microsoft Excel 2016 Introduction - Online Instructor-led Training

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 - 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 View schedule
Microsoft Excel 2016 Advanced - Online Instructor-led Training 1.0 day course View schedule
Microsoft Excel 2016 Intermediate - Online Instructor-led Training 1.0 day course View schedule
Microsoft Excel 2016 Introduction - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Excel Essentials - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 OneNote Essentials Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Outlook Essentials Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 PowerPoint Essentials Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Training Part 1 - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Training Part 2 - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office 365 Word Essentials - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office OneNote 2016 Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Office Upgrade 2016 Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Outlook 2016 Advanced Training Course - Online Instructor-led Training 1.0 day course View schedule
Microsoft Outlook 2016 Introduction Training Course - Online Instructor-led Training 1.0 day course View schedule
Microsoft PowerPoint 2016 Advanced Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft PowerPoint 2016 Introduction Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Project 2016 Advanced Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Project 2016 Intermediate - Online Instructor-led Training 1.0 day course View schedule
Microsoft Project 2016 Introduction - Online Instructor-led Training 1.0 day course View schedule
Microsoft Visio 2016 Advanced Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Visio 2016 Introduction Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Word 2016 Advanced Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Word 2016 Intermediate Training - Online Instructor-led Training 1.0 day course View schedule
Microsoft Word 2016 Introduction Training - Online Instructor-led Training 1.0 day course View schedule

Your Learning Outcomes

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 Live Online Experts



Reviews

Microsoft Excel 2016 Introduction - 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

 




Download Course Outline (PDF)

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.


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

Topic 1
Getting Started with Microsoft Excel 2016
  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System
Topic 2
Performing Calculations
  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas
Topic 3
Modifying a Worksheet
  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet
Topic 4
Formatting a Worksheet
  • Modify Fonts
  • Add Borders and Colours to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles
Topic 5
Printing Workbook Contents
  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options
Topic 6
Managing Large Workbooks
  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks
Topic 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


Face-to-Face, 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 connecting online, 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

PDT Training Management Centre Logo

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 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.

Outstanding learning that people can do in the flow of work

  • Fresh targeted video-based microlearning content with interactive lessons and quizzes included.
  • Rigourous review process
  • Only $11.00 per course per person per year.
  • Or get the $110.00 bundle and save.
Bite Size learning that people love
Not exactly what you needed? Try other courses in the Live Online MS Office Courses Category