# Features

## Excel Filter: Basic to Advanced

Filter Basics First Excel's AutoFilter is a great feature to quickly display the rows in your data table that meet a certain criteria. The remaining rows that don't match your criteria are automatically hidden. Once you have your selection in view, you can edit

## Conditional Format Index Match Result

Highlight the lookup value in Excel Excel Conditional Formatting the Index Match result in a data table In some cases, it would be a good idea to highlight the result of the Index Match lookup formula inside the original data set based

## Excel Solver example and step-by-step explanation

Handle complex data models and solve for the optimal solution. Excel Solver example and step-by-step explanation Excel’s Solver tool can do complex statistical modeling. There are many ways to benefit from it when you want to manipulate multiple cells to get

## Excel Goal Seek Explained in Simple Steps

Find the required numbers to achieve a target value. Excel Goal Seek Explained in Simple Steps In cases where you have a target value that is derived from a formula and you need to find the required numbers to achieve it, Excel’s Goal

## How to Set a Default Theme in Excel

Set your default Excel theme to the theme of your choice. How to Set a Default Theme in Excel When you create a new Excel workbook, you'll notice that it always reverts to the Office theme color by default.   However, in some cases, you might

## Smart Uses of Custom Formatting

Use Custom Formatting instead of Conditional Formatting in Excel. Smart Uses of Custom Formatting We normally use custom formatting to show numbers with thousand separator, as percentage or even to show green for positive and red for negative values. But we hardly

## Smart Uses of Custom Formatting – Part 2

Smart Uses of Custom Formatting - Part 2 Explore the possibilities of Custom Formatting with Part 2 of our guide. If you missed it, check out Part 1. CHAPTER 4: Any Symbol of your choice for Deviations

## Excel Table Design

Use data tables when you want the reader to look up individual values and do exact one-to-one comparisons. Data tables are ideal for effectively presenting different types of data - such as costs, quantities, ratios, etc. - all in one place.   Let’s look at

## Conditional Formatting Symbols

How to use Own Symbols in Excel and Conditionally Format Them You'd like to use symbols in your reports to bring attention to certain tasks or results? You find the icons available in Excel's Conditional Formatting limited? You'd like something different to make your

## Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3)

You'll learn a few methods to replace the TRANSPOSE function In Part 3, I show you how you can use the INDIRECT, ROW, ADDRESS and later INDEX functions to avoid the use of TRANSPOSE which requires CSE Make sure you watch PART 1 and