POPULARITY
George Mount is an Excel MVP and author of Modern Data Analytics in Excel (he describes it as a guide to becoming a data analyst in Excel). His latest book, Advancing into Analytics: From Excel to Python and R could be subtitled “becoming a data scientist in Excel. As founder and CEO of Stringfest Analytics, he provides analytics education and upskilling including works with finance departments at the top ten banks. In this episode he answers how someone in FP&A – killing it in Excel – can go further in their career while using Excel as home base. In this episode: Two books and the ROI you get as a finance professional from reading it Using Excel as your home base for FP&A When to use Excel vs Python citizen data scientists (or citizen data analysts) in Python Using low code/no code tools Excel, copilot and Python as a new “trinity” for FP&A Getting your data house in order before getting to AI A surprising Excel favorite befitting an MVP Connect with George Mount on LinkedIn: https://www.linkedin.com/in/gjmount/ Further Reading George Mount: Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics George Mount: Advancing into Analytics: From Excel to Python and R
Learn all about how an Excel MVP uses data to solve the world's problems, one improv skit at a time. It was such an honor to have Oz on the show, he is a true raconteur. We talked about a whole lot of things including how to clean data, what fun tools you can build, and why you should be suspicious of data. It was also really fun to talk about Oz's experience with improv, standup comedy, and how they relate to being a data professional because you have to be prepared to fail and quickly learn how to learn from those failures. Where to find Oz YouTube: https://www.youtube.com/@OzduSoleilDATA LinkedIn: https://www.linkedin.com/in/ozdata/ Several LinkedIn Learning courses --- Support this podcast: https://podcasters.spotify.com/pod/show/nerdnourishment/support
Join Power BI experts Sam McKay and Wyn Hopkins as they discuss the evolution of Power BI, from its early days to its current AI-powered capabilities, and explore how it has transformed data analytics and reporting. In this episode, Sam and Win Hopkins, Power BI veterans from Access Analytic, delve into their experiences with Power BI, its growth as a tool, and its impact on organizations' efficiency and productivity. They explore real-life success stories, the power of automation, and the revolutionary potential of AI in data analytics. Don't miss this insightful conversation about the past, present, and future of Power BI. Wyn Hopkins is the Director at Access Analytic, where he provides amazing Excel and Power BI solutions to leading companies in Perth. With extensive expertise as an Excel MVP, Microsoft Certified Excel Expert, and Power BI Developer, Wyn is a highly sought-after trainer and speaker. He brings years of experience working with Chevron and a deep understanding of business intelligence software to help organizations optimize their analysis, reporting, and process improvement. With a track record of delivering solutions that exceed expectations, Wyn is at the forefront of empowering businesses with modern data analytics tools. For full show notes, and the links mentioned visit: https://www.enterprisedna.co/podcast Be our guest, register here: https://www.enterprisedna.co/be-our-podcast-guest/ Connect with Wyn Hopkins: LinkedIn: https://www.linkedin.com/in/wynhopkins/ Website: https://www.accessanalytic.com.au/ Website: https://pbi.guide/book YouTube: https://www.youtube.com/@AccessAnalytic Podcast: https://www.youtube.com/@PowerQuery Connect with Sam McKay Website: https://www.enterprisedna.co/LinkedIn: https://www.linkedin.com/in/sammckayenterprisedna/ Loved this episode? Leave us a review and rating here: https://podcasts.apple.com/us/podcast/the-analytic-mind/id154106699
Danielle Stein Fairhust literally wrote the book on Excel and Financial Modeling. Well two books, actually. Using Excel for Business and Financial Modelling and Financial Modeling in Excel for Dummies. Here, the Excel MVP from Australia provides her secrets to financial modeling. Her road to financial modeling after traveling for seven years, and leaving investment banking Why Excel is so crucial for businesses Budgeting and forecasting vs financial modeling How she was commissioned to write her famous books Difference between creating a LinkedIn course vs writing a book Encouraging and raising the profile of women in financial modeling Secrets to training and behind the scenes of the Financial Modeling World Cup How to Become an Excel MVP The biggest issue people face with financial modeling The Financial Modeling Institute work and how to ace the test Favorite Excel Function? Biggest advice for someone starting in FP&A today? Links Danielle Stein Fairhurst: Using Excel for Business and Financial Modeling Danielle Stein Fairhurst: Financial Modeling in Excel For Dummies Danielle's LinkedIn course (new), Excel: Financial Functions in Depth. Follow Danielle Stein Fairhurst on LinkedIn YouTube video of the episode Follow Paul Barnhurst on LinkedIn Follow Datarails on LinkedIn FP&A Today is brought to you by Datarails. Datarails is the financial planning and analysis platform that automates data consolidation, reporting and planning, while enabling finance teams to continue using their own Excel spreadsheets and financial models. Get in touch at www.datarails.com For AFP FP&A Continuing Education credit please complete the course via the Earmark Ap, must pass the quiz with 80% accuracy and send the completed certificate to pbarnhust@thefpandaguy.com for issuance of 1 hour of credit toward your AFP FP&A Certification.
Oz is the host of the YouTube channel, Excel on Fire where Oz bring a fun, dramatic and humorous approach to teaching Excel. Oz is the author of several books and has presented Excel topics and master classes at conferences in Amsterdam; Sofia, Bulgaria; São Paulo, Brazil; Toronto, Canada; and cities around the United States and Australia. When Oz isn't elbows-deep in the guts of a spreadsheet, he does storytelling around Portland, Oregon. He has told stories onstage for Risk!, Pants on Fire, Seven Deadly Sins, Pickathon, The Moth, and other storytelling shows. Helpful links: https://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 https://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470743 https://www.mrexcel.com/products/cleaning-excel-data-with-power-query-straight-to-the-point https://www.mrexcel.com/products/excel-insights/ https://www.mrexcel.com/products/excel-data-cleansing-straight-to-the-point Connect with Oz on social: https://www.youtube.com/c/OzduSoleilDATA https://www.linkedin.com/in/ozdata --- Send in a voice message: https://anchor.fm/feisworld/message
In this second part of this series on Excel, Liam Bastick, FCMA, CGMA, an Excel MVP, shares what he thinks are the top functions for accountants and finance professionals, Excel's limitations, and what he thinks is the future direction of this most popular spreadsheet software in the world.
Hoy no estoy solo, hoy tengo un invitado muy especial… Una personal que ha conseguido llevar su canal de Youtube a otra dimensión, compartiendo contenido de Excel, Macros… Una locura… Si ya es complicado hacer crecer un canal de Youtube hoy en día con contenido más comercial, imaginaros que locura con contenido de una hoja […]
John David interviews Oz du Soleil, Host of Excel on Fire, about thinking like an analyst. Oz talks about the importance of being curious and looking at data with a critical eye.Looking to land an analytics job? Sounds like you need a solid resume. Sign up for our email list to get a free analytics resume guide.Follow us on LinkedIn: John David Ariansen https://www.linkedin.com/in/johndavidariansen/ Elizabeth Illig https://www.linkedin.com/in/eillig/Want to learn some analytics skills? Check out John David’s courses:Tableau Desktop Specialist GuidePower BI Top SkillsInterested in private career coaching? Click the link to work one-on-one with Elizabeth.
Chandoo.org is one of the top online Excel resources, with tutorials on everything from dashboards to financial modelling. Chandoo is the CEO, or Chief Excel Officer, of Chandoo.org, which provides training on Excel and PowerBI. He is also an Excel MVP. In this interview, I chat with Chandoo about Excel trends and how he became an Excel master.
In today´s episode we interview Chandoo from Chandoo.org who was my Excel mentor and someone who gave me the inspiration to teach my Excel knowledge to the masses. Chandoo is an Excel MVP and an expert in Excel Dashboards, Data Analytics, Visualization & Power BI. His website has been running since 2004 and has over 600,000 monthly viewers and has been featured in many top newspapers, websites & books. In this Excel Podcast episode, Chandoo shares with us his journey into becoming the No.1 Excel website, how Power BI is changing the Excel landscape and shares with us his upcoming live webinar on Budget vs. Actual analysis in Power BI and his live Masterclasses on Advanced Excel & Dashboard Reporting + Power BI, Power Pivot, Power Query!
Rob Collie is an Excel MVP since 2010 who is a world expert and author in Excel Power Pivot and Power BI and resides in Indianapolis, USA! One of the founding engineers behind Power Pivot during his 14 year stint at Microsoft, Rob Collie now runs a consulting and analytics company over at www.PowerPivotPro.com In this episode, Rob talks about his adventure into Excel, the various features within Power Pivot (Measures, DAX, etc) and his online and public courses.
Mynda Treacy is an Excel MVP since 2014 who resides in sunny Queensland, Australia and is an expert in Power BI and Excel Dashboards. In 2009 she started an online training website called MyOnlineTrainingHub.com, where they provide free and paid online training tutorials and courses on Microsoft Excel, Outlook and Word. Mynda has trained over 5,000 people from all over the world and today she focuses on Excel online courses.
Jordan Goldmeier is an Excel MVP and an expert in Excel Dashboards and Data Visualization. He is an internationally recognized speaker, and author of Advanced Excel Essentials and Dashboards For Excel. He has consulted with and provided training for NATO, the Pentagon and The Financial Times. Jordan is the co-founder of Excel.tv and the founder of OptionExplicitVBA.com and resides in New York, USA and in today's episode speaks with us about Excel Dashboards.
Jon Acampora is an Excel MVP and the founder of ExcelCampus.com, which has in depth Excel blog tutorials, online Excel courses and helpful Excel add-ins. In this episode Jon talks about how he got into learning VBA and Macros, his various Excel add-ins that have helped thousand of Excel users and his newly released Excel VBA Pro Online Course which takes beginners and turns them into VBA masters!
Oz du Soleil is an Excel MVP since 2015 and is an expert in data cleansing & analysis. He has an Excel blog over at www.datascopic.net which is his commitment to data literacy. He’s the leading author on the revised version of Guerrilla Data Analysis Using Microsoft Excel and is working on a new book called Full Contact Data Management In this episode Oz shares his passion on data cleansing, talks about his books and his favourite Excel features.
Zack Barresse is an Excel MVP since 2005 and is an expert in Excel Tables. He is a full time Excel consultant and runs an Excel blog over at www.ExcelTables.com He has recently published the only in depth book relating to Excel Tables: A Complete Guide For Creating, Using and Automating Lists and Tables
Bill Jelen aka "Mr. Excel" is an Excel MVP and one of the biggest names associated with Microsoft Excel. He is the author of 40 books about Microsoft Excel, Power Pivot and Power View. Bill has produced over 1900 Excel episodes of his daily video Podcast and has one of the most popular Excel websites and forums called MrExcel.com In this podcast we talk about how he became to be an Excel expert, his first days as Mr. Excel, the evolution of Microsoft Excel, the weirdest thing he has seen done with Excel, stories about his Power Excel Seminars, his new XL book, his favourite tips & shortcuts and much much more....
Ken Puls is an Excel MVP who is the founder of long standing Excel website & forum called ExcelGuru.ca He is an expert in Power Query and has co-authored the book M is for (Data) Monkey: A Guide to the M Language in Excel Power Query
Chandoo.org Podcast - Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel
In the 5th session of Chandoo.org podcast, we are going to demystify form controls. I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor - Debra Dalgleish about this topic. In this podcast, you will learn, What are form controls When you would use them? Example form control - Combo box How form controls differ from active-x controls How to enable form controls in your Excel? Various important form controls Special bonus & how to obtain it The post CP005: Introduction to Form Controls – an interview with Debra Dalgleish appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.