Latest Blog Posts

How to Create a Sunburst Chart in Excel (With Detailed Steps)

Introduction to Sunburst Charts A Sunburst chart is a powerful visualization tool for displaying hierarchical data in a circular format. It ...

How to Do Excel Encoding (Check and Change)

In this Excel tutorial, you will learn how to - Check the encoding of an Excel file - Change the encoding to UTF-8 using the web option - Change ...

Report in Excel (Using Pivot Table and Charts)

In this Excel tutorial, you will learn how to generate a report in Excel. You can organize raw data with PivotTable, create charts to visualize data, ...

How to Recover Excel File? (Overwritten and Deleted Files)

We often have to recover our overwritten or deleted Excel files. These files are important for retrieving important information. To recover ...

Excel Interest Rate Calculator

Excel Interest Rate Calculator: Knowledge Hub Effective Interest Method of Amortization Excel Interest Rate Swap Calculation Excel ...

Excel AutoSave (Including VBA Macro)

This tutorial will delineate the approaches to turning on Excel AutoSave. While constructing approaches we are likely to use Quick Access Toolbar ...

Box and Whisker Plot in Excel (Create & Customize)

The box and whisker plot in Excel shows the distribution of quartiles, medians, and outliers in the assigned dataset. This article will ...

[Fixed!] Excel Is Not Opening Files (14 Solutions)

Method 1 - Open File with MS Excel It is possible to open some spreadsheet with different applications. However, you must open .xlsx, .xlsm, or .csv ...

Excel Sales Formula: All You Need to Know

In this article, we will explore several important Excel Sales formula that can greatly improve your sales analysis and help you to find valuable ...

How to Add, Format & Remove Title in Excel (Complete Guideline)

In this Excel tutorial, you will learn how to: - Add or Insert a title in Excel - Format a title - Create a title column - Remove a title - Add ...

All About Excel Files (Types, Extensions, Open, Merge, Etc. )

What Are the Available File Types That Are Supported in Excel? Excel supports 3 file formats. Their names, extensions, and details are in separate ...

Reconciliation Template Excel

Reconciliation Template Excel: Knowledge Hub Material reconciliation format in excel Party ledger reconciliation format in excel Vendor ...

Format Axis in Excel: 7 Different Modifications

Method 1 - Change Display of Chart Axes 1.1. Display or Hide Axes Click the chart and select it. From the Chart Design tab, select Add Chart ...

Cost Calculator Excel Template

Cost Calculator Excel Template: Knowledge Hub Electricity Cost Calculator in Excel  Opportunity Cost Calculator in ...

How to Check, Highlight & Return Value If Cell Contains Text?

In this Excel tutorial, we will cover all the scenarios we need to know if a cell contains text in Excel. We will discuss 13 different scenarios ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo