Excel Basics

Macro has been an essential part of Excel since its early days. It automates repetitive tasks by recording and executing specific … Read more

Imagine you are working with an Excel file where you need to scroll down and suddenly you cannot scroll through your … Read more

If you have used Excel for quite some time you would be familiar with the function keys. These are very convenient … Read more

If you have worked with Excel for a while you would know by now some of the shortcuts to do your … Read more

If you have been working in Excel for a while, you will come across a time when you will face intentional … Read more

Working with Excel means dealing with data. As part of your job, you get raw and messy data from different sources. … Read more

One of the most common problems that you may face with Excel is when you open a file in Excel, It … Read more

Say you are working on a project and want to adjust the project schedule. But you want to add 6 months … Read more

Combining multiple strings in Excel is a part of the job for any Excel user. The CONCATENATE function is there to … Read more

Often may come a time, when you are trying to figure out what time it will be after certain hours. You … Read more

We use Excel to work with a lot of numbers. So often we may need to change some negative numbers to … Read more

In everyday situations, casual Excel users write numbers manually in the cells when they need to create random four-digit numbers. It … Read more