Microsoft Excel Intermediate

Excel Intermediate training Melbourne

Overview

Microsoft Excel training course in Melbourne and across Australia.  Face-to-face Excel training or Live online Excel training courses available.

Learn shortcuts, tips and tricks to help make working with Excel easier and more productive.  Learn about formulas and functions to build powerful calculating spreadsheets.  Apply custom formats to numbers in Excel to display the data the any way you like.  Group and Outline data to easily collapse and show information in a spreadsheet.

Build charts to visually display data trends and apply custom formatting to them.  Use Data Validation to control how users of your spreadsheets enter data into Excel by adding limitations and custom error messages.

Excel Intermediate Course Outline

File size: 541 kb

Excel Intermediate Exercise Files

File size: 270 kb

Inclusions

  • Live instructor led training
  • Comprehensive training manual
  • Training certificate

Course prerequisites

You need to be familiar with the basics of Excel.

What's covered

AutoComplete features
  • Fill Handle
  • Filling values, text and dates
  • Custom Fill Lists
Keyboard Shortcuts
  • Selecting cells
  • Insert Cells, Columns and Rows
  • Insert Dates
  • Adding Data
Formulas
  • Formula structure
  • Formula Calculation order
  • Absolute and Relative cell references
  • Formula Auditing
  • Trace formula Dependence and Precedence.
  • Find and correct Formula Errors
  • Watch and Evaluate formulas
Functions
  • Function Structure
  • Using Formula Bar and Paste Function features
  • Introduction into various function types:
    • Math & Trig functions
    • Date functions
    • Text functions
  • Using AutoCalculate
Formatting
  • Creating Custom Number formats
  • Conditional Formatting
Grouping and Outlining
  • Grouping Rows and Columns
  • Modify Groups
  • Show / hide Outlines
  • Clearing Outlines
Charting
  • Creating charts
  • Formatting chart components
  • Creating and applying user-defined charts
  • Combining chart types and adding a secondary axis
  • Adding Trendlines and Error Bars
Data Validation
  • Set Validation criteria
  • Specify a data Input Message
  • Customise Error Messages

PRIVATE SESSION

Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.

from $198 per person
Course Length: 1 day

PUBLIC SESSION

Join a public course session conducted LIVE ONLINE via Microsoft Teams.

$355 per person

Public session Available dates:

Mar 26
1 day
9:00 am - 4:30 pm
Apr 30
0
9:00 am - 4:30 pm
Jun 25
0
9:00 am - 4:30 pm

Learn some shortcuts, tips and tricks to help make working with Excel easier and more productive.

Our Microsoft Excel Intermediate training course can be delivered face-to-face in Melbourne or live online across Australia.

Get a quote for a group

Enquire

Enrol

Private Session

Link partner: max77 gopek178 ondel4d sirkuit4d spade88 slot188 qqmobil area188 sky77 bro138 slot5000 luxury333 batman138 bos88 roma77 indobet zeus138jaya.org ligaplay88 toto togel slot88 warungtoto pokerseri autowin88 vegas77 vegasslot77 mantra88 sensa gaming