Advanced Excel

How to Print Avery 5160 Labels from Excel (with Detailed Steps)

Standard Microsoft office products such as Avery 5160 Labels are very well known. If you are looking for some special tricks to print Avery 5160 ...

How to Adjust Page Size for Printing in Excel (6 Quick Tricks)

Whenever we want to print a single worksheet or even more than that, the common problem that occurs is the page adjustment issue. The page size or ...

Perform Holt-Winters Exponential Smoothing in Excel

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. In ...

How to Create a Legend in Excel Without a Chart (3 Steps)

When dealing with Excel Charts, users usually insert Chart Legends using Chart’s options. However, in some cases, users need to create a legend in ...

How to Track Changes in Excel (with Easy Steps)

This tutorial will demonstrate steps to calculate track changes in Excel. If you work with an Excel file that needs to be updated or reviewed by ...

How to Use Excel Solver for Linear Programming (with Easy Steps)

We can use Excel to carry out many different mathematical operations. Linear Programming is an aspect of Statistics and Applied Mathematics. This has ...

How to See Who Made Changes in Excel (6 Easy Methods)

Method 1 - Applying Version History Feature to See Who Made Changes in Excel All newer versions of Excel come with a Version History feature that ...

How to Check Edit History in Excel Online (With Simple Steps)

Microsoft Excel has expanded its versatility with the option to check edit history in its Excel online platform. It has benefited its users widely as ...

How to Mail Merge Pictures from Excel to Word (2 Easy Ways)

Mail Merging is an extremely useful feature of the office suits. Using this feature users can autofill hundreds of doc files at one go, even with ...

How to Print Avery Labels from Excel (2 Simple Methods)

  Method 1 - Print Avery Labels Using Word from Excel Let’s consider the following dataset shown in B4:F14 cells, with Company Name, Address, ...

How to Mail Merge from Excel to Word Envelopes (2 Methods)

If you want to mail merge from Excel to Word envelopes, this article is for you. Here, we will walk you through 2 easy and suitable methods to do the ...

Mail Merge from Excel to Excel (with Easy Steps)

Often, users have one or two customers’ mailing credentials in an Excel file. Therefore, they need to fetch other credentials matching the existing ...

How to Mail Merge from Excel to Outlook with Attachments (2 Examples)

Using mail merge, we can create a collection of documents that each recipient receives individually. If you are looking for some special tricks to ...

How to Change Date Format in Excel Mail Merge (with Quick Steps)

Mail Merge is an outstanding feature of Microsoft Word. Using this feature of Microsoft Word and an Excel datasheet, we can create as many copies of ...

How to Transform Data to Normal Distribution in Excel (2 Easy Methods)

The article will show you how to transform data to the normal distribution in Excel. In statistics, it’s important to imply the normal distribution ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo