Excel Basics

How to Apply the Accounting Number Format (ANF) in Excel (6 Methods)

The following image provides a clear overview of the purpose of this Excel tutorial. The right side of the image presents the result of the methods ...

Creating and Editing Comments in Excel (4 Practical Examples)

While working in Microsoft Excel Sometimes we feel the need to create and edit comments so that other users can see and reply according to them. I ...

Viewing Excel Worksheets in Multiple Ways

In this tutorial, we will be discussing how you can view worksheets of an Excel workbook in multiple ways. For example, look at this workbook. ...

How to Hide and Unhide Excel Worksheets from a Workbook

If you are looking for how to hide and unhide Excel worksheets from a workbook, then you are in the right place. In some situations, while using ...

Excel Table vs. Range: What Is the Difference?

A Range in Excel An Excel Range is a set of two or more cells. It is represented by the combination of the reference of the first cell and the last ...

Excel Table Formatting Tips – Change the Look of the Table

When we create a table, Excel applies the default table style. Say I want to make the following range into a table. I just select any cell within the ...

How to Add or Remove Cell Borders in Excel

In the last edition of our posts, you read about aligning contents in the cells in all directions possible. Today we will be focusing on cell borders ...

How to Enable and Use Synchronous Scrolling in Excel (2 Cases)

Synchronous scrolling allows you to view and compare two Excel workbooks or two worksheets within the same workbook simultaneously. It’s a handy ...

What Is the Order of Operations in Excel (An Ultimate Guide)

Here is the order of operations in Excel and their precedence: Order and Precedence of Operations 1 - Parentheses Operator In ...

How to Use Paste Special Command in Excel (5 Suitable Ways)

We are all familiar with Cut/Copy and Paste commands. They’ve been around since the early days of word processing, and they are universal across ...

How to Use Microsoft Excel for Beginners (25 Common Tasks)

This article is intended for beginner users of Excel. We will discuss the basics of how to use Microsoft Excel and describe how to do 25 of the most ...

The Excel Function Arguments

How to Show the Function Arguments in Excel 1. Show the Function Arguments While entering a Function When you enter the function name and the first ...

Data Clean-Up Techniques: Fill Blank Cells in Excel (4 Ways)

Sometimes we keep some blank cells to understand that they will be the first filled ones, have a look at our dataset to understand it. But sometimes ...

How to Change a Vertical Column to a Horizontal row in Excel – 6 Methods

This is the sample dataset. This will be the output: Method 1 - Change a Vertical Column to a Horizontal row using the Paste ...

How to Import Data in Excel (from Text, CSV, Database, Web etc.) – 10 Methods

The image above showcases a CSV (Comma Separated Values) file which was imported to an Excel worksheet.   Method 1 - Importing ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo