Excel Basics

Skip to the Next Result with VLOOKUP If a Blank Cell Is Present – 3 Methods

This is the sample dataset. Method 1- Combining the VLOOKUP and the IFNA Functions Steps: Enter “Ben” in B13. Enter the following ...

How to Remove Table Formula in Excel (With Quick Steps)

Using the table formula in Excel is a quick and easy method for referencing data tables and creating formulas inside them. The table formula in Excel ...

How to Move a Row to the Bottom If a Cell Contains a specific Value in Excel – 2 Methods

The sample dataset contains customer name, product brand name, sales amount, and target status. Some cells of the target column display “ Passed” . ...

How to Move Rows to Columns in Excel (4 Effective Ways)

Excel is exceptionally well to handle and calculate large datasets. When working with large datasets, it is a frequent need to move rows in Excel to ...

How to Move a Row to Another Sheet Based on the Cell Value in Excel (2 Methods)

Dataset Overview Often, we need to move or copy rows based on cell values to different worksheets for various purposes. The cell value can be in any ...

The Quick Access Toolbar is Missing in Excel – 6 Solutions

This is an overview. Why is the Quick Access Toolbar Missing? Possible Reasons: It was Accidentally Removed. The Customized Quick ...

How to Print Background in Excel (With Easy Steps)

Sometimes we need to print a dataset in Excel with a background. We can insert a background to our dataset if we choose the Background option from ...

How to Use Header and Footer in Excel (3 Quick Ways)

People like to have their things decorated. Header and Footer are one of the most amazing features to decorate Microsoft Excel worksheets. If you ...

How to Flip Data from Horizontal to Vertical in Excel (6 Methods)

Dataset Overview We will be working with the following dataset, which includes product names and their corresponding total prices. Our task is to ...

How to Turn Off AutoSum in Excel (2 Easy Ways)

Every time a cell is modified, Excel by default updates every formula in a workbook. This may cause work to become slower, especially in complex ...

How to Sum Negative and Positive Numbers in Excel – 2 Methods

To sum positive and negative numbers in the dataset: Method 1 - Sum Only Positive Numbers 1.1 Using SUMIF Function Sum all numbers above ...

How to Use Blue Line with Arrows in Excel

Method 1 - Add Precedent Arrows In cell D8, use this formula: =$D$4*C8 Cell D8 is preceded by cells D4 and C8. We can see this ...

How to Set Print Area for Multiple Pages in Excel (2 Ways)

To demonstrate our methods, we'll use the following dataset:   Method 1 - Using Set Print Area Option STEPS: Select the cells ...

How to Group and Hide Columns in Excel (3 Easy Methods)

Method 1 - Using Excel Ribbon to Group and Hide Columns in Excel Steps: To hide the Product ID and Sold Amount, you need to group them first. ...

How to Flip Data Horizontally in Excel – 3 Methods

These are the sample datasets.   Method 1 - Using the Sort Command to Flip Data Horizontally in Excel  Steps: Select any ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo