![](/assets/artwork/1x1-42817eea7ade52607a760cbee00d1495.gif)
14 min
![](/assets/artwork/1x1-42817eea7ade52607a760cbee00d1495.gif)
Top Excel tips for your first 100 days in a new job Excel Tips
-
- Education
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:
Interface setup – 1:29 Pin files and folders and quick access – 2:43 Using checklists – 3:50 INstruction sheets – 5:10 Notes and comments – 6:24 Setting up hyperlinks – 7:40 Using colours in Excel – 8:58 Centralise inputs – 9:54 Validations – 10:25 Save-as and copy-sheets for monthly reporting – 11:51 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
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:
Interface setup – 1:29 Pin files and folders and quick access – 2:43 Using checklists – 3:50 INstruction sheets – 5:10 Notes and comments – 6:24 Setting up hyperlinks – 7:40 Using colours in Excel – 8:58 Centralise inputs – 9:54 Validations – 10:25 Save-as and copy-sheets for monthly reporting – 11:51 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
14 min