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

Follow

Consulting

Newsletter

Excel Insights

Excel Functions eBook

Microsoft MVP

Categories

Recent Posts

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
9 Ways To Add Leading Zeros In Excel
May 14, 2020 | Tutorials
25 Awesome Microsoft Teams Tips and Tricks
May 4, 2020 | Teams
5 Ways to Convert Excel Files to PDF
Apr 19, 2020 | Tutorials

Advertisement

Newsletter

Pin It on Pinterest