Latest Blog Posts

Custom Number Format in Excel (13 Unique Examples)

Here's the overview of the Format Cells dialog box, where you can use Custom Formats. Let's showcase some examples for custom formats. ...

Excel Depreciation Template

Excel Depreciation Template: Knowledge Hub Create Depreciation Schedule in Excel  How to Create Vehicle Depreciation ...

Excel Project Management Template

Excel Project Management Template: Knowledge Hub How to track project progress in excel How to track multiple projects in excel How to ...

How to Move Columns in Excel?

Download Practice Workbook Moving Columns.xlsx Method 1 - Moving Columns with Mouse Cursor Select all the cells of the column that ...

How to Share Workbook in Excel? (Complete Guideline)

In Excel, the Share Workbook option enables multiple users to work on a workbook simultaneously, enabling real-time collaboration where changes made ...

Excel Payment Calculator [Free Download]

Excel payment calculator is one of the most common and essential calculators to track and plan various loan or savings payments. In this free ...

How to Export Data and Save as Image in Excel?

Here's an overview of exporting a chart as an image in Excel. Download the Practice Workbook Save Excel Spreadsheet as Image.xlsm ...

Translating in Excel – 3 Methods

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

Using the Excel SUMIFS Function with Multiple Criteria – 5 Examples

This is an overview: Download Practice Workbook Download the Excel file. Using SUMIFS Function with Multiple Criteria.xlsx ...

Excel Project Estimate Template

Excel Project Estimate Template: Knowledge Hub Building estimation and costing excel sheet Residential construction cost estimator excel ...

How to Create Alerts in Excel – 4 Examples

This is an overview. Download Practice Workbook Create Alerts.xlsm Example 1 - Using the Conditional Formatting to Set Up ...

How to Export Excel to XML – A Guide

Introduction to Extensible Markup Language (XML) XML, a markup language similar to HTML, is specifically designed to store and transport data. Here ...

How to Export Excel to CSV – 4 Methods

This is an overview: Download Practice Workbook Download the Excel files. Excel CSV.xlsm Excel CSV.csv Excel CSV ...

Excel Reconciliation Formula (for Data, Vendor, Bank)

In this article, we will demonstrate how to use the VLOOKUP, INDEX, MATCH and SUMIF functions to perform data reconciliation in Excel. ...

A Complete Guide on How to Pad Zeros in Excel?

Method 1 - How to Pad Leading Zero with Custom Format in Excel? Select data range D5:D20 >> Press Ctrl + 1 >> Format Cells dialog ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo