How to Turn on Autosave in Word [Easy Step by Step Tutorial]

CASE statement, an expression to evaluate different conditions to return a scalar value, when a condition is met. If none of the condition evaluated to TRUE then expression from ELSE block will be returned. Although ELSE block is optional. Above all, the CASE statement have two formats Simple CASE & Searched CASE. Continue Reading

The stacks of white rows can dull your senses. Shading every other row in Excel can produce a wonderful contrast between these white rows and brighten your Excel experience. Continue Reading

Lost a Facebook post you recently liked? Or do you want to change the privacy of a recently shared status update? Learning how to see your recent activity on Facebook can help resolve these issues. Continue Reading

To overcome the rising popularity of short-clip sharing video platforms like Tik Tok, Instagram has released an update to its music stickers. You can now add-on screen lyrics to your Instagram music stickers, and let your followers sing along to your favorite hits. Continue Reading

Most people prefer working on the smooth interface of Google Sheets. It’s interactive and easily shareable with other users. Because of this users often feel the need to import their Excel files to Google Sheets and work on them there. In this tutorial, we will teach you how to convert your Excel spreadsheets to Google Sheets so that you can follow in their footsteps.

Continue Reading

Sometimes, we need to pause the execution of a query to simulate different scenarios. Waiting for a desired amount of time or executing it at a specified clock time. Helpful to pause a query, batch or a stored procedure. WAITFOR statement can be used for delaying a query or execute a query at a specified time. Continue Reading

Every few years Facebook makes you relearn how to deactivate your facebook account. Continue Reading

Word documents received after extensive treatment from an editor are riddled with track changes and markup areas. Learning how to hide comments in word enables you to restore the integrity of the document, making it squeaky clean. You can either delete all the comments in one go or remove them individually. In this tech-recipe, we’re going to show you how to do both. Continue Reading

Unlike other previous Microsoft operating systems, Windows 10 comes with in-built auto updates that enable the computers to work efficiently. This version of Windows is a data monster, especially if you are tethering with limited bandwidth. But you don’t have to worry about running out of your data plans anymore. Our step by step guide will help you learn how to stop Windows 10 from eating up your data bundles while browsing or enjoying online games on your laptop. Although Windows 10 auto updates play a significant role in data consumption on your computer, applications are also highly involved. Thus, it is essential to understand the amount of data each app on your laptop is using.

Continue Reading

SQL Server supports ANSI SET operators. Including UNION, UNION ALL, EXCEPT and INTERSECT. Generally, SET operators used to combine multiple query result sets into a single result set. In an early post on tech-recipes, we have learned the use of UNION and UNION ALL operators. Continue Reading

To calculate CAGR in Excel, there’s no preset Excel function. However, there’s an easy method with which you can input a custom Excel formula and calculate it. Continue Reading