Computers & Software

Featured Articles

Windows 8

What’s New in Windows 8.1?

You've heard the buzz about Windows 8.1, but you're probably wondering what's really changed. Actually, there are quite a few changes between Windows 8 and Windows 8.1; following are eight of the most significant changes. [more…]

Windows 8

How to Install the Windows 8.1 Preview

Are you ready to try out the latest and greatest version of Windows? If so, the Windows 8.1 preview may be for you. You can download and install the Windows 8.1 preview on your PC by following these steps. [more…]

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…]

Excel 2016

Useful Microsoft Power Query Date Functions

The following table contains Excel date functions that help do things like add months, pull out date parts, and get the number of days within a given time period. [more…]