Microsoft Excel 2010 - Intermediate

Who is the course for?

This course is ideal for those who have some experience using spreadsheet applications and want to learn the more advanced features. Participants will learn formula techniques, formatting, sorting and filtering data and how to use logical functions. 

 

What is Microsoft Excel?

Microsoft Excel is a widely used program that is used to create and format spreadsheets. This course focuses on basic spreadsheet production using Microsoft Excel 2010, part of the Microsoft Office 2010 suite, which is used in the majority of enterprises.

What skills will I learn?

  • Creating spreadsheets
  • Inserting and editing data
  • Creating simple formulas
  • Changing with fonts
  • Aligning cells
  • Adjusting column widths
  • Formatting numbers
  • Printing spreadsheets
  • How to create charts

What are the benefits?

  • Become a better job candidate
  • Create advanced spreadsheets
  • Become a more efficient worker
  • Develop your software application skills

Modules

  • Filling data
  • Moving data
  • Logical functions
  • Formula techniques
  • Number formatting techniques
  • Conditional formatting
  • Applying borders
  • Page setup
  • Working with a worksheet
  • Worksheet techniques
  • Finding and replacing
  • Sorting data
  • Filtering data
  • Charting techniques
  • Chart text formatting

Click here to download the full course guide.

 

Why study with us?

  • Experienced RTO
  • CBD located training centres
  • Modern facilities
  • Qualified trainers
  • On-site training available for groups

For more about our training methodology click here


Click here to enquire

 

Quick Course Guide for Navitas Workforce Solutions Training Program

CourseMicrosoft Excel 2010 - Intermediate
Enrolment datesCampus - see class dates
CampusMelbourne, Sydney, Brisbane, Adelaide and Perth

Course Duration

1 day

Fees (Exc. GST)

$330

Entry Requirements

Basic Microsoft Excel skills

 

Learning Progression