Collaborate Disseminate
A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.
The post How to sync Microsoft Lists with Microsoft Excel appeared first on TechRepublic.
Continue reading How to sync Microsoft Lists with Microsoft Excel
There is no COUNTIF function in Microsoft Power BI. If you need to apply that logic, you’ll have to turn to other measures.
The post How to apply COUNTIF logic in Microsoft Power BI appeared first on TechRepublic.
Continue reading How to apply COUNTIF logic in Microsoft Power BI
Multiple daily records for calls into your call center can be reformatted as a single record for each caller.
The post How to return first and last times from timestamps in Microsoft Excel appeared first on TechRepublic.
Continue reading How to return first and last times from timestamps in Microsoft Excel
If you want a hyperlink to always work, use absolute and relative hyperlinks appropriately in a Microsoft Word document.
The post How to insert absolute and relative hyperlinks in a Microsoft Word document appeared first on TechRepublic.
Continue reading How to insert absolute and relative hyperlinks in a Microsoft Word document
The busier a Microsoft Excel workbook is the more ways you need to get around in it. Check out these shortcuts to help you move between sheets.
The post How to use hyperlinks to move quickly between sheets in Microsoft Excel appeared first on TechRepub… Continue reading How to use hyperlinks to move quickly between sheets in Microsoft Excel
Use hidden text to hide content you’d otherwise have to put in another Microsoft Word document.
The post How to use hidden text to make one document do the work of two in Microsoft Word appeared first on TechRepublic.
Continue reading How to use hidden text to make one document do the work of two in Microsoft Word
Microsoft Power BI uses measures the same way Microsoft Excel uses functions. Learn how to recognize them in use and how to manipulate them when you want something different.
The post How to manipulate implicit measures in Power BI Desktop appeared fi… Continue reading How to manipulate implicit measures in Power BI Desktop
You might know how to use Microsoft Flash Fill to create new content, but you might not know that you can use this feature to parse characters across several rows.
The post How to use Flash Fill to parse characters across multiple columns in Microsoft… Continue reading How to use Flash Fill to parse characters across multiple columns in Microsoft Excel
Page numbers serve an important function in your Microsoft Word documents, but they can be a bit boring. If you’d like to draw attention to page numbers, try adding color and graphics.
The post How to add a bit of pizazz to your page numbers in Micros… Continue reading How to add a bit of pizazz to your page numbers in Microsoft Word
Knowing how many days you’ve allotted to a project is important, but once you’re into the project, knowing how many days remain might be more important.
The post How to determine the number of remaining workdays for Microsoft Excel projects appeared f… Continue reading How to determine the number of remaining workdays for Microsoft Excel projects