Microsoft Excel Introduction Training Course

Our Microsoft Excel Introduction Course will ensure your team members have sound working knowledge of Excel. This course gives a solid introduction Microsoft Excel and its data management features. It is designed for Excel 2013, 2016, 2019 & 365.

Who is this course for?

Our Microsoft Excel Introduction course is suitable for beginners (individuals or corporate) to Microsoft Word or those that need a solid foundation to the basics of Word.

Prerequisites

A working knowledge of Microsoft Windows. No knowledge of Excel is required

Benefits

  • At the end of this course you will have a good working knowledge of Excel basics.
  • You will feel more confident using Excel and be able to create a spreadsheet from scratch.
  • Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments.
  • Spreadsheets that you create will be easier to use and look more presentable.
  • After completing this course you will be prepared to attend the Excel Intermediate training course.
  • At the end of this course you will have a good working knowledge of Excel basics.
  • You will feel more confident using Excel and be able to create a spreadsheet from scratch.
  • Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments.
  • Spreadsheets that you create will be easier to use and look more presentable.
  • After completing this course you will be prepared to attend the Excel Intermediate training course.

Course Outline

Getting Started

Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks

Entering and Editing data

Best practice spreadsheet design
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks
Flashfill

Modifying a Worksheet

Moving and copying data
Moving and copying formulas
Inserting and deleting ranges

Using Functions

Entering functions
Using AutoSum
Using AVERAGE, MIN, MAX and COUNT
Absolute and Relative cell references

Formatting Worksheets

Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat

Working with Large Worksheets

Viewing options
Adjusting zoom
Using Freeze Panes
Hiding and displaying data
Hiding rows and columns
Creating an outline

Printing

Preparing to print
Page Setup options
Printing large worksheets
Page Break preview
Working with page breaks
Printing multiple sheets

Using Templates

Built-in templates
Accessing and using Excel’s templates
Creating, using and modifying a custom template file

Training Mode

  • Online/virtual
  • Physical/in-person

Get In Touch

Send us a message & we will respond shortly

Registration Form

Enter your name, like you want it to appear on your Certificate