Microsoft Office

Most Recent

Excel 2016 For Dummies Extras

10 Resources for Power Pivot and Power Query Help

If this is your first exposure to Power Pivot and Power Query, you're probably a bit overwhelmed by all the features and options available. That's normal. No one is going to become a Power BI expert in [more…]

Excel 2016 For Dummies Extras

Sample Files for Excel Power Pivot & Power Query For Dummies

Click here to download the sample files for Excel PowerPivot & Power Query For Dummies. These files contain all of the sample files from the book. Use them to work through the book's examples. [more…]

Excel 2016 For Dummies Extras

Use Power Query and Power Pivot Together for Better Reporting Models

Using Power Pivot and Power Query together can help you create reporting models that are easy to manage and maintain. A reporting model provides the foundation on which the reporting mechanism is built [more…]

Excel 2016

Useful Microsoft Power Query Text Functions

The Microsoft Power Query functions in the table that follows are helpful text functions to know. You can use them to clean and manipulate textual strings. [more…]