Category: Power Pivot

5 Ways to Get the Current Date or Time in Excel

by John | Apr 14, 2020 | DAX, Functions, Power Automate, Power Pivot, Power Query, Shortcuts, Tutorials | 1 |

Learn 5 different ways to add the current date or time into Excel with keyboard shortcuts, functions, power query, power pivot and power automate.

Read More

5 Ways To Change Text Case In Excel

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

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

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

Read More

Subscribe

Consulting

Newsletter

Excel Insights

Excel Functions eBook

Microsoft MVP

Categories

Recent Posts

6 Ways to Add Strikethrough Format in Excel
May 17, 2021 | Tutorials
4 Ways to Wrap Text in Excel
Mar 5, 2021 | Tutorials
3 Ways to Transpose Data in Excel
Feb 14, 2021 | Tutorials
8 Ways to Split Text by Delimiter in Excel
Dec 28, 2020 | Tutorials
9 Ways to Copy and Paste as Values in Excel
Dec 25, 2020 | Tutorials

Advertisement

Newsletter

Pin It on Pinterest