Top Excel tips for your first 100 days in a new job

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 .css-j9qmi7{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-flex-direction:row;-ms-flex-direction:row;flex-direction:row;font-weight:700;margin-bottom:1rem;margin-top:2.8rem;width:100%;-webkit-box-pack:start;-ms-flex-pack:start;-webkit-justify-content:start;justify-content:start;padding-left:5rem;}@media only screen and (max-width: 599px){.css-j9qmi7{padding-left:0;-webkit-box-pack:center;-ms-flex-pack:center;-webkit-justify-content:center;justify-content:center;}}.css-j9qmi7 svg{fill:#27292D;}.css-j9qmi7 .eagfbvw0{-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;color:#27292D;}