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

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

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

Read More

Abu

Subscribe

Consulting

Newsletter

Excel Insights

Excel Functions eBook

Microsoft MVP

Categories

Recent Posts

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
8 Ways to Extract the Month Name from a Date in Excel
Dec 6, 2020 | Tutorials
7 Ways to Extract the First or Last N Characters in Excel
Oct 4, 2020 | Tutorials
3 Ways to Calculate a Pearson’s Correlation Coefficient in Excel
Aug 23, 2020 | Statistics, Tutorials

Advertisement

Newsletter

Pin It on Pinterest