Latest Blog Posts

How to Use Conditional Formatting in Data Labels in Excel

In this article, we will demonstrate how to use conditional formatting in data labels to present data in charts more eloquently. Download the ...

Excel Practice & Exercises with SUM Function

Problem Overview You will get six exercises related to the SUM function. To illustrate the problems, we have used a dataset. This dataset represents ...

How to Scrape Data from a Website into Excel (2 Easy Methods)

To illustrate our methods, we'll use a table on a webpage (see the screenshot below) that we want to export into Excel for further analysis. ...

How to Change Font Style in Excel (5 Easy Ways)

In this Excel tutorial, we will describe how to change font style. Changing font style in Excel is a process that enhances the visual appeal of the ...

How to Add Subscript in Excel Graph (7 Easy Methods)

If you want to add subscript(s) in an Excel graph, you have come to the right place. Here, we will walk you through 7 easy and effective methods to ...

How to Anchor Text Box in Excel

Anchoring the text box in Excel means fixing the position of the text box relative to a specific location. This ensures that the text box remains in ...

How to Shuffle Numbers in Excel (7 Easy Methods)

Excel can help you shuffle or randomize different formats of data quickly in easy ways. You can shuffle data within one column as well as around ...

How to Convert Abbreviations to Words in Excel (2 Easy Methods)

In this tutorial, I am going to show you 2 simple methods to convert abbreviations to words in Excel. You can quickly use these methods even in large ...

How to Create Excel File from Metadata with CSV File

Microsoft Excel is a powerful tool to create a dynamic database. We can store the data of our device folders or browsers which is called Metadata. In ...

Excel Practice & Exercises with IF Function

This article contains seven Excel practice exercises related to the IF function. The problems are easy to solve, so you will only need a basic level ...

How to Increase Font Size for Printing in Excel (2 Suitable Ways)

Method 1 - Apply Scaling Option to Increase Font Size for Printing in Excel STEPS: Click on File. Select Print. The Print ...

How to Apply Margin Setting in Excel (2 Handy Approaches)

Microsoft Excel is one of the most important and capable computer applications. We can do endless computations on any dataset using Excel's features ...

How to Use REGEX to Match Patterns in Excel – 6 Examples

Example 1 - Using a Combined Formula to Match a REGEX Pattern in Excel REGEX will be: the total character length - 9, the first 3 - uppercase ...

Excel VBA to Translate Language with Formula (With Easy Steps)

  Codes for Different Languages Here's a short list of language codes for some languages. You will find the detailed list on the Google Cloud ...

How to Add Margin in Excel (7 Effective Ways)

Microsoft Excel is a very useful software. We use Excel functions and features for our educational, business, and other daily life purposes. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo