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

Odyssey Training Logo
Microsoft Excel Advanced Formulas Training Course

Microsoft Excel Advanced Formulas

1 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

20 Oct 2017
1 Day     9:00 am – 4:00 pm

Need your training approved?

Computer Course Inclusions
 

This course is ideal for

This Advanced Functions training course is ideal for people wanting to perform complex calculations in Microsoft Excel 2010.

Course prerequisites

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel 2013 Intermediate course including working with named ranges, using basic functions such as SUM and AVERAGE.

What you will learn

  • Perform calculations using the IF, OR and NOT functions to display information in Microsoft Excel 2010
  • Create data sets for VLOOKUP functions and perform calculations
  • Use database functions to produce results from a Microsoft Excel list
  • Nest functions to perform complex calculations
  • Use functions to work with text.

Topics covered in this training course

  • Commonly Used Functions
    • COUNTIF
    • COUNTIFS
    • SUMIF
    • SUMIFS
  • Logical Functions
    • Logical Function Concepts
    • Displaying Information Using IF
    • Displaying Values Using IF
    • Using The AND Function
    • Nesting Functions
    • Using The OR Function
    • Using the NOT Function
    • INDEX Function
  • VLOOKUP Functions
    • Data requirements
    • The VLOOKUP Function
    • Using VLOOKUP For Exact Matches
    • HLookup Function
  • Worksheet & Workbook Protection
    • Protect the Contents of a Worksheet
    • Protect all Worksheets in a Workbook
    • Protect the Workbook from Being Deleted
    • Restrict the Distribution of a Workbook
    • Restrict Permission Access
  • Working with text functions
    • Splitting and merging
    • Extracting data using text functions
    • TRIM, VALUE, LEN, LEFT, RIGHT, MID
    • Formatting text using functions
  • Working with dates and times
    • Formatting dates and times
    • Date and time functions
    • DATE, YEARFRAC, NETWORKDAYS
    • Calculating date and time differences
  • Use Arrays
    • Using Array formulas
    • Single cell array formulas
    • Multi-cell array formulas
  • Using IS functions to test value types in cells
    • ISBLANK
    • ISNUMBER
    • ISTEXT
    • ISERROR
  • Database Functions
    • DCOUNTA
    • DSUM
    • DAVERAGE
    • DMIN & DMAX
  • Error Checking and Audit tools
    • Error Alerts
    • Audit tools
    • ISERROR, IFERROR
  • Advanced conditional formatting and data validation
    • Conditional formulas
    • Colour banding
    • Finding cells with conditional formatting
    • Finding and preventing duplicate values

Home > Microsoft Excel Training > Advanced Formulas Course > 2010

Our Training Courses

- +
Subtotal