Excel 2016 Essentials

Description

Overview

Excel 2016 is the powerful spreadsheet application in the Office suite. It seems every organization, large and small, uses Excel to organize and analyze data. However, many users are intimidated by Excel and confused by how it behaves as an application. The Excel 2016 Essentials series strives to empower users by learning the foundations to conquer this program. We begin with basic skills such as navigating the interface, identifying items in a spreadsheet, selecting cells, and inputting data. The series also covers formatting text and numbers, modifying a worksheet layout, printing and page layout, and managing worksheets in a workbook. While this series is designed for beginner users, it has lots of great tips and tricks for experienced users as well.

Objectives

Insert rows and columns
Merge and split cells
Select data
Use Find and Replace
Hide and unhide cells
Create a new workbook
Save a workbook
Enter and delete data

Prerequisites

Type and use a keyboard
Navigate through Windows files and folders
Work with windows – minimise, maximise, open and close

Target Audience

This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2016 / 365 worksheets.