Excel Basics

### How to Perform If Zero Leave Blank Formula in Excel (3 Methods)

In this article, we will discuss how to perform if zero leave blank formula in excel. Sometimes you are dealing with a worksheet that requires you to ...

### How to Generate Moving Average in Excel Chart (4 Methods)

Moving average is a common term in time-series analysis to review previous data and predict the future. In this article, Iâ€™ll show the fundamental ...

### How to Convert Date to Number in Excel (4 Methods)

In many situations, we need to convert Date to Number in Excel to accomplish a calculation. Working with Date and Time values is one of the trickiest ...

### How to Hide Columns in Excel (4 Simple Methods)

In some situations, you may want to hide one or more columns in an Excel worksheet. Obviously, Excel allows users to easily hide columns. You might ...

### Different Types of Lookup to Apply in Excel (8 Types)

Certainly, one of the frequent uses of Excel is looking up a value in a table or data range. Now, Excel contains a couple of dedicated lookup ...

### How to Freeze Rows in Excel (6 Easy Methods)

In this article, we will discuss how to freeze rows in Excel. Often, we have to work with spreadsheets containing a larger number of rows and ...

### How to Select Row in Excel If Cell Contains Specific Data (4 Ways)

Sometimes you may need to select an entire row based on any specific data in a cell of that row. You can do the task in multiple ways. In this ...

### How to Lock Rows in Excel (6 Easy Methods)

When working with huge datasets in Excel, it is common to wish to lock some rows or columns. So we can see their contents while navigating to another ...

### How to Move Cells in Excel with Arrow Keys (6 Methods)

Sometimes while working on a large worksheet, we need to move cells in Excel to work faster and for the ease of working. We can move cells in Excel ...

### How to Copy a Cell in Excel Using Formula(7 Methods)

Copying a cell in Microsoft Excel is an important feature when we deal with different kinds of data. There are lots of ways to copy a cell value. ...

### Fix: Excel Cannot Shift Nonblank Cells (4 Methods)

While working in Excel, sometimes we need to add or Shift a Row or Column in our Worksheet. When we insert a new Cell then it pushes the next cell up ...

### If Cell is Blank Then Show 0 in Excel (4 Ways)

In Excel, if there is no data in any cell, it normally remains blank. But you can display 0 in the blank cells by following some techniques. In this ...

### How to Convert Timestamp to Date in Excel (2 Suitable Cases)

In short, a timestamp is a sequence of characters used to specify the date and time of a day. Of course, any specific time or event can be expressed ...

### How to Unhide Rows in Excel (8 Quick Ways)

On the off chance that there is data on our worksheet we don't have to see, we can hide those which we would rather not see. Then, when we want that ...

### How to Use Excel EXACT Function (6 Suitable Examples)

The Excel EXACT function tests two text strings and returns TRUE or FALSE depending on their exact match or otherwise respectively. The EXACT ...

Advanced Excel Exercises with Solutions PDF