Excel Basics

How to Set Scientific Notation to Powers of 3 in Excel (2 Methods)

Excel has the default format to set the scientific notation for 10 to the power of a number. But there are some more ways to set the scientific ...

How to Extend a Table in Excel (4 Methods)

Dataset Overview We'll use the below dataset with order ID, product, category, and amount to demonstrate the methods. Method 1 - Extend ...

How to Add Currency Symbols in Excel: 5 Easy Methods

Method 1 - Using Number Format Drop-down Applying Currency Format To add currency symbols in Excel using the Currency format, follow these steps: ...

How to Stop Showing Formulas in Excel (7 Quick Fixes)

Basically, formulas are an essential component of Excel, as they allow users to perform complex calculations and automate tasks. But, while sharing ...

How to Rotate Pie Chart in Excel (4 Useful Cases)

If you want to rotate Pie Chart in Excel, this article will be helpful for you. Here, we will walk you through 4 cases where you can rotate Pie ...

How to Enter Scientific Notation in Excel (4 Methods)

In this article, we’re going to show you 4 methods of how to enter scientific notation in Excel. We’ve taken a dataset containing 3 columns: Movie, ...

[Fixed!] ‘There Isn’t Enough Memory’ Error in Excel (8 Reasons)

Interpretation of the ‘There Isn’t Enough Memory’ Error Message There isn't enough memory to complete this action. Reduce the amount of data by ...

How to Rotate Text by 180 Degrees in Excel

Steps: In Tools, select Text in Insert. Click Text Box. Click and drag the box to place it in the sheet. Resize and move ...

How to Remove Decimals in Excel Formula Bar (3 Methods)

We have a simple dataset of numbers that have a decimal number in the formula bar, which we'll replace or display as an integer. Note: We used ...

Excel Phone Number Format Not Working (2 Possible Cases)

There are some built-in formats for phone numbers in Excel, so if you want to try other formats using the built-in formats, then, of course, it won’t ...

How to Display Power in Excel (6 ways)

In Excel, we can easily calculate the value of different power/exponent of different base values. But they are often not shown in the traditional ...

How to Write Vertically in Excel: 2 Methods

Method 1 - Using Orientation to Write Vertically in Excel We have a dataset that contains the book name and author of that book. We need to write ...

How to Rotate Text in an Excel Chart (2 Methods)

Scenario Here, we have an Excel chart of sales quantity containing months on the X-axis and the value of sales quantity on the Y-axis. Now we want ...

How to Write Phone Number in Excel (Every Possible Way)

Here's an overview of how phone numbers are usually displayed in Excel in two columns, in one column without any formatting and in another column ...

How to Show Value Instead of Formula in Excel (7 Methods)

We will consider the following dataset to demonstrate how to show value instead of formula in Excel. Method 1 - Using the Paste Values ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo