uAdvance

Excel 1A

Begin your mastery of Excel, learning how to efficiently manage and analyze data.
The session covers:

  • Fundamentals of Excel interface
  • Data entry and formatting
  • Basic formulas and functions (SUM, AVERAGE, MIN, MAX)
  • Creating and formatting charts
  • Data sorting and filtering
  • Introduction to PivotTables

    • The amount for the Excel 1A single day session is: $670 + GST

    Excel 1B

    Expand your Excel capabilities with advanced features tailored for in-depth data analysis and decision-making:

  • Advanced formulas and functions (VLOOKUP, INDEX, MATCH)
  • Complex data validation techniques
  • Advanced charting and dashboard creation
  • Automation with macros and VBA basics
  • Dynamic reports with PivotTables and Slicers
  • Best practices for data analysis

    • The amount for the Excel 1B single day session is: $670 + GST

    Course Materials

    This course has been custom made by our experts that have a mastery of excel and play with excel like a maestro plays a piano.
    It has a focus for the financial services industry in Australia.