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 | 5 |

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

5 Easy Ways To Create A Data Entry Form In Excel
Dec 24, 2019 | Tutorials
9 Ways to Delete Blank Rows in Excel
Dec 20, 2019 | Tutorials
7 Ways To Get The Weekday Name From A Date In Excel
Nov 13, 2019 | Tutorials
Everything You Need To Know About XLOOKUP
Sep 24, 2019 | Functions
The Complete Guide To Slicers And Timelines In Microsoft Excel
Aug 12, 2019 | Pivot Tables, Tutorials

Advertisement

Newsletter

Pin It on Pinterest