Collaborate Disseminate
Learn a seemingly tricky way to extract data from your Microsoft Excel spreadsheet.
The post How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel appeared first on TechRepublic.
Continue reading How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel
Adding headers and footers to a Microsoft Word document is easy, even if you have a mix of header needs. Susan Harkins will show you how.
The post How to make different headers and footers in Word appeared first on TechRepublic.
Continue reading How to make different headers and footers in Word
Wouldn’t it be grand to have your Microsoft Outlook calendar in plain sight? Well, you can, and it’s easier than you might think.
The post How to pin a calendar to your desktop in Outlook appeared first on TechRepublic.
Continue reading How to pin a calendar to your desktop in Outlook
Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.
The post 4 quick and easy ways to convert numbers stored as text to real numbers… Continue reading 4 quick and easy ways to convert numbers stored as text to real numbers in Excel
To add a little fun to a Microsoft PowerPoint slide, combine a few animations to a star shape to create a flashing star.
The post How to add a flashing star to a PowerPoint slide appeared first on TechRepublic.
Continue reading How to add a flashing star to a PowerPoint slide
This simple procedure can save you a lot of time when you’re finished with your work. Susan Harkins tells you how.
The post How to create a VBA procedure that closes all open workbooks in Excel appeared first on TechRepublic.
Continue reading How to create a VBA procedure that closes all open workbooks in Excel
If simple but consistent formatting across Excel, Word, PowerPoint and Outlook are important to your organization, consider designing custom themes that all the apps will use. Susan Harkins tells you how.
The post How to create and use the same Office … Continue reading How to create and use the same Office themes across files in Microsoft 365
If you have tables in your Word document, these procedures will help you make them look nice. Susan Harkins will show you how to jazz them up.
The post How to use a style or VBA to assign just the look you want for all tables in Word appeared first on … Continue reading How to use a style or VBA to assign just the look you want for all tables in Word
If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.
The post How to open and populate an Outlook appointment from inside Excel using VBA appeared first on TechRepublic.
Continue reading How to open and populate an Outlook appointment from inside Excel using VBA
A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.
The post How to use conditional formatting to compare values from row to row, or not, in Excel appeared … Continue reading How to use conditional formatting to compare values from row to row, or not, in Excel