Advanced Excel Archives - Page 18 of 65

Excel Slicer Greyed Out: 2 Methods

May 30, 2024

Method 1 - Greyed Out Slicer for Excel Table Reason: Earlier Version Slicers are not natively supported in older versions of Excel, such as Excel ...

How to Create Excel Floating Total Row (2 Quick Ways)

Nov 11, 2025

In this article, I am sharing with you how to create Excel floating total row with a running total. Creating a floating row with a running total in ...

How to Create Excel Floating Total Row (2 Quick Ways)

How to Make Slicer Horizontal in Excel

Jul 6, 2024

Excel slicer is a vital tool that gives users easy access to data filtering and interaction. Slicers are often shown vertically, however, a ...

Excel Slicer Multiple Columns: 3 Examples

May 24, 2024

Method 1 - Excel Slicer with Multiple Columns Find all the columns in the Excel slicer in a single column. You can see the below image. ...

Excel Slicer Multiple Columns: 3 Examples

How to Create Files From Excel List

Jul 3, 2024

Step 1 - Launch VBA Editor Go to the Developer tab. Select Visual Basic. Step 2 - Insert a Module Select Insert, Select ...

Unprotect Excel Sheet (Complete Guideline)

Jul 31, 2024

In this article, we will unpack how to unprotect an Excel sheet. We’ll also learn how to protect worksheets or workbooks, and even remove passwords ...

Unprotect Excel Sheet (Complete Guideline)

Excel Checkbox – How to Insert, Format and Remove

Aug 9, 2024

This is an overview. Download Practice Workbook Download the practice workbook. Checkbox in Excel.xlsm How to Add a ...

Excel Checkbox – How to Insert, Format and Remove

Excel Dynamic Range (Complete Guideline)

Nov 11, 2025

In this article, we will demonstrate how to create a dynamic range in Excel. We will go over topics including defining dynamic ranges, using ...

Excel Dynamic Range (Complete Guideline)

How to Print Excel Sheet (Tips and Tricks)

Nov 11, 2025

In this article, you get a complete guideline of how to print an Excel sheet considering different aspects. Printing Excel sheets is an essential ...

How to Print Excel Sheet (Tips and Tricks)

Dynamic List Excel (Complete Guideline)

Jun 20, 2024

Download Practice Workbook Dynamic List.xlsx Method 1 - Using FILTER and OFFSET Functions Based on Single Criteria: We will combine ...

How to Create a Database in Excel with Pictures (5 Easy Steps)

Jul 28, 2024

Step 1 - Create a Header Row in a Worksheet Open a new Excel workbook. Create a new worksheet (you can name it Employee Database or something ...

How to Create a Database in Excel with Pictures (5 Easy Steps)

Power Pivot Excel

Nov 11, 2025

Power Pivot Excel: Knowledge Hub Import Data Power Pivot Dax in Power Pivot Power Pivot Formulas << Go Back to Learn Excel

How to Use Excel UserForm as Date Picker (with Easy Steps)

Jun 14, 2024

Here's a dataset of sales data for a grocery shop. In the Date & Time of Sale column, users have to enter the date and time manually. This is not ...

How to Use Excel UserForm as Date Picker (with Easy Steps)

Power Query Examples

Nov 11, 2025

Power Query Examples: Knowledge Hub Dealing with Tables with Changing Headers in Power Query Compare Two Tables with Power Query in Excel ...

Excel Not Filtering Entire Column (9 Reasons with Solutions)

Jul 5, 2024

Here are some cases of Excel not filtering the entire column. Excel Not Filtering Entire Column: 9 Possible Reasons with Solutions ...