Microsoft Excel Fundamentals

An ideal introduction to Microsoft Excel
Overview

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.

Course Code
MSE1FND
Duration
1 Day
Delivery Style
Classroom
Course Type
Public or Private
Max Delegates
12
Available as Nutshell
No

Book your team training at your premises

  • Date
  • Venue
  • Cost
  • More info

Book your place

  • Date
  • Venue
  • Cost
  • Availability
  •  
  • 14 Jan 2019
  • VenueWorcester
  • Cost£295
  • AvailabilityAvailable
  • Book Now
Purpose of this course

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

Who is this course for

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

You will learn how to
  • Create and customise workbooks in Excel
  • Use Excel as a day to day user
  • Present data graphically

If you wish to keep a copy of the exercises that you produce on this course, please remember to bring a USB memory stick along with you.

Benefits for your organisation

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

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.

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
Prerequisites

There are no prerequisites for this course.

About the Lead Trainer

Jason is one of the technical trainers here at Quanta covering areas such as the CompTIA course track and Microsoft systems and applications. Jason has previously worked as a web designer, system administrator and technical consultant for organisations including a plant nursery and web service provider.

When he’s not at Quanta, Jason is an avid American Football fan and can also occasionally be found singing and dancing with local Amateur Gilbert and Sullivan societies. He does however promise to keep the theatrics to a minimum in the classroom.