"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 1 Day

Course Overview

The Intermediate Microsoft Excel course provides knowledge of the more advanced functions of Excel for anyone looking to develop their Excel skills further. From Advanced Formulas and Functions, Using Named Ranges and Charting you’ll be equipped with the knowledge and skills you need to work with Excel on a more advanced level.



Prerequisites: A working knowledge of Excel to L1 Introductory level or equivalent working knowledge.

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

Advanced Functions

  • Working with BODMAS
  • Defining Relative, Mixed, and Absolute References
  • Creating and Using Functions:
  • IF and Nested IF
  • Sumif and Countif
  • Understanding and working with Dates
  • Subtotals
  • Flashfill

Protecting and maintaining workbooks

  • Saving as a template
  • Protecting a Worksheet
  • Protecting a workbook

Moving and Copying Data between Worksheets

  • Linking Data Between Worksheets
  • Creating a 3-D Formula

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

  • Sorting a List
  • Filtering a List
  • Advance Filter
  • Using Subtotals in a List
  • Outlining
  • Data Validation
  • Dropdown menus using Validation lists

Advanced Formatting

  • Creating Custom Number Formats
  • Applying an AutoFormat (Table Format)
  • Conditional Formats
  • Clear conditional formats


  • Creating a Chart
  • Changing Chart Type, Style, and Chart Sub-Type
  • Change the data in an existing chart
  • Filter in charts
  • 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
  • Dual Axis
  • Saving Chart Template
  • Sparklines