As the admin, you may have company requirements to allow some users access to another user’s mailbox. For example, you may want to enable an assistant to send or read email from their manager’s mailbox, or one of your user’s the ability to send email on behalf of another user. This topic shows you how Read More
Category: Microsoft Office
Add or Subtract Time in Excel
Add or subtract time Let’s say that you need to add two different time values together to get a total. Or, you need to subtract a one-time value from another to get the total time spent working on a project. As you’ll see in the sections below, Excel makes it easy to add or subtract time. Read More
Understand Excel File Types, XLSX, XLSM, XLSB, and More.
When you save an Excel workbook for the first time or use the “Save As” function, you are asked for a folder, file name as well as the file type. By default, Excel suggests the XLSX file type (unless your file doesn’t have VBA macros). The window looks similar to the screenshot on the right Read More
Excel VBA, How to Delete Entire Row if Contains Certain Text
Question I’ve searched on here, but every code I put in gives me an error back. Data in column D, If any of the cells contain “Record Only” I need it to delete the entire row. Solution
How to Enable External Forwarding in Microsoft 365
When setting up forwarding from Microsoft 365 (formerly referred to as Office 365) to Help Scout, you may need to take an additional step to complete the process. Some Microsoft 365 accounts default to block automatic email forwarding as part of their outbound spam protection. If external forwarding is disabled for your Microsoft 365 account, Read More
How to Merge Columns to Create a New Column in Power Query (Power BI and Excel)
Merge columns (Power Query) Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 In Power Query, you can merge two or more columns in your query. You can merge columns to replace them with one merged column, or create a new merged column alongside the columns that are merged. You can only merge columns of a Text data Read More