top of page

Public workshops are available, and private group training sessions are available for all our courses.

PriorityTech Logo
Excel Training

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

bottom of page