Search a title or topic

Over 20 million podcasts, powered by 

Player FM logo

Python Out Loud Podcasts

Series
Series
Episodes
Language:
English
All languages
English
Afrikaans
Cymraeg
Dansk
Deutsch
Eesti
Español
Esperanto
Français
Gaeilge
Gàidhlig
Hrvatski
Indonesia
Khmer
Latviešu
Lietuvių
Malay
Nederlands
Norsk
Oʻzbekcha
Pyccĸий
Shqip
Slovenčina
Slovenščina
Suomi
Svenska
Tatar
Tiếng Việt
Türkçe
català
italiano
magyar
polski
português
română
rumantsch
Íslenska
Čeština
Ελληνικά
Български
Српски
Українська
беларуская
Қазақша
Հայերեն
עברית
اردو
العربية
فارسی
हिन्दी
বাংলা
ไทย
ქართული
中文
日本語
한국어
show episodes
 
E
Excel Tips
Excel Tips podcast artwork

1
Excel Tips

CPA Australia

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Monthly
 
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 regular articles in INTHEBLACK, CPA Australia’s award-winning business magazine. Every podcast episode ...
  continue reading
 
Along the treacherous Borgo Pass In the mountains of Transylvania, a meek English real estate agent is on a harrowing journey to meet a new and mysterious client...who also just happens to be the most terrifying and ferocious monster the world has ever known. COUNT DRACULA!! Christopher Sieber leads an all-star cast, including John Stamos, Annaleigh Ashford, Laura Benanti, Alex Brightman, James Monroe Iglehart, Richard Kind, Rob McClure, Ashley Park, Alan Tudyk, Kathy Fitzgerald, Jeff Kready ...
  continue reading
 
The Sounds in My Head is a biweekly music show featuring songs and bands you might have missed. Hosted by Daniel since 2004. Musically The Sounds in My Head attempts to be fairly eclectic, but probably tends to lean towards "indie pop" music. Also, I try to squeeze in as much left-wing propaganda as possible between tracks.
  continue reading
 
Loading …
Episodes
Series
Episodes
Sort:
Newest
Newest
Oldest
Longest
Shortest
Language:
English
All languages
English
Afrikaans
Cymraeg
Dansk
Deutsch
Eesti
Español
Esperanto
Français
Gaeilge
Gàidhlig
Hrvatski
Indonesia
Khmer
Latviešu
Lietuvių
Malay
Nederlands
Norsk
Oʻzbekcha
Pyccĸий
Shqip
Slovenčina
Slovenščina
Suomi
Svenska
Tatar
Tiếng Việt
Türkçe
català
italiano
magyar
polski
português
română
rumantsch
Íslenska
Čeština
Ελληνικά
Български
Српски
Українська
беларуская
Қазақша
Հայերեն
עברית
اردو
العربية
فارسی
हिन्दी
বাংলা
ไทย
ქართული
中文
日本語
한국어
show series
 
Unlock the potential of Python in Excel with this essential first episode in a three-part series. Designed for accountants, finance professionals and Excel power users, this episode introduces the basics of integrating Python code directly into Excel cells. Learn how Python enhances Excel’s capabilities for data handling and visualisation without r…
  continue reading
 
SEASON 22 EPISODE 4 A Clean House - Dash Hammerstein Athena - Born Ruffians Can We Go Now - Born Ruffians Aerial Troubles - Stereolab Vermona F Transistor - Stereolab Left Behind - Club 8 Sucker - Club 8 Closer to You - Club 8 Godzilla Rises - Being Dead Big Bovine - Being Dead Sally Go Round the Sun - Elephant Stone Love the Sinner, Hate the Sin -…
  continue reading
 
Excel’s new functions, GROUPBY and PIVOTBY, offer a smarter way to build reports. Instead of relying on traditional pivot tables, these new tools allow you to summarise datasets using dynamic, formula-based solutions that update automatically when the underlying data changes. In this episode: Understand the key differences between GROUPBY and PIVOT…
  continue reading
 
SEASON 22 EPISODE 3 SPECIAL "COMEDY MUSIC" EPISODE! The Check's in the Mail - "Weird Al" Yankovic Foux Du Fafa - Flight of the Conchords Carol Brown - Flight of the Conchords You Don't Have to Be a Prostitute - Flight of the Conchords Pregnant Women are Smug - Garfunkel and Oates 29 / 31 - Garfunkel and Oates In My Country - The Lemon Sisters Natal…
  continue reading
 
Need to turn stock market data into smart, professional reports? Discover how to use Excel’s new and powerful Stock History function to quickly transform raw share price data into clear, insightful reports. Learn how to streamline reporting, visualise trends and make better-informed decisions with ease. In this episode, gain the skills to: Access d…
  continue reading
 
The Pareto principle is a powerful concept for business. In this episode we’ll explore this principle (also known as the 80/20 rule) and learn how to apply it effectively in Excel for smarter, data-driven decisions. Discover how to pinpoint vital data – such as the 20 per cent of clients generating 80 per cent of your revenue as an example – to cre…
  continue reading
 
What if you could seamlessly collect and analyse data right inside Excel? In this episode, learn more about Microsoft Forms, a powerful tool in Microsoft 365 (which, by the time you read this may be renamed Microsoft 365 CoPilot). Discover how Forms integrates directly into Excel, making it easier than ever to gather feedback, conduct quizzes, and …
  continue reading
 
Ready to unlock a hidden gem in your Microsoft Excel subscription? In this episode you’ll discover the power of checkboxes with practical examples to explore how this new function can streamline your workflow. This includes how to use TRUE/FALSE values in formulas and conditional formatting to dynamically control calculations and visuals. Learn fro…
  continue reading
 
Ever struggled to extract crucial financial data from PDF files into Excel? As accountants and finance professionals, this can be a regular occurrence. To help you, this episode explores Microsoft Excel’s Power Query feature. You’ll uncover how to seamlessly import data from system-generated PDFs like invoices and statements. From tackling tricky f…
  continue reading
 
Excel doesn’t have a built-in timeline chart but we’ll show you how to create one. In this episode you’ll learn how using a scatter chart can help you build a timeline chart. For easy reference, here are the episode timestamps: 0:17 - About timeline charts in Excel 1:33 - Hacking the scatter chart to make a timeline chart 2:43 - Formatting dates us…
  continue reading
 
Calendars are your go-to tool for planning. In this Excel Tips episode, you'll learn the steps to create a single-month calendar from scratch. Discover how to combine advanced functions to build a two-dimensional calendar structure, and how to format your dates and highlight weekends and holidays. You'll also gain knowledge of how to customise the …
  continue reading
 
Reports are crucial to your work, aren't they? Power Query is a valuable tool for importing many types of data into Excel to help you create these reports. However, it does have limitations. In this episode, you’ll learn how to address one of Power Query’s key shortcomings: user interactions. By using staging queries, reference techniques and range…
  continue reading
 
Looking to improve your report-building skills? If so, this is the episode for you. Uncover tips on how to leverage multiple Excel features to create a system that effortlessly hides blank and zero rows in your reports. Also in this episode, you’ll discover the subtotal function’s superpower and learn how you can use it to help identify if a filter…
  continue reading
 
Looking for ways to gain deeper insights from your sales and costs data in Excel? This episode explores the power of heat maps, a data visualisation technique often used for climate data, but equally effective for business analysis. For fast access, use these timestamps: 0:15 – Using heat maps for sales and cost information. 1:59 – Colour scales op…
  continue reading
 
There's a misconception that Excel macros are outdated or unnecessary. In this episode we set the record straight and explore their continued value. Delve into three practical macros that can streamline various tasks in your Excel workflow. More importantly, you’ll come away with the knowledge to decide when creating a macro makes sense for optimis…
  continue reading
 
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 - Settin…
  continue reading
 
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 ar…
  continue reading
 
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 …
  continue reading
 
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 a…
  continue reading
 
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 a…
  continue reading
 
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:3…
  continue reading
 
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 U…
  continue reading
 
SPECIAL “ALL WOMEN” EPISODE! There She Goes - Hazel English Fast Lane - Genevva Crazy Horse - Genevva Instinct That I Wanna Know - Jade Imagine Back and Forth - Jade Imagine Principia - En Attendant Ana The Cut Off - En Attendant Ana The Drinking Song - Nellie Mckay Make a Wish - Nellie Mckay Le Temple Volant - Crumb & Melody's Echo Chamber Apathy …
  continue reading
 
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: …
  continue reading
 
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 CT…
  continue reading
 
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 XLOOK…
  continue reading
 
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…
  continue reading
 
Season 20 Episode 10 Life Waits for Nothing - Phantom Youth Don't Fade Away - Beach Fossils Tough Love - Beach Fossils I Wish - Dayaway A Brief Dream of Sun - Dayaway Milanesa al Pan - Juan Wauters feat. Zoe Gotusso Modus Operandi - Juan Wauters feat. Frankie Cosmos Big Black Void - TV Girl All the Way Through - TV Girl Shame - TV Girl What the Ech…
  continue reading
 
