006: Excel Tables with Zack Barresse

Learn Microsoft Excel with MyExcelOnline

Player FM - Internet Radio Done Right

68 subscribers

הוסף לפני ten שנים

תוכן מסופק על ידי John Michaloudis, John Michaloudis interviews Microsoft Excel experts, and MVPs about their fa. כל תוכן הפודקאסטים כולל פרקים, גרפיקה ותיאורי פודקאסטים מועלים ומסופקים ישירות על ידי John Michaloudis, John Michaloudis interviews Microsoft Excel experts, and MVPs about their fa או שותף פלטפורמת הפודקאסט שלהם. אם אתה מאמין שמישהו משתמש ביצירה שלך המוגנת בזכויות יוצרים ללא רשותך, אתה יכול לעקוב אחר התהליך המתואר כאן https://he.player.fm/legal.

The So What from BCG

1
Not All Growth Is Good—Here's How to Get It Right 20:09

לפני 18 ימים20:09

הפעל מאוחר יותר

רשימות

לייק

אהבתי

20:09

Justin Manly, BCG’s lead on growth and innovation, explains how businesses can choose the right growth strategy given their aspirations and position in the market. Whether a company is gaining or losing share, in a booming or sluggish industry, profitable growth depends on knowing your starting point. Learn More: Justin Manly: https://on.bcg.com/4kGYyPH BCG’s Latest Thinking on Growth and Innovation Analytics: https://on.bcg.com/4kjTEIB BCG’s Latest Thinking on Corporate Finance and Strategy: https://on.bcg.com/3ZeAMlX Your Growth Strategy Depends on Your Starting Point: https://on.bcg.com/43YpzZm The Vitality Code: How Growth Leaders Master Strategy, Technology, People, and Culture: https://on.bcg.com/4dMKjH1 This podcast uses the following third-party services for analysis: Podtrac - https://analytics.podtrac.com/privacy-policy-gdrp…

לפני 10 שנים 46:25

MP3•בית הפרקים

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

👉 Join Our Academy Online Excel Course

👉 Show Notes: https://www.myexcelonline.com/podcast/006-excel-tables-with-zack-barresse-excel-podcast-from-exceltables/

37 פרקים

006: Excel Tables with Zack Barresse

Learn Microsoft Excel with MyExcelOnline

68 subscribers

published לפני 10 שנים

שתפו

MP3•בית הפרקים

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

👉 Join Our Academy Online Excel Course

👉 Show Notes: https://www.myexcelonline.com/podcast/006-excel-tables-with-zack-barresse-excel-podcast-from-exceltables/

37 פרקים

כל הפרקים

1
034: The Best Microsoft Excel Tips & Tricks in 2024 39:37

לפני 25 weeks39:37

39:37

We have rounded up the best Microsoft Excel experts & MVPs from around the world to share their best Microsoft Excel tips & tricks in 2024! These Microsoft Excel tips & tricks will save you time and make you a more efficient Excel user. Make sure to learn and apply at least 1 tip from today's podcast show. Show Notes: MyExcelOnline.com Each tip is covered in our latest Excel E-Book which you can download for FREE for a limited time only: Click here to download our FREE 101 Excel Tips & Trick E-Book!…

1
033: The Best Microsoft Excel Tips & Tricks in 2023 26:04

לפני 1 year26:04

26:04

We have rounded up the best Microsoft Excel experts & MVPs from around the world to share their best Microsoft Excel tips & tricks in 2023! These Microsoft Excel tips & tricks will save you time and make you a more efficient Excel user. Make sure to learn and apply at least 1 tip from today's podcast show. Each tip is covered in our latest Excel E-Book which you can download for FREE for a limited time only: Click here to download our FREE 101 Excel Tips & Trick E-Book! Show Notes: MyExcelOnline…

1
032: The Best Microsoft Excel Tips & Tricks in 2022 28:16

לפני 2 years28:16

28:16

We have rounded up the best Microsoft Excel experts & MVPs from around the world to share their best Microsoft Excel tips & tricks in 2022! These Microsoft Excel tips & tricks will save you time and make you a more efficient Excel user. Make sure to learn and apply at least 1 tip from today's podcast show. Each tip is covered in our latest Excel E-Book which you can download for FREE for a limited time only: Click here to download our FREE 101 Excel Tips & Trick E-Book! Show Notes: MyExcelOnline.com…

1
031: How to become an Excel Expert in 2022 and stand out from the crowd! 15:33

לפני 3 years15:33

15:33

In this epsiode, I will reveal the No.1 tool that you need in order to become an Excel expert in 2022 and get the recognition, promotion, pay raises or new jobs that you deserve! Here is the link to your special invite: MyExcelOnline.com

1
030: The Best Microsoft Excel Tips & Tricks in 2021 40:19

לפני 3 years40:19

40:19

We have rounded up 25 of the best Microsoft Excel experts & MVPs from around the world to share their best Microsoft Excel tips & tricks in 2021! These Microsoft Excel tips & tricks will save you time and make you a more efficient Excel user. Make sure to learn and apply at least 1 tip from today's podcast show. Each tip is covered in our latest Excel E-Book which you can download for FREE for a limited time only: Click here to download our FREE 101 Excel Tips & Trick E-Book! Show Notes: MyExcelOnline.com…

1
029: 101 Best Excel Tips & Tricks Book Launch + My Top 10 Tips & Tricks 26:21

לפני 4 years26:21

26:21

In this episode we discuss our 3rd and latest Excel book that we launched today called the 101 BEST EXCEL TIPS & TRICKS! We go through the amazing tips that you will find in this book plus I talk about my Top 10 favorite Excel Tips & Tricks inside this book. You can purchase this book today in Amazon using this link. Don't forget to also check out our other best selling books on Amazon, 101 Most Popular Excel Formulas & 101 Ready To Use Excel Macros! Check out our show notes here!…

1
028: The Best Microsoft Excel Tips & Tricks in 2020! 52:58

לפני 5 years52:58

52:58

This is one of our biggest episodes of the year and we have 30 Excel experts sharing their nest Excel tip & trick of 2020! We go from New Zealand, via Asia, Europe, America and end up in Brazil! Show Notes: MyExcelOnline.com

1
027: Top 3 Excel Mistakes to avoid if you want to ADVANCE your Microsoft Excel level 16:24

לפני 5 years16:24

16:24

If you want to Advance your Microsoft Excel level, then listen to my Top 3 mistakes to avoid! I have also made these mistakes and I don't want you to make the same. Enroll in the MyExcelOnline Academy online course which will Advance your Excel level within 30 days! This is now open for a limited time only: MyExcelOnline.com…

1
026: The Best Microsoft Excel Tips & Tricks in 2019! 30:52

לפני 6 years30:52

30:52

In this Christmas Special podcast episode, we round up the best Microsoft Excel experts & MVPs from around the world to share their best Microsoft Excel tips & tricks in 2019! These Microsoft Excel tips & tricks are the best that we have received to date and will make you a better and more efficient Excel user. What is your best Excel tip & trick in 2019? You can share it with us at the bottom of this page in the comments area, we would love to hear it! Get all the links to these Excel tips by clicking in the show notes here!…

1
025: Free Excel Formulas Webinar Training - VLOOKUP, INDEX, MATCH, IF, SUMIF 5:24

לפני 6 years5:24

5:24

I am excited to announce that our in house MyExcelOnline and Microsoft Certified Trainer, Kyle Pew and myself will be holding a free Excel formulas webinar over the coming few days on: The MUST KNOW Excel Formulas to ADVANCE your Excel skills! 👉 JOIN FREE FORMULAS WEBINAR Whether you are just getting started with Formulas, or have been using Formulas for a while, this webinar will cover everything you need to know to get going. During this free training you will learn: 👉 The MUST KNOW Excel Formulas that your boss EXPECTS you to know! 👉 A proven step by step guide to creating Excel Formulas in SECONDS! 👉 The limitations of using a VLOOKUP and why INDEX & MATCH is better! 👉 3 TIPS that the Excel experts & MVPS use that will enhance your Formula knowledge forever! 👉 You will also be able to download the Excel workbook used in the training so you can follow along & practice! 👉 JOIN FREE FORMULAS WEBINAR…

1
024: Excel Power BI with Chandoo from Chandoo.org 59:42

לפני 6 years59:42

59:42

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 ! 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/024-excel-power-bi-with-chandoo-from-chandoo-org…

1
023: Top Excel Tips & Tricks of 2018 36:40

לפני 6 years36:40

36:40

In this annual special podcast episode, we round up the best Excel experts & MVPs around the world to get their best Excel tips & tricks of 2018! 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen/…

1
022: New Microsoft Office 365 Excel Features with Mr. Excel Bill Jelen 56:02

לפני 7 years56:02

56:02

Microsoft recently released some new Excel features in their Office 365 subscription license. What better way to talk about these new Excel features than with Bill Jelen from MrExcel.com who has published more than 50 books about Microsoft Excel! In this Excel podcast we talk about: The difference between Office 365 subscription and Excel 2019 download version; The different Office 365 subscription options; The new Excel features released in Office 365 Geography & Stock Data Type Artificial Intelligence with Ideas Dynamic Arrays: SORT, SORTBY, FILTER, UNIQUE & RANDARRAY 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/022-new-microsoft-office-365-excel-features-with-mr-excel-bill-jelen/…

1
021: The MyExcelOnline Academy Online Excel Course 22:19

לפני 7 years22:19

22:19

Today we are launching our latest online Excel course called "The MyExcelOnline Academy Online Excel Course". This online Excel course covers all the best Excel features like Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Charts, Analysis plus much more! You can access this course today and lock in our special Grandfathered Pricing ($20 a month or $200 a year) FOREVER by going to our course page: 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/021-the-myexcelonline-academy-online-excel-course/…

1
020: How To Prepare For An Excel Assessment Test For A Job Interview 42:55

לפני 7 years42:55

42:55

In this special Excel podcast episode I interview 11 Microsoft Excel experts and MVPs from around the world to get their insights as to the best way to prepare for an Excel Assessment Test for a job interview. They also share the must know Excel features that you need to learn before going into this job interview. If you can take at least 3 points from this podcast show and apply them to your next job interview, you will have a competitive advantage over your peers. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/020-how-to-prepare-for-an-excel-assessment-test-for-a-job-interview/…

Learn Microsoft Excel with MyExcelOnline

1
019: Xtreme Macros & VBA Online Course with Kyle Pew 37:51

לפני 7 years37:51

37:51

In this special course announcement episode, I interview Kyle Pew who is the creator of our latest course on MyExcelOnline.com - The Xtreme Macros & VBA Online Course! 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/019-xtreme-macros-vba-excel-online-course-with-kyle-pew/…

Learn Microsoft Excel with MyExcelOnline

1
018: The Best Excel Tips of 2017 from 20 Excel Experts [Christmas Special] 39:44

לפני 7 years39:44

39:44

In this Christmas Special podcast episode, 20 Excel experts from around the world share their best Excel tip of 2017! At the end of the podcast episode, there is a catchy Excel song parody of Ed Sheeran's song "Shape of you" created by Clint Tuttle! Happy New Excel Year! Love, John Michaloudis :) 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/018-best-excel-tips-2017-from-20-excel-experts-christmas-special/…

Learn Microsoft Excel with MyExcelOnline

1
017: Microsoft Excel Webinars 16:39

לפני 8 years16:39

16:39

Excel Webinars are a great way to learn the different features within Microsoft Excel for free! These Excel webinars are usually about 60 minutes long (great for lunch time learning), you can ask questions via the chat box & get your answers directly in your inbox! At MyExcelOnline we have free Excel webinars on Pivot Tables and Power Query/Get & Transform! These have been viewed by more than 20,000 people and have helped them get better at Excel! You too can join our free Excel webinars by clicking on the link below and receive your bonus cheat sheet: 👉 https://www.myexcelonline.com/115-23.html 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/017-free-microsoft-excel-webinars/…

Learn Microsoft Excel with MyExcelOnline

1
016: Excel Power Pivot With Rob Collie 1:08:17

לפני 8 years1:08:17

1:08:17

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. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/016-excel-power-pivot-with-rob-collie-from-powerpivotpro/…

Learn Microsoft Excel with MyExcelOnline

1
015: Excel Power BI With Mynda Treacy 53:15

לפני 8 years53:15

53:15

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. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/015-excel-power-bi-mynda-treacy-from-myonlinetraininghub/…

Learn Microsoft Excel with MyExcelOnline

1
014: Excel Dashboards With Jordan Goldmeier 1:15:21

לפני 8 years1:15:21

1:15:21

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. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/14-excel-dashboards-jordan-goldmeier/…

Learn Microsoft Excel with MyExcelOnline

1
013: The Best Excel Tips of 2016 from 23 Excel Experts [Christmas Special] 52:57

לפני 9 years52:57

52:57

In 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 Excellin g" and it is a very catchy song indeed! Merry Christmas and a Happy New Year! Love, John Michaloudis :) 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/christmas-special-013-best-excel-tips-2016-23-excel-experts-2/…

Learn Microsoft Excel with MyExcelOnline

1
012: Financial Modelling with Danielle Stein Fairhurst 1:10:03

לפני 9 years1:10:03

1:10:03

Danielle 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. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/012-financial-modelling-danielle-stein-fairhurst-from-plumsolutions/…

Learn Microsoft Excel with MyExcelOnline

1
011: VBA Pro Course with Jon Acampora 1:13:38

לפני 9 years1:13:38

1:13:38

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! 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/011-excel-vba-pro-course-jon-acampora-from-excelcampus/…

Learn Microsoft Excel with MyExcelOnline

1
010: Excel Power Query (Get & Transform) & Data Cleansing Online Course 47:51

לפני 9 years47:51

47:51

In 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. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/010-excel-power-query-get-transform-data-cleansing-online-course/…

Learn Microsoft Excel with MyExcelOnline

1
009: Excel for Accountants with Jeff Lenning 46:35

לפני 9 years46:35

46:35

Jeff 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! 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity/…

Learn Microsoft Excel with MyExcelOnline

1
008: Inside The Microsoft Excel Offices With John Campbell 1:00:20

לפני 9 years1:00:20

1:00:20

John 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! 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/008-inside-the-microsoft-excel-offices-with-john-campbell/…

Learn Microsoft Excel with MyExcelOnline

1
007: Data Cleansing & Analysis with Oz du Soleil 1:12:10

לפני 9 years1:12:10

1:12:10

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. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast/…

Learn Microsoft Excel with MyExcelOnline

1
006: Excel Tables with Zack Barresse 46:25

לפני 10 years46:25

46:25

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 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/006-excel-tables-with-zack-barresse-excel-podcast-from-exceltables/…

Learn Microsoft Excel with MyExcelOnline

1
005: My Top 10 Excel Keyboard Shortcuts 16:26

לפני 10 years16:26

16:26

Excel 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: 👉 Show Notes: https://www.myexcelonline.com/podcast/005-my-top-10-excel-keyboard-shortcuts-excel-podcast/ 👉 Academy Online Excel Course: https://www.myexcelonline.com/courses…

ברוכים הבאים אל Player FM!

Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.