Collaborate Disseminate
Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.
The post How to shorten references using the hashtag symbol in Microsoft Excel appeared first on… Continue reading How to shorten references using the hashtag symbol in Microsoft Excel
Leaders offer a visual guide to information separated between the left and right margins of a document. Learn how to add them and how to avoid potential problems.
The post How to add leaders to a document in Microsoft Word appeared first on TechRepublic.
Continue reading How to add leaders to a document in Microsoft Word
Use a video to add a bit of movement behind your text in a Microsoft PowerPoint slide.
The post How to use a video as a slide’s background in Microsoft PowerPoint appeared first on TechRepublic.
Continue reading How to use a video as a slide’s background in Microsoft PowerPoint
Averaging is easy until you want to dynamically average the last few years on the fly. There are at least two easy ways to accommodate the n requirement.
The post How to return monthly sales averages for the last n years in Microsoft Excel appeared fi… Continue reading How to return monthly sales averages for the last n years in Microsoft Excel
If your list and dropdown are on different pages, you’ll need to know this trick to make the dropdown dynamic.
The post How to populate a dropdown with data from another sheet in Excel appeared first on TechRepublic.
Continue reading How to populate a dropdown with data from another sheet in Excel
This VBA macro generates a list of Microsoft Word styles that are custom, built-in or both.
The post How to use VBA to document custom styles in a Microsoft Word document appeared first on TechRepublic.
Continue reading How to use VBA to document custom styles in a Microsoft Word document
If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.
The post How to find missing records using VLOOKUP() in Microsoft Exc… Continue reading How to find missing records using VLOOKUP() in Microsoft Excel
Timelines provide an easy way for viewers to quickly filter Microsoft Excel data in a meaningful way.
The post How to use a timeline to filter multiple PivotCharts in Microsoft Excel appeared first on TechRepublic.
Continue reading How to use a timeline to filter multiple PivotCharts in Microsoft Excel
Lots of email will slow down Microsoft Outlook’s performance. Part of a regular maintenance routine should include deleting large emails that you no longer need.
The post How to free up space by deleting large email messages in Microsoft Outlook appea… Continue reading How to free up space by deleting large email messages in Microsoft Outlook
Microsoft Power Automate helps you automate repetitive tasks without code.
The post How to use Microsoft Power Automate to convert bulk Word files to PDF appeared first on TechRepublic.
Continue reading How to use Microsoft Power Automate to convert bulk Word files to PDF