Excel Basics

How to Take Log of Negative Numbers in Excel

If you are looking for how to take log of negative numbers in Excel, then you are in the right place. The logarithmic function is a basic function in ...

[Fixed!] CTRL C Not Working in Excel

CTRL + C  or CTRL C, a widely used keyboard shortcut, is utilized for copying text or anything to the clipboard. Later, you can paste the copied ...

How to Update Excel Links (Manually/Automatically)

We'll use the following datasets to demonstrate how you can update links inside and between sheets. ⏷Update Links Automatically ⏷Update ...

How to Create Tabs Within Tabs in Excel (With Simple Steps)

  Watch Video – Create Tabs Within Tabs in Excel Steps to Create Tabs Within Tabs in Excel In this tutorial, we will create ...

How to Move Up and Down in Excel (5 Easy Ways)

Moving up and down in Excel is essential for efficient data review, analysis, and entry. This functionality allows for easy navigation to specific ...

How to Skip to Next Cell If a Cell Is Blank in Excel (5 Easy Ways)

If you are looking for ways to skip to the next cell if a cell is blank in Excel, then this article will serve this purpose. So, let’s start with the ...

How to Select Highlighted Cells in Excel (4 Easy Techniques)

An organized and neat presentation is always a priority especially when we work with a large dataset. This is why most Excel users prefer to ...

How to Move Every Other Row to Column in Excel (6 Ways)

Sometimes we need to move every odd or even row to other cells in the worksheets. Obviously, it can be done manually. But if the worksheet size is ...

How to Reverse Data in Excel Cell (5 Easy Ways)

While working in Excel, users may have to reverse the data in the worksheet’s cells for working purposes. But there are no integrated options in ...

How to Reverse Rows in Excel (4 Easy Ways)

Surprisingly, you may not find any inbuilt option to reverse a set of data in rows in Excel. It needs to be done manually. These are all the methods ...

How to Cut and Paste in Excel (4 Quick Ways)

This article illustrates how to cut and paste in Excel. Cut and Paste is one of the most used features in Excel. You can use this feature to move ...

How to Select Random Cells in Excel (5 Ways)

Sometimes you may need to select some random cells and show them in your Excel workbook. If you are searching for a way to select random cells in ...

How to Calculate Root Mean Square Error in Excel

When comparing two data sets, we employ root mean square error in a variety of applications. Moreover, the root mean square error is one of the most ...

How to Update Links Without Opening File in Excel (4 Methods)

If you are looking for special tricks to learn how to update Excel links without opening file, you've come to the right place. There are four tricky ...

How to Flip Data Vertically in Excel (4 Quick Methods)

The article will show you how to flip data vertically in Excel. If a user wants to reverse his data so that the data are stored from bottom to top in ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo