Microsoft Excel Level 1

The aim of this course is to provide a good introduction to Creating and Managing Spreadsheets using Microsoft Excel. Even if you have been using Excel for a long time, the shortcuts and extra hints will enable you to be more efficient with the spreadsheets you use.

COURSE CONTENT

Creating, Pinning and Saving Spreadsheets
Using key Shortcut keys for File Management Cell selection
Working with column and row widths
Formatting Text and Numbers
Using Speedfill
Formulas and functions
Subtotals and Grandtotals
Absolute References
Managing Large Files
Working with Multiple sheet files
Printing
Headers and Footers
Filtering and Sorting
Charts and Pivot Tables

Upon completion of the course, participants will be able to:

Create and manage Spreadsheets for everyday use
Understand the principal of Functions
Create and use Multiple Sheet files
Filter and sort Data within a spreadsheet
Create and Manage Charts and Pivot tables

The online course consists of the theory with a range of interactive activities that include:

Experiential learning activities
Individual exercises
Questionnaire
Reflective practices
Workbook

5-6 hours

Account Dashboard

Cart

Related