Excel Basics Archives - Page 22 of 176

How to Convert Accounting Format to Number Format in Excel?

Nov 11, 2025

When we work in Excel, some of the data are in Accounting format, and we may want it to display in number format. It’s quite easy, and Excel has ...

How to Convert Accounting Format to Number Format in Excel?

How to Convert Old Excel Files to New Format: 2 Quick Methods

Jul 5, 2024

Method 1 - Using Convert Option Steps: Go to the File tab from Ribbon. The following window will open in your worksheet. Select ...

How to Convert Old Excel Files to New Format: 2 Quick Methods

How to Create a Catalogue in Excel (with Easy Steps)

Aug 6, 2024

Step 1: Giving a Suitable Title to the Catalogue Open an Excel file and give a suitable title to the workbook. On the 2nd row of the ...

How to Create a Catalogue in Excel (with Easy Steps)

How to Draw Pictures in Excel (3 Easy Ways)

Nov 11, 2025

Drawing pictures or shapes can help an individual to enhance the appearance of his presentation. Excel offers various options to draw pictures or ...

How to Draw Pictures in Excel (3 Easy Ways)

Excel Options Dialog Box

Nov 11, 2025

Whenever you need to change some setting of Excel, the go-to place is the Excel Options dialog box. In short, this is where all the important ...

How to Calculate Mean Squared Error in Excel (3 Easy Methods)

Nov 11, 2025

In this article, I will show how to calculate Mean Squared Error in Microsoft Excel with quick steps and clear illustrations. In practical life, ...

How to Calculate Mean Squared Error in Excel (3 Easy Methods)

How to Create a Stopwatch in Excel (with Easy Steps)

May 31, 2024

Step 1 - Display Stopwatch Clock in Excel Select the desired cell range, e.g., B4:C4. Navigate to the Home Choose the Merge and Center ...

How to Create a Stopwatch in Excel (with Easy Steps)

How to Perform Custom Scaling in Excel (3 Easy Ways)

Nov 11, 2025

In this article, we will show you how you can perform custom scaling in Excel to control the print area. When it comes to printing an Excel ...

How to Perform Custom Scaling in Excel (3 Easy Ways)

How to Perform Page Scaling in Excel (4 Quick Tricks)

Nov 11, 2025

In this tutorial, I am going to show you 4 quick tricks on how to perform page scaling in Excel. You can quickly use these methods, especially in ...

How to Perform Page Scaling in Excel (4 Quick Tricks)

How to Draw a Mohr Circle in Excel (with Effective Steps)

Nov 11, 2025

Today, we will show how to draw a Mohr Circle in Excel. The Mohr’s Circle is a powerful engineering visualization tool. It is a sophisticated way to ...

How to Draw a Mohr Circle in Excel (with Effective Steps)

[Solved!] Excel Spin Button Not Working (2 Reasons with Solutions)

Nov 11, 2025

While using the spin button in Excel, users can choose a numerical value from a predetermined range. These buttons appear as scroll bars without the ...

[Solved!] Excel Spin Button Not Working (2 Reasons with Solutions)

[Solved!] Excel Scaling Issues (2 Easy Methods)

Aug 4, 2024

Method 1 - Change Scaling in Settings Steps: Go to the File tab from the Ribbon or press Ctrl + P. Select Print from the menu list, and the ...

[Solved!] Excel Scaling Issues (2 Easy Methods)

How to Create Data Dictionary in Excel (with Easy Steps)

Aug 4, 2024

If you want to create a data dictionary in Excel, you have come to the right place. Here, we will walk you through 3 easy steps to do the task ...

How to Create Data Dictionary in Excel (with Easy Steps)

How to Fix Excel to PDF Size Problem While Printing: 4 Methods

Jun 2, 2024

Method 1 - Utilize Print Option to Solve Excel to PDF Size Problem STEPS: Choose the intended sheet as the Active sheet. Go to the File tab. ...

How to Fix Excel to PDF Size Problem While Printing: 4 Methods

How to Make a Picture Catalog in Excel (with Easy Steps)

Aug 6, 2024

In this article, we will describe a step-by-step procedure to make a picture catalog in Excel. As an example, we'll make a picture catalog to provide ...