This is a selection of our course dates and locations, please call or email for other course details. Callback Request

Loading Public Courses

« All Public Courses

  • This public course has passed.

Excel Intermediate

Wednesday, November 22nd, 2017 @ 9:30 am - 4:30 pm

£295
CPD CERTIFIED COURSE
CPD accredited course

 

Note: this Excel Intermediate course is CPD certified.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate.

 COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

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.

MODULE 1:  Advanced 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 2:  Working 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:
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Formulas with Absolute References
  • Text Functions
MODULE 3:  Managing 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 4 Data 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 5:  Doing 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 6 Sparklines
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

Tickets

Unlimited available
Excel Introduction Training Course Manchester£295.00

Please fill in all required fields

Details

Date:
Wednesday, November 22nd, 2017
Time:
9:30 am - 4:30 pm
Cost:
£295
Public Course Categories:
, , , , ,
Public Course Tags:
,

Venue

London – Tower Bridge
46-48 East Smithfield London E1W 1AW + Google Map

Organiser

Taylor Mason
Phone:
0843 289 1713
Email:
info@taylor-mason.co.uk
Website:
www.taylor-mason.co.uk
X

Send this to a friend