november, 2019

This is a repeating course

2019mon11nov9:15 am4:30 pmEvent OverExcel IntermediateBuild on your Excel Knowledge9:15 am - 4:30 pm GMT 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

monday 11 november 2019 9:15 AM - monday 11 november 2019 4:30 PM GMT

Location

London Victoria

83 Victoria Street London SW1H 0HW

Organiser

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

Send this to a friend