Here is the generic formula to get sum by month in Excel=SUMPRODUCT(sum_range,–( TEXT(date_range,”MMM”)=month_text)) Manytimes, we want to calculate some values by month. Like, how much sales was done in a perticular month. Well this can be done easily using pivot tables, but if you are trying to have a dynamic report than we can use a Read More
Category: Microsoft Office
How to Change Your User Photo in Office 365
This article describes how to change your user photo that’s displayed in Exchange Online in Office 365, Lync 2013, and Lync Web App. PROCEDURE To update your user photo in Exchange Online, Lync 2013, and Lync Web App, follow these steps: Sign in to Office 365 portal (http://portal.office.com) Click your user photo (or its placeholder) Read More
How to Batch Convert Word Documents to PDF Files
Method 1: Using a custom VBScript Microsoft Office has automation or scripting support. Using a VBScript, you can bulk convert Word documents to PDF. Here is a simple script I wrote to do the job: ‘Convert .doc or .docx to .pdf files via Send To menu Set fso = CreateObject(“Scripting.FileSystemObject”) For i= 0 To WScript.Arguments.Count Read More
How to Fix Outlook Opens Then Closes Immediately
If your Outlook 365 won’t open, and you already tried “Quick or Online Repair” from the Control Panel with no luck… See below for the solution. A lot of people have been having problems with Microsoft Outlook crashing with error 0xc0000005. The problem with Outlook crashing when trying to open it was caused by a Read More
How to use Excel VBA “Select Case”
Select Case statement Executes one of several groups of statements, depending on the value of an expression. Syntax Select Case testexpression[ Case expressionlist-n [ statements-n ]][ Case Else [ elsestatements ]]End Select The Select Case statement syntax has these parts: Part Description testexpression Required. Any numeric expression or string expression. expressionlist-n Required if a Case appears. Delimited list of one or more of the following forms: expression, expression to expression, Is comparison operator expression. The To keyword specifies a range of Read More
How to Check Excel if Cell Contains Partial Text
To check if a cell contains specific text, you can use the ISNUMBER and the SEARCH function in Excel. There’s no CONTAINS function in Excel. 1. To find the position of a substring in a text string, use the SEARCH function. = SEARCH(B2,A2) Explanation: “duck” found at position 10, “donkey” found at position 1, cell A4 does not Read More