Lookup Logic Update

This past Wednesday I announced the release of Lookup Logic: Harnessing Excel's 17 Most Powerful Functions, and the response has been very gratifying.

Dozens of professionals have already grabbed their copies, and the feedback is outstanding:

I had no idea XLOOKUP could do so much. I spent an hour yesterday converting my old VLOOKUP formulas and my workbooks are cleaner, faster, and easier to maintain. This book paid for itself in the first chapter.
— Michael T., Financial Analyst

The FILTER function section is a revelation. I've been manually filtering and copying data for years. Now I have dynamic reports that update automatically. Game-changer!
— Sarah K., Operations Manager

I was intimidated by Dynamic Arrays, but the book explains them so clearly that I was building sophisticated formulas within an hour. The combination of UNIQUE and SORT for dropdown lists alone was worth the price.
— David R., Data Analyst

Finally, a resource that focuses on modern Excel instead of rehashing the same old VLOOKUP tutorials. This is what I've been looking for.
— Jennifer L., Business Intelligence Specialist

There are only a few days left to save 30%

The introductory discount ends Tuesday, November 11, at 11:59 PM Pacific Time. After that, prices return to normal.

Order Now!

—Allen
     

ExcelTips (menu) for 8 November 2025

Spelling
Setting Spell-Checking Options

The spell checker can come in handy when entering data in a worksheet. Because the type of data you enter can vary so much from worksheet to worksheet, it is good that you can configure the spell checker to either ignore or pay attention to certain items.

Read this tip »

 
Worksheets
Relative Worksheet References

Copy a formula from one place to another and Excel helpfully adjusts the cell references within the formula. That is, it adjusts everything except the names of any worksheets that may be referenced in the formula. Here's how you can get around that lack of change.

Read this tip »

 
Making Sense of Times and Dates

One of Excel's great strengths is its ability to work with huge amounts of raw data. Two of the most common types of data stored in Excel are times and dates. Working with these special data types is not as easy as it may first seem. Check out ExcelTips: Times and Dates and learn the secrets of working with your times and dates.

 
Formulas
Returning Least-Significant Digits

Do you ever have a need to return just a few digits out of a number? This tip shows different formulas you can use to return the three right-most digits in a four-digit number.

Read this tip »

 
Powerful spreadsheets
Setting Stable Column Widths in a PivotTable

When you update a PivotTable, Excel can take liberties with any formatting you previously applied to the PivotTable. Here's how you can protect the column widths you want for the PivotTable.

Read this tip »

     

Special Note!

I've been publishing ExcelTips for years. Decades, actually. The newsletter you are reading right now is for very old versions of Excel. I still publish it because I know that some people are still using very old versions of Excel. Most people, however, are using newer versions of the program. If you are are using a newer version of Excel (2007, 2010, 2013, 2016, 2019, 2021, or the version in Microsoft 365), then you should seriously consider changing to the version of the newsletter designed for you. You can do so by clicking this link.

Thanks for your support of ExcelTips, and I hope you enjoy whichever version of the newsletter you receive. If you have any questions, just let me know.

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939