Microsoft Excel Intermediate

Duration:9:00am - 2:00pm
Cost (pp):$197
Location:3/610 Lorimer Street, Port Melbourne VIC 3101
Entry Requirements:

Participants should have attended or have the knowledge of our Microsoft Excel Introduction course.

Description:

Click here to download the Microsoft Excel Intermediate course outline.

Let our experienced trainers show you how to save time, increase productivity, and transform the way you you Microsoft Excel in the future. All of our training is customised to suit your companies requirements instead of delivering a standard generic course.

Microsoft Excel – Intermediate Course Outline

Cell Referencing
• Relative referencing
• Absolute referencing

Functions
• Function syntax
• Date functions
• The Max/Min function
• Financial functions

Range Names
• Define range names
• Names in formulas
• Navigating with names

Conditional Formatting
• Formatting from cell value
• Formatting from a formula
• Create/edit spark lines

Number/Formatting Techniques
• Create custom formats
• Formatting time
• Formatting data
• Us alternate currencies

Outlining
• Showing details
• Hiding details
• Grouping

Autofill
• Filling dates
• Filling text
• Custom lists

Charts
• The chart wizard
• The chart toolbar
• Creating charts manually
• Chart types
• Gridlines and axis

Formatting Charts
• Deleting a data table
• Printing charts
• Chart titles
• Formatting chart titles
• Printing separate chart cheets
• Coloured charts

Other courses you might be interested in:

  • Microsoft Advanced
  • Microsoft Foundation
  • Useful online free Microsoft Excel Advanced tutorials

  • Excel Exposure
  • Microsoft Tutorials
  • GCF Learning Tutorials
  • Excel jet Tutorials
  • Units of Competency:
    Assessment Type:No Assessment
    Course Expires After:Certificate of Completion never expires
    Delivery Method:Face to face
    What to Bring and Wear:
    • Closed in shoes
    • Sleeved shirt
    • Photo ID

    SOME OF THE ORGANISATIONS THAT WE’VE WORKED WITH

    “Working with Training Ahead Australia has been phenomenal. What they have delivered to my organisation has been nothing short of exceptional. We have seen a direct correlation between recent growth and success in sales, productivity and in culture from the training and influence of TAA.”- Bernard Fernandez, Agero Group
    Book online
    Training Ahead Australia - Rail Training