Beginner Excel Course

Overview

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

 Program Fundamentals

 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

Max Numbers of Delegates

10

Menu

Hello! We are able to offer the vast majority of our courses online in a virtual classroom via your preferred video conferencing platform. All of our course contents have been updated to reflect the current COVID-19 situation. To enquire about any of our courses to be delivered online please go to our ‘Contact Us’ page