How to create a calculated table of top values in Microsoft Power BI

Calculated tables are helpful tools when you want to add calculated values to the model instead of calculating them on the fly.
The post How to create a calculated table of top values in Microsoft Power BI appeared first on TechRepublic.
Continue reading How to create a calculated table of top values in Microsoft Power BI

How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.
The post How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata appeared first on TechRepublic.
Continue reading How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata

How to use the new TEXTAFTER() and TEXTBEFORE() functions in Microsoft Excel

Microsoft Excel’s new text functions make working with strings a breeze.
The post How to use the new TEXTAFTER() and TEXTBEFORE() functions in Microsoft Excel appeared first on TechRepublic.
Continue reading How to use the new TEXTAFTER() and TEXTBEFORE() functions in Microsoft Excel

How to change formats using Replace or by modifying a style in Microsoft Word

When faced with a massive reformatting task, try the replace feature or modify a style before going the manual route in Microsoft Word.
The post How to change formats using Replace or by modifying a style in Microsoft Word appeared first on TechRepublic.
Continue reading How to change formats using Replace or by modifying a style in Microsoft Word

How to add action buttons to a report in Microsoft Power BI

Using buttons allows you to quickly and easily navigate between pages in Microsoft Power BI reports. Here’s how.
The post How to add action buttons to a report in Microsoft Power BI appeared first on TechRepublic.
Continue reading How to add action buttons to a report in Microsoft Power BI

How to tone down a busy picture using Merge in Microsoft PowerPoint

Too many pictures in a presentation can be overwhelming. Here’s how to turn a busy picture into a focused visual using Merge in PowerPoint.
The post How to tone down a busy picture using Merge in Microsoft PowerPoint appeared first on TechRepublic.
Continue reading How to tone down a busy picture using Merge in Microsoft PowerPoint