Excel Basics

How to Insert Sigma Symbol in Excel (8 Easy Ways)

Sigma is the Greek alphabet's eighteenth letter. The lowercase letter sigma (σ) denotes the standard deviation in math and statistics. In math, the ...

How to Edit Text Box in Excel (2 Simple Ways)

In Microsoft Excel, we often use a Text Box for indicating certain instructions. It is a very handy tool with different types of elements. We can ...

How to Lock Font in Excel (with Other Cell Formatting)

In many situations, the main editor of an Excel workbook does not allow others to change the font, font size, fill color, etc. cell formatting in a ...

How to Randomize List of Names in Excel: 8 Easy Methods

Method 1 - Utilizing Sort Feature Steps: Select the entire dataset for which you want to do your task. We copied C5:C15 data in D5:D15. ...

How to Make Exponent in Excel Text (7 Easy Methods)

In this article, I will show how to make an exponent in Excel text by using 7 easy methods. You may need to do mathematical calculations when you ...

How to Use Excel Exponential Function of Base 10: 6 Examples

Method 1 - Use Exponential Function POWER of Base 10 Steps: Select a blank cell C5 where you want to keep the exponents. Use the formula ...

How to Use Negative Exponents in Excel – 3 Methods

In the following dataset, you can see the Base and Exponent columns. The Exponent column has negative exponents. Method 1 - Using Keyboard ...

How to Add Superscript in Excel (8 Easy Methods)

Suppose you are in a situation to add a superscript, a letter written just above the standard line, in your Excel data. But you don’t know how to do ...

How to Display Exponents in Excel: 7 Simple Methods

Method 1 - Using Superscript Effect To display exponents by applying the Superscript effect, follow the steps: Insert the values of Number and ...

How to Recalculate in Excel (2 Built-In Options + Bonus)

Recalculation means calculating the existing formula based on the change of data in Excel. When we input any formula in a cell of Excel, we get the ...

How to Type Exponential in Excel (6 Easy Ways)

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, ...

How to Remove Highlighted Rows in Excel?

When working with large data sets in Microsoft Excel, you may need to remove specific rows from the worksheet for security purposes. This article ...

How to Abbreviate Billions in Excel (6 Easy Methods)

When you have a large number as a cell value for monetary purposes, then you may need to abbreviate Billions in Excel. So, if you are looking for how ...

The Font Changes Automatically in Excel – 2 Solutions

This is the sample dataset. Solution 1 - Using the Format Cells Feature Steps: Select the whole dataset and right-click. Choose ...

How to Put Space in Text Box in Excel (2 Cases)

Method 1 - Changing Space Between Lines in an Excel Text Box ⏩ Steps: Click on the Text Box. Select the whole text of the box and ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo