Excel Basics

How to Compare and Merge Excel Workbooks (3 Steps)

Why Do We Need to Compare and Merge Workbooks? Take a look at the following dataset: This is the Master file. Or you can see the main file. ...

Absolute Cell Reference Shortcut in Excel – 4 Examples

This is an the overview. Shortcut Cell Reference Description Press F4 Single Cell or Cell Range Changes neither the column nor ...

How to Use Excel Formulas for Current Time (7 Methods)

Overview Herewith an overview of some of the easiest ways to fetch current time in Excel.   Applying or Changing the Time Format ...

How to Use Format Painter in Excel (7 Ways)

Whenever you need to copy format in Excel the Format Painter tool is the best to do it. It is used to change a string or cell content format with the ...

How to Copy Cell Format in Excel (4 Methods)

Excel allows you to easily format cells in a spreadsheet. Formatting options like font, font size, text alignment, cell borders, background fills and ...

How to Change the Column Width to mm in Excel – A Guideline

The dataset showcases information about Product, Delivery Date, Deadline to deliver the product, and delivery Status. To change the column width ...

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

VBA Syntax to Remove Duplicates in Excel Generic Syntax Range.RemoveDuplicates(Columns, Header) Parameter Description ...

Using an Excel Shortcut to Merge Cells – 3 Methods

Download Practice Workbook Download the practice workbook. Merge Cells Shortcuts.xlsm The title of the dataset below doesn't fit in B2. ...

Cell Reference in Excel VBA (8 Examples)

We'll use a data set with the Book Name, Book Types, and Price of some books of a bookshop called Martin Bookstore. The data set lies in the range ...

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 the Excel Cell Format Formula (4 Methods)

What is Cell Formatting in Excel? Cell formatting involves adjusting or changing the appearance of a cell without altering its original value. In ...

SUM Not Working with Time Values in Excel: 5 Methods

Method 1 - Get the SUM of Time Value Inserting Individual Cells Step 1: Go to Cell E5. Find the sum of the Cells C5 and D5 using the ...

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

How to Use the Format Painter Shortcut in Excel

What is Format Painter? In Microsoft Excel, the Format Painter is a powerful tool that allows you to copy the formatting from one cell or range of ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo