Collaborate Disseminate
Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.
The post How to use the new TEXTSPLIT() function in Microsoft Excel appeared first on TechRepublic.
Continue reading How to use the new TEXTSPLIT() function in Microsoft Excel
Create this neat collage effect with one picture and a few line shapes.
The post How to create a faux picture collage in Microsoft PowerPoint appeared first on TechRepublic.
Continue reading How to create a faux picture collage in Microsoft PowerPoint
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.
The post How to work with a numeric range slicer in Microsoft Power BI appeared first on TechRepublic.
Continue reading How to work with a numeric range slicer in Microsoft Power BI
Creating a Microsoft SharePoint list from Microsoft Excel data is safer than sharing the entire Excel workbook.
The post How to export a Microsoft Excel table to Microsoft SharePoint for easy collaboration appeared first on TechRepublic.
Continue reading How to export a Microsoft Excel table to Microsoft SharePoint for easy collaboration
VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.
The post How to execute a VBA sub procedure in Microsoft Excel appeared first on TechRepublic.
Continue reading How to execute a VBA sub procedure 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.
The post How to hide rows and columns and use groups in a shared Microsoft Excel workbook appeared first o… Continue reading How to hide rows and columns and use groups in a shared Microsoft Excel workbook
Complex updates don’t have to be difficult if you use Replace in Microsoft Word.
The post How to add a conditional font format using Replace in Microsoft Word appeared first on TechRepublic.
Continue reading How to add a conditional font format using 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.
The post How to create and populate a table in Microsoft Excel’s Power Query appeared first on TechRepublic.
Continue reading How to create and populate a table in Microsoft Excel’s Power Query
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
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