IT Microsoft Excel Fundamentals

Course Code: MSE1FND

Book

Duration

1 Day(s)

Course Type

Public or Private

Max Delegates

Delivery Style

Classroom

Home » Microsoft Excel Fundamentals

An ideal introduction to Microsoft Excel

Excel has long been a popular choice for creating spreadsheets, analysing data and creating graphical representations of information. There are few things in life more impressive than a properly formatted and presented spreadsheet, so if you want to dazzle colleagues with your workbook wizardry or automate a process you repeat every day then this is the course for you! This course can be run using Excel 2010, 2013 or 2016. Please discuss your version requirements with us when booking.

Book a Private Event

If you require the content of this event tailored or have around 7 or more people to train it maybe better for you to host a Private Event, please get in touch to discuss this.

Get in touch

Who is this course for

Anyone that manages, stores or looks at data as part of their role.

Purpose of the course

This course will introduce you to Excel and give you the skills to use the program every day.

You will learn how to

Create and customise workbooks in Excel
Use Excel as a day to day user
Present data graphically

Prerequisites

There are no prerequisites for this course.

Benefits for you as an individual

An in depth knowledge of Excel is useful for any role in an organisation and can make day to day data management quicker and easier.

Benefits for your organisation

This course will enable delegates to format and present data in easier to understand ways.

Welcome to Excel

Workbooks and Worksheets
File types
Spreadsheet navigation

Excel Interface

The Quick Access Toolbar
Excel Ribbon
Overview of Tabs
Command groups

Excel Basics

Labels
Printing
Autosum and Autofill
Copy/Cut/Paste
Introduction to Formulae

Workbook Formatting

Modification of cells and cell data
Styles and borders
Chart creation and modification
Cell referencing

Functions and Formulae

Mathematical operators
Error checking
Nested functions
Array formulae

Tables

Creation and formatting
Sort and filter
Excel as a database

Data as a Graphic

SmartArt
Symbols
Add and edit shapes
Sparkline

Get Started

Forget trawling through endless course catalogues – Find the training that’s right for you

Learn More