Category: Power Pivot

5 Ways To Change Text Case In Excel

by John | Apr 30, 2019 | DAX, Functions, Power Pivot, Power Query, Tutorials | 0 |

Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot.

Read More

Summarizing Text Data With Pivot Tables

by John | Jan 13, 2019 | DAX, Pivot Tables, Power Pivot | 2 |

Learn how to summarize text data in the values area of a pivot table using the data model and DAX formulas.

Read More

Follow

Consulting

Newsletter

Excel Functions eBook

Microsoft MVP

Categories

Recent Posts

An Introduction to Microsoft Forms for Excel
Jun 10, 2019 | General
The Complete Guide to Rich Data Types in Excel
May 9, 2019 | General, Tutorials
6 New Functions in Excel 2019 and Office 365 You Must Learn
May 7, 2019 | Functions
5 Ways To Change Text Case In Excel
Apr 30, 2019 | DAX, Functions, Power Pivot, Power Query, Tutorials
Create A Thermometer Visual To Display Actual Versus Target
Apr 23, 2019 | Charts

Advertisement

Newsletter

Pin It on Pinterest