Excel Basics

Return Non Blank Cells from a Range in Excel (3 Suitable Ways)

Microsoft Excel is, in fact, a beneficial program. We can do many things with a given dataset using Excel's tools and features. In Excel, we often ...

How to Stop Cell Format Changes Automatically in Excel

Cell format changes automatically in Excel refers to the option where Excel automatically changes the format according to the data type. Sometimes ...

How to Create a Custom AutoFill List in Excel (2 Quick Methods)

The AutoFill feature of Excel is an excellent tool that saves both time and labor. It has some built-in list like a series of numbers to autofill. ...

How to Perform Tab Navigation in Excel (8 Easy Ways)

Here are two simple ways to navigate worksheet tabs in Excel: To move to the adjacent sheet tabs, press Ctrl+PgDn to move to the next sheet, and ...

How to Create Drawing Register in Excel (With Easy Steps)

Want to learn the basics of a drawing register? Well… you have landed in the right place. This tutorial will provide a complete overview of the ...

How to Create Approval Workflow in Excel (with Easy Steps)

Imagine you are in a team but the situation does not go in favor of you and your team members that you hardly communicate with them. So how will you ...

How to Convert Old Excel Files to New Format (2 Quick Ways)

While working in Excel, we often need to deal with Excel files in an old format. As a result, we encountered a number of compatibility issues. To ...

How to Make Catalogue in Excel (with Easy Steps)

In this article, I will show you how to make a catalogue in Excel. As we know, a catalogue is a collection of items, organized systematically to make ...

How to Create a Stopwatch in Excel (with Easy Steps)

Microsoft Excel is one of the most useful applications available, and we can utilize a dataset unlimitedly using Excel's features and tools. In this ...

[Solved!] Excel Scaling Issues (2 Easy Methods)

While printing Excel files, some issues related to scaling may occur and create disturbance to the user. To solve the scaling issue, a user needs to ...

How to Create Data Dictionary in Excel (with Easy Steps)

If you want to create a data dictionary in Excel, you have come to the right place. Here, we will walk you through 3 easy steps to do the task ...

[Fixed!] Excel to PDF Size Problem While Printing

Microsoft Excel is considered one of the most valuable tools currently accessible. With Excel's tools and capabilities, it is feasible to perform an ...

How to Make a Picture Catalog in Excel (with Easy Steps)

A picture catalog is an attractive tool to showcase your product. Moreover, it can also help to give audiences a clear idea about the company ...

How to Catalog Books in Excel (2 Easy Methods)

Excel is now widely used to track records of inventories such as supply chains or libraries for book collection management. One of the most common ...

SmartArt in Excel: All Things You Need to Know

Drawing shapes and adding text boxes is tiring and time-consuming. SmartArt in Excel is a feature introduced by Microsoft that has a set of ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo