Excel Basics

How to Link Multiple Checkboxes in Excel (3 Easy Methods)

  Method 1 - Using a Formula with a Cell Reference We have to prepare a dataset containing different tasks as shown below. Steps: ...

How to Add Numbers 1 2 3 in Excel: 8 Suitable Methods

Method 1 - Use Excel Fill Handle Tool to Add Numbers 1 2 3 Steps: Insert 1 in cell B5 and 2 in cell B6. This initiates a pattern; the Fill ...

How to Change Orientation from Horizontal to Vertical in Excel

Excel is the most widely used tool for dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we ...

How to Add Automatic Serial Number with Formula in Excel

We will use a dataset that contains information about the Marks of some students. We will add automatic serial numbers to the dataset using some ...

How to Change Text Orientation in Excel (5 Easy Methods)

When you are working on a dataset for presenting to customers or stakeholders, you may need to organize the texts in the most easily readable way. In ...

How to Use a Barcode Scanner for Inventory Counts in Excel

What Is a Barcode? A Barcode is a machine-readable code consisting of spaces and varying widths of parallel lines representing numers and characters ...

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

How to Organize Addresses in Excel (2 Effective Ways)

A Microsoft Excel sortable table organizes your address details for quick access. In an alternative, style a pre-designed address book using a ...

How to Create Barcode Without Font in Excel (2 Smart Methods)

Method 1 - Using Add-in to Create Barcode Without Font Steps: Download an Add-in and install it on your computer. Click on the Add-ins ...

How to Use Barcode Scanner in Excel (2 Suitable Ways)

Method 1 - Use a Barcode Scanner and Show the Scanned Code in an Excel Cell Steps: You need to manage a barcode scanner. Turn off the computer ...

How to Use Conditional Formatting with 5 Color Scale in Excel (2 Methods)

We have financial information about some wrestling superstars: their Yearly Income and Net Worth. We'll format the data in a five-color-scale. ...

How to Use QR Code Attendance Tracking with Excel (with Easy Steps)

    Step 1: Making a List of Holidays and Leave Days To create an attendance tracker, we have to follow some specified rules. We have ...

How to Stop Auto Capitalization in Excel (with Quick Steps)

Auto Capitalization is often a handy feature of Excel. But sometimes it can be a frustrating thing as Excel does Auto Capitalization by default. In ...

How to Separate an Address in Excel (3 Methods)

Method 1 – Using the ‘Text to Columns’ Option to Split Addresses  The below dataset shows an address 986 Riverview Ct-Xenia, OH, 45385’ in the B5 ...

Barcode Scanner Entry in an Excel Database with Timestamp – 3 Examples

There are barcodes with corresponding timestamps in the dataset below. Example 1- Apply Barcode Scanner Entries to an Excel Database with ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo