Beginner Microsoft Excel

Overview

Turn unorganized data into useful information and quickly make spreadsheets your colleagues in this beginner Excel course

Who is Beginner Microsoft Excel aimed at?

Anyone in the organisation who is new to MS Excel

Course Length

1 day

Learning Outcomes

On conclusion of the course, participants will have understanding of these elements:

 Starting Excel 2016

What’s New in Excel 2016

Understanding the Excel Program Screen

Giving Commands

Using Command Shortcuts

Creating a New Workbook

Opening a Workbook

Previewing and Printing a Worksheet

Saving a Workbook

Closing a Workbook

Using Help

Exiting Excel

Getting Started with Worksheets

Navigating a Worksheet

Entering Labels and Values

Selecting a Cell Range and Entering Data in a Cell Range

Overview of Formulas and Cell References

Entering Formulas

Editing a Worksheet

Editing Cell Contents

Copying and Moving Cells

Controlling How Cells Are Moved or Copied

Collecting Items to Move or Copy

Checking Your Spelling

Inserting Cells, Rows, and Columns

Deleting Cells, Rows, and Columns

Using Undo and Redo

Finding and Replacing Content

Adding Comments to Cells

Tracking Changes

Formatting a Worksheet

Formatting Text

Formatting Values

Adjusting Row Height and Column Width

Working with Cell Alignment

Adding Cell Borders and Background Colors

Copying Formatting

Applying and Removing Cell Styles

Creating and Modifying Cell Styles

Using Document Themes

Applying Conditional Formatting

Creating and Managing Conditional Formatting Rules

Finding and Replacing Formatting