Did you know that Microsoft is constantly updating Excel? There have been some great new features added to Excel in the last few years. You might be struggling to get your spreadsheet to do something, that can now be done with a simple formula or built-in feature. Come and hear from Grant Baldwin of Custom Spreadsheet Solutions about the latest features to be added to Excel, including:
- Ideas - Excel will analyse your data for you.
- Data Types – get information direct from the web into your spreadsheet.
- Xlookup - powerful lookup formula to replace vlookup.
- Sort - a new function that can sort a list.
- Filter - a function that can return filtered data.
Most people use a spreadsheet for something in their business and most don't make use of the many features available. Come and make sure you are up with the play and getting the most out of Excel.
This workshop is suitable for anyone who is using a spreadsheet in their organisation and wants to learn about the latest capabilities that Excel has. If you are using vlookup then this course is for you!
Presenter: Grant Baldwin
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.