Excel 2013 Advanced Training Courses – Online or Face to Face

Duration: 1 Day

Course Objective:

Creating, Maintaining, Filtering and using Subtotals in a List, Recording, Assigning and using Macros, Creating and using User-Defined Functions, Performing ‘What If’ Analyses, Working with Scenarios, Querying a Database, Importing and Exporting Files and Data, Protecting Data, Pivot Tables, Reports and Charts

Course Contents:

Working with lists

  • creating a list
  • maintaining a list
  • editing records using the data form
  • filtering a list
  • assignment

Working with macros and user-defined functions

  • recording and using macros
  • assigning macros
  • using user-defined functions
  • assignment

Using basic analysis tools

  • performing ‘What If’ analyses
  • working with scenarios
  • assignment

Using advanced analysis tools and external data

  • querying a database
  • importing, exporting files
  • protecting data
  • using data validation
  • using worksheet protection
  • password protecting a workbook
  • assignment

Using business analysis tools

  • working with pivot tables      
  • identifying the parts of a basic
  • pivot table
  • pivot table reports
  • create a pivot table from
  • worksheet data
  • create a pivot table from
  • multiple tables
  • create a pivot table from an
  • external data source
  • create a pivot chart report from
  • an existing pivot table report
  • slicers
  • using slicers
  • formatting slicers for a consistent look
  • sharing slicers between Pivot Tables
  • sparklines
  • types of sparklines
  • create a sparkline
  • customize sparklines
  • control which value points are shown
  • change the style of or format sparklines

Enquire About Excel 2013 Advanced Training Courses – Online or Face to Face Course
This course can be tailored to meet your exact requirements.
 

* fields are mandatory.

What our attendees have said about us:
Very good approachable trainer, and a very useful course.
BMA
Brilliant day, I have learnt a lot. The trainer was very focused and knowledgeable
Bank of England.
Fantastic. Well organised, knowledgeable very friendly and personable. Easily approachable made the class feel welcome.
Ince & Co
An excellent trainer who made the course interesting. A worthwhile course. Thank you
Sandwell College
Very enthusiastic and helpful in explaining, made sure everyone was comfortable before moving to next topic.
Southern Health
Tony was brilliant at setting the right pace to challenge us but not making us feel uncomfortable at all. His training style is excellent.
EISAI
Very good tutor, very pleasurable course and good content, he kept the day interesting.
NFU Mutual
Trainer was very engaging and knowledgeable on subject, I really enjoyed the course.
Can't wait to put it all to practice.
Herefordshire Group