Excel 2016 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 to automate your work environment. Use Templates

Course Contents:

Using Multiple Worksheets and Workbooks

  • Using Multiple Worksheets
  • Inserting New Worksheets
  • Renaming Worksheets
  • Deleting Worksheets
  • Creating Multiple Views
  • Freezing Panes    
  • Viewing and Arranging Multiple Worksheet Windows
  • Navigating in Multiple Workbooks
  • Selecting and Viewing Multiple Workbooks
  • 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
  • Remove data from a chart
  • Managing Chart Objects   
  • Moving and Resizing Chart Objects
  • Deleting Chart Objects
  • Adding Data Series and Objects to a Chart
  • Changing the Chart Type
  • Formatting Chart Objects
  • Printing Charts

Advanced Functions

  • Creating and Using 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)
  • Conditional Formats
  • Clear conditional formats

Enquire About Excel 2016 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:
Brilliant, outstanding knowledge on subject. I really enjoyed the day, thank you.
Maritime Museum
Excellent all round knowledge, very informative training.
Carpetright
The trainer was more than willing to go off track when required to and made sure everyone was content with all the subjects covered. Really friendly approach.
Premier Modular
Great sense of humour and dealt with us perfectly when we wilted a bit in the afternoon. His knowledge is superb.
Royal Albert Hall
A well delivered course, good content and pace.
Port of Tilbury
A very well presented course, clear, concise and knowledgeable.
Metropolitan Police
Another good course and led on well from the Introduction to Excel. Trainer explained different functions in a way I could understand.
London Borough of Redbridge
Trainer used excellent communication skills to meet the needs of individuals. Perfect.
London Borough of Havering
Very good and friendly. Explained what we needed to know in a simple way.
GAB Robins
Great knowledge of subject and taught in a professional manner.
Weber