Latest Blog Posts

How to Left Align in Excel (3 Handy Ways)

In many cases, you might need to align cells to the left in Excel. It is very easy to choose or change alignment in Microsoft Excel. Also, you can do ...

What Can You Do with Cell Value If Checkbox Is Checked in Excel: 3 Methods

Method 1 - If Checkbox Is Checked, Set Cell Value Steps: Go to the Developer tab. If you don’t have it, enable the Developer tab on ribbon from ...

How to Align Shapes in Excel (5 Simple Methods)

Method 1 - Align Shapes in Same Plane in Excel We have four shapes that are on the same plane but are not arranged in a particular way. ...

How to Promote a Row to a Column Header in Excel (2 Ways)

If you are looking for some special tricks to promote a row to a column header in Excel, you've come to the right place. There are two ways to ...

How to Convert Text to Title Case in Excel (4 Methods)

Dataset Overview We'll use the data set below to demonstrate the methods. Method 1 - Using the PROPER Function The PROPER function is a ...

How to Calculate Pro Rata Share in Excel (with 2 Examples)

Example 1 - Calculation of Pro Rata Share for Employee of a Company The sample dataset below will be used to calculate the annual salary of the ...

How to Center Accounting Format in Excel – 2 Methods

This is an overview.   The sample dataset showcases employees' names and their respective salary. The salary amounts are in ...

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 Add Regression Line to Scatter Plot in Excel

If you are looking for how to add a regression line to scatter plot in Excel, then you are in the right place. In statistics, a regression line is a ...

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 Apply Accounting Number Format to Selected Cells in Excel

When you are working with a dataset, and you need to represent some cells as money, then you need them to show as the accounting number format. It ...

How to Calculate Trend Percentage in Excel (With Easy Steps)

Trend Percentage represents the comparison of financial information like net sales, operating expenses, gross profit, inventory, cost of goods sold, ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo