Phone 1300 793 951 or visit www.odysseytraining.com.au

Odyssey Training Logo
Microsoft Excel Introduction Training Course

Microsoft Excel Introduction

1 Day Training Course

Book a public course

Venue – Brisbane

Odyssey Training
Level 1, 60 Edward St
Brisbane QLD 4000
View map and directions

Times and Dates

6 Oct 2017
1 Day     9:00 am – 4:00 pm

Need your training approved?

Computer Course Inclusions
 

Course overview

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.

Course prerequisites

Participants will need to be familiar with Microsoft Windows and basic Windows techniques such as opening, closing and saving files.

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

Home > Microsoft Excel Training > Excel Introduction Course > 2016

Our Training Courses

- +
Subtotal