Written by Allen Wyatt (last updated August 5, 2025)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
When creating workbooks, it can sometimes be intimidating to keep all the available worksheet functions straight. And for some functions, it can be downright impossible to put your finger on how to use the various parameters available. (Exactly how, again, am I supposed to put together the CHITEST function?)
Excel itself provides a modicum of help, visible as you start to type a function in a formula or through the use of the Insert Function tool. When you want more detailed information, though, you may be at a loss as to where to turn.
Here's a great resource you can download and use for free: the Excel Function Bible. Developed by Norman Harker and Ron de Bruin; the work is massive. It comes (appropriately enough) as an Excel workbook and an associated set of example workbooks.
You can find more information about this free resource here:
http://www.rondebruin.nl/efb/efb.htm
Note that it has been several years since the Excel Function Bible has been updated, so it doesn't include some of the functions released in newer versions of Excel. Even so, it contains a wealth of information that can be very helpful as you are trying to figure out how to use most of the functions available in Excel.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13342) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
When you need to count a number of cells based upon a single criteria, the standard function to use is COUNTIF. This tip ...
Discover MoreExcel provides a handy worksheet function that allows you to forecast values based upon a set of known values. This ...
Discover MoreExcel includes a handy function that allows you to repeat characters or strings of characters. How you use the REPT ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2025-08-23 07:18:34
Dr. Bartolo
I have for many years now used an add-in created by Greg Maxey called "Style Report" (which I cannot see mentioned in the earlier tip mentioned here). I use it to do what is described in this tip. The website where the add-in can be found (https://gregmaxey.com/word_tip_pages/style_report_addin.html) describes the add-in like this:
"With Style Report, users can quickly loop through the style collection and with the user interface provided make a decision to keep or delete the styles used in a document or previously used styles that are not applied to any text. [When] finished, Style Report summarises user actions and reports style status."
Have look if interested. I am not affiliated with Greg, and I give no guarantee that this will work for anyone reading this comment. But I have used this add-in successfully for a long time!
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments