No Upcoming Events
No upcoming Scheduled Courses. Contact us for information on booking a private course or join the waiting list for a public event.
Contact Us
An ideal introduction to Microsoft Excel
Descriptions
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 ExcelUse Excel as a day to day user
Present data graphically
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.
Prerequisites
There are no prerequisites for this course.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 MoreLatest News from Quanta
Service Management State of Play: All talks available to watch now.
Following the recent Service Management State of Play event in collaboration with PeopleCert, we are pleased to share the presentations…
Read More
Quanta Achieves FTG Gold Partner Status
We’re thrilled to share that Quanta Training has been awarded FTG Gold Partner status at this year’s FTG (Forces Transition…
Read More
ITIL Version 5: Bringing Clarity, Confidence & Connection to the Digital Age
With the launch of ITIL Version 5, Quanta’s head of portfolio for IT Service Management and ITIL Master, Adam White-Bower…
Read More