Latest Blog Posts

How to Organize Addresses in Excel (2 Effective Ways)

A Microsoft Excel sortable table organizes your address details for quick access. In an alternative, style a pre-designed address book using a ...

How to Create a Pie Chart in Excel with One Data Column – 2 Methods

This is the sample dataset. Method 1 - Inserting a PivotTable to Create a Pie Chart in Excel Step 1: Select the entire column. Here, ...

How to Plot a Stacked Bar Chart from an Excel Pivot Table – 2 Examples

Example 1 - Plot a Stacked Bar Chart from an Excel Pivot Table This is the sample dataset. To Create a Pivot Table: Select the whole ...

How to Create Barcode Without Font in Excel (2 Smart Methods)

Method 1 - Using Add-in to Create Barcode Without Font Steps: Download an Add-in and install it on your computer. Click on the Add-ins ...

How to Format Data Labels in Excel (Easy Steps)

Dataset Overview To display formatted data labels in Excel, follow these steps using the below dataset that includes country names and their ...

How to Create a Pie Chart by Count of Values in Excel (2 Methods)

Dataset Overview To illustrate the methods, we’ve chosen a dataset with three columns: Company, Product, and Sold (Qty). Method 1 - ...

How to Do Exponential Smoothing in Excel: 2 Methods

Method 1 - Using Data Analysis Tool to Do Exponential Smoothing in Excel Step 1 - Enabling Data Analysis ToolPak Add-In In Excel, Data Analysis ...

Progress Circle Chart in Excel as Never Seen Before

A progress circle chart is a great tool to visualize the completion status of a task. Generally, we can create a progress circle chart by simply ...

Excel Area Chart Data Label & Position

This article deals with the excel area chart data label position. An area chart is used to plot data arranged in rows or columns on a worksheet. You ...

How to Make a Progress Monitoring Chart in Excel – 2 Steps

The sample dataset contains information on different projects. Step 1 - Create a Dataset Calculate the percentage of work on the ...

Create an Excel Bar Chart with a Line Overlay – 3 Steps

The following table contains the Month, Sales, and Profit. Create an Excel bar chart with a line overlay: Step 1- Inserting the Bar Chart ...

How to Use Barcode Scanner in Excel (2 Suitable Ways)

Method 1 - Use a Barcode Scanner and Show the Scanned Code in an Excel Cell Steps: You need to manage a barcode scanner. Turn off the computer ...

How to Make a Personal Monthly Budget in Excel (2 Smart Ways)

We always try to make the best out of our limits. In order to make the best use of our monthly income, it is best to make a personal monthly budget. ...

How to Change Legend Colors in Excel: 4 Easy Methods

Method 1 - Using Context Menu Steps: Right-click on the column that is represented by the legend you are trying to change the color. The ...

How to Create a Bar Graph in Excel with 2 Variables – 3 Methods

  Types of Bar Graphs in Excel There are two types of bar graphs: Horizontal (2-D/ 3-D bars) and Vertical (2-D/ 3-D Columns). Bar ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo