Starting a new role in accounting and finance? We understand it can be stressful as you try to make a good first impression.

This Excel Tips episode is specially designed with your first 100 days in mind, to help you hit the ground running.

For fast access, use these timestamps:

  1. Interface setup – 1:29
  2. Pin files and folders and quick access – 2:43
  3. Using checklists – 3:50
  4. INstruction sheets – 5:10
  5. Notes and comments – 6:24
  6. Setting up hyperlinks – 7:40
  7. Using colours in Excel – 8:58
  8. Centralise inputs – 9:54
  9. Validations – 10:25
  10. Save-as and copy-sheets for monthly reporting – 11:51
  11. Tips recap – 13:08

Tune in now.

Host: Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

  • With Interest
  • INTHEBLACK
  • INTHEBLACK Out Loud
  • Excel Tips

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au