Microsoft Excel 2016/19
Introduction

Course Overview

In this course, you will learn the fundamentals of working with spreadsheets. You will learn how to produce a professional looking worksheet by entering numbers and creating time-saving Excel formulas and use the predefined Microsoft Excel 2016/19 functions. You will also learn how to quickly and easily change the layout of your worksheet and enhance the appearance of your worksheet using the format commands. You will also learn how to work with multiple sheets within a file and how to setup and print your worksheet.

Course InformationRelated Training

Duration: One-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Create and Edit a Worksheet

Get acquainted with the Backstage View, Ribbon and Quick Access Toolbar in Office 2016.
Explore the Excel screen.
Efficiently move through the worksheet using many shortcut keys.
Proficiently select cells and ranges.

Create Formulas and Functions

Produce a professional looking worksheet by entering numbers and creating time-saving Excel formulas.
Effectively use the following Excel functions: SUM, AVERAGE, MIN, MAX and COUNT.

Manage your Worksheet

Quickly insert, delete or hide cells, rows, and columns.
Discover many unique techniques to cut, copy and paste.
Use the latest Flash Fill features that will automate many repetitive tasks.

Format your Worksheet

Enhance the appearance of your worksheet using the many formatting commands.

Manage your Workbook

Name, group, move, copy and colour your worksheet tabs.

Print your Worksheet

Setup and print your worksheet.

Get Help Using the "Tell me what you want to do" Box

Use the new feature to learn how to do anything in Excel.

Application Overview: Microsoft Excel 2016/19

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, calculate data, create rich data visualization and professional-looking charts. You can compile your company's data into a Microsoft Office Excel workbook that can contain many worksheets.
Microsoft Excel can be used to manage numbers and calculations. You can create formulas in Excel that automatically update when you change your data.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.

Microsoft Excel 2016/19 Introduction