Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching The 10 Most Important Excel Formulas and functions - Made Easy! (2024). and this video is uploaded by CareerFoundry at 2022-08-26T05:00:07-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [B4dBMsOT1aA]
| Name | The 10 Most Important Excel Formulas and functions - Made Easy! (2024) |
| Video Uploader | Video From CareerFoundry |
| Upload Date | This Video Uploaded At 26-08-2022 12:00:07 |
| Video Discription | 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/aditya6196/retail-analysis-with-walmart-data 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! https://youtu.be/B4dBMsOT1aA [B4dBMsOT1aA] |
| Category | Education |
| Tags | data analytics | data analyst | excel tips and tricks | microsoft excel tutorials | data analytics in excel | microsoft excel for data analysis | microsoft excel for data analytics | data analytics for beginners | data analyst skills | how to become a data analyst | microsoft excel | excel for analysts | excel formulas and functions | data analytics project | excel functions for data analysis | excel data analysis | data analytics job | data analytics career | data analyst day in the life |
