WeChat-Image_20220609143550

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

WeChat-Image_20220609143550

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

WeChat-Image_20220609143550

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