Intro to Excel Tables and Power Query for Creo Users!
Overview
This video is a beginner-friendly introduction to Excel Tables and Power Query, specifically tailored for Creo users who work with BOM data. Many Creo engineers are comfortable with basic Excel but haven't explored Tables and Power Query — two features that dramatically improve how you work with exported BOM data. Excel Tables provide structured, auto-expanding data ranges with built-in filtering, sorting, and formatting. Power Query is Excel's data transformation engine that lets you clean, reshape, merge, and automate data processing without writing VBA macros. The video covers converting exported BOM data into Excel Tables, using Power Query to connect to BOM export files, performing common transformations (filtering rows, renaming columns, changing data types), and refreshing queries when new data is exported. These foundational skills unlock the more advanced Power Query workflows shown in other Nitro-BOM videos, such as cost summaries and description comparisons.
Key Steps
- Export BOM data from Creo using Nitro-BOM
- Convert the exported data range into an Excel Table
- Explore Table features: auto-filters, structured references, and auto-expansion
- Open Power Query Editor and connect to the BOM data source
- Apply basic transformations: filter rows, rename columns, change data types
- Load the transformed data back into Excel and refresh when new exports are available
Tips
- Excel Tables are the foundation for reliable Power Query connections — always convert your data to a Table first
- Power Query transformations are recorded as steps and replay automatically on refresh
- This video is a prerequisite for the more advanced Power Query workflows in the Nitro-BOM video series