Excel Basics

How to Change Date Format in Excel (4 Ways)

Dates are one of the most common data types we use in Excel. Using and interpreting dates can be confusing, as Excel has several formats to display ...

Serial Number in Excel (With Practical Examples)

In this article, you will learn about creating the serial number in Excel. We will show you how to create a serial number in Excel using built-in ...

Filter Data in Excel

Filter Data in Excel: Knowledge Hub Filter Data in Excel Using Formula How to Filter Cells with Formulas in Excel How to Filter Email ...

Insert Column in Excel (All Possible Ways)

In this article, you will learn everything about how to insert a column in Excel. Throughout this article, we will discuss a total of 11 easy ways to ...

How to Select Column in Excel (6 Easy Ways)

In this article, you will find various methods on how to select column in Excel. You will find the way of selecting column using one click as well as ...

Move Rows in Excel (All Things You Need to Know)

In this article, we will learn how to move contiguous and non-contiguous rows or columns by using the Excel features and formula. The ability to ...

Row Height Excel (All Things You Need to Know)

In the article, you will get a complete overview of row height in Excel. You will learn about the default row height, and the ways to change, and ...

Excel Filter Not Working

  Excel Filter Not Working: Knowledge Hub Excel Filter Not Working After Certain Row Excel Not Filtering Entire Column Excel Filter ...

Indentation in Excel (5 Effective Ways)

In this article, you will learn about the indentation in Excel. You get to know how to indent by using ribbon, shortcut and many more methods. We ...

Excel Accounting Number Format (Apply and Customize)

Using the Accounting Number Format in Excel is easy and can be done in a variety of ways. You will learn to apply accounting number format in ...

Currency Format in Excel (Format, Change & Remove)

Currency format in Excel allows you to present numbers as currency amounts, complete with currency symbol, decimal precision and many other ...

Excel Auto Formatting (Add, Customize, Use & Remove)

In this article, we are going to explore how to use auto formatting in Excel and how we can modify and remove the formatting in Excel. We have used ...

Excel Number Format (from Toolbar, Ribbon and Dialog Box)

In this Excel tutorial, you will learn how to apply the number format. You can access number formatting options from the toolbar, ribbon, and number ...

Data Entry Form in Excel

Data Entry Form in Excel: Knowledge Hub How to Create Data Entry Form in Excel How to Make an Excel Spreadsheet Look Like a Form How to ...

Cell Styles in Excel (All You Need to Know)

In this article, we will show you all the features and benefits of cell styles in Excel. Particularly the default cell styles that enhance the visual ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo