Adding a numeric range slicer to a Microsoft Power BI report is easy, but users will need a bit of training to get the most out of it.
Creating a Microsoft SharePoint list from Microsoft Excel data is safer than sharing the entire Excel workbook.
VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.
Microsoft Excel’s sheet view collaboration feature has been around for a while, but now it supports hiding rows and columns and applying groups.
Complex updates don’t have to be difficult if you use Replace in Microsoft Word.
You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.
Calculated tables are helpful tools when you want to add calculated values to the model instead of calculating them on the fly.
If you need a complete list of Microsoft Excel sheet names, Power Query is fast and generates a dynamic list.
By subscribing, you can have every report you need to start the day in your Inbox.
Microsoft Excel’s new text functions make working with strings a breeze.
When faced with a massive reformatting task, try the replace feature or modify a style before going the manual route in Microsoft Word.
Using buttons allows you to quickly and easily navigate between pages in Microsoft Power BI reports. Here’s how.
