Latest Blog Posts

How to Map Data Using VLOOKUP in Excel: 4 Quick Methods

Method-1 - Using VLOOKUP Function to Map Data in Excel Steps: Navigate to the G5 cell and enter the expression below. ...

Construction Company Financial Statements in Excel

Step 1 - Enter Values for Current and Non-current Assets A balance sheet has three parts: records of assets, liabilities, and stakeholders’ equity. ...

How to Calculate Cumulative Cash Flow in Excel (with Quick Steps)

Calculating cumulative cash flow is a very handy approach for various business analysis purposes. Moreover, sometimes for our own personal reasons, ...

How to Create a Subsidiary Ledger in Excel (Easy Steps)

Introduction to Ledgers A ledger serves as a summarized record of financial transactions related to various accounts. It contains information from ...

How to Make Legend Markers Bigger in Excel: 3 Easy Ways

Method 1 - Change Font Size to Make Legend Markers Bigger in Excel STEPS: Right-click on the Legend Box to open the Context Menu. Select ...

How to Prepare Financial Statements in Excel (with Easy Steps)

  What Is a Financial Statement? Financial Statements are summary reports that contain the state of a company or organization's financial ...

How to Add Text to a Cell Value in Excel (4 Ways)

Method 1 - Using Ampersand Operator to Add Text to a Cell Value in Excel Steps: Click on the first cell, F5, in the column where you wish the ...

How to Add Gridlines for Specific Cells in Excel (3 Easy Methods)

While working in Microsoft Excel, we might find files with no gridlines in the workbook. In that scenario, we might feel the need to add gridlines ...

How to Make a Bank Reconciliation Statement in Excel Format

  Step 1: Entering Particulars for Bank Reconciliation Statement in Excel Format In the sample dataset below, it is evident that the ...

How to Make a Trading Journal in Excel (with Easy Steps)

Let’s say we have a dataset that contains information about several Trades. We will make a trading journal in Excel using Mathematical formulas, the ...

How to Change Page Orientation in Excel (2 Simple Methods)

If you are looking for simple ways to change page orientation in Excel, this article will serve the purpose. Excel by default uses the Portrait ...

How to Insert Page Number in Excel (7 Easy Methods)

Method 1 - Using Page Layout View Style to Insert Page Number Steps: Go to the View tab and from the Workbook Views section, select Page ...

How to Convert Entire Column to Number in Excel (9 Methods)

Let's use the following dataset, which contains some Subject and Marks. The numbers are showing errors (or error suggestions) because the format is ...

How to Remove Gridlines from Table in Excel (2 Examples)

There may be some instances where you need to remove gridlines from tables. In Microsoft Excel, you can do this type of task within seconds. This ...

How to Add Text to an Excel Spreadsheet – 6 Methods

  This is the sample dataset. Method 1- Using the Ampersand Operator to Add Text in Excel 1.1 Using the Ampersand Operator to Add ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo