Excel 2016 Essentials

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.