Excel Level 1 – Basic
​
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
-
Spellcheck 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 Customizing the Excel Environment:
You will learn how to:
-
Customize general, language, formula, proofing, and saving options
-
Use Excel’s version control features
-
Customize the ribbon and the Quick Access toolbar
-
Enable add-ins and
-
Customize advanced and Trust Centre options