Excel Basics

Excel Formula for Working with Positive and Negative Numbers

In this Excel tutorial, you will learn how to work with positive and negative numbers using Excel Formula. We will discuss how to do these using ...

Excel Conditional Formatting Icon Sets with Relative Reference

While working with Microsoft Excel, to emphasize specific numbers or make specific cells simple to recognize we use Conditional Formatting. According ...

How to Create a Table with Existing Data in Excel

In this article, we will learn to create a table with existing data in Excel. The Table is one of the most powerful features of Excel. It helps the ...

How to Add Header in Excel (5 Quick Methods)

We can insert header on each page of our Excel worksheet to make it more classy and professional. Headers typically contain some fundamental ...

What is an Unqualified Structured Reference in Excel?

Excel Tables assign names to each table and column header within a table. Referring the assigned column header names to formulas within and outside ...

How to Lock Zoom in Excel (Using VBA with Detailed Steps)

This article highlights how to lock zoom in excel. The zoom feature in Excel is a great way to quickly maximize or minimize the view as required. ...

How to Create New Sheets for Each Row in Excel (4 Quick Ways)

Sometimes, we need to create new sheets in our Excel workbook for each corresponding row of any dataset. We can do this task in several ways. In this ...

How to Use HLOOKUP with Structured Reference in Excel

The HLOOKUP function in Microsoft Excel searches for a specific value in the topmost row and column of a table in order to extract data from a table ...

How to Create Multiple Sheets in Excel with Different Names

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default ...

How to Insert Sheet from Another File in Excel (3 Easy Ways)

In this article, we will learn to insert a sheet from another file in Excel. Excel users often need to insert files from another file. Sometimes, we ...

How to Create Table of Contents in Excel (6 Suitable Ways)

Sometimes you may have lots of data in different worksheets. In that case, you can use a Table of Contents to find out any worksheet easily. So, you ...

Find and Replace Tab Character in Excel (2 Suitable Ways)

Tab character plays a vital role in Excel usage. With this character, we can quickly create four spaces in one hit. But, during data analysis and ...

How to Use Drawing Tools in Excel (2 Easy Methods)

While working in Microsoft Excel you might need to draw various shapes in the workbook. Does it seem possible? Can we really draw inside a ...

[Fixed!] Undo and Redo in Excel Not Working (3 Simple Solutions)

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default ...

How to Zoom in on Map Chart in Excel (5 Easy Methods)

An Excel Map chart is used to represent and compare values over geographical regions. For better understanding and to make the values of the Map ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo