Every business uses spreadsheets one way or another, developing your skills in MS Excel 2016 should be an essential part of your professional development plan.

The PD Training Microsoft Excel 2016 Essentials Training Course teaches you the basic features of Excel 2016, including formatting, printing, entering data, filter tools, editing, graphics and a thorough understanding of the interface. This course creates a solid foundation on which you can create your next spreadsheet with confidence.

This practical training course is now available throughout the U.S., including Atlanta, Austin, Baltimore, Birmingham, Boston, Charlotte, Chicago, Dallas, Houston, Jackson, Los Angeles, Manhattan, Miami, New York, Orlando, Philadelphia, San Antonio, Seattle and also via instructor-led online training.

Your Learning Outcomes

This extensive training course in Excel 2016 Essentials develops basic skills and understanding of the application. After this course, participants will be able to use all of Excel 2016’s basic functions to complete tasks expertly.

After completing this course, participants will have learned to:

Create a new workbook
Save a workbook
Enter and delete data
Insert rows and columns
Merge and split cells
Select data
Use Find and Replace
Hide and unhide cells
Understand cell references and formulas
Use basic formulas
Understand and use basic functions
Use spell check

Download PDF Outline Duration: 1.0 Days

Other Training courses for MS Office Apps

Training courses for MS Office Apps

Course name	Length	Next class
Microsoft Office 365 Word Essentials Training	1.0 day course	View schedule
Microsoft Office 365 Excel Essentials Training	1.0 day course	View schedule
Microsoft Office 365 Outlook Essentials Training	1.0 day course	View schedule
Microsoft Office 365 OneNote Essentials Training	1.0 day course	View schedule
Microsoft Office 365 Lync Essentials Training	1.0 day course	View schedule
Computer Basics Intermediate Training	1.0 day course	View schedule
Computer Basics Advanced Training	0.5 day course	View schedule
Computer Basics Foundation Training	1.0 day course	View schedule
Computer Basics Expert Training	1.0 day course	View schedule
Microsoft Office 365 PowerPoint Essentials Training	1.0 day course	View schedule
Office Upgrade 2016 Training Course	1.0 day course	View schedule
Microsoft Excel 2016 Essentials	1.0 day course	View schedule
Microsoft Excel 2016 Advanced	1.0 day course	View schedule
Microsoft Excel 2016 Introduction	1.0 day course	View schedule
Microsoft Word 2016 Advanced Training	1.0 day course	View schedule
Microsoft Word 2016 Introduction Training	1.0 day course	View schedule
Microsoft Outlook 2016 Advanced Training	1.0 day course	View schedule
Microsoft Outlook 2016 Introduction Training Course	1.0 day course	View schedule
Microsoft Access 2016 Advanced Training	1.0 day course	View schedule
Microsoft Access 2016 Introduction Training	1.0 day course	View schedule
Microsoft PowerPoint 2016 Advanced	1.0 day course	View schedule
Microsoft Word 2016 Intermediate Training	1.0 day course	View schedule
Microsoft Excel 2016 Intermediate	1.0 day course	View schedule
Microsoft PowerPoint 2016 Introduction Training	1.0 day course	View schedule
Microsoft Project 2016 Advanced Training	1.0 day course	View schedule
Microsoft Project 2016 Introduction Training	1.0 day course	View schedule
Microsoft Visio 2016 Advanced Training	1.0 day course	View schedule
Microsoft Visio 2016 Introduction Training	1.0 day course	View schedule
Effective Time Management Using Outlook 2016	1.0 day course	View schedule
Microsoft Office OneNote 2016 Training	1.0 day course	View schedule
Microsoft Project 2016 Intermediate	1.0 day course	View schedule

PDT Training specialise in:

Live Online

Face-to-Face

Hybrid

Plus the workshops are always tailored to your current context

Microsoft Applications Training Courses Reviews:

Excel 2010 Intermediate

This was one of the most productive training sessions that I have done in the last 5 years Good content, delivered very well.
Sun Engineering Ltd

I felt the trainer as very informative and knowledgeable and delivered the session well, I enjoyed the session and gained some well needed knowledge.
Sun Engineering Ltd

Excel 2010 Introduction

Appreciated Robbie's ability to involve all participants thru program whilst playing catch-up with those that did not immediately relate to issue.
Liquor Legends

MS Excel 2010 Advanced

FANTASTIC! I have already recommended you guys to 3 friends who are looking at doing some courses soon!!
Presence of IT

Robby was Brilliant! I learnt heaps of new tricks and will definitely be back for another advanced excel course. Thanks again Robby for all your hard work yesterday. I found Pete an excellent trainer with plenty of patience and willingness to share his knowledge. Thank you Pete!
Mater

I enjoyed the course and found my attendance to be beneficial.
ERM Power

Murray was very helpful and was able to work with our specific requirements which made the course even more beneficial. I have already recommended PD Training to CASA for future training.
Civil Aviation Safety Authority

Excel 2010 Advanced

I had a chat to two of the participants from yesterday's Excel training. We didn't discuss the specific questions listed in your survey, but they both said the training was excellent and they definitely gained valuable knowledge from it. They said their trainer (Peter) was an excellent trainer.
Mater

MS PowerPoint 2010 Essentials

Denise was a fantastic trainer and I thoroughly enjoyed my training
Westfield Ltd

MS Project 2010 Essentials

Thanks for making the organizing so easy. You have all been very helpful.
Mater

Plus you’ll also receive:

Money Back
Guarantee

If you’re not happy with the outcomes from
the course we offer a money back guarantee

REACH
Profiles

For every participant
valued at $199 each

Sick Day
Safety Net

No one left behind
with our 1/2 price re-run promise

Development
Dashboard

12-months access to the unique REACH Future Proofing Personal Development Dashboard with personally curated learning to develop agility to adapt to different people tasks and situations.

Learn Microsoft Excel 2016 Essentials Now

This course was written for trainees wishing to learn to use Microsoft Excel. It is written for using Microsoft Excel in the Office 2016 suite of applications. However, it does not include a ‘New Features’ section exclusively about new features in Microsoft Excel within Office 2016 (see appendix A). It is very easy to see a complete list of the new features in Office v2016 in the Help menu on-screen. This courseware cannot and should not compete with the comprehensive coverage of new features detailed by Microsoft within the application’s help files. To do so would be to hinder learning the raw application.

What this course seeks to do is teach the trainee Excel in the hope that he/she may be able to go and work just as well using v2002 for example and other versions. Wherever possible, ‘version functionality’ is purposely avoided.

Course Outline for Microsoft Excel 2016 Essentials

After completing this course, participants will have learned to:

Topic 1

Getting started

Workshop Objectives Explained
Pre-Assignment

Topic 2

Excel Essentials

Objectives
Starting Excel

Starting Excel
Starting Excel in Windows 8 Only

What is a Worksheet?
What is a Workbook?
Identifying Parts of the Screen
The Ribbon
Using Selection Techniques

Selecting a Cell

Selecting a Range of Cells
Selecting Nonadjacent Cells and Ranges
Selecting an Entire Worksheet
Entering Data

Identifying Types of Data

Entering Text Data into a Cell
Entering Values
Entering Data into a Range
Quickly Adjusting a Column Width
Finishing a Workbook

Saving a New Workbook

Saving a Named Workbook
Printing a Worksheet
Closing a Workbook and Exiting from Excel
Assignment

Topic 3

Modifying a Workbook

Opening a Workbook

Opening an Existing Workbook

Creating a New Workbook
Opening a Recently Used Workbook
Creating Simple Formulas

Creating a Formula by Typing

Creating a Formula by Pointing
Using Functions

Using the SUM Function

Using the AutoSum Button

Using AutoSum

Using the Formula Palette

Editing Data on the Worksheet

Replacing the Data in a Cell

Editing the Data in a Cell

Editing a Formula

Clearing the Contents from a Cell or Range

Using Undo and Redo

Assignment

Topic 4

Managing the Worksheet

Navigating in a Worksheet

Using Special Navigation Keys

Using the Scroll Bars and Boxes
Moving One Screen

Moving to the End of the Worksheet

Changing Worksheets
Using Go To
Changing the Worksheet Structure

Inserting Cells, Rows and Columns

Deleting Cells, Rows, and Columns
Performing a Simple Sort
Creating and Using Named Ranges

Naming Ranges

Automatically Naming Ranges
Navigating with Named Ranges
Using Range Names in Formulas
Pasting a List of Named Ranges
Deleting and Editing Range Names
Creating Named Constants
Assignment

Topic 5

Formatting the Worksheet

Moving and Copying Data

Moving Data

Copying Data
Copying Data with AutoFill
Creating a Series with AutoFill
Defining Relative, Mixed, and Absolute References
Copying Formulas
Changing the Appearance of Data

Changing Column Width

Changing Row Height
Formatting Numbers
Fonts
Adding Enhancements

Using Font Style Attributes

Aligning Data in Cells
Merging and Centre Cells
Rotating and Indenting Text
Adding Borders and Shading
Assignment

Topic 6

Printing the Worksheet

Printing a Single Worksheet

Using the Print Dialog Box

Using Print Preview
Creating Headers and Footers
Removing the Grid
Printing a Workbook

Printing a Whole Workbook

Printing a Selection
Using Print Areas
Using Advanced Printing Techniques

Changing Page Layout

Aligning the Printout
Fitting a Document onto a Desired Number of Pages
Working with Page Breaks
Working with Page Breaks in Normal View
Setting Print Titles
Removing Print Titles
Assignment

Topic 7

Course Wrap Up

Words from the Wise
Lessons Learned

Download PDF Outline Duration: 1.0 Days