MS Excel Advanced

This Advanced Excel course is for existing users of Excel. You should have completed the Excel Beginner Course or be familiar with the content covered in this courses. The course is aimed at those wishing to move to the next level with Excel with a focus on increasing automation and employing the more advanced tools offered.

During the course of this workshop, you will cover:

  • Conditional Formatting; applying formatting such as colour to data that meet a certain criteria
  • Charts: creating graphical representation of your data
  • Filters: applying filters allows you to work with a subset of your data
  • Data Validation: controls the data that is entered into a cell eg can use a pick list
  • What if’s statements: create IF statements to return one value if a condition is true and another value if it’s false.
  • vLook-up: create a vlookup to look at a value in one column, and finds its corresponding value on the same row in another column.,
  • Sub-totals: with this function you can create subtotals from a list or database.
  • Workbook protection; protecting cell/s in a worksheet to avoid data loss or change
  • Macros: create a macro to automate repetitive tasks and save time
  • Pivot Table Reports: are used to summarize, analyze and explore, large amounts of data and present a summary of data.

Please note:
All courses need a minimum number of students to run. If your course does not have enough students it will be cancelled prior to the commencement and you will be informed. For your convenience information about class cancellations or changes are made initially via email and SMS, please ensure these details are correct.

$100 Limited GST free / $¤90
MS Excel Advanced

<p>This <strong>Advanced Excel</strong> course is for existing users of Excel. You should have completed the Excel Beginner Course or be familiar with the content covered in this courses. The course

...

If there isn't a class to suit you, please join the waiting list.