Excel Tips
Looking to elevate your spreadsheet skills? You’ve found the right podcast! Microsoft Excel expert Neale Blackwood CPA shows how to master Excel’s hidden features, newest functionality and clever shortcuts so accounting, business and finance professionals can gain a competitive edge by unleashing Excel’s full potential.
Subscribe to Excel Tips
Follow Excel Tips on your favourite player and listen to the latest podcast episodes
Episodes
Handy hack to create timeline charts
Excel doesn’t have a built-in timeline chart - but that doesn’t mean you can’t create one
- MS Excel
11 min listening timePublished onMaster calendar creation in Excel
Create and customise your calendar by learning how to combine advanced functions
- MS Excel
17 min listening timePublished onHow to add a user interaction into Power Query
Learn this smart Excel technique to help you with your data preparation
- MS Excel
12 min listening timePublished onLearn a smart way to hide blank or zero rows
How to leverage multiple Excel features to maximise your report-building efficiency
- MS Excel
10 min listening timePublished onThe power of heat maps for sales and costs data
Discover how to use the heat map tool to visualise crucial business data in Excel
- MS Excel
10 min listening timePublished on3 powerful macros to streamline your workflow
Explore three powerful macros and learn when to create them for optimal productivity
- MS Excel
9 min listening timePublished onLevel up your custom functions skills
Use these valuable skills to help problem-solve two tricky tasks with Excel formulas
- Personal and career development
10 min listening timePublished onHow to create a dashboard using Excel’s dynamic arrays
Elevate your Excel skills with these expert tips
- Personal and career development
11 min listening timePublished onHow to automate report building in Excel (part 2)
How to automate your reports in Excel using dynamic arrays
- Career skills
12 min listening timePublished onHow to automate report building in Excel
How to automate your reports in Excel using dynamic arrays
- Career skills
12 min listening timePublished onMaster the latest Excel changes: your ultimate guide
Learn about three new Excel functions and the changes to working with CSV files
- Personal and career development
16 min listening timePublished onHow to master using different Excel techniques together
Boost your Excel skills by learning how to build custom lists and use range names
- Personal and career development
17 min listening timePublished onTop Excel tips for your first 100 days in a new job
Essential tips to give you an edge when starting a new role in accounting and finance
- Personal and career development
15 min listening timePublished onHow to create improved data visualisations in Excel
A guide to Excel’s charts and visualisation tools to enhance your data when displayed
- Career skills
15 min listening timePublished onMaster 10 new and revamped Excel features
Improve your efficiency and boost your workflow by learning these 10 smart Excel features
- Career skills
15 min listening timePublished onBoost your skills with tips for Excel function updates
Stay on top of Excel function updates with these tips for dynamic arrays, XLOOKUP and more
- Personal and career development
13 min listening timePublished onUnlock 14 expert tips for Excel formulas
Boost your Excel skills with these practical shortcuts and techniques for formulas
- Personal and career development
- Career skills
24 min listening timePublished onWhy Excel can be a university student’s secret weapon
Excel can help students hit the ground running when starting off in accounting or finance
- Personal and career development
26 min listening timePublished on22 Excel shortcuts to supercharge your efficiency
Boost your productivity with these time-saving tips for everyday Excel tasks
- Technology
- Career skills
32 min listening timePublished onExcel and ChatGPT
5 May 2023 | We evaluate ChatGPT to see if this AI tool accurately answers Excel questions
- Technology
14 min listening timePublished onLearn Excel’s built-in artificial intelligence feature
The AI function can help with data analysis and audit work. Here’s how.
- Personal and career development
- Career skills
11 min listening timePublished onExcel tips: how to use custom functions without macros
Learn how new functions expand the power and versatility of formula capability
- Personal and career development
12 min listening timePublished onExcel tips: how to do dynamic arrays (subscription version)
An update addresses a key challenge when using dynamic arrays
- Personal and career development
10 min listening timePublished onExcel tips: how to create vertical lines in line charts
If you want to mark something on a line chart, here’s how
- Personal and career development
11 min listening timePublished onExcel tips: how to work with dates and days
Addition and subtraction calculations for dates and days explained
- Personal and career development
15 min listening timePublished onExcel tips: how to use Goal Seek
Use this tool to help create a loan schedule with an interest-free period using formulas
- Personal and career development
11 min listening timePublished onExcel tips: how to improve your formatting
Make your files easier to read, understand and use
- Personal and career development
9 min listening timePublished onExcel tips: how to use the new data types feature
Learn about the four data types you can now import via the data ribbon in Excel
- Personal and career development
- Career skills
16 min listening timePublished onHow to unleash the power of PivotTables
Learn how to create reports without using a single formula
- Personal and career development
15 min listening timePublished onExcel skills for current and future accountants
Tips you need to know, today and in the future
- Personal and career development
22 min listening timePublished onIntroducing the Excel Data Model
Learn some of the basic features, which are extremely powerful and flexible
- Personal and career development
16 min listening timePublished onHow to solve the printing challenge in Excel
Learn how to use the icons in the workbook views section
- Personal and career development
15 min listening timePublished onHow to handle formula errors in Excel using IFERROR
What to do if you create a formula and then realise it needs to handle errors
- Personal and career development
13 min listening timePublished onUse LET function to solve tricky Excel challenges
Stumped by an Excel problem? Check out the LET function.
- Personal and career development
9 min listening timePublished onCreating hyperlinked index sheets
Useful tools to speed up and simplify navigation around large Excel files
- Personal and career development
13 min listening timePublished onHow to import Excel files using Power Query
Power up your data transformation and preparation in Microsoft Excel
- Personal and career development
14 min listening timePublished onUsing flexible conditional formats in Excel
Make conditional formats work for you in dashboards and reporting
- Personal and career development
11 min listening timePublished onUnderstanding the LET function
Use this Excel function to solve real-world problems
- Personal and career development
9 min listening timePublished onHow to use an IS function in Excel
Knowing what a cell contains can be useful when developing your formulas
- Personal and career development
10 min listening timePublished onDynamic charts in Microsoft Excel
Learn how to use range names to convert a static chart in a dynamic one
- Personal and career development
13 min listening timePublished onSlicers in Microsoft Excel
Learn how to use slicers on formatted tables
- Personal and career development
8 min listening timePublished onWorking with small data sets
Convert a data entry layout into one that works with PivotTables and other reports
- Personal and career development
8 min listening timePublished onGet proficient with function macros
Learn how to create your own function in Excel
- Personal and career development
11 min listening timePublished onExcel tips: How to use Text Boxes
Discover how to use text boxes and why they'll help in your day-to-day work
- Personal and career development
10 min listening timePublished onAll about the XLOOKUP Function
How to look up code in a table and return entries on the same row
- Personal and career development
19 min listening timePublished on
