$438.91

Multiple Dates

Microsoft Excel Introduction - 1 Day Course - Brisbane

Event Information

Share this event

Date and Time

Location

Location

Odyssey Training (RACQ Building)

Level 1, 60 Edward St

Brisbane, QLD 4000

Australia

View Map

Event description

Description

Get the basic skills to produce spreadsheets, work with data and perform basic calculations.


This course is ideal for

This basic Microsoft Excel 2016 course is ideal for beginners who want to learn how to produce spreadsheets, work with data and perform basic calculations.


What you will learn

  • Create, modify and format a spreadsheet

  • Use basic formulas and functions

  • Calculate and manage multiple worksheets

  • Create a chart

  • Customise the print settings and print


Topics covered in this training course


Overview

  • Navigation shortcuts

  • Quick range selection techniques

  • Getting data into your spreadsheet

  • Data entry ranges


Formatting the worksheet

  • Adjust column widths

  • Indenting

  • Centre aligning

  • Merging and centring

  • Text Wrap


Formulas

  • The Sum function

  • AutoSum

  • AutoFill a formula

  • Basic formulas

  • BOMDAS rule

  • AutoCalculate

  • Editing formulae


Multiple worksheets

  • Copy and paste

  • Copy an entire sheet

  • Calculating across worksheets

  • Copying formulas

  • Renaming sheets

  • Inserting/deleting a sheet

  • Grouping sheets


Functions

  • The AVERAGE function

  • The MAX function

  • The MIN function


Formatting text and numbers

  • Font formatting

  • Number formatting

  • Borders

  • Cell shading

  • Format painter

  • Adding comments


Working with columns and rows

  • Inserting columns/rows

  • Deleting columns/rows

  • Hiding columns/rows

  • Freeze panes

  • AutoFill sequences


Sorting and filtering

  • Quick list sorting

  • Basic list filtering


Charts

  • Selecting data to chart

  • Creating a chart

  • Changing the chart type

  • Switching columns/rows

  • Adding titles

  • Reposition the legend

  • Using chart layouts

  • Printing a chart

  • Pie chart specifics


Printing and page setup

  • Print preview

  • Margins, orientation, scaling

  • Page layout view

  • Page break preview

  • Headers and footers

  • Printing titles on all pages

  • Setting a print area

  • Print

  • Save as PDF

Share with friends

Location

Odyssey Training (RACQ Building)

Level 1, 60 Edward St

Brisbane, QLD 4000

Australia

View Map

Save This Event

Event Saved