• ms certification

Jobs Requiring Excel Skills

Excel is for everyone. An employer is looking that you can create basic spreadsheets with formatting, basic formulas and functions like SUM, AVERAGE and COUNT. For the high-end skilled jobs you'll need complex function skills.

  • 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