Microsoft Excel 2016 – Level 2

Duration: 1 day

In this Introduction to Microsoft Excel 2016 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets. Students who have little or no familiarity with Microsoft Excel 2016 or more experienced Excel users who want to learn the topics covered in this class to be working with this application easier.

Interested in attending? Have a suggestion about running this course near you?
Register your interest now

Description

On completion of this course, you will be able to:

Understand and Work with Microsoft Excel
Understanding and Working with Microsoft Excel
Understand Difference Between Rows, Columns, Cell, Cell Pointer, AutoFilter Handle
Identify and Use of the Formula Bar
Identify and Use of the Name Box
Identify and Use Status Bar & Features
Review of Mathematical Symbols and Other Symbols to be used
Customize the Ribbon and Quick Access Toolbar
The Design of a Basic Worksheet
Create and Editing Formulas in a Worksheet
Insert Functions in a Formula
SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, DATEDIF, TODAY, NOW, SUBTOTAL, TEXT, IF
Working with AutoSum
Copying Formulas
Sort Data
Insert, Manipulate, and Delete Cells, Columns, and Rows
Working with Flash Fill vs Concatenate
Find and the Replace Command
Spell Check a Worksheet
Formatting the Worksheet
Modify Font Name, Size and Color, Fill, Borders and Underlining
Apply Date and Number Formats
Align Cell Contents and Indentation of Labels
Working with Orientation, Wrap Text and Merge and Center
Working with Clear
Adjusting Column Width and Row Height
Understand Use of and Working with the Format Painter
Refine the Page Layout and Apply Print Options
Manage Worksheets
Rename Worksheet
Insert and Delete Worksheet
Copy and Move Worksheet
Re-Arrange Sheet Tab Order
Change Tab Color
Move Between Worksheets
Manage the View of Worksheets and Workbooks
Change Worksheet Zoom
Progression: Microsoft Excel 2016 Level 2

Target audience

This is a hands on class is for novice information workers, anyone self-taught, learnt on the job and now need  to learn the beginning-level Excel 2016 skills.

Prerequisites

Basic knowledge of computers, use of mouse and the keyboard.

Similar courses
Advantage Caribbean Institute