Latest Blog Posts

Excel Status Bar Not Showing Sum (2 Possible Solutions)

By default, in Excel, when the user selects a range of numbers, the count, sum, and average value of the selection are shown in the status bar on the ...

How to Count Checkboxes in Excel (3 Easy Methods)

We'll use the following data set, which contains 3 columns (Name, ID, and Attendance) to count the checkboxes. Method 1 - Using Properties ...

How to Make a 100% Stacked Column Chart in Excel

What Is a 100% Stacked Column Chart? If you want to compare parts of a whole, then a 100% Stacked Column chart is the way to go. This type of chart ...

How to Change Font Size of Data Labels in Excel

This tutorial will demonstrate how to change the font size of data labels in Excel charts using 2 different examples. Example 1 - Changing the ...

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 Display Variance in an Excel Bar Chart (Easy Steps)

Dataset Overview In the following dataset, I have an annual profit record. In the record, I have some annual profit amounts against their ...

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

Excel VBA to Convert Textbox Value to Number (2 Ideal Examples)

How to Add a Textbox in Excel STEPS: Go to the Developer tab and select the Insert icon. A drop-down menu will appear. Select the Text Box ...

How to Make a Bar Graph Comparing Two Sets of Data in Excel (4 Ways)

  Watch Video – Make a Bar Graph Comparing Two Sets of Data In the dataset, we have the profit amount of some products in the ...

[Fixed] Excel Pie Chart Leader Lines Not Showing

Excel Pie Chart Leader Lines Not Showing: Solution in 3 Steps We have the number of students in different classes in a school. Step 1 - ...

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

How to Add a Trendline to a Stacked Bar Chart in Excel (2 Methods)

Dataset Overview We'll use the following dataset that contains the sales data of three shops for the first six months of the year: Method ...

[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 Convert a 4 Digit Number to Time in Excel – 3 Methods

The sample dataset contains 4 digits that represents time value in column C. Method 1 - Use Excel Functions to Convert the 4 Digit Number ...

Convert Number to Time hhmmss in Excel: 2 Suitable Ways

Method 1 - Use TEXT Function to Convert Number to Time in hhmmss Format Steps: First and foremost, click on the C5 cell. Insert the following ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo