"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Microsoft Excel Level 2 Intermediate Duration: 1 Day

Course Overview

Course Objectives Using multiple worksheets, workbooks and workspaces Working with advanced functions Use advanced formatting techniques Using charts to display data Using Excel as a Database



Target student

This course takes users to a high level of knowledge using multiple worksheets, charting, advanced

functions and advanced formatting.


Delegates should have an understanding of any of the Windows operating system and a good

understanding of Microsoft Excel or alternatively students should have attended MS Excel level 1 training or

have equivalent knowledge.

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
  • 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

Advanced Functions

  • Creating and Using Functions ie If, Vlookup, countif
  • Using Built-in Functions
  • Working with Arguments: Using Dates and Times
  • Using Dates in Calculations
  • Using Nested Functions

Named Ranges

  • Creating and Using Named Ranges
  • Automatically Naming Ranges
  • Navigating with Named Ranges
  • Using Range Names in Formulas
  • Pasting a List of Named Ranges
  • Deleting and Editing Range Names
  • Creating Named Constants

Working with Lists

  • Creating a List
  • Maintaining a List
  • Sorting a List
  • Filtering a List
  • Using Subtotals in a List

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


  • 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

Adding Graphic Elements

  • Creating Graphic Objects
  • Editing a Graphic Object
  • Creating and Editing 3-D Objects
  • Using Other Drawing Tool