Copy of Excel: Excel Essentials and Formulas

Actions and Detail Panel

On Sale Sep 15 at 12:00 AM

Event Information

Share this event

Date and time

Location

Location

Online event

Event description
This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work

About this event

1 - 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

2 - PERFORMING CALCULATIONS

Create Worksheet Formulas

Insert Functions and use Autocomplete

Reuse Formulas and Functions

Create an Absolute Reference

3 - 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

4 - FORMATTING A WORKSHEET

Apply Text Formats

Apply Number Formats

Align Cell Contents

Apply and Copy Cell Styles

Apply Basic Conditional Formatting

5 - PRINTING WORKBOOKS

Preview and Print a Workbook

Controlling Page Layout

Adding Headers and Footers

Set Print Titles and Print Ranges

6 - MANAGING WORKBOOKS

Manage Worksheets

Insert and Delete Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties

Share with friends

Date and time

Location

Online event

Save This Event

Event Saved