Excel Introduction

Call Us On:
0118 324 3000

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

Overview

This course will provide you with the foundational Excel knowledge and skills necessary for business today. As you apply the robust functionality that's part of Excel to your organization's raw data, you will be able to gain a level of insight into that data that would have been almost impossible years ago. Excel helps you organize, calculate, analyze, revise, amend, and present your data in ways that will help you and the decision makers in your organization steer forward in the right direction

Course Requirements

Learners must be confident using a mouse and keyboard.

What will you learn

In particular you will be able to:

Get working with Microsoft Excel efficiently and effectively
Perform calculations
Optimize your worksheets by creating and using formulas
Modify worksheets to manipulate and edit data
Format and style worksheets to get more impact from data

1. Getting Started With Excel

Starting Excel
Selecting the Blank Worksheet Template
The Excel Cell Referencing System
Entering Numbers and Text
Default Text and Number Alignment
Summing a Column of Numbers
Entering a Date
Worksheets and Workbooks
Saving a Workbook to Your Hard Disk
Creating,Opening and Closing a Workbook
Opening a Recently Used Workbook
Saving a Workbook Using another Name
Getting Help within Excel

2. Excel Selection Techniques

Why Are Selection Techniques Important?
Selecting a Cell, a Row and a Column
Selecting a Range of Cells
Selecting a Range of Rows
Selecting a Range of Columns
Selecting the Entire Worksheet
Recommended Techniques When Creating or Editing Lists

3. Manipulating Rows And Columns Within Excel

Inserting Rows and Columns into a Worksheet
Deleting Rows and Columns within a Worksheet
Modifying Column Widths
Modifying Column Widths Using 'Drag and Drop'
Automatically Resizing the Column Width to Fit Contents
Modifying Row Heights

4. Manipulating Cells and Cell Content within Excel

Copying a Cell or Range Contents within a Workbook
Deleting Cell Contents
Moving the Contents of a Cell or Range within a Workbook
Editing Cell Content
Undo and Redo
Copying or Moving Data between Worksheets (Within the Same Workbook)
Copying or Moving Data between Worksheets (In Different Workbooks)
AutoFill
Copying a Data Range Using AutoFill
Searching and Replacing Data

5. Excel Worksheets

Switching between Worksheets
Renaming a Worksheet
Recommended Techniques with Naming Worksheets
Inserting and Deleting a Worksheet
Copying or Moving a Worksheet within a Workbook
Copying or Moving Worksheets between Workbooks

6. Alignment Formatting within Excel

Horizontally Aligning Contents in a Cell Range
Centring a Title over a Cell Range
Text Wrapping within a Cell
Format Painter

7. Number Formatting within Excel

Number Formatting
Decimal Point Display
Applying and Removing Comma Style
Formatting (To Indicate Thousands)
Currency Symbol
Date Styles
Percentages

8. Freezing Titles

Freezing Row and Column Titles

9. Excel Formulas

Creating Formulas
The Easy Way to Create Formulas
Copying Formulas
Operators
Using Operators in Formulas
Relative Cell Referencing within Formulas
Absolute Cell Referencing within Formulas

10. Excel Functions

What Are Functions?
Common Functions
Sum and Average Function
Max and Min Function
Count and Counta Function

11. Excel Charts

Inserting a Column Chart
Changing the Chart Type
Formatting Charts

12. Customising Excel

Modifying Basic Excel Options

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

Training Centres

1 Day Course

Mon, 6 Jan 2025

Virtual

£275

Mon, 3 Feb 2025

Virtual

£275

Mon, 3 Mar 2025

Virtual

£275

Mon, 7 Apr 2025

Virtual

£275

Tue, 6 May 2025

Virtual

£275

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:

At Your Offices

Virtual Online

Training Centres

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

Sian Stephenson - Aldi Stores Ltd

Very good introduction. Well paced and suited a range of experience levels.

Felicity Howdle - Health Education England

Very clear instruction, pace was kept moving, great snippets of advice given.

Robert Montgomery - Liberty Aluminium Technologies

The trainer was a really good instructor, he took the time to help us with individual issues and also tried to cater the course to meet our collective needs.

Ben Knight - Atlas Copco Ltd

Trainer was very engaging, spent time explaining topics clearly.

Laura Choake - Desoutter Industrial Tools

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

Next on Mon 6 Jan

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 Mon 9 Dec

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 Wed 11 Dec

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.

Payments processed by card