Fresh Tutorials
updated April 18, 2019
Posted April 16, 2019 by

How to Divide in Excel: Division Formulas and Shortcuts

There are many different methods to divide in excel. Some of them require a lot of time and manual labor, whereas others are more to simple to follow.

Continue Reading

Category Microsoft Excel

Posted April 13, 2019 by

How to Stop People from Adding you to Whatsapp Groups

Are you tired of leaving Whatsapp groups that you never wanted to be a part of, to begin with?

Lately, I’ve been the victim of a serious Whatsapp breach. Getting notifications from strange Whatsapp groups, with people spurting nonsense that I have no interest in has left me infuriated and frustrated beyond measure.

Continue Reading

Category WhatsApp

Posted April 11, 2019 by

SELECT vs SET For Variable Assignment In SQL Server

SELECT vs SET For Variable Assignment In SQL Server

Using SELECT and SET statement for variable assignments is a common practice in SQL Server. I did not pay more attention to SELECT vs SET difference, until I met with surprising logical errors. In production code using SELECT over SET, produced unanticipated results. Both are used interchangeably for variable assignment. Importantly, understanding when to use SELECT over SET and vice versa. Continue Reading

Category Database, SQL Server

Posted April 11, 2019 by

How to Multiply in Excel — 4 Easy Solutions

You can use many different methods to multiply in excel. They are quite similar to the protocols used for subtraction, addition, and division. Each has its own use. Some are suitable for multiplying within single cells, whereas others are used for multiplying an entire range or column of cells.

Continue Reading

Category Microsoft Excel

Posted April 7, 2019 by

How to Remove Duplicates in Excel

When you’re working with massive piles of data or dealing with an aggregation of spreadsheets, identifying and removing duplicate rows can turn into back-breaking manual labor. However, with the right knowledge and tools, you can automate this process in excel.

Continue Reading

Category Microsoft Excel

Posted April 5, 2019 by

How to Subtract in Excel — Basic Excel Guide

There are many different methods you can use to subtract in Excel. All of them have their own use. Some are perfect for performing subtraction within cells, while others are more suitable for subtracting an entire range of cells.

Continue Reading

Category Microsoft Excel

Posted April 3, 2019 by

How to Add Drop Down List in Excel – Data Validation Lists

A drop-down list in Excel can limit and regulate the number of entries in a single cell. You can use it to better organize your spreadsheet by containing the length of its data.

In my opinion, learning how to add drop down list in Excel is essential if you want to save valuable time and enhance productivity. This is why every Job position for an Excel expert requires you to know this little gimmick.

Continue Reading

Category Microsoft Excel

Posted April 1, 2019 by

How to Add in Excel – Master The Basics of Excel

microsoft excel

There are many ways of adding two or more numbers in excel.

You will have to get familiar with crafting formulas, which isn’t that complex. Learning how to construct formulae will not only teach you how to add in excel but also multiply, divide and subtract. In this tutorial, however, our main focus will be on adding two or more numbers.

Continue Reading

Category Microsoft Excel

Posted March 31, 2019 by

How To Schedule SQL Agent Job Using T-SQL Script

How To Schedule SQL Agent Job Using T-SQL Script

SQL Server agent job is a windows service based scheduler. Agent job is used to schedule and automate SQL scripts, administrative tasks, SSIS packages and various other tasks using SQL agent job tool. This component is integrated along with SSMS and available under Object explorer as SQL Server Agent. Continue Reading

Category Database, SQL Server

Posted March 28, 2019 by

How to Remove Followers on Instagram — The Easiest Way

Source: Katka on Unsplash

Some Instagram users hasten to get Instagram followers without weighing in the implications. What this unthinkable drive to earn “quick fame” does is drive stalkers, bots, and strangers. They add no value whatsoever to your Instagram account and only serve the purpose of increasing “hollow statistics”.

Continue Reading

Category Instagram

Posted March 26, 2019 by

How to Add Video to PowerPoint Presentation – Simplest Method

There’s a reason why people drone and yawn over powerpoint presentations. Who likes sitting for hours on end,  his gaze fixated on bland text? We live in an age where video content has taken over the world by storm. And for good reason, too. It’s interesting, it’s direct and doesn’t drain attention spans.

Continue Reading