Looking to start analyzing your first dataset in Microsoft Excel? We’ve prepared the top 10 Excel formulas and functions you will need in your career as a data analyst! With them, you'll be able to do many of the essential data analysis tasks such as data cleaning, grouping, and sorting—laying the essential base for your career!

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

Already using Excel? Comment your favorite use cases down below!

Here are the functions we’ll cover:

(00:00) An introduction to essential Excel functions
(00:24) The Dataset
(00:52) Creating an "IF" Function in Excel
(02:27) What is a "UNIQUE" Function?
(03:38) How to create an "AVERAGEIF" statement
(06:25) An introduction to the "CONCATENATE" Function
(08:29) An explanation of the "ISBLANK" Function
(12:28) Get started with "LEFT / MID / 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 "FILTER" Function
(18:57) Outro

Here's the link the data came from originally, some changes have been made to the original dataset to fit this video better - https://www.kaggle.com/datasets/adity...

Looking to start a career in data analytics? Check CareerFoundry’s free data analytics short course:
https://bit.ly/DAShortCourse7

Want a deeper dive on some key data analytics topics? Check out CareerFoundry’s blog: https://careerfoundry.com/en/blog/

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

Thanks for watching!

#Excel #DataAnalytics #DataTools

Want more from CareerFoundry?

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

For more information on our programs, visit us at:
🖥 https://careerfoundry.com/

Top 10 Excel Functions Every Data Analyst Needs in 2022!
   • The 10 Most Important Excel Formulas ...