What you'll learn

This intensive one-day training course is designed to let users get to grips with the main features of Microsoft Office Excel 2007, 2010, 2013 or 2016, including a thorough treatment of the new 'Ribbon' interface, originally introduced with Excel 2007. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Requirements

A basic understanding of Microsoft Windows

Description

MODULE 1: Getting Started with Microsoft Excel

Learning outcomes: Starting Excel and some of its basic navigation and help controls.

Topics covered:

Starting Out

About Workbooks

Exploring your Workbook

Getting Help with Excel

MODULE 2: The Excel Interface

Learning outcomes: A look at the Ribbon interface and the different tabs and options the Ribbon offers.

Topics covered:

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

MODULE 3: Microsoft Excel Basics

Learning outcomes: Identify and Use Cells, Columns, Rows, Workbooks to enter and manage data.

Topics covered:

Working with Excel

Moving your Data

Basic Excel Features

Smart Tags and Options Buttons

Editing Tools

MODULE 4: Editing your Workbook

Learning outcomes: Understanding formatting features and enhancing a workbook's overall appearance and using Conditional Formatting.

Topics covered:

Cell Formatting

Conditional Formatting

Enhancing a Worksheet's Appearance

MODULE 5: Printing and Viewing your Workbook

Learning outcomes: Exploring Excel's printing and viewing options enhancing your ability to print and work with your data effectively.

Topics covered:

Using the View Tab

Managing a Single Window

Managing Multiple Windows

Printing your Workbook

Print Page Layout options

MODULE 6: Working with Charts in Excel

Learning outcomes: Introducing charts within Excel and explain how to create basic charts to help convey your data with.

Topics covered:

Using Recommended and Standard Charts

Chart Elements

Chart Tools - Design & Format

Who this course is for:

The course is intended for new users of Microsoft Excel 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.