Skip to main content Help with accessibility Skip to main navigation
MLCSU Academy logo

MLCSU Academy

Excel Introduction - half day 7 Apr 22

Event Date:

7 April 2022 9:30 AM - 12:00 PM

Closing 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
Course information

Category:

Online

Trainer:

Sharon Tew

Location:

online