Good podcast? Give it some love!
CPA Australia
Excel TipsClaimedEpisodes
CPA Australia
Excel Tips
ClaimedGood podcast? Give it some love!
Rate Podcast
Episodes of Excel Tips
Mark All
Search Episodes...
Tune in to discover how mastering custom functions can help simplify two complex issues with Excel formulas. Improve your problem-solving skills by harnessing the power of custom functions. For fast access, use these timestamps: 0:20 - Custom
Do you want to improve your dashboard-creating skills in Excel? Look no further. This episode has all the expert tips you need to know using dynamic arrays to create a dashboard. For fast access, use these timestamps: About the report template
Don’t miss this episode, the second in a three-part series that explains how you can use the power of dynamic arrays in report building. Learn how to review a report that’s using dynamic arrays to create an automated month and year-to-date repo
Are you an accountant or finance professional looking to enhance your daily workflows? Don’t miss this episode, which delves into the exciting capabilities of dynamic arrays, empowering you to effortlessly build automated reports. For fast acc
For accounting and finance professionals, it’s vital that you keep up-to-date with changes to Microsoft Excel functionality. This episode explains what you need to know, including the latest changes to three Excel functions, and opening and wo
Do you want to improve your Excel skills in 2024? Start the new year on a positive note with these essential tips that can help you master a couple of Excel techniques together. In this episode, we show you how to build custom lists and use ra
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. F
If you’re looking for ways to display diverse types of data using Excel’s charts and visualisation tools, this podcast, loaded with tips, will show you how. The example in this episode compares one month's data from this financial year with the
Do you want an Excel edge? Whether you're a seasoned pro or starting out, master these 10 new and revamped features to help streamline your workflow and boost your spreadsheet efficiency. For fast access, use these timestamps: Web based vers
Excel is constantly evolving and improving, and it's crucial to stay up to date with all the latest changes. This companion podcast is here to help you sort quickly through the most relevant function updates. Are you ready to take your Excel s
Unleash your Excel skills by using the valuable functionality of formulas. Go straight to episode sections: The formula bar – 1:06 Starting formulas – 1:41 Using functions – 2:58 Function arguments – 4:09 Relative and absolute cell and range
Are you a university student or recent graduate? Are you looking to gain a competitive edge in the job market, specifically in the fields of accounting and finance? Then this episode is what you need! Packed with practical advice tailored t
Unlock your Excel efficiency with these 22 time-saving shortcuts for everyday work tasks. Tune in now to supercharge your productivity. Timestamps: Files and folders: 1:05 Quick access toolbar: 4:17 Keyboard types: 7:20 Keyboard shortcut
Can ChatGPT give accurate and reliable answers to Excel questions? Neale Blackwood CPA puts this popular AI tool to the test. Host: Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of mor
Artificial Intelligence (AI) has come to Microsoft Excel, and it will make your life easier when working with data. The AI function can easily create PivotTables and PivotCharts, which is useful for analysis and audit work. You can also gene
Along with the LAMBDA function, other new functions make Excel’s function language behave more like a programming language. Which can help you in various ways. Want to learn more? Excel expert Neale Blackwood CPA steps you through. Listen now
An update to the subscription version of Microsoft Excel has the LAMBDA function, which addresses a key challenge when using dynamic arrays. To explain more about this functionality is Excel expert, Neale Blackwood CPA. Listen now. Host: Nea
When creating a line chart in Microsoft Excel, do you need to insert a vertical line to mark something on the chart? To explain how is Excel expert, Neale Blackwood CPA. Listen now. Host: Neale Blackwood CPA has more than 20 years of exper
Today’s episode examines the new data types feature in Microsoft Excel. There are four data types you can now import from the data ribbon, and that includes stock prices. To explain how you do all this is CPA Australia’s Excel expert, Neale Bla
Today’s episode investigates working with dates and days in Microsoft Excel. Excel can perform basic addition and subtraction calculations using dates, as well as dedicated functions that perform more complex calcs. To explain is CPA Australia’
Today’s episode looks at a handy tool in Microsoft Excel called Goal Seek. It can be used to create a loan schedule with an interest-free period using formulas. To explain how you do this is CPA Australia’s Excel expert, Neale Blackwood. Listen
Today’s episode will help with your formatting in Microsoft Excel. Want to know how to make your files easier to read, understand and use? To explain is CPA Australia’s Excel expert, Neale Blackwood. Listen now. Host: Neale Blackwood CPA. He ha
In this episode, we look at three new text functions released in the latest (subscription) version of Microsoft Excel. The functions are: “Text Before”, “Text After” and “Text Split” To explain this is CPA Australia’s Excel expert Neale Black
Excel Tips is a podcast for accounting, business and finance professionals who are looking to sharpen their spreadsheet skills and learn new hacks and tricks from Neale Blackwood CPA, a Microsoft Excel expert. EXCEL TIPS helps spreadsheet users
Join Podchaser to...
- Rate podcasts and episodes
- Follow podcasts and creators
- Create podcast and episode lists
- & much more
Unlock more with Podchaser Pro
- Audience Insights
- Contact Information
- Demographics
- Charts
- Sponsor History
- and More!
- Account
- Register
- Log In
- Find Friends
- Resources
- Help Center
- Blog
- API
Podchaser is the ultimate destination for podcast data, search, and discovery. Learn More
- © 2024 Podchaser, Inc.
- Privacy Policy
- Terms of Service
- Contact Us