(Google updated the name of its G Suite service to Google Workspace in October 2020 and added one new plan to its lineup. This article has been updated to include details of the new plan.) Both Microsoft and Google would like to be your one-stop shop for business productivity software. Their respective subscription offerings, Microsoft 365 and Google Workspace, tick Read More
Category: Microsoft Office
5 Ways to Export Outlook Calendar to Excel, Google, iPhone, iCal and iCloud
Export Outlook Calendar to Excel If you’re looking for a way to share your Outlook calendar with others, you can export your Outlook calendar to Excel, and then import it into others’ Outlook calendar folder by following these steps: Go to File> Open & Export > Import/Export. When Import and Export Wizard opens, under Choose an action to Read More
Reduce the Size of an Outlook Data File (.pst) or Offline Outlook Data File (.ost)
If you delete items from an Outlook Data File (.pst) or Offline Outlook Data File (.ost), Outlook automatically compacts the file in the background during idle time, when you’re not using your computer, but Outlook is still running. Note:Outlook only compacts the file if there is more than 20% of ‘white space’ (unused space) in the file. You Read More
How to Fix The WebEx Toolbar is Not Appearing in Microsoft Outlook
Solution: To resolve the issue: Ensure you have installed Productivity Tools on your computer. For help with downloading and installing Productivity Tools, see: Install and Set Up Webex Productivity Tools for Windows. Enable or activate the Webex Integration Add-in if it is disabled or inactive. To enable or activate the Webex Integration Add-in: Open Microsoft Outlook, click Read More
5 Reasons for Why You Should Use SUBTOTAL in Excel
SUBTOTAL formula is used to find out subtotal of a given range of cells. You give SUBTOTAL two things – (1) a range of data (2) type of subtotal. In return, SUBTOTAL will give you the subtotal for that data. Unlike SUM, AVERAGE, COUNT etc. which do one thing and only one thing, SUBTOTAL is versatile. Read More
How to Convert Number to Text or Reverse in Excel
You can use the VALUE function to return just the numeric value of the text. 1. Insert a new column Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column. 2. Use the VALUE function In one of Read More