Latest Blog Posts

Excel Test Cases Template

Excel Test Cases Template: Knowledge Hub How to write test cases in excel sheet Test cases for banking application in excel sheet How to ...

Pivot Table in Excel: Create and Explore

What Is a Pivot Table in Excel? A Pivot Table is a data analysis tool in Excel. Its main purpose is to summarize and analyze a large amount of data ...

How to Format Cells in Excel: Everything You Need to Know

  What Options Are Available to Format Cells in Excel? 1. Ribbon Commands The Ribbon has various commands for formatting a cell in Excel. You ...

Excel Cells Basics – A Beginner’s Guide

A cell is the smallest unit of an Excel worksheet. Each cell has a unique address. The cell address is a combination of a column letter and a row ...

How to Print in Excel – Basic Guidelines for Beginners

Here's an overview of the Print menu in Excel. You can choose your printer, and you can change print settings including what to print, how many ...

How to Split in Excel (Text, Numbers, Cells & Columns)

The overview shows the summary of splitting first and last names, separating numbers from text, and splitting cells vertically across rows. Here, the ...

How to Create Named Range in Excel: 4 Suitable Methods

Method 1 - Create Named Range Using Name Box Create a name for the Annual Salary column using the Name Box. Select the cell range F6:F15 ...

Excel Quarterly Amortization Schedule [Free Download]

The quarterly amortization schedule is a helping tool to track one’s quarterly loan repayment process. It is assumed that the borrower pays his ...

Excel Monthly Amortization Schedule [Free Download]

Download our free Excel Monthly Amortization Schedule template to generate your monthly amortization schedule and read the article to learn how to ...

Excel Bi-Weekly Amortization Schedule [Free Download]

A bi-weekly amortization schedule is a great tool to visualize one’s bi-weekly loan repayment process. From this schedule, s/he will be able to know ...

Excel Weekly Amortization Schedule [Free Download]

Amortization schedule is a visualization tool that helps borrowers keep track of their loan repayment process over the loan term. For the weekly ...

Data Validation in Excel: A Complete Guideline

In this tutorial, you will learn everything about Data Validation from its purpose to how to apply it in your Excel worksheet. In the image ...

How to Copy a Formula in Excel (Column, Rows, Copy as Formulas)

The following image shows a dataset containing products from different sellers. Each product has a discount. The formula to calculate the discounted ...

How to Calculate Percentage Change in Excel (4 Examples)

The following dataset contains some products (B5:B14) and their sales in January (C5:C14) and February (D5:D14). We have calculated the percentage ...

How to Wrap Text in Excel (Wrap, Unwrap, Fix Issues)

Method 1 - Using the Wrap Text Option from the Home Tab Select range D6:D13. Go to the Home tab. Click on Wrap Text in the Alignment ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo