Excel Tips
October 16, 2017
You have Excel data with icons, such as traffic lights. You want to find all of the red icons. You can sort or filter by color.
Iterate Multiple Random Results »
October 16, 2017
Using Excel's What-If Data Table to generate a bunch of random results. Even if you have a tricky formula that is the result of several steps, the Data Table will allow you to generate hundreds of answers to the model without repeating the model 100's of times.
Learn Excel Replace OFFSET with INDEX »
October 13, 2017
Excel's OFFSET function will slow your workbook's calculation. There is a better alternative: an unusual syntax of INDEX.
Consolidating to a Pivot Table »
October 12, 2017
Consolidate several ranges in Excel to a single pivot table. This episode will show you how.
October 11, 2017
Today, an ancient technique called Data Consolidation. If you have to combine data from multiple worksheets or multiple workbooks, Consolidation can handle the job if your data is in a specific format. Learn more about this ancient tool.
October 10, 2017
There is a killer formula for extracting the unique values that match a criteria. It requires Ctrl+Shift+Enter, but it is powerful and cool.
October 9, 2017
This article reveals hidden secrets about Excel number formatting. How you can store numbers in Excel but add words next to the numbers. Read on for more cool tips about number formatting.
October 6, 2017
SUMIF and COUNTIF were great when they were introduced in Excel 97. But they could only handle one condition. The new, superior SUMIFS handles up to 127 conditions.
October 6, 2017
How to use conditional formatting to mark cells that link to another worksheet or workbook.