Excel Basics

Creating Barcode Scanner to Track Check in & Check out Time in Excel

You can track check in time and check out time by using a barcode. Barcode provides a unique code for a specific item. So, it becomes easy to track ...

How to Change International Number Format in Excel (4 Examples)

Often, we need to use large numbers in international number format in our Excel sheet. It becomes difficult to read those numbers if the formatting ...

Border Not Showing in Excel – 6 Solutions

This is the sample dataset. Solution 1 - Changing Line Color In the following dataset some cells have no borders because the Borders line ...

How to Add Thick Box Border in Excel (3 Quick Ways)

When dealing with complex data in Excel, reading can be challenging. To enhance clarity, add borders to differentiate and focus on specific data in ...

How to Align Right in Excel (5 Simple Methods)

Excel users frequently try to adjust the alignment to improve data representation. As a result, in this article, altering alignment to the right will ...

How to Lock Borders in Excel (With Easy Steps)

While working in Excel, we need to deal with a lot of tables in a dataset. Sometimes we may need to lock the borders of a table in Excel. There is a ...

How to Align Text Boxes in Excel (3 Suitable Examples)

Excel will allow you to add text boxes. Text boxes provide a separate area in which you can write texts, and you can also move the position of the ...

How to Calculate Barcode Check Digit with Excel Formula

While working in Microsoft Excel sometimes we need to calculate check digits from barcodes. In order to do that, you can use formulas to get your ...

How to Apply Borders in Excel with Conditional Formatting

This article illustrates how to apply conditional formatting borders in Excel. Conditional formatting is one of the most useful features in Excel. ...

All Types of Alignment in Excel (Explained in Detail)

While working with data in Excel, you may need to organize your data in the cells. One of the key elements that contribute to effective data ...

[Fixed!] Excel Cell Alignment Not Working (5 Possible Solutions)

Cell alignment is one of the most paramount ways to emphasize and categorize your data. In different situations, different cell alignment makes users ...

How to Show Tracer Arrows in Excel (2 Handy Ways)

When working with a large spreadsheet in Microsoft Excel, it can be challenging to track which cell contains the data you’re looking for. To make it ...

How to Make Auto Enter with Barcode Scanner in Excel

Microsoft Excel is a powerful software to conduct the same work as technological devices. With this, we can auto enter the barcode scanner without ...

How to Add or Remove Dotted Border in Excel

A dotted border in Excel is a formatting style that uses dotted lines to outline a cell or a range of cells. The dotted border is not a permanent ...

How to Fill Blank Cells with Value Below in Excel (4 Easy Ways)

Let's say we have a dataset with some empty or blank cells. Using a dataset with blank cells for calculations is not practical. We must, therefore, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo