logo
episode-header-image
Nov 2023
43m 40s

82: Mastering Data Analytics with Excel ...

Avery Smith - Data Career Coach
About this episode

Join host Avery Smith, with Excel expert Matt Brattin about mastering data analytics with Excel in this episode of the Data Career Podcast.

From customizing shortcuts to leveraging advanced functions, Matt shares tips and tricks to take your Excel skills to the next level.

Get insights from an industry pro and boost your chances of landing your dream data job.

Tune in now!


Connect with Matt Brattin:

🤝 Connect on Linkedin

▶️ Subscribe to Youtube Channel

🎒 Learn About the Excel 4 Academy


🤝 Ace your data analyst interview with the interview simulator

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp


Timestamps:

(07:53) - 5 Concepts of Excel you should know

(20:35) - Top Excel Shortcuts

(26:54) - Can you make a dashboard in Excel?

(30:20) - Excel is like Thor’s hammer


Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Up next
Yesterday
187: Would You Survive This Data Analyst Interview?
<p>Help us become the #1 Data Podcast by leaving a rating &amp; review! We are 67 reviews away! </p><p>Can You Pass This Data Analyst Interview?</p><p>🖥️ Build your own app with Replit: https://replit.com/refer/AveryData</p><p>👔 Mock Interview Platform: https://interviewsimula ... Show More
12m 30s
Nov 18
186: I analyzed 6,512 data analytics jobs – here’s where you’re most likely to get hired
<p>Help us become the #1 Data Podcast by leaving a rating &amp; review! We are 67 reviews away! </p><p>I wouldn't try to become a data analyst next here. Here's 4 reasons why and what I'd do instead. </p><p>💌 Join 30k+ aspiring data analysts &amp; get my tips in your inbox weekl ... Show More
12m 15s
Nov 11
185: How I Would Become a Data Analyst in 2026 (if I had to start over again)
<p>🏆 Follow this roadmap w/ The Data Analytics Accelerator (My Bootcamp): <a href="https://www.youtube.com/redirect?event=video_description&amp;redir_token=QUFFLUhqa2Y3RlBlajFSUy1mcmVYQmpvZUFaeVphWnRtd3xBQ3Jtc0tuRk1wVy1rY25wMWNPWl9CaDJiT05EUWlyNnpydC1vbG00cEktZUdndmlqLVJQSWhIX0R ... Show More
25m 34s
Recommended Episodes
Oct 2022
Ryan Serhant: His Multimillionaire Mindset
<p>#1: I am interviewing <a href="https://www.instagram.com/ryanserhant/?hl=en">Ryan Serhant</a>, CEO and founder of real estate company <a href="https://www.serhant.com/">SERHANT</a>. Ryan and I discuss his path from a struggling actor to a real estate multimillionaire, how a re ... Show More
47m 59s
Sep 2022
MI224: How to Work and Live with Purpose w/ Matt Spielman
IN THIS EPISODE, YOU’LL LEARN:   04:57 - Matt’s top tips for Millennials who are thinking about a career change.  07:46 - How to decide when it makes sense to follow your passion.  10:41 - How to use Matt’s “Game Plan System” as a framework to set and achieve your goals.  24: ... Show More
47m 5s
Aug 2023
Utilizing data to drive smart business outcomes -- Matt Kilmartin & Matthew Karasick // Habu
Matt Kilmartin and Matthew Karasick, CEO and CPO at Habu, explore data-driven AI solutions for business efficiency. Using data to drive smart business outcomes within the framework of data clean rooms involves collaborating with partners' data without sharing the actual data itse ... Show More
19m 16s
Apr 2023
Asking The $100,000,000 Man How To Get Rich | Alex Hormozi
<p>#27: Alex Hormozi, monetization expert and the CEO of Acquisition.com shares his inspiring journey of going from the security of his 9-5 job to building a multi-million dollar business empire in the fitness industry. Through his relentless pursuit of knowledge and hard work, A ... Show More
44m 45s
Dec 2022
Jeremiah Lowin: Explaining the New AI Paradigm - [Invest Like the Best, EP.307]
My guest this week is Jeremiah Lowin. Jeremiah has been on the podcast a number of times over the years. He’s one of my oldest friends who has been a sounding board for me throughout my career. Today he is the founder and CEO of Prefect, which helps companies automate and orchest ... Show More
1h 2m
Mar 2023
S9E23: How a Biology Major Landed an EY-Parthenon Summer Internship
<p><a target="_blank" href="https://www.buzzsprout.com/twilio/text_messages/1002655/open_sms">Send us a text</a></p><p>We&apos;re excited to bring you today&apos;s episode where Eric Lu shares insights from his journey into consulting. <br/><br/>A Duke University Biology major, E ... Show More
25m 50s
Nov 2022
Happiness Based On Your Personality Type with Gretchen Rubin
<p>#5: Author of the groundbreaking personality test and New York Times bestselling book, “The Four Tendencies”, <a href="https://gretchenrubin.com/">Gretchen Rubin</a>, teaches us how to define happiness and achieve goals through better understanding our personality type.</p><p> ... Show More
1h 23m
Jun 2023
Former Secret Service Agent Reveals Psychological Tricks You're Falling For
<p>#38: Evy Poumpouras is a former Secret Service agent, speaker, author, and media personality. In this episode, she shares with us what she learned from her training and her time on the job as security for multiple presidents of the United States and polygraph specialist, and h ... Show More
1h 6m
Jul 2023
How to Become Better With Money With Financial Expert Rachel Cruze
<p>#39: Rachel Cruze is an author and certified financial coach, and she co-hosts the Ramsey Show alongside her father, Dave Ramsey. In this episode, Rachel and I discuss money habits and how to improve your relationship with money, we give tips on how to set up your kids for fin ... Show More
1h 1m