Excel Basics

How to Convert Currencies in Excel (7 Methods)

We have some currencies in USD. We'll convert them to Euro and GBP. ⏷Simple Arithmetic Formula for Currency Conversion ⏷Currency ...

How to Restore the Toolbar in Excel (3 Quick Methods)

  Method 1 - Use the Ribbon Display Option Steps: Go to the top-right corner of the sheet. Click on Ribbon Display Options. We ...

How to Auto Backup Excel File: 2 Easy Methods

Method 1 - Use Excel’s General Options to Auto Backup an Excel File Step 1: Create an Auto Backup File Click the File tab. Select Save ...

How to Convert Minutes to Decimal values in Excel – 3 Methods

The sample dataset is in Time Format. To convert time into minutes and then to decimal format: Method 1 - Using a Simple Multiplication to ...

Currency Conversion Using VLOOKUP in Excel (2 Suitable Examples)

As of now, Excel doesn’t have any built-in currency conversion tool yet. So we either need at least a basic multiplication formula or other formulas ...

How to Recover Corrupted Excel Files from USB (4 Quick Methods)

Due to either physical or logical corruption, an Excel file may be corrupted. In this article, you will learn 4 quick methods to recover corrupted ...

How to Fill Blank Cells with Text in Excel (3 Methods)

Dataset Overview Let’s start with our sample dataset, which contains several blank cells. Our objective is to fill these blank cells with text. ...

How to Change Decimals to Percentages in Excel (4 Easy Ways)

If you want to change decimals to percentages in Excel, this article will be helpful to you. Here, we will walk you through 4 easy and effective ...

How to Stop Excel from Rounding Large Numbers (3 Methods)

In this article, we will learn to stop Excel from rounding large numbers. Whenever we type large numbers in cells, Excel rounds it off. Sometimes, it ...

How to Make a Cell Read-Only in Excel – 2 Methods

This is the sample dataset. Method 1 - Making a Cell Read-Only by Using the 'Format Cells' Command STEPS: Go to the file location ...

Excel Not Responding When Deleting Rows: 4 Solutions

Method 1 - Sort Data before Deleting Steps: Add Index to observe the Sort effect. Go to Data and select Sort. In the Sort by ...

[Fixed!] This Excel Workbook Was Opened in Read-Only Mode

Method 1 - Enabled Read-Only Attribute Makes Excel Workbook Open in Read-Only Mode STEPS: Select the Excel file and right-click your mouse. ...

How to Restore Ribbon in Excel (5 Quick Ways)

You may find your Excel ribbon hidden for several reasons. In this article, you will learn 5 quick methods to restore your ribbon back in Excel with ...

How to Change Default Currency in Excel (4 Simple Methods)

The following Employee List contains ID, Name and Salary columns. We can see in the Salary column that there is a dollar sign ($). This dollar sign ...

How to Turn Off Flash Fill in Excel (2 Easy Methods)

When Excel recognizes a pattern or sequential value, it suggests filling in the data to make our job easier. When the Flash Fill functionality is ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo