Sinopse
This podcast will teach beginner & intermediate Microsoft Excel users the different Excel tools like: Formulas, Pivot Tables, Charts, Analysis, Macros, VBA, Dashboards, Power BI, Add-Ins, Shortcuts, Tips plus much more.I interview Excel MVPs and experts around the world to share their Excel insights, knowledge, tips and tricks that will get you on the way to becoming an advanced Excel user, just like them.
Episódios
-
013: The Best Excel Tips of 2016 from 23 Excel Experts [Christmas Special]
22/12/2016 Duração: 52minIn this Christmas Special podcast episode, I gather 22 Excel experts from around the world to share their best tip of the year! At the end of the podcast episode, there is a great Excel song created by Clint Tuttle called "Can't Stop Excelling" and it is a very catchy song indeed! Merry Christmas and a Happy New Year! Love, John Michaloudis :)
-
012: Financial Modelling with Danielle Stein Fairhurst
07/12/2016 Duração: 01h10minDanielle Stein Fairhurst is an MBA and an expert in Financial Modelling. She is the owner of www.PlumSolutions.com.au, a company dedicated to helping Financial Modellers via her online courses, training seminars and consulting gigs. Danielle is also the author of Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals and an expert in her field, who resides in Sydney, Australia.
-
011: VBA Pro Course with Jon Acampora
26/10/2016 Duração: 01h13minJon 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!
-
010: Excel Power Query (Get & Transform) & Data Cleansing Online Course
17/06/2016 Duração: 47minIn this special course announcement podcast, I talk with Oz du Soleil (Excel MVP, Author & world expert on data cleansing) about our new Excel online course which I had the pleasure to co-author! We talk about the need to clean dirty data and explain the different ways that you can so this, saving you hours each working day and ending your misery! We chat about the Power Query course content, course benefits and the different times that this course will be open for registration.
-
009: Excel for Accountants with Jeff Lenning
21/04/2016 Duração: 46minJeff Lenning is a CPA and a Microsoft Office Certified Excel Expert & Trainer and who has shown thousands of CPAs and accounting professionals how to use Excel to streamline their work and become more efficient. In 2012 he launched Excel-University.com, a Microsoft Excel Training website for CPAs and Accounting Professionals, has written various publications and published three books about Excel's features. In this episode Jeff tells us how you can save hours during your month-end closing procedures using Excel, expands on his online Excel courses and shares with us his favorite Excel features & tips!
-
008: Inside The Microsoft Excel Offices With John Campbell
28/02/2016 Duração: 01h20sJohn Campbell is an experienced Program Manager at Microsoft Excel for and has been working on the Excel Team for over 10 years. In this episode John takes us behind the scenes and inside Microsoft’s offices to discuss the evolution of Microsoft Excel, Excel’s 30th Anniversary, the new features in Excel 2016, Microsoft’s plans for the next 5 yeras and he also talks about how it is to work with Bill Gates!
-
007: Data Cleansing & Analysis with Oz du Soleil
29/01/2016 Duração: 01h12minOz 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.
-
006: Excel Tables with Zack Barresse
19/11/2015 Duração: 46minZack 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
-
005: My Top 10 Excel Keyboard Shortcuts
05/10/2015 Duração: 16minExcel Keyboard shortcuts are used by almost every one of the 750 million Microsoft Excel users worldwide. They range from the CTRL combinations shortcuts to the Function keys shortcuts as well as many other Excel keyboard shortcuts. In this episode I go through my top 10 favorite Excel keyboard shortcuts that will save you heaps of time when working with Excel data. What is your favorite Excel keyboard shortcut? Let me know by entering it in the comments section of this episode over at:
-
004: Excel with MrExcel Bill Jelen
13/08/2015 Duração: 01h10minBill 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....
-
003: Xtreme Pivot Table Online Excel Course
07/08/2015 Duração: 11minThe Xtreme Pivot Table online course is my flagship Excel course which has 14 different chapters, over 200 short video tutorials and around 10 hours of content. I discuss the different topics that are covered in this course and the benefits that you get and I also provide a special discount coupon for you!
-
002: Power Query with Ken Puls
31/07/2015 Duração: 57minKen 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
-
001: VBA & Excel Add-Ins with Chris Newman
14/07/2015 Duração: 40minChris Newman (aka Chris Macro) is the founder of one of the best looking Excel websites around called TheSpreadhseetGuru.com He is a VBA expert and has created various time saving Excel Add-Ins that have helped thousands of Excel users worldwide.
-
000: My Excel Story - MyExcelOnline Podcast
01/07/2015 Duração: 10minIn this introductory podcast I share with you my story into becoming an Excel expert and tell you about the show´s format and what to expect from this Excel podcast!