top of page


Foundation Microsoft Excel Training

Microsoft Excel is the world's most well-known and most used spreadsheet application. It comes with an overwhelming number of uses, that can sometimes feel a little daunting.
Our Foundation Microsoft Excel training is designed for individuals with little or no experience with this incredibly powerful application.
Let us help build your confidence with Microsoft Excel and start you on your journey to being more productive and proficient.
What will you learn?
01
An Introduction to Microsoft Excel
-
The anatomy of Excel
-
Manipulating Sheet tabs
-
Cells, rows and columns
-
Cell locking, protection and security
-
Saving in different file formats
-
Savings and using templates
03
Useful Commands
-
The find and replace tool
-
Freeze panes
-
The fill handle
-
Flash fill
05
Printing and PDF Creation
-
Common printing problems and how to solve them
-
Page breaks
-
Print areas
-
Headers & Footers
02
Formatting
-
Using the ribbon to format
-
Cell styles
-
The format painter
-
The format cells menu
04
Basic Formulas and Functions
-
Understanding formulas
-
Introducing AutoSum
-
Cumulative totals
-
Working with basic functions: AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, TRIM, PROPER, UPPER, LOWER, LEN, ROUND, ROUNDUP, ROUNDDOWN, TODAY, NOW
06
Data Analysis
-
Sorting
-
Filtering
-
Getting started with Charts
-
Sparklines
How can you learn?
Want to book? Get in touch today!
bottom of page