Microsoft Excel - Introduction Course

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

  

Software versions

Available for 2010, 2013, 2016 & 365

  

Further development

MS Excel Intermediate  


    

Is this the right course for you?

Find out here > 

  

  

Book Now

 

 

  IT

  

"Our suite of Computer Training courses are designed to support each participant in learning new skills and implementing them back into their workplace. We want to ensure that your organisation’s key assets, your people, are equipped to achieve maximum productivity."   

 

  

Standard Course Information

  
Inclusions:

  • Take home course manual
  • Facilitator led training
  • Qualified trainer
  • Certificate of Attendance for participants
  • Post-course Help Desk support
  • Morning & afternoon refreshments
  • Lunch

    
 
 
Training venue:

Cloisters Level 1, 863 Hay Street
Perth CBD
  
    
     
Additional information:

  • IT standard training day runs from 9.00am - 4.00pm
  • 1 hour lunch break for full day courses
  • ½ day courses vary, please contact us for timings
  • Prices quoted are standard rates
  • Government and other discounts may apply and will be confirmed on invoice

                
 
  

Roving Training

Need IT Training? Don't have time to go on a course? We are happy to come to you!

One of our expert instructors roams your workplace calling in any users that require coaching in any desktop applications. 

Roving training is perfect if numerous employees need some tips and tricks on various programs. Training is tailored to your individual needs and we are able to train using your own documents.   

   
  

Customised Solutions

We understand one size does not always fit all. Our team of qualified trainers can create a customised solution tailored to your specific needs.

We are happy to offer closed group sessions or additional dates as you require.

To discuss customisation training, simply call 08 9218 9059 or email admin@ati-mirage.com.au

 
 

Logo Bulb
  

Enriching lives.
Empowering organisations.