Want to start analyzing your first data set in Microsoft Excel? We've put together the top 10 Excel formulas and functions you'll need in your career as a data analyst! This will allow you to perform many of the essential data analysis tasks such as cleaning, grouping and sorting data, laying the essential foundation for your career!

Tom Gadsby, our very own senior data scientist, will walk you through the selection, explain why each feature is so important, and show them in use on a real data set!

Do you already use Excel? Comment below with your favorite use cases!

These are the features we cover:

(00:00) An introduction to essential Excel functions
(00:24) The data set
(00:52) Create an /"IF/" function in Excel
(02:27) What is a /"UNIQUE/" Function?
(03:38) Create an /"AVERAGEIF/" statement
(06:25) An introduction to the /"CONCATENATE/" function.
(08:29) An explanation of the /"ISBLANK/" function.
(12:28) Getting started with the /"LEFT / CENTER / RIGHT/" functions.
(13:36) An introduction to the /"LEN/" function
(14:29) How to use the /"VLOOKUP/" function
(16:39) How to use the /"SORT/" function
(17:37) What is the function /"FILTER/".
(18:57) Outro

Here is the link where the data originally came from. Some changes were made to the original dataset to better suit this video – https://www.kaggle.com/datasets/aditya6196/retail-analysis-with-walmart-data

Do you want to start a career in data analysis? Check out CareerFoundry's free data analytics short course:
https://bit.ly/DAShortCourse7

Would you like to delve deeper into some important topics in data analysis? Check out CareerFoundry's blog: https://careerfoundry.com/en/blog/

Interested in live events and webinars around UX design? View our events page: https://careerfoundry.com/en/events/

Thanks for looking!

#Excel #DataAnalytics #DataTools

Want more from CareerFoundry?

Also check out our other social media channels and blog:
https://linktr.ee/CareerFoundry​

For more information about our programs, please visit us at:
https://careerfoundry.com/

Top 10 Excel Features Every Data Analyst Needs in 2022!
https://youtu.be/B4dBMsOT1aA

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.