Excel LEVEL 1

 

Objectives:

This workshop is intended to help all novice computer users get up to speed with Excel quickly. There are different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing.

​

Unit 1 Getting Started:

You will learn how to:

• Identify the elements of the Excel interface

• Create a basic worksheet

• Use the help system.

 

Unit 2 Working with Data:

Priority Management will show you:

• Using formulas and functions in a worksheet

• Working with data

• Rows, and columns

• How to sort and filter data.

 

Unit 3 Modifying a Worksheet:

You will learn how to:

• Format text and cells

• Align cell contents

• Use Find & Select tools

• Spell-check a worksheet

​

Unit 4 Printing Workbook Contents:

You will learn how to:

• Define the basic page layout for a workbook

• Refine the page layout

• Apply print options.

 

Unit 5 Managing Large Workbooks:

You will learn how to:

• Format worksheet tabs

• Manage worksheets

• Manage the view of worksheets and workbooks.

 

Unit 6 Customising the Excel Environment:

You will learn how to:

• Customise general, language, formula, proofing, and saving options

• Use Excel’s version control features

• Customise the ribbon and the Quick Access toolbar

• Enable add-ins and

• Customise advanced and Trust Center options