request@systematix.co.uk
supermarketBasket
Call Us On:
0118 324 3000

Exciting News! Systematix is rebranding to Future Savvy. Same great services, with a fresh new look. Learn More

banner image

Excel Intermediate

1 Day Instructor-led
course icon

Course Information

Overview

This course is designed for learners who already have foundational knowledge and skills in Microsoft Excel and who wish to take advantage of some of the higher-level functionality in Excel to analyze and present data. Upon completion of this course, you will be able to leverage the power of data analysis and presentation to make better informed, intelligent organizational decisions.

Course Requirements

Learners should have used Excel before and be familiar with creating basic formulas, using Autofill along rows or columns and working with Absolute Cell References (e.g. $C$5) to refer to fixed figures – such as VAT rates or performance targets.

What You Will Learn

In particular you will be able to:

  • Create advanced formulas
  • Work with named ranges
  • Analyze data by using functions and conditional formatting
  • Organize and analyze datasets and tables
  • Manipulate worksheets

Course Outline

Download PDF Outline
1. Excel Setup & Printing Issues
  • Headers and Footers
  • Scaling Your Worksheet to Fit Page(s)
  • Printing Titles on Every Page
  • Previewing a Worksheet
2. Excel Functions and Formulas
  • Getting Help with Functions
  • Nested Functions
  • Consolidating Data Using a 3-D Reference Sum Function
  • Mixed References within Formulas
3. Excel Most Used Functions
  • Inserting the Current Time and Date
  • Today Function
  • Now Function
  • Round Function
  • Sumif Function
  • If Function
  • Trim Function
  • Concatenate Function
  • Vlookup Function
4. Excel Named Ranges
  • Naming Cell Ranges
  • Removing a Named Range
  • Named Cell Ranges and Functions
5. Excel Cell Formatting
  • Conditional Formatting
  • Custom Number Formats
6. Manipulating Worksheets within Excel
  • Copying or Moving Worksheets between Workbooks
  • Hiding Rows
  • Hiding Columns
  • Un-Hiding Rows
  • Un-Hiding Columns
7. Paste Special Options within Excel
  • Using Paste Special ‘Values’
8. Tables
  • Preparing data for a table
  • Creating a table
  • Formatting a table
  • Display the table total row
  • Adding a row to a table
  • Deleting a row from a table
  • Inserting a column in a table
  • Deleting a column in a table
  • Renaming a table
  • Advantages of a table

Dates & Prices

Attend one of our public Excel courses:

Small Class Sizes

Maximum of 6 students per course.

Reference Manual

High quality reference manual supporting the topics covered.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:
Virtual Online Virtual Online
Choose a location...
1 Day Course
Wed, 8 Jan 2025
Virtual
£275
Thu, 6 Feb 2025
Virtual
£275
Thu, 6 Mar 2025
Virtual
£275
Thu, 10 Apr 2025
Virtual
£275
Thu, 8 May 2025
Virtual
£275

Private Courses

We can arrange your own private Excel course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:
On-Site At Your Offices
Virtual Online Virtual Online
Training Centres Training Centres

What Our Clients Think

Really good trainer. He made the training interesting and fun.

Wendy Sipson - Hampshire Constabulary

I found the course very relevant to a lot of the day-to-day work I do.

Sian Stephenson - Aldi Stores Ltd

The trainer was very through and very helpful. The course was delivered superbly and I'm very pleased.

David O'Hara - Multibrands UK

This course was excellent and I am delighted with how much I have achieved. The trainer was very friendly and approachable.

Rosie Heath - Licensed Trade Charity

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

The pace he delivered the course was perfect and he explained everything so clearly and in a way I could understand.

Jessica Homer - All About Food

Related Courses

Next on Mon 6 Jan

Excel Introduction

Format:
Virtual or Classroom
Length:
1 Day
This introductory Microsoft Excel course is ideal for beginners who want to learn how to:
  • Produce spreadsheets
  • Work with data
  • Perform basic calculations
Next on Wed 8 Jan

Excel Intermediate

Format:
Virtual or Classroom
Length:
1 Day

This course has been developed for people wanting to use Excel to perform calculations with a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

Next on Fri 10 Jan

Excel Advanced

Format:
Virtual or Classroom
Length:
1 Day
  • Work with multiple workbooks and worksheets at the same time
  • Share and protect workbooks
  • Automate workbook functionality
  • Apply conditional logic
  • Audit worksheets
  • Present your data visually effectively
Next on Mon 13 Jan

Excel VBA Introduction

Format:
Virtual or Classroom
Length:
2 Days
  • Understand the functions of Excel VBA
  • Understand applications of Excel VBA to improve efficiency
  • Use Excel VBA to enhance efficiency of the software
  • Investigate and solve problems related to Excel VBA

Excel Dashboards

Format:
Virtual or Classroom
Length:
1 Day
  • Create advanced formulas
  • Automate workbook functionality
  • Apply conditional logic
  • Visualise data using basic charts
  • Implement advanced charting techniques
  • Use PivotTables, slicers and PivotCharts to analyse data

Excel Pivot Tables

Format:
Virtual or Classroom
Length:
1 Day
  • Prepare data for PivotTables
  • Create PivotTables from various data sources
  • Analyse data using PivotTables
  • Work with PivotCharts

Excel PowerPivot

Format:
Virtual or Classroom
Length:
1 Day
  • Utilise Power Pivot in your data analysis
  • Visualise Power Pivot data
  • Apply the advanced functions to your data

Excel Power Query Introduction

Format:
Virtual or Classroom
Length:
1 Day

Learn the basics of the M language and how to use Power Query to organise and query your data inside Excel.