Excel Basics

How to Take Log of Negative Numbers in Excel: 3 Ways

The logarithm function provides an imaginary number as a result for negative numbers and isn't defined for them in Excel. You'll need to go around ...

What to Do If CTRL C Is Not Working in Excel (8 Solutions)

4 Major Reasons Why CTRL C Might Not Be Working in Excel Hardware problem can create the issue. The keyboard can malfunction so that CTRL C ...

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)

To shift a row upwards using the Shift key and mouse, we first choose a row and then place it in the upper position. You will notice that the ...

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

Consider the following dataset containing a list of Ids, Products, and their corresponding Sales values. In the Product ID column and Product column, ...

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

Below is a dataset with information on a company's Customer Name, Product ID, and Price. We highlighted the cells with similar product ID numbers and ...

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

We'll use a simple dataset containing the product ID and corresponding profits of certain products to move rows to columns. Method 1 - ...

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

Method 1 - Combining INDEX and ROWS Functions to Reverse Data Create a second data table in your worksheet to see the result after reversing. ...

How to Reverse Rows in Excel (4 Easy Ways)

Method 1 - Transposing Rows to Columns, Then Reversing Columns to Rows Steps: Select the rows you want to reverse and copy it by pressing ...

How to Cut and Paste in Excel – 4 Methods

This is the sample dataset. To cut the Sales column and paste it into the next column:   Method 1 - Cut and Paste Using ...

How to Select Random Cells in Excel (5 Ways)

Consider a dataset of Salesmen of an organization and their respective Sales over a certain period of time. We want to select some random cells from ...

How to Calculate Root Mean Square Error in Excel

Introduction to the Root Mean Square Error (RMSE) The Root Mean Square Error (RMSE) calculates the amount of error between 2 datasets. It compares a ...

How to Update Links Without Opening File in Excel: 4 Methods

Method 1 - Using Edit Links Command to Update Links Without Opening File in Excel Steps: Go to the Data tab. Select the Edit Links option. ...

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

Suppose you have the following dataset: Method 1 - Combining INDEX and ROWS Functions to Flip Data Vertically in Excel Steps: Make ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo