Excel Basics

Excel AutoFill (16 Useful Examples)

Here's an overview of the AutoFill feature when working with days of the week. Download the Practice Workbook Excel AutoFill.xlsm ...

Insert Row in Excel After Every Row and for Table: 8 Methods

Method 1 - Using Keyboard Shortcut Select row 7 and then press ALT+I+R. A new row has been inserted into your Excel sheet. You can use ...

How to Show Formulas in Excel (4 Easy Ways)

Here is an overview of showing formulas in Excel. How to Show Formulas in Excel? There are a few ways you can show formulas in Excel. ...

How to Find Anything in a String in Excel

Excel Find in String: Knowledge Hub How to Find Character in Excel String How to Find from Right in Excel How to Find Character in ...

String Manipulation in Excel

String Manipulation in Excel: Knowledge Hub How to Count Number of Characters in a Cell in Excel How to Extract Text from a Cell in Excel ...

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)

Serial numbers are important for sorting, ordering, and maintaining the consistency of data in Excel. In this article, you will learn how to create a ...

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 ...

Inserting Columns in Excel – 11 Methods

This is an overview: Download Practice Workbook Download the practice workbook. Inserting Column.xlsm This is the sample ...

How to Select Column in Excel (6 Easy Ways)

Here's an overview of how you can select a column by giving it a name. Read on to learn more. Download the Practice Workbook Select ...

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)

Here's a basic overview of selecting a row header to see its height. Download the Practice Workbook Row Height Excel.xlsx ...

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 Methods

This is an overview. Download Practice Workbook Download the workbook and practice. Indentation in Excel.xlsx Method 1 - ...

Excel Accounting Number Format (Apply and Customize)

Here's an overview of where you can find the Accounting format to apply it to cells. Download the Practice Workbook Accounting Number ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo