About this course
This 1-day Excel Power Query training course. It's instructor-led, exercise based and very hands-on in nature with each delegate using one of our computers throughout the day.
Group sizes are always kept relatively small (less than 6 users per session) which allows for effective support from our trainers.
What you will learn
What Power Query and PowerPivot are
Identify where in the data analysis process Power Query sits
Import data from various sources
Restructure and transform data ready for output
Loading data to a Table Query, Create a Connection only and add to the Data Model
Recent reviews
Need to spend time working through notes and using with my own data.
I liked Serena's presentational style. She was very patient and explained things slowly and carefully. There was no racing at 100mph and I was able to keep up. Although I use Power Query in my role as NHS Data Analyst, I was looking to get more out of it. I…I liked Serena's presentational style. She was very patient and explained things slowly and carefully. There was no racing at 100mph and I was able to keep up. Although I use Power Query in my role as NHS Data Analyst, I was looking to get more out of it. I was impressed with how to create Age Groups based on someone's DOB.Read more
Enjoyed the course and feel I have a better understanding of the capabilities of Power Query.