Excel Basics

How to Apply Double Accounting Underline Format in Excel

The following image gives an overview of this Excel tutorial. On the right side of the image, you can see the outcome of the methods explained in ...

How to Color Scale Per Row with Conditional Formatting in Excel (2 Methods)

Dataset Overview We'll use the following Annual Profit Record for various companies to demonstrate these methods. In the Company column, there is a ...

How to Create a Number Sequence with Text in Excel (5 Methods)

Watch Video – Create a Number Sequence with Text in Excel   Method 1 – Using Excel TEXT and ROW Functions to Create a Number ...

[Fixed] Excel Column Numbers Instead of Letters (2 Solutions)

The article will demonstrate how to solve the issue of Excel columns being designated in numbers instead of letters. Excel displays column numbers as ...

How to Add a Title to a Table in Excel (with Simple Steps)

While making a dataset it is very important to make a title of the dataset. But sometimes it becomes critical when we have already made our dataset ...

How to Increment the Row Number in an Excel Formula – 6 Methods

The dataset shows Category and Item names. Method 1 - Adding 1 to Increment the Row Number in Excel Steps: Enter 1 in B5 and press ...

How to Sort Multiple Headings in Excel – 2 Methods

The dataset showcases Product Sales data. It has multiple headings.   Method 1 - Enabling the Filter Feature to Sort ...

Keep Row Headings in Excel When Scrolling Without Freeze (2 Ways)

We have selected a dataset with four columns detailing the Product, Brand, Model, and Price. The dataset has 24 rows of data. When scrolling down, ...

Subtotal Formula in Excel for Serial Number: 3 Suitable Methods

Method 1 - Use of SUBTOTAL Function for Serial Number Steps: Select Cell B5 and type the formula below. =SUBTOTAL(3,$C$5:C5) ...

How to Create a Number Sequence in Excel Without Dragging

Dragging is a quick and easy way to create a number sequence in Excel. But there are scenarios where you might want to create one without dragging ...

How to Group Checkboxes in Excel (3 Easy Ways)

Looking for ways to know how to group checkboxes in Excel? Usually, we use checkboxes to select or unselect an option in Excel. Here, you will find ...

How to Add Bullet Points to an Excel Text Box – 4 Methods

You have a list of four tasks. To add bullet points inside the text box: Method 1 - Add Bullet Points in Excel Text Box from Right-Click ...

The Excel Bullets and Numbering Feature is Grayed Out – Reason and Solution

The Bullets and Numbering feature is not usually available on the Ribbon. To enable it: Right-click the Home tab and select Customize the ...

How to Change Text Direction in Excel Chart (3 Easy Methods)

While working in Microsoft Excel with the sales-related worksheets, sometimes we need to change the text direction in an Excel chart. The chart shows ...

How to Create a Number Sequence in Excel Based on Criteria

  To demonstrate our methods, we have selected a dataset with 3 columns consisting of “Product,” “Brand,” and “Sequence.” The sequences will be ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo