How to Do Bank Reconciliation in Excel (with Easy Steps)

Let’s assume you have a Bank Statement and a Cash Book as shown below. Here, we can see that the closing balances don’t match. So, you want to do ...

How to Make a Vendor Ledger Reconciliation Format in Excel

  Step 1 - Form a Basic Template Insert the time period in a cell for which you want to make a vendor ledger reconciliation. We inserted ...

How to Draw a Floor Plan in Excel (2 Easy Methods)

In this article, we'll demonstrate two quick ways to draw a floor plan in Excel. Here’s an overview of the dataset we'll be using. Floor Plan - ...

[Solved]: Track Changes Greyed Out in Excel (3 Quick Fixes)

Method 1 - Unprotect Workbook in Excel The track changes option becomes greyed due to various reasons. One of the reasons is that your workbook is ...

How to Make a Box and Whisker Plot in Excel?

Excel’s Box and Whisker Plot demonstrate the distribution of Quartiles, Median, and Outliers of the assigned dataset. Users often need to make a Box ...

How to Do Intercompany Reconciliation in Excel – 2 Easy Methods

  The sample dataset showcases transactions in the book of Company 1 and Company 2. Products have Invoice No, Price per Unit, and Total ...

How to Do Repeated Measures ANOVA in Excel (With Easy Steps)

In this article, we will do repeated measures ANOVA in Excel. We can perform different types of data analysis with the help of Microsoft Excel. ANOVA ...

[Fixed!] Sub or Function Not Defined in Excel VBA

‘Sub or Function not defined’ is a compilation error in Excel VBA, that is displayed whenever anything specified by name cannot be found. Before ...

How to Make a Box Plot in Excel?

This tutorial will demonstrate how to make a box plot in Excel. The box plot is another way of presenting statistical data for better visualization. ...

How to Show Dash Instead of Zero in Excel (4 Easy Methods)

We will consider this example below. Here, the dataset contains the number of different products sold over three days and their Product IDs. ...

How to Do Reconciliation in Excel (12 Effective Techniques)

Consider the following dataset example for demonstration. Here the two datasets represent sales information for June and July of 8 products. We will ...

How to Repeat Rows at the Top of Printed Pages in Excel

Suppose you have the following dataset and want rows 2 through 6 to always show at the top of the page when printed. If you press Ctrl + P to ...

How to Create a Credit Card Payoff Spreadsheet in Excel – 2 Methods

This is a quick view of the credit card payoff spreadsheet used in the first method. Method 1 - Creating a Credit Card Payoff ...

How to Interpret ANOVA Results in Excel – 3 Methods

ANOVA, or Analysis of Variance, is an amalgamation of multiple statistical models to find the differences in means within or between groups. Multiple ...

How to Hide Header and Footer in Excel (2 Easy Methods)

We have a dataset of some Student Names and their respective Departments. We will add the header and footer to this workbook. While in the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo