0845 450 6120

Microsoft Excel Intermediate 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 hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010, 2013 or 2016, in order to increase their knowledge and productivity.

 
TARGET AUDIENCE

Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

 

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

 

Reset

Course Content

MODULE 1Advanced File Tasks

Learning outcomes: A look at some important administrative features which are useful for managing and controlling Excel files.
Topics covered:
  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility
MODULE 2Working with Functions and Formulas
Learning outcomes: Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.
Topics covered:
  • Formulas with Absolute References
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Text Functions
MODULE 3Managing Tables in Microsoft Excel
Learning outcomes: Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.
Topics covered:
  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters
MODULE 4Data Tools in Excel
Learning outcomes: Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.
Topics covered:
  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate
MODULE 5Doing More with Charts in Excel
Learning outcomes: Developing your ability to effectively create charts and format them specific to the reader
Topics covered:
  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting
MODULE 6Sparklines
Learning outcomes: Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand out
Topics covered:
  • Creating Sparklines
  • Editing Sparklines
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