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

The Complete Guide To Slicers And Timelines In Microsoft Excel
Aug 12, 2019 | Pivot Tables, Tutorials
7 Ways To Find And Remove Duplicate Values In Microsoft Excel
Jul 13, 2019 | General, Tutorials
The Complete Guide To Microsoft PowerApps
Jul 5, 2019 | PowerApps, Tutorials
Everything You Need To Know About Flash Fill In Microsoft Excel [15 Examples]
Jun 24, 2019 | General, Tutorials
An Introduction to Microsoft Forms for Excel
Jun 10, 2019 | General

Advertisement

Newsletter

Pin It on Pinterest