Home / Training Courses / EXLL1: Microsoft Excel - The Essentials

Training Courses

search courses

EXLL1: Microsoft Excel - The Essentials

Guaranteed to Run Scheduled Fully Booked
Location
Christchurch
Auckland
Wellington
Jan 2020
20
23
27
Feb 2020
10 24
3 17 27
10
Mar 2020
16 30
5 16 27
2 16 30
Apr 2020
14
9 17 28
13 20
May 2020
20
4 18
Jun 2020
22
8 22
Jul 2020
20
6 20 27
Aug 2020
19
10 24
Sep 2020
14
14 28
Oct 2020
12
12
Nov 2020
16
2 16 30
Dec 2020
7
Code: EXLL1
Length: 1 Day
Overview

Learn the fundamentals of Microsoft Excel.

Delivery format(s)
On-Site
On-Site
Classroom
Classroom
OBJECTIVES
This course is intended for students who wish to gain the foundational understanding of Microsoft Excel. You will use Microsoft Excel to create spreadsheets and workbooks containing values and formulas that can be used to store, manipulate, and share data.
PREREQUISITES

You should be comfortable with the windows environment.

WHAT YOU’LL LEARN

After completing this course, students will be able to:

• Open Microsoft Excel and identify the components of the Excel interface; identify spreadsheet areas and terminology; create and save a workbook; navigate worksheets; and enter and edit text and values.

• Create simple mathematical formulas; move and copy formulas using AutoFill and use Paste Link; view formulas in a spreadsheet; work with relative and absolute references; and use the SUM function, AutoSum, and other common functions to perform calculations in a worksheet.

• Modify a worksheet by inserting and deleting ranges, rows, and columns; find and replace text and data; check spelling and use the other research and proofing tools.

• Format text, cells, rows, and columns; apply colour and borders; format numbers; apply conditional formats; use the Format Painter; and create and use templates.

• Preview and print a worksheet; set page orientation and margins; create and format headers and footers; and print gridlines.

• Manage worksheets by inserting, renaming, deleting, moving and copying sheets; navigate Excel views and set workbook properties.

WHO SHOULD ATTEND

Anyone new to Microsoft Excel or those with limited experience.

COURSE OUTLINE

Getting started 
• Spreadsheet terminology
• The Excel environment
• Navigating a worksheet
• Using a template

Entering and editing data 
• Entering and editing text and values 
• Entering and editing formulas 
• Saving and updating workbooks 

Modifying a worksheet 
• Moving and copying data 
• Moving, copying, and viewing formulas 
• Absolute and relative references 
• Inserting and deleting ranges, rows, and columns 

Functions
• Entering functions 
• AutoSum 
• Other common functions 

Courses you might be interested in

EXLL2: Microsoft Excel - Managing Data and Large Workbooks Microsoft Office, Microsoft Excel Code: EXLL2 Learn how to create advanced formulas and analyse data.
EXLL3: Microsoft Excel - Data Analysis and Reporting Microsoft Office, Microsoft Excel Code: EXLL3 Learn to perform advanced data analysis, collaborate and automate workbook functionality.
EXLPT: Excel Data Analysis with PivotTables Microsoft Office, Microsoft Excel Code: EXLPT Harness the power of advanced PivotTable features.
EXLBP: Best Practices for Microsoft Excel Microsoft Office, Microsoft Excel Code: EXLBP Planning carefully, thinking ahead and setting up worksheets and workbooks in a standard and conventional way will lead to robust and scalable spreadsheets.
EXLPP: Excel Data Analysis with Power Pivot Microsoft Office, Microsoft Excel Code: EXLPP Use Power Pivot to help you organize, manipulate, and report on your data in the best way possible.

Enquiry Form