Learn Excel

SmartArt in Excel: Everything You Need to Know

OS Industries Ltd manufactures Men’s Shirts and sells in Texas, California, and New Mexico. The supply chain is showcased below with SmartArt. ...

How to Count Words in Excel?

In this article, I will show you how to count words in Excel. While working in Excel, we may want to calculate the total number of words in a cell or ...

How to Create Data Visualisation in Excel (7 Practical Examples)

Excel spreadsheet is extensively used for data analysis. Also Excel provides many inbuilt features for insightful data visualisation. In this ...

How to Draw Circle in Excel (4 Simple Methods)

The sample dataset that represents circular components and values. We will use these number values to draw a circle in Excel. Method 1 - ...

How to Add Cell Tooltip in Excel (3 Easy Methods)

Consider a worksheet where we have a list of grocery items. In this list, in one column, we have the item name. In another column, the price per unit ...

How to Undo and Redo in Excel (2 Suitable Ways)

Sometimes we mistakenly perform an action in Excel and we need to undo it. Again we need to redo an action sometimes. These can be easily done in ...

How to Create QR Code in Excel (3 Suitable Methods)

  To explain how you can generate QR codes in Excel, let's use a dataset that contains the Site Name and its URL which is the Value for our ...

Data Cleaning in Excel: 30+ Useful Techniques

In this free Excel tutorial, we will explain the definition, importance, and several simple ways of data cleaning in Excel. We'll use a dataset with ...

How to Convert Currencies in Excel (7 Methods)

We have some currencies in USD. We'll convert them to Euro and GBP. ⏷Simple Arithmetic Formula for Currency Conversion ⏷Currency ...

Errors in Excel and Their Meaning (15 Different Errors)

We're going to use a sample dataset to show most common errors. The following dataset represents the Salesman, Product, and Net Sales of a company. ...

How to Insert a Date Picker in Excel (With Step-by-Step Procedure)

Download the Practice Workbook Insert Date Picker.xlsm Why Is Date Picker Useful in Excel? Here's an example of a date picker in ...

Transpose Data in Excel (Applying Functions, Commands, and VBA)

Download Practice Workbook Transpose Data.xlsm Method 1 - Using Excel Paste Special Tool to Transpose Data Press Ctrl + C to ...

How to Concatenate in Excel (5 Easy Methods)

One of the most important features of Excel is to collect and contain data from various places into a single cell. In other words, to concatenate. ...

Excel Sparklines: Simplifying Data Trend Analysis in a Single Cell

Here's an overview of Excel Sparklines. We have sales data for several months in a worksheet. We have used the Excel Sparklines feature to visualize ...

How to Do Conditional Formatting in Excel (Ultimate Guide)

⏷What Is Conditional Formatting in Excel? ⏷Where Is Conditional Formatting Located in Excel? ⏷Apply Different Types of Conditional Formatting      ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo