Excel - Excel Essentials and Formulas

Duration

1 Days

This course is intended for

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows 10 environment and be able to manage information on their computers.

Overview

Upon successful completion of this course, you will be able to create and develop Excel 2016 worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organization.

Description

This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organize, calculate, analyze, revise, update, and present your data.

Getting Started with Excel 2016

Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter and Edit Cell Data
Fill Cells with Series of Data (AutoFill and Flash Fill)
Use Excel Help

Performing Calculations

Create Worksheet Formulas
Insert Functions and use Autocomplete
Reuse Formulas and Functions
Create an Absolute Reference

Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows
Move and Copy Data between Cells
Search for and Replace Data
Use Spellcheck and Proofing

Formatting a Worksheet

Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply and Copy Cell Styles
Apply Basic Conditional Formatting

Printing Workbooks

Preview and Print a Workbook
Controlling Page Layout
Adding Headers and Footers
Set Print Titles and Print Ranges

Managing Workbooks

Manage Worksheets
Insert and Delete Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties