Latest Blog Posts

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 ...

Mailing Labels in Excel (Prepare to Be Amazed)

Hi there! Are you tired of making Mailing Labels? Guess what you came to the right place. In this article, we will discuss all the steps of creating ...

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 ...

Stocks in Excel

In this blog post, we'll delve into the Excel world of stocks and examine some of the valuable features found in the Stocks ribbon, which is located ...

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 Send Email from Excel?

Send Email from Excel: Knowledge Hub How to send excel file to email automatically Automatically send emails from excel based on cell content ...

Workbook Views in Excel (Everything You Need to Know)

Workbook Views in Excel: Knowledge Hub Show Only One Page in Excel Page Layout View How to Show Ruler in Excel Excel Ruler Not Showing ...

YTD Formula in Excel

YTD Formula in Excel: Knowledge Hub How to Sum Year to Date Based on Month in Excel How to Calculate YTD (Year to Date) in Excel How to ...

Pivot Table Grand Total

Pivot Table Grand Total: Knowledge Hub How to Show Grand Total in Pivot Table How to Collapse the Table to Show the Grand Totals Only ...

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 - ...

Subtotals in Pivot Table

Subtotals within pivot tables are a pivotal feature that enhances the way you analyze and summarize data, providing a comprehensive view of ...

Excel Tips and Tricks

Maximize Excel efficiency with shortcuts like Ctrl+C/V, freeze panes for scrolling, and use "Format as Table" for better data management. Master ...

Pivot Table Running Total

Pivot Table Running Total: Knowledge Hub How to Use Pivot Table to Calculate Running Total by Date in Excel << Go Back to Pivot ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo