Microsoft Excel 2013 Intermediate

Course Details

This Excel course is aimed at those who wish to build on their knowledge of the latest version of Microsoft Excel and gain a more detailed understanding of what the software can offer.

Our Microsoft Excel 2013 courses are delivered in over 50 locations nationwide. The course is accredited by Microsoft and includes all course materials, a manual and a certificate.

Course Contents

The course includes the following modules:

Advanced File Tasks

  • Saving and File Management 
  • Converting and Encrypting Files 
  • File Properties and Digital Signatures 
  • File Accessibility and Compatibility

Working with Functions and Formulas

  • Formulas with Absolute References 
  • AutoSum Functions (SUM & AVERAGE) 
  • IF and Nested Functions 
  • Working with Named Ranges 
  • Array Functions (SUMIF & AVERAGEIF) 
  • Formula Auditing

Managing Tables

  • Creating Excel Tables 
  • Working with Records and Filters 
  • Advanced Filters

Data Tools

  • Text to Columns 
  • Flash Fill 
  • Remove Duplicates 
  • Data Validation 
  • Consolidate

Doing More with Charts

  • Trend lines 
  • Error Bars 
  • Working with Axis Options 
  • Advanced Chart Formatting

Spark lines

  • Creating Spark lines 
  • Editing Spark lines 

FAQ's

What are the prerequisites for this course?

The course has no prerequisites.

What am I provided on the course?

You will be provided with an official courseware folder, detailed user-friendly manual, pre/post course email support, refreshments and a certificate of completion.

Who will be instructing me?

You will be a taught by a qualified, knowledgeable instructor with years of experience in their field.

When should I arrive to the venue?

You should aim to arrive at 9am.

How can I contact you?

If you would like more information about any course please feel free to either contact us on 01159 031 029 or you can email us at info@coursebargains.com.