cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Intro to Excel Tables and Power Query for Creo Users!

Highlighted

Intro to Excel Tables and Power Query for Creo Users!

We did a webinar last week with Elite Digital Enterprise to help educate people on Microsoft Excel Tables and Power Query functionality.

 

The Webinar was focused on Bill of Materials (BOM) Data, covering the problems typically encountered using conventional Excel Approaches (Cell Address/Named Range References) and why Excel Tables and especially Power Query should be more widely used/adopted.

 

Creo BOM export techniques and options were also covered as well as a live example of exporting Creo BOM data to Excel Tables (via Nitro-BOM) and Manipulating them with Power Query to automatically summarize costs.

 

We hope you find this webinar useful.

 

Intro to Excel Tables and Power Query for Creo Users!

 

This webinar presented by Elite Digital Enterprise and Simplified Logic to provide fundamentals training for Excel Tables and Excel Power Query for Creo User...
4 REPLIES 4
Highlighted

Re: Intro to Excel Tables and Power Query for Creo Users!

That's a good presentation! Thanks for sharing. I knew most of this stuff, but it's nice to get a refresher.

Highlighted

Re: Intro to Excel Tables and Power Query for Creo Users!

Thanks for that feedback!

 

We have seen enough people "nodding heads" -- trying to run off and figure it out... and getting stuck (not willing to acknowledge they are stuck) when it comes to Excel alone.

 

So we figured a good basic introduction with some practical examples might be a good thing to help refresh and step forward into Excel functionality.

 

Thanks for the feedback!

 

Dave

Highlighted

Re: Intro to Excel Tables and Power Query for Creo Users!

Thank you very much for this presentation, I did not know anything about Power Query!!
 
My  little contribution to this excel post: you can do a dynamic range name using offset.
Highlighted

Re: Intro to Excel Tables and Power Query for Creo Users!

YES - Power Query is a very hidden capability compared to the rest of Excel...   So glad you got something out of that presentation.

 

And good thought on the offset.   We use "indirect" a lot for similar things - also powerful, but painful at the same time.

 

Dave

Announcements