Excel features: Advanced Formula and upgrades. - Oct 2024 - Online

One hour - Online workshop. 

Investment $30 + GST.

Excel is continual being updated. Stay up to date with the big changes in formula and other features that will make your use of Excel more efficient.

This workshop is suitable for anyone who is familiar with Excel formula (such as vlookup) and using filters and sorting. Features and formula will be from Excel 2021 version onwards, including:

• Xlookup - powerful replacement to vlookup.

• How to Filter and Sort your data with formulas.

• Remove duplicates from a list with Unique.

• Use Date Types to pull information from the web directly into your spreadsheet.

• Ask questions of your data with Analyze Data directly in Excel.

Grant set up Custom Spreadsheet Solutions to build customised spreadsheets for organisations and provide coaching in spreadsheet use. His clients are able to work more efficiently and spend time on the parts of their jobs they enjoy instead of dealing with repetitive tasks or manual calculations.

Grant has 20 years’ experience working with spreadsheets. He has used them to do everything from presenting official statistics, to calculating investment returns, determining medication dosing, recording school competition results, and solving penguin puzzles.

Bring a friend for free!