Discover Array Formulas

If you haven't taken the opportunity to check out the fifth edition of ExcelTips: Amazing Array Formulas, you might want to do so in the near future. I released this new-and-improved edition about ten days ago, and the special sale will be ending in just a few more days.

What does that mean? It means that after Wednesday the price on this valuable e-book will return to normal (not a bad price, even then), but through Wednesday you can get your own download for 30% off the regular price.

ExcelTips: Amazing Array Formulas provides great detail on how you can use array formulas to calculate results in ways you can't do with regular formulas. Some folks have called array formulas a "regular formula on steroids," and with good reason; they are super powerful! They allow you to perform calculations on large amounts of data in a single step.

You can find more information about this new edition here:

     http://store.tips.net/T010130

Remember: the sale ends on Wednesday, so don't delay!

—Allen
     

ExcelTips (menu) for 8 December 2018

Graphics
Inserting from a Camera or Scanner

One of the ways you can insert graphics into a worksheet is by grabbing them from a digital camera or a scanner. This tip discusses how you can add pictures from these input devices.

Read this tip »

 
Online collaboration
Printing Web Discussions

If you are using the Web discussions feature built into some versions of Excel, you may want to print out a discussion at some point. It is easy to do if you follow the four steps in this tip.

Read this tip »

 
Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

 
Files
Don't Update Links to Other Programs

If you have links in your workbook to data in other workbooks, you may want to control whether Excel updates those links or not. Here's how to find the settings that Excel uses for that purpose.

Read this tip »

 
Powerful spreadsheets
Displaying a Count of Zeros on the Status Bar

Excel allows you to display the results of several common worksheet functions on the status bar. The available functions are limited, and you may wonder if you can add other functions to what is available.

Read this tip »

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  •  307-200-0450