Microsoft Excel Refresher Essentials
Course Duration: 90 Minutes
Target Audience:
This session is designed for those who have not used Excel in a long time or are intermittent users and would like to refresh their key skills in Excel.
Course Objectives:
To develop a good working knowledge of Excel to include features such as basic functions and formulas, sorting and filtering data, formatting and printing spreadsheets.
Course Outline:
Course Introduction
Microsoft Excel Basics
-
Creating a new Workbook and new Worksheet
-
The Excel screen and user environment
-
Entering data into a Worksheet, and managing columns and rows
-
Formatting information to look professional
-
Printing the information and using Print Preview
-
Saving and closing a Workbook
-
Opening existing Workbooks
-
Creating standard formulas
-
Formula concepts within Excel
-
The four different mathematical operators
-
The order of operators within a formula
-
Editing formulas in-cell and using the Formula Bar
-
Using Copy & Paste, and the Autofill feature
-
Understanding Relative and Absolute cell referencess
-
What is are Functions in Excel?
-
Using Standard Functions - Sum, Average, Max, Min, and Count
Discussion and Question Time
Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.