top of page
Businessman typing on laptop

Foundation Microsoft Excel Training

Microsoft Excel Logo

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?

Check out our other courses

Excel.png

Intermediate Microsoft Excel

Excel.png

Advanced Microsoft Excel

Power BI.png

An Introduction to Power BI

Power BI.png

Further

Power BI

Want to book? Get in touch today!
How can I help?
bottom of page