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