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.
Microsoft
Demonstration file: How to export a Microsoft Excel table to Microsoft SharePoint for easy collaboration
This is the demonstration file to accompany the article, How to export a Microsoft Excel table to Microsoft SharePoint for easy collaboration by Susan Harkins.
The post Demonstration file: How to export a Microsoft Excel table to Microsoft SharePoint for easy collaboration appeared first on TechRepublic.
How to execute a VBA sub procedure in Microsoft Excel
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.
How to hide rows and columns and use groups in a shared Microsoft Excel workbook
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 on TechRepublic.
Demonstration files: How to execute a VBA sub procedure in Microsoft Excel
This is the demonstration file to accompany the article, How to execute a VBA sub procedure in Microsoft Excel by Susan Harkins.
The post Demonstration files: How to execute a VBA sub procedure in Microsoft Excel appeared first on TechRepublic.
How to add a conditional font format using Replace in Microsoft Word
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.
How to create and populate a table in Microsoft Excel’s Power Query
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.
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.
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.
How to subscribe to a report in Microsoft Power BI
By subscribing, you can have every report you need to start the day in your Inbox.
The post How to subscribe to a report in Microsoft Power BI appeared first on TechRepublic.