Excel 365 Introduction

There are no specific requirements needed to attend this course.

To introduce users to the main features of Microsoft Office Excel 365. The course is mainly 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Format of the Course:

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Audience:

Anyone looking to become familiar and productive in the use of Microsoft Excel 365.

By the end of this training, participants will know

• Excel interface and workbook structure
• how to edit data and and format cells
• viewing options and how to print their workbook
• to perform basic calculations, formulas and functions
• how to create basic charts

Getting Started

• Starting Out
• About Workbooks
• Exploring your Workbook
• Getting Help with Excel

The Excel Interface

•  The Quick Access Toolbar and File Menu
• The Home Tab
• The Insert Tab
• The Page Layout Tab
• The Formulas Tab
• The Data Tab
• The Review Tab

Workbook - Basics 

• Working with Excel
• Basic Excel Features
• Moving your Data
• Smart Tags and Options Buttons
• Editing Tools

Workbook - Editing 

• Cell Formatting
• Conditional Formatting
• Enhancing a Worksheet's Appearance

Workbook - Printing and Viewing 

• Using the View Tab
• Managing a Single Window
• Managing Multiple Windows
• Printing your Workbook
• Print Page Layout options

Charts

• Using Recommended and Standard Charts
• Chart Elements
• Chart Tools - Design & Format