Excel Basics

How to Change Column Width in mm in Excel (A Step-by-Step Guideline)

Sometimes you need to change the width of columns or height of rows in Excel from default unit Inches to other standard universal units like ...

Mixed Cell Reference in Excel (4 Examples)

In this article, we will let you know what mixed cell reference is in Excel and describe it with 4 examples. What is Mixed Cell Reference in ...

How to Use VBA to Remove Duplicates in Excel (6 Examples)

Sometimes you want to remove duplicate values from your worksheet to work only with the unique values. In Excel, you can remove duplicates very ...

Excel Shortcut to Merge Cells (3 Methods + Bonus)

In Microsoft Excel, merging cells is one of those essential tasks. To prepare a great presentation, you may need to merge some cells of your dataset. ...

Cell Reference in Excel VBA (8 Examples)

In this article, I’ll show you how you can access a cell reference in VBA in Excel. You’ll learn to access a single cell, as well as multiple cells ...

How to Apply AutoFill Shortcut in Excel (7 Methods)

This tutorial will help you to use Autofill shortcut in Excel of various types to conveniently autofill or populate the cells in Excel without any ...

How to Use Excel Cell Format Formula (4 Effective Methods)

In some cases, we need to convert or adjust or transform the data cell in a specific format without changing the originality. In this article, I’ll ...

[Fixed!] SUM Not Working with Time Values in Excel (5 Solutions)

Microsoft Excel is one of the most popular applications used in big corporations and business centers. It contains lots of built-in functions that ...

How to Delete Rows Using Excel Shortcuts

While working with Microsoft Excel, you will face a lot of situations where you need to delete rows. Some people love to work with the mouse and the ...

Format Painter Shortcut in Excel

Format Painter is a useful tool for quickly copying and applying the format from one cell to another. Excel does not have a dedicated keyboard ...

How to Hide Duplicates in Excel (4 Ways)

While working in Excel, you may have duplicate values in your dataset. For any reason, if you need to hide those duplicate values or rows then you ...

How to Delete Hidden Rows in Excel?

Sometimes while working in Microsoft Excel, we may have to deal with a lot of hidden rows or columns. Hidden data may be unavailable as well as ...

Example with Absolute Cell Reference in Excel (4 Apllications)

In this article, we will let you know what absolute cell reference in Excel is and describe it with 4 useful examples. What is Absolute Cell ...

How to Calculate Time in Excel (17 Possible Ways)

It is possible to calculate time in Excel using arithmetic operations along with functions because in Excel dates and times are stored as numbers in ...

Timesheet Formula in Excel (5 Examples)

To calculate the time difference (e.g. work hours) between two time periods, we create a timesheet. There are several ways that we can use to keep ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo