Excel Basics

### How to Create an Attendance Roster in Excel (with Easy Steps)

In this article, I will show you how to create an attendance roster in Excel. As we know, Excel is a very handy tool for keeping track of employeesâ€™ ...

### How to Create Weekly Duty Roster Format in Excel

Microsoft Excel is a powerful software. We use Excel functions for our educational, business, and daily staff duty roster management. It is important ...

### Using Spin Button to Increment Decimal in Excel (2 Easy Ways)

While working in Excel, we often use the Spin Button to quickly change the values of a cell. But, the minimum increment value of the Spin button is ...

### How to Build Lottery Prediction Algorithm in Excel (With Easy Steps)

In this article, we will learn how to build a lottery prediction algorithm in Excel. In Excel, we can easily predict a lottery number by creating an ...

### How to Convert Accounting Format to Number Format in Excel?

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 Old Excel Files to New Format (2 Quick Ways)

While working in Excel, we often need to deal with Excel files in an old format. As a result, we encountered a number of compatibility issues. To ...

### How to Make Catalogue in Excel (with Easy Steps)

In this article, I will show you how to make a catalogue in Excel. As we know, a catalogue is a collection of items, organized systematically to make ...

### How to Draw Pictures in Excel (3 Easy Ways)

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 Display Excel Options Dialog Box (3 Suitable Ways)

You can use the Excel Options dialogue box to tailor the Excel IDE to a particular data collection. This article will examine three simple methods ...

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

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 Create a Stopwatch in Excel (with Easy Steps)

Microsoft Excel is one of the most useful applications available, and we can utilize a dataset unlimitedly using Excel's features and tools. In this ...

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

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 Page Scaling in Excel (4 Quick Tricks)

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 Draw a Mohr Circle in Excel (with Effective Steps)

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 ...

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

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 ...

Advanced Excel Exercises with Solutions PDF