july, 2019

This is a repeating course

wed17jul9:30 pm4:30 pmEvent OverExcel IntermediateLearn more about Microsoft Excel9:30 pm - 4:30 pm London Victoria, 83 Victoria Street London SW1H 0HW Training Course Price : £295

To book your course simply click add to cart & checkout

Excel Intermediate London

Book Online Now!

Tickets are not available for sale any more for this course!

Training Course Price

£295

Training Course Detials

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

Time

(Wednesday) 9:30 pm - 4:30 pm

Location

London Victoria

83 Victoria Street London SW1H 0HW

Other course dates at this location

22nd august 2019 9:30 am

Organiser

Taylor MasonTraining for the Workplace & Individuals0843 289 1713 PO Box 3125 450 Brook Drive Reading RG1 9RX

X

Send this to a friend