Learn Excel

How to Compare in Excel? (10 Practical Examples)

In the following overview image, we have compared two different lists containing the available products in a store and ordered products. If the ...

How to Use Fill Handle in Excel (All You Need to Know)

The Fill Handle tool is used to fill or extend data or series in Excel. It is a plus-sign cursor (+). For example, in the following GIF, we have ...

Barcode in Excel: Definition, Types, Creation, Font Installation & Uses

Barcode is a machine-readable code that can store information. Barcode is widely used in business to identify and track products, inventory, assets, ...

How to Add, Edit, Hide and Remove Notes in Excel

In this article, we will explore how to add, copy, hide, remove notes, etc. in Excel. We will also learn to add pictures in notes and convert notes ...

How to Add, Remove, and Print Background in Excel

In this Excel tutorial, you will learn how to: - Add image to Excel background - Change the default background color - Add color to the cell ...

How to Freeze Panes in Excel (Rows/Columns/Multiple Panes)

In Excel, we use the Freeze Panes feature to lock or fix specific rows or columns in your worksheet so that they remain visible as we scroll through ...

How to Attach File in Excel (4 Easy Methods)

In this Excel tutorial, you will learn to - Attach a file in Excel as an object - Attach new and existing updated files in worksheets - Use the ...

How to Use the Excel Screenshot Option (Take, Edit and Copy)

To take a screenshot in Excel, first, go to the Insert tab and then select the Screenshot option from the Illustrations group. There are two ...

220++ Keyboard Shortcuts in Excel ( for Quick Navigation)

Shortcuts in Excel allow us to complete a task quickly because we don't have to go through multiple tabs or context menus. Instead, we only need a ...

SmartArt in Excel: All Things You Need to Know

Drawing shapes and adding text boxes is tiring and time-consuming. SmartArt in Excel is a feature introduced by Microsoft that has a set of ...

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

Currency conversion in Excel means converting the value of one currency into the equivalent value of another currency using Excel functions and ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo