HeyJaredExcel Tips
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.
- Indexed episodes, last 90 days
- 2
- Latest publication
- Sep 1, 2026
- Audience
- Checking…
- Earliest in this view
- Aug 3, 2026
Latest episodes
Create interactive Excel charts (part 2) (opens the original)
Read excerpt
Can you make Excel reporting more interactive? Yes, you can. And it's all to do with dynamic arrays. In the second of this two-part series, discover how to create dynamic Excel charts this time using financial year calculations and checkboxes. This is useful for finance pros because the techniques allow users more control. You will learn: How to convert calendar year calculations into financial years How to use checkboxes to control ascending or descending chart order How checkboxes can figure o
Create interactive Excel charts (opens the original)
Read excerpt
Wouldn't it be useful to learn how to build interactive Excel charts that respond automatically to user input using dynamic arrays? This expert-led episode introduces the core techniques behind flexible charting in Excel, with practical examples . Key takeaways: Create charts that automatically adjust the number of months displayed Use SEQUENCE to build flexible dynamic array calculations Combine data for charts with the HSTACK function Find the latest reporting period using MAX and EOMONTH Extr
Publishing over time
Last 90 days. Choose a month to open its work.
Recurring subjects
Named in the text we hold. One piece can cover several.
Audience
No verified audience measurement yet.
About this data
Counts cover the work we have indexed. Tone needs enough text and a confident classification. Excerpts and episode notes are not full articles or transcripts.
Identity or attribution wrong? Suggest a correction.