logo
episode-header-image
Nov 2023
44m 15s

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

Mentioned in this episode:

Join The Next Cohort of The Accelerator

Want to land your first data job? Join my data bootcamp to get EVERYTHING you need to land your first data job! Excel, SQL, Tableau, Power BI, Python, R? Yup. Projects? Lots of them. LinkedIn help? Of course. Resume optimization? You betcha. Job hunting strategy? Duh. Click to learn more!

https://www.datacareerjumpstart.com/daa

💙 Thank you for subscribing & leaving a review

Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

Up next
Jul 8
168: Stop Doing Random Data Courses - Read These Books Instead
Tired of spending money on data courses you never finish? Here are 7 essential books that will actually boost your analytical skills, with no subscription required! Plus, make sure to tune in till the end as one lucky listener will get a free book from this list! Get the books he ... Show More
15m 30s
Jul 1
167: Hiring Manager Explains: How to Become a Healthcare Analyst (Jason Bryll)
Jason Bryll is a healthcare analytics expert and hiring manager with nearly two decades of experience. In this episode, Jason explains what healthcare analytics entails, why it's essential, and the role of AI in the field. More importantly, you'll learn how to stand out to hiring ... Show More
40m 43s
Jun 24
166: You’re Already a Data Analyst (You Just Don’t Know It)
Turn your current tasks into clear, resume-ready bullets that sound more data-focused👉 Resume Transformer: https://datafairy.io/GMM2DJKWM9Here's a realization you need to hear: You're a Data Analyst ALREADY. You're not as far away as you think you are. In this episode, I teach y ... Show More
14m 23s
Recommended Episodes
Oct 2022
Ryan Serhant: His Multimillionaire Mindset
#1: I am interviewing Ryan Serhant, CEO and founder of real estate company SERHANT. Ryan and I discuss his path from a struggling actor to a real estate multimillionaire, how a reality TV show helped him build his career, and the tools he uses to work towards the future version o ... Show More
52m 44s
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:03 - ... 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
#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, Alex ... Show More
49m 30s
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
Send us a textWe're excited to bring you today's episode where Eric Lu shares insights from his journey into consulting. A Duke University Biology major, Eric wanted to combine his love for business with his passion for healthcare through a career in consulting. He land ... Show More
25m 18s
Nov 2022
Happiness Based On Your Personality Type with Gretchen Rubin
#5: Author of the groundbreaking personality test and New York Times bestselling book, “The Four Tendencies”, Gretchen Rubin, teaches us how to define happiness and achieve goals through better understanding our personality type. Get Gretchen’s book “The Four Tendencies" Special ... Show More
1h 28m
Jun 2023
Former Secret Service Agent Reveals Psychological Tricks You're Falling For
#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 how ... Show More
1h 10m
Jul 2023
How to Become Better With Money With Financial Expert Rachel Cruze
#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 financ ... Show More
1h 6m