Skip to main content
D
DavidBigelow17-Peridot
17-Peridot
April 20, 2020
Question

Intro to Excel Tables and Power Query for Creo Users!

  • April 20, 2020
  • 1 reply
  • 2095 views

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!

 

    1 reply

    P
    Pettersson15-Moonstone
    15-Moonstone
    April 23, 2020

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

      D
      DavidBigelow17-PeridotAuthor
      17-Peridot
      April 23, 2020

      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

      T
      Trebla16-Pearl
      16-Pearl
      April 24, 2020
      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.
        Terms & ConditionsAccessibility statement