Latest Blog Posts

How to Calculate Payment in Excel?

In this article, we will demonstrate how to: Apply a direct formula to calculate monthly payment. Use the PMT function to calculate monthly ...

Edit Gridlines in Excel (Add, Remove, Change, and Print)

This is an overview: Download the Practice Workbook Editing Gridlines.xlsx Removing Gridlines in Excel Worksheets Go to ...

How to Add Data Series in Excel Chart (2 Easy Methods)

After inserting a chart, you may need to add another row or column to plot in the same Excel chart. Let's use the following dataset to demonstrate ...

Formatting a Chart in Excel – 8 Examples

Download Practice Workbook Download the following workbook. Formatting Chart in Excel.xlsx How to Insert a Chart from Data in ...

Chart Style in Excel

This tutorial will show you how to change the Chart Style in Excel. Learning how to change the chart style can help your charts look better overall. ...

Excel Axis Scale (Change Scale, X and Y-Axis Values)

Let's use a dataset that contains information about annual rainfall for a decade and converts that into a column chart to demonstrate how to scale ...

Customizing Excel Charts – 8 Examples

Download Practice Workbook Customize Charts.xlsx Chart Elements in Excel There are 9 different chart elements available in Excel: ...

Formatting Worksheet in Excel: 11 Examples

1. Turning Off Gridline in an Excel Worksheet Go to the View tab. Uncheck the Gridlines option to disable it. The gridlines will turn off ...

How to Show the Gridlines in Excel – 3 Methods

This is an overview. Download Practice Workbook Download the practice workbook. Show Gridlines in Excel.xlsx Method 1 - ...

Add Gridlines in Excel (Complete Guideline)

In this article, you will learn all things you need to know about how to add gridlines in Excel and also ways to remove them. Gridlines in Excel ...

Encryption in Excel: 3 Possible Methods

Method 1 - Encrypt an Excel File Using Encrypt with Password Feature Go to File>> Info>> Protect Workbook>> Encrypt with ...

Excel Read Only: All You Need to Know

Method 1 - Use ‘Open as Read-Only’ Feature to Make Excel File Read Only Go to File>> Info>> Protect Workbook>> Always Open ...

Excel Protect

Excel Protect: Knowledge Hub How to Protect Cells in Excel How to Protect Columns in Excel Protect Workbook in Excel ...

How to Perform Regression Analysis in Excel? (3 Methods)

Excel is a popular tool for doing regression analysis because it has a user-friendly interface and a variety of features. Here's the dataset we'll ...

Anova in Excel (One and Two-Way)

In this Excel tutorial, we provide a comprehensive look at ANOVA in Excel. We will demonstrate how to enable the Data Analysis feature and use it to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo