Excel

  • excel courses

Complex Functions

Need to cross check or copy, paste data but keep it linked. Lessons in Excel available in Sydney. Try VLOOKUP or XLOOKUP Function in Excel.

  • SUM

Basic Functions

Functions are different to Formulas. Formulas use operations like + - * / where as Functions follow a structure. They both start with = A Functions has = Function Name ( in that order. There are over 300 Functions in Microsoft Excel.

  • bodmas

Basic Formulas

All Formulas and Functions begin with =. Operators are + - * / and they need to be used in a specific order.

  • excel courses

Excel Formatting

Formatting Excel spreadsheets made easy by using the correct tools. Most useful tools are Conditional Formatting and Format as Table features.

  • woman-typing-writing-windows

Pivot Tables

Use Dynamic data to create your Excel Pivot Tables. Excel Courses available M: 0414417059