Phone 1300 793 951 or visit www.odysseytraining.com.au

Microsoft Excel Advanced 2010 Training Course

Duration: 2 Days

Book a public course

Venue – Melbourne

Odyssey Training
Level 3, 118 Queen Street
Melbourne VIC 3000
View map and directions

Times and Dates

14-15 May 2014
2 Days     9:00 am – 4:00 pm
(Lunch and refreshments provided)

Microsoft Excel Advanced Training Reviews

  • “I loved the course :) ” Jenaya

Overall course rating

Microsoft Excel Advanced 4.8 out of 5 from 18 reviews.

Share this course

This course is ideal for

This advanced Microsoft Excel 2010 training course is ideal for people wanting to use more complex functions within Excel, including tools for analysing, linking and exporting data.

Learning outcomes

  • Protect a workbook and save with a backup
  • Understand and use advanced functions
  • Consolidate data, link and export data
  • Use What-If Analysis tools such as Goal Seek, Solver and Scenarios
  • Create and modify PivotTables and PivotCharts
  • Create and modify Microsoft Excel 2010 Macros

Course prerequisites

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course.

Topics covered in this training course

  • File Protection
    • Attaching a Password
    • Modifying a Password
  • Cell Protection
    • Protecting Cells
  • Circular References
    • Circular Error Messages
    • The Circular Reference Toolbar
  • Functions
    • Function Overview
    • Math and Trig Functions
    • Financial Functions
    • Logical Functions
    • The AND Function
    • The OR Function
    • Nesting Functions
    • The VLOOKUP Function
    • The HLOOKUP Function
    • Concatenating Functions
    • Index and Match Functions
    • Using Help for Functions
  • Goal Seek
    • Using Goal Seek
  • Solver
    • Saving a Scenario
    • Solver Reports
  • Scenarios
    • Adding a Scenario
    • Showing Scenarios
  • Linking
    • Worksheet Linking
    • Workbook Linking
  • Data Validation
    • Data Consolidation
      • Importing Data
        • Importing CSV Files
        • Text Import Wizard
      • Exporting Data
        • Choosing a Specific Format
        • Exporting to Word
        • Pasting Data with a Link
        • Copying a Graph with a Link
      • PivotTable Reports
        • PivotTable Layout
        • Rearranging Data
        • Filtering a Report
        • Adding Fields
        • Field Settings
        • Refreshing Data
        • Formatting a PivotTable
        • Showing Detail
        • Create a Calculated Field
        • Advanced Data Field Settings
      • PivotChart Reports
        • Creating a PivotChart
        • Creating PivotChart Reports from Scratch
        • Adding Fields to a PivotChart
      • Macros
        • Recording a Macro
        • Editing a Macro
        • Relative/Absolute Recording
        • Stepping through a Macro
        • Macro Buttons
        • Customising the Toolbar
        • Deleting a Macro

        Our Training Courses

        - +
        Subtotal