Excel 2016 - Beginner

3 Hours, 45 Minutes


Delivery Method

UT Pro from New Horizons

This class is part of a 12‑month UT Pro Subscription

Course Overview

Microsoft Excel is one of the major workhorses in the Microsoft 365 suite of applications and arguably the most widely-used 365 product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Course Objectives

Getting Started with Excel, Creating Workbooks and Using Templates, Entering Data, Excel Formula Basics, Adjusting a Worksheet, Formatting and Aligning Worksheet Data, Using Cell Styles and Themes, Inserting Objects and Graphics, Proofing a Workbook, Printing an Excel File, Managing Worksheets, Navigating and Viewing Excel Files

Course Prerequisites

The recommended pre-requisite for this course is basic computer skills.


1 - Introduction

  • Introduction

2 - Getting Started with Excel

  • What is Excel?
  • Opening Excel
  • Navigating the Excel User Interface
  • Using the Excel Ribbon
  • Understanding Excel Worksheet Components
  • Using the Backstage View

3 - Creating Workbooks and Using Templates

  • Creating a New Workbook
  • Creating Workbooks Using Templates
  • Saving an Excel Workbook
  • Using Convert and Checking Compatibility

4 - Entering Data

  • Navigating a Worksheet by Mouse or Keyboard
  • Understanding Excel Data Types
  • Working with Cell and Range Addressing
  • Using Various Data Selection Techniques
  • Working with Common Excel Commands
  • Using the Autofill Handle

5 - Excel Formula Basics

  • What are Formulas and Functions?
  • Understanding the Components of a Formula
  • Understanding Calculation Hierarchy and the Order of Operations
  • Creating Basic Formulas
  • Working with Basic Functions and AutoSum
  • Using Cell References
  • Using the Quick Analysis Tool

6 - Adjusting a Worksheet

  • Modifying Columns and Rows
  • Hiding and Unhiding Columns and Rows

7 - Formatting and Aligning Worksheet Data

  • Formatting and Aligning Data
  • Merging Data
  • Wrapping Text and Adjusting Orientation
  • Formatting Numbers
  • Using Borders and Shading
  • Using the Format Painter
  • Removing Formatting Quickly

8 - Using Cell Styles and Themes

  • Understanding Cell Styles
  • Applying Cell Styles
  • Applying Themes

9 - Inserting Objects and Graphics

  • Inserting and Formatting Images
  • Inserting and Formatting Shapes
  • Inserting and Formatting SmartArt
  • Inserting Screenshots
  • Inserting Hyperlinks
  • Inserting Symbols and Equations
  • Inserting WordArt and Text Boxes
  • Inserting Other Excel Objects
  • Arranging Objects

10 - Proofing a Workbook

  • Using Find and Replace
  • Finding and Replacing Formatting
  • Using Go To and Go To Special
  • Using the Spell Checker
  • Using the Thesaurus and Translation Features

11 - Printing an Excel File

  • Printing and Previewing Excel Files
  • Creating Custom Margins and Scaling
  • Adding Headers and Footers
  • Formatting a Page with the Page Layout Tab
  • Printing Titles and Specific Worksheet Areas
  • Exporting to PDF and XPS

12 - Managing Worksheets

  • Renaming and Coloring Worksheet Tabs
  • Adding, Deleting, and Navigating Worksheets
  • Moving and Copying Worksheets
  • Hiding and Unhiding Worksheets

13 - Navigating and Viewing Excel Files

  • Viewing Workbooks
  • Using Zoom Tools
  • Configuring Sheet Options
  • Using the Freeze Panes and Split Commands
  • Working with Window Commands
  • Adjusting Workbook Properties

14 - Conclusion

  • Course Recap

What is UT Pro?

UT Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your UT Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of a UT Pro Subscription

Our UT Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about UT Pro.