Excel Introduction - half day 7 Apr 22
Event Date:
7 April 2022 9:30 AM - 12:00 PMClosing Date:
Description:
Getting Started
- Entering text and numbers
- Data entry techniques
- Data entry keyboard shortcuts
- Editing data
- Worksheet navigation shortcuts
- Data selection techniques
Formatting
- Changing fonts, size and applying colour
- Changing number style and decimal points
- Exploring cell formatting
- Formatting rows and columns
Sorting and Filtering
- Using Sort and Custom Sort options
- Applying Filters
- Using filters to analyse data
Simple formulae
- Using Auto calculate
- Using Excel like a Calculator
- Using the Autosum function
Printing
- Hassle free 1-2-3 printing rules
- Print Preview
- Page Setup
- Printing part of a worksheet
Charts
- Insert a Quick Chart
- Insert a chart from the ribbon
- Formatting Charts
Online training will be delivered via MS Teams. You will receive joining instructions before your selected session
On successful completion of this course you will be able to:
- Review spreadsheets and navigate a worksheet
- Select and format columns, rows and cells
- Use data entry techniques
- Add and edit formulae including Autosum and calculator functions
- Print and adjust page setup functions