Microsoft Excel Tutorial – BOM Tool Suite from Main Sheet Solutions

Do you deal with Bills of Material? Also known as BOMs. Any Structured List in Excel can make use of this add-in from Main Sheet Solutions:

Download a trial from https://www.mainsheetsolutions.com/

Download the two data sets that I used in this video: https://www.mrexcel.com/youtube/k4A1lg9pPlc/

Table of Contents
(0:00) Bills of Material in Excel
(2:02) Data in a typical BOM
(2:21) Ribbon for BOM
(2:29) Adding Grouping
(2:46) Choosing highlight colors
(3:17) Highlight rows
(3:27) Indent BOM
(3:36) BOM Rollup Calculations
(4:30) Analyzing Mike Girvin Book Table of Contents
(6:03) Adding Structure ID and UID
(6:44) Applying colors to group levels
(7:06) Check out the add-in
(7:31) Wrap-up