The easiest way for any business to get started with Analytics and to get more value from your data is by using the most popular analytics tool of all time, Excel. When you include Power Query, you double your Excel powers.
Get an overview of the features within to Power Query to save time, automate repetitive tasks and incorporate more and different data in your Excel reports and pivot tables.
- Get data from text files and the web
- Append data in separate files from the same source
- Get data from multiple files in a folder
- Choose and remove Columns and Rows
- Remove Duplicate records
- Split Columns on delimiters
- Pivot and Unpivot
- and more
Available via webinar, locally in Broomfield, or onsite at your place of business in the Denver, Boulder and Fort Collins areas.
Classes are scheduled periodically. For information on when the next scheduled class will be delivered, send an email to firstname.lastname@example.org.
Free Excel Power Query online training resources
For other learners, self paced online content works well. Here are some links to good online resources: