What you’ll learn:
This half-day course is designed to build on the intermediate skills you have and help you use advanced functions within Excel to analyse data to give you valuable insights into patterns and trends for your work or your business.
After, you’ll be able to…
- Set up and refresh data connections to call in data from external sources
- Analyse and report on key data with pivot tables and charts
- Analyse and repoprt on multiple sets of data with PowerPivot
- Connect to and transform data with Power Query
- Insert Form Controls to customise worksheets
- Record and run macros to automate actions.