Season 20 Episode 9 Good Friday - Ham Sandwich Newfound Oxygen - Steady Holiday The Balance - Steady Holiday Coma Culture - Coma Culture Bad Habits - Coma Culture Virtual Dancer - Group Rhoda Din För Evigt - Kanot Bottenmannen - Kanot Dee Dee - Nimrawd Quicksilver (single version) - Nimrawd Aquamarine - Hand Habits This episode features a clip of a…
  continue reading
 
Season 20 Episode 8 Hot Blue Summer - Dayaway Shooting Star - Sylvie Further Down the Road (Maston Remix) - Sylvie Waiting for the Band - Nicky Hopkins You Have Something Special - Joanna Sternberg This Is Not Who I Want To Be - Joanna Sternberg I Never Get Lonesome - Arthur Russell Iowa Dream - Arthur Russell Wan Ka Helaa - Dur-Dur Band Int. Riyo …
  continue reading
 
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…
  continue reading
 
Season 20 Episode 7: Special “Music from Soundtracks” Episode! Asteroid City 1. Last Train to San Fernando - Johnny Duncan 2. Freight Train - Chas McDevitt Skiffle Group Poker Face 3. Charlie's Theme - Pellea 4. Six Foot Down - Gene Ski 5. Blues Run the Game - Jackson C. Frank John Denver: Country Boy 6. Take Me Home, Country Roads - John Denver Th…
  continue reading
 
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 C…
  continue reading
 
Season 20 Episode 4 - SPECIAL “MUSIC IN FRENCH!” EPISODE! Soulevant - Cléa Vincent Contact - Jarvis Cocker Le cannibale - Juniore Je me suis fait tout petit - Juniore B1 - Ce soir - Kumisolo Kabuki femme fatale - Kumisolo La Femme aux Faux Cils - We are Enfant Terrible La poudre aux yeux - Lisa LeBlanc Tite gêne - Lisa LeBlanc Apprenti - Dumas Fill…
  continue reading
 
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…
  continue reading
 
Season 20 Episode 3 Organic Tea - Jacob King We, Us the Pharaohs - Maxwell Farrington & Le SuperHomard I Had It All - Maxwell Farrington & Le SuperHomard Always on the Telephone - The Ladybug Transistor Stranger - Tiny Microphone feat. Gary Olson Mine Forever - Lord Huron At Sea - Lord Huron Blameless - Zach Schimpf Mind Like a Sitting Duck - Zach …
  continue reading
 
Season 20 Episode 2 Apologizing - Celler Dwellers Or Else - Marina Allen Superreality - Marina Allen If You Love Her - Tokyo Tea Room Feel Your Heart - Tokyo Tea Room Poor Devil - Fruit Junior Saddle Up -Fruit Junior The Promise (feat. Jelani Aryeh) - Samia As You Are - Samia Edge of the Edge - Panda Bear & Sonic Boom Everything’s Been Leading To T…
  continue reading
 
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 …
  continue reading
 
Season 20 Episode 1 Rebels Without Applause - Morrissey Always on My Mind - Roller Derby Friday I'm in Love - Roller Derby Afterworld - Phantom Youth Dear October - Phantom Youth Places - Holy Now Silk - Holy Now Nerves - Freeds Fuzzy - Freeds If I Could Ride a Bike - Chevy & Park Bird Never My Love - The Association and The Courettes This episode …
  continue reading
 
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 au…
  continue reading
 
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…
  continue reading
 
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, A…
  continue reading
 
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 Exce…
  continue reading
 
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 exper…
  continue reading
 
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…
  continue reading
 
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 INTHEB…
  continue reading
 
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 professio…
  continue reading
 
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 f…
  continue reading
 
SEASON 19 FINALE! Be True - RL Cherry Blossom - Rubblebucket Earth Worship - Rubblebucket Empty Head - Frankie Cosmos Aftershook - Frankie Cosmos Strangers - Dana Gavanski Sacatela - La Femme No pasa nada - La Femme Dyslexic Poetry - Petite League Pantone Karaoke - Petite League Belinda Says - Alvvays Very Online Guy - Alvvays San Francisco - Bonny…
  continue reading
 
SPECIAL "CHRISTMAS MUSIC 2022" EPISODE! Kemonomichi no Uta (alt ver.) - Shugo Tokumaru & John John Festival Ode to Just Like Christmas - Twitchels Just Like Christmas - Housewife When the River Meets the Sea - Daniel Zott Love to Keep Me Warm - Laufey & Dodie Merry Christmas to the Drunks, Merry Christmas to the Lovers - Ballboy He's the One - Ali …
  continue reading
 
Loading …
Copyright 2025 | Privacy Policy | Terms of Service | | Copyright
Listen to this show while you explore
Play