10 Excel Functions You NEED to KNOW as Engineers!

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses This video is a must-watch for all engineers, especially mechanical engineers, who use Excel in their professional lives. It introduces a variety of Excel functions that are critical in engineering work, with a special focus on how these functions can simplify and enhance your workflow. These functions are applicable across all versions of Excel and are tailored to meet the unique demands of engineering tasks. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/excel-engineers-file Key Excel Functions Covered: ▪️ REPT Function: Learn how to repeat values effectively for visual hierarchy in data. ▪️ TRIM Function: Discover how to remove unnecessary spaces in data entries. ▪️ LEN & SUBSTITUTE Functions: Master the art of determining hierarchical levels in data. ▪️ LEFT and RIGHT Functions: Gain insights into extracting specific parts of text entries. ▪️ FIND Function: Explore how to locate specific characters within text and manipulate data accordingly. ▪️ LOOKUP Function: Understand the complex yet powerful uses of the original Excel lookup function. ▪️ IFERROR Function: Learn error handling to maintain clean and accurate data. ▪️ IF Function: Dive into logical tests to categorize and analyze data efficiently. ▪️ Bonus - Extended Quantity Calculation: A composite function that combines key elements from other functions for comprehensive data analysis. All are great for engineers and anyone else who'd like to use Excel more efficiently. If you're working with data for bill of materials, part numbers, or need to calculate extended quantity, this tutorial will help you. 🌍 My Online Excel Courses ► https://www.xelplus.com/courses/ 00:00 The Most Important Excel Functions in Engineering 00:55 Working with a Bill of Material (BOM) in Excel 01:37 REPT Function 03:11 TRIM Function 03:48 LEN & SUBSTITUTE Function 06:04 LEFT 06:42 FIND Function 07:55 RIGHT Function 09:11 LOOKUP Function 12:09 IFERROR Function 12:56 IF Function 13:40 Bonus: Calculating Extended Quantity 14:43 Wrap Up 🎬 LINKS to related videos: - 5 Excel Functions YOU NEED in 2021: https://youtu.be/_EWcAR_Hkvg - Basic Excel Formulas and Functions You NEED to KNOW!: https://youtu.be/y1126PQ5zRU - Excel IF Function explained in detail: https://youtu.be/KkTaQ5OjAGc ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel #Billofmaterials #BOM