Latest Blog Posts

How to Create Pro Forma Financial Statements in Excel

In this article, we will create pro forma financial statements in Excel. We will project three years of financial statements for a startup company. ...

How to Use the VLOOKUP Function with Multiple Criteria in Different Sheets – 4 Methods

The sample dataset is an overview. Method 1 - Using in VLOOKUP Function on Each Sheet Individually Steps: Create a dataset as shown ...

How to Use Excel VLOOKUP with Multiple Criteria in Column and Row: 6 Methods

Methods 1 - Insert Ampersand Inside Excel VLOOKUP to Join with Multiple Criteria in Column and Row STEPS: Insert a Helper column on the ...

How to Add Option Button in Excel (With Easy Steps)

Consider the following dataset of fruit items and two stores. We'll insert option buttons so we can use this dataset to input data in other sheets. ...

How to Make All Numbers Positive in Excel (11 Effective Methods)

Method 1 - Using the ABS Function to Make All Numbers Positive Steps: Make a column to store the positive numbers and enter the following ...

How to Create Format for Projected Financial Statements in Excel

Part 1 - Creating a Projected Income Statement Format Steps: Insert all the assumptions. These values will be referenced in the income ...

How to Create a Histogram in Excel with Two Sets of Data – 4 Methods

The sample dataset contains 3 columns: Student ID, Math, and English. You want to calculate how many students get marks between different intervals. ...

How to Use Multiple Excel Formulas in One Cell (with Easy Steps)

We'll use the following dataset to combine formulas in a single cell. Step 1 - Creating the Data Set In this step, the SUM function and ...

How to Apply Formula in Excel for Alternate Rows (5 Easy Ways)

We have Sales Data of a Company as our dataset. In the dataset, we have Quarterly Sales for the Years 2021 and 2022. We will find the Half-Yearly ...

How to Draw AOA Network Diagram in Excel: 5 Methods

Method 1 - Entering Activities, Predecessors, and Schedule Times of Project Divide the entire project into multiple activities such as A, B, C, ...

How to Create a Weekly Schedule in Excel (2 Suitable Methods)

Watch Video – Create a Weekly Schedule in Excel Method 1 - Creating a Weekly Schedule in Excel Without Templates Step 1: Create ...

How to Use VLOOKUP with Multiple Criteria in Different Columns

Whilst working in Microsoft Excel, we’ve all faced a scenario where we need to look up a value from a dataset based on a few criteria. Now, even with ...

How to Create a Monthly Schedule in Excel (3 Simple Ways)

Watch Video - Create a Monthly Schedule in Excel Method 1 - Using Excel Templates to Create Monthly Schedule in Excel Step 1 ...

How to Swap Non-Adjacent Cells in Excel (3 Easy Ways)

If you are looking for ways to swap non-adjacent cells in Excel, this article is for you. Swapping values can be time-saving for correcting any ...

How to Create an Account Statement in Excel (with Easy Steps)

  Watch Video – Create an Account Statement in Excel   Step 1: Prepare an Appropriate Outline The first step is to create ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo