Latest Blog Posts

How to Add a Comment on a Graph in Excel (3 Easy Methods)

We will consider a dataset of Sales of ABC Traders from B4 to C10. We will add a chart and add a comment on it. Method 1 - Adding a ...

How to Create Quarterly Comparison Chart in Excel: 5 Easy Methods

Method 1 - Use Pie Chart for One Set of Quarterly Data Comparison Steps: Select the range B4:C8. Go to the Insert Choose a pie- chart. ...

How to Use Comparison Bar Chart in Excel (2 Practical Examples)

Example 1 - Year-over-Year Comparison with a Bar Chart We have the data for goals scored by famous footballers in the 2016/17 and 2015/16 seasons. ...

How to Rename Multiple Sheets in Excel (With Easy Steps)

We can rename multiple sheets by using a simple Visual Basics for Applications (VBA) code. Step 1: Insert Multiple Sheets In this ...

How to Create CAGR Graph in Excel (2 Easy Ways)

Method 1 - Utilizing Combo Chart The sample dataset below contains the following known values. Steps: Enter the following formula in ...

How to Model Uniform Probability Distribution in Excel (3 Ways)

Looking for ways to model uniform probability distribution in Excel? Then, this is the right place for you. Here, you will find 3 suitable ways to ...

How to Clear Recent Documents in Excel (3 Effective Ways)

Method 1 - Using Excel Options Feature to Clear Recent Documents Steps: Go to the File tab. Click on Options. In the Excel ...

Comments Are Not Displaying Properly in Excel: 3 Methods

Method 1 - Mark Indicator Only, and Comments and Notes on Hover Option Solution: Click the File tab beside the Home tab. Click on ...

How to Calculate ‘Time Weighted Return’ in Excel (2 Methods)

Method 1 – Applying the Arithmetic Formula  Steps: Create an organized dataset. Here, we have a situation where a man invested $55,000 as ...

Calculation of Interest During Construction in Excel

What Is Interest During Construction? Interest During Construction is the interest that is applied in the construction period. It is calculated on ...

How to Calculate Variance Inflation Factor in Excel

In this article, we will learn to calculate the variance inflation factor in Excel. It is also expressed as VIF. Variance Inflation Factor or VIF ...

How to Create Projected Balance Sheet Format for 3 Years in Excel

What Is a Projected Balance Sheet? A projected balance sheet, also called a pro forma balance sheet, contains all the financial information (such as ...

How to Calculate Semi Variance in Excel – 3 Simple Methods

Semi Variance evaluates the variation among the observations in a sample. Semi-variance deals  with the observations that are below the average of ...

How to Remove Chart Border in Excel (with Quick Steps)

Whether you are wondering how to remove a chart border in Excel, you have come to the perfect spot. We regularly need to build charts in Excel for ...

How to Track Cash Flow in Excel (Step-by-Step Guideline)

Cash Flow is one of the basic fundamentals of financial statements. It is a frequently used tool to to insight into the performance of a company. If ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo