0845 450 6120

Microsoft Excel Introduction 2007-2016

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

FREE E-LEARNING REVISION

Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) class.

DURATION

This is a one-day training course structured into 6 modules

COURSE AIMS

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.

TARGET AUDIENCE

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.

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

Reset

Course Content

MODULE 1Getting 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 2The 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 3Microsoft 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 4Editing 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 5Printing 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 6Working 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

 

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Online Courses

You may prefer an online course if you are looking for a flexible and cost-effective solution. Online courses allow you to study at your own pace, at a time that suits you.

We have the following eLearning options available:

Our Customers Include