Excel 2013 Intermediate Training Courses – Online or Face to Face

Duration: 1 Day

Course Objective:

Using multiple worksheets, workbooks and workspaces. Working with Financial functions, use advanced formatting techniques, using the Auditing Tools to track information, using charts to display financial data, using macros and templates.

Course Contents:

Using multiple worksheets/workbooks

  • using multiple worksheets
  • creating and using functions
  • inserting new worksheets
  • deleting worksheets
  • creating multiple views
  • freezing panes
  • viewing and arranging multiple worksheet windows
  • navigating in multiple workbooks
  • selecting and viewing multiple workbooks
  • creating and opening a workspace
  • managing multiple worksheets and workbooks
  • selecting multiple worksheets
  • moving and copying data between worksheets
  • linking data between worksheets
  • creating a 3-D formula
  • assignment

Charting  

  • using charts
  • creating a chart
  • changing chart type, style and chart sub-type
  • changes to the chart source data
  • add data to an existing chart
  • change the data in an existing chart
  • managing chart objects
  • deleting chart objects
  • adding data series and objects to a chart
  • printing charts

Advanced functions

  • using built-in functions
  • working with arguments
  • the PMT function
  • using dates and times
  • using dates in calculations
  • using nested functions
  • auditing worksheets
  • identifying the auditing commands
  • the watch window
  • the formula evaluator
  • tracing and correcting worksheet errors
  • assignment

Advanced formatting

  • using comments in a worksheet
  • reviewing, showing and hiding comments
  • deleting a comment
  • working with styles
  • applying a style
  • modifying existing styles
  • using format painter
  • creating custom number formats
  • applying an AutoFormat (table format)
  • remove data from chart
  • conditional formats
  • clear conditional formats

Enquire About Excel 2013 Intermediate 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 clear, adapted course to suit our needs.
London Borough of Redbridge
Tony was extremely patient and gave me lots of ideas to help me with my job. I learnt a lot of short cuts to save me typing the same thing.
LGA Ltd
Excellent. The trainer was very knowledgeable which made me feel very relaxed - ideal style of training for me.
Hammersmith Council
A very good course, Tony was friendly and interactive.
Griffin Travel
I really enjoyed the training, I feel more confident and can not wait to get back to the office.
Port of Tilbury
Very knowledgeable and ready to explain how we could utilise the information to suit our needs. Tony made the learning fun - thank you.
Barry Stowart & Sons
I attended the Introduction course with Tony, and pleased to say I enjoyed this course just as much. I will definitely be on his Advanced course.
Curtiss Wright
The trainer was very helpful made sure we understood each topic before carrying on.
Lend Lease
Very good, informative and approachable.
MacMillan Cancer Support