Microsoft Excel - Introduction Course - Bunbury

Overview

Participants will gain fundamental skills in creating, formatting and printing spreadsheets using Microsoft Excel.

   

Content

Spreadsheet Concepts

  • Introduction to the Excel environment & the components available to the user
     

Working In The Worksheet

  • Moving around the worksheet
  • Entering text, numbers and simple formulae
  • Cell referencing in formulae
  • Cell selection techniques
  • Cut, copy & paste data
  • Inserting & deleting cells, columns, rows, worksheets
  • Change the display & freeze part of the worksheet
     

Working With Excel Files

  • Saving files
  • Opening and closing files
      

Excel Concepts

  • Working with ranges
  • Copying and moving text, numbers and formulas
  • Editing data
  • Creating formulae
  • Introduction to Excel functions

Data Presentation

  • Cell formatting options
  • Number formatting
  • Cell alignment options
  • Creating charts
  • Changing the chart type & moving charts
  • Sort & subtotal data
      

Print Options

  • Print options
  • Add comments to a worksheet

   

Learning outcomes

On completion of this course, participants will be able to create and print a spreadsheet using basic editing and formatting.

  

Prerequisites

A familiarity with the computer keyboard and Windows is desirable.

      

Duration

1 day

 

Investment

$410 GST free per person

Includes:

  • Experienced facilitator
  • Interactive, practical and hands on learning
  • Comprehensive take-home training and reference manual
  • Post-course Help Desk support
  • Certificate of Attendance for participants
  • Morning & afternoon refreshments
  • Delicious cafe lunch
  • Post course follow up

 

Enjoy Real People, Real Conversations, Real Results 

  

Software versions

Available for 2010, 2013, 2016 & 365

  

Further development

MS Excel Intermediate  


    

Is this the right course for you?

Find out here >