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

Odyssey Training Logo
Microsoft Excel Advanced Training Course

Microsoft Excel Advanced

2 Day Training Course

Book a public course

Venue – Brisbane

Odyssey Training
Level 1, 60 Edward St
Brisbane QLD 4000
View map and directions

Times and Dates

26 Jul - 27 Jul 2017
2 Days     9:00 am – 4:00 pm

Need your training approved?

Computer Course Inclusions
 

This course is ideal for

This course exposes several advanced features of Excel for What-if analysis, database analysis and how to build calculations using advanced functions as well as how to automate processes

Course prerequisites

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

What you will learn

  • Build complex calculations with advanced functions
  • Link, export and consolidate data
  • Limit data entry and build complex models with Lookup functions
  • Analyse data with simple PivotTables and PivotCharts
  • Create and modify Macros

Topics covered in this training course

  • Protecting your data
    • Workbook protection
    • Protecting cells
    • Protecting structure
  • Circular references
    • Locating and deleting circular references
    • When circular references are necessary
    • Formula error checking
  • Range names
    • Defining range names
    • Using names in formulas
    • Navigating with names
    • Using named constants
    • Documenting range names
  • Functions
    • Math and rounding functions
    • The AND function
    • The OR function
    • Nested IF function
    • The VLOOKUP function
    • The HLOOKUP function
    • Transposing data
    • Concatenating functions
    • INDEX and MATCH functions
    • Using help for functions
  • Data Validation
    • Limiting cell values
    • Creating drop-down cell lists
    • Validation error messages
  • What-if analysis tools
    • Using goal seek
  • Importing data
    • Importing CSV files
    • Text import wizard
  • Workbook linking
    • Workbook linking
    • Dealing with broken links
  • Data consolidation
    • Consolidation by cell position
    • Consolidation by headings
  • Exporting data
    • Saving as a different file type
    • Exporting to Word
    • Pasting data with a link
    • Copying a graph with a link
  • PivotTable reports
    • Create a PivotTable
    • Rearranging data
    • Applying filters
    • Adding fields
    • Modify field settings
    • Refreshing data
    • Formatting a PivotTable
  • PivotCharts
    • Creating a PivotChart
    • Filtering a PivotChart
  • Macros
    • Recording a Macro
    • Editing a Macro
    • Relative/Absolute Recording
    • Stepping through a Macro
    • Macro buttons
    • Customising the toolbar
    • Writing a line of code
    • Deleting a Macro

Home > Microsoft Excel Training > Excel Advanced Course > 2010

Our Training Courses

- +
Subtotal
Special offer