Excel Tips

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 functions, episode overview. 1:39 - Summing spill ranges. 2:58 - Using prefixes in functions. 4:07 - Setting up a switch function. 5:31 - Financial year cust...

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 and using dynamic arrays - 0:17 About dynamic arrays - 0:55 Dynamic charts and dashboards using dynamic arrays - 1:33 Variance charts and budget comparisons...

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 report.  For fast access, use these timestamps: About the report template and using dynamic arrays 00:18 Range names for formatted tables 2:35 Budget layout and...

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 access, use these timestamps: The tutorial example report, and companion file 1:50 Dynamic array calculation and spill ranges 3:12 Referring to a spill range 4...

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 working with CSV files .  Tune in now for insights that will help enhance your productivity in 2024.   For fast access, use these timestamps: Importing and us...

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 range names.  For fast access, use these timestamps: Custom lists explained – 0:29 Creating custom lists – 1:34 Automating lists with range names – 4:08 Creat...

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...

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 corresponding month from the previous fiscal year. For fast access, use these timestamps: Column charts: 2:13 Variance charts: 3:22 Recommended charts: 4:2...

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 version of Excel: 0:30 Position of the blanks option in filter dropdown : 3:02 Power Query import updates : 4:13 CTRL key and mouse updates : 4:54 Formula bar va...

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 skills to the next level? Tune in now. For fast access, use these timestamps: 0:29 Dynamic arrays 2:29 XLOOKUP 3:19 LET function 3:49 LAMBDA 4:56 TEXTAFTER,...

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 references – 7:15 The calculation sequence – 9:46 Parentheses (brackets) – 10:39 Colours in formulas – 12:37 Entering cell and Range references – 13:50 The Fu...

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 to your needs, it will equip you with valuable Excel tips that will enhance your employability as you move into your first accounting or finance role. Delve int...

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 shortcuts: 9:06 Save as: 12:54 Control key: 13:45 More control key shortcuts: 14:46 Copying: 15:55 Date shortcut: 17:36 Control key combinations: 18:12 The ALT key: 19:4...

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 more than 200 INTHEBLACK articles as well as a book,  Advanced Excel Reporting for Management Accountants . Read the accompanying online article of this podcast...

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 generate reports at the click of a button.  Listen here to learn more.  Host: Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educat...

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.  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 wel...

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: 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...

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 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 Accoun...

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 Blackwood. Listen now. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200  INT...

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's Excel expert, Neale Blackwood. Listen now. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the aut...

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 now. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK article...

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 has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book,  Advanced Excel R...

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 Blackwood CPA. Listen now. Host:  Neale Blackwood CPA Excel Tips is for accounting, business and finance professionals looking to sharpen their spreadsheet skill...

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 discover Excel's hidden features and shortcuts and understand how best to apply the newest features and functionality. The podcast is a companion to regula...