Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 More… The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF(Something is True, then do something, otherwise do something Read More
Month: July 2020
2 Ways to Sum by Month in Excel
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
Azure Blob Storage vs File Storage
Microsoft offers several options to store data on the cloud. Each option has its unique purpose for serving different business needs. One of the significant capabilities that Microsoft Azure provides is the agility to migrate to different storage options if required. There are various options available in the Azure Storage Account for storing user data. Blob Storage Read More
How To Enable C$ Share in Windows 10
How To Enable Remote Access To Administrative Shares in Windows 10 Step 1 On the computer you are having trouble connecting to, search for the Windows setting for: “Manage Advanced Sharing Settings” and make sure that “Turn on file and printer sharing” is selected for your Domain network. Doing this will automatically enable the necessary Windows firewall rules to enable Read More
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 Use Built-in Screen Recorder in Windows 10
When you need to take a screenshot, you can just hit Print Screen, or use Windows 10’s Snipping Tool. But what about if you want to record a video of your desktop? It might surprise you to learn that Windows 10 has a screen recording tool built-in. For some reason, Microsoft has chosen not to Read More