In This Chapter
A utility, in general, is something that enhances software, adding useful features or making existing features more accessible. This chapter is about Excel utilities:
- Exploring Excel utilities and utilities in general
- Why use VBA to develop utilities
- What you need to know to develop good utilities
- Step-by-step details for developing a useful Excel utility to manipulate text in cells
- Where to go for more Excel utilities
A Fabulous new Excel Add-In for Power Pivot Written by Matt Allington on 28 January 2016. The Excel Utilities. An Excel Utilities Ribbon Tab - Users of Excel 2007 and higher can now access all features of the Excel Utilities add-in from a new Excel Utilities Ribbon Tab. The layout of this tab has been optimized for wide screen monitors and provides one-click access to the 23 most commonly used features. One-Click Access.
Power Utilities For Excel 2007
As you’ll see, creating utilities for Excel is an excellent way to make a great product even better.
A utility isn’t an end product, such as a quarterly report. Rather, it’s a tool that helps you produce an end product. An Excel utility is (almost always) an add-in that enhances Excel with new features or capabilities.
Download Power Tools For Excel 2003-2007 for free. This addin project for excel 2003 provides a base platforms for addtional functionalities be added upon the same and bring the most advanced features to excel in the simplest manner and interconnect features by external providers (like Google/SQL).
Excel Utilities Free
- PowerPivot: Install the PowerPivot Add-In for Excel PowerPivot for Excel is a free download that significantly expands the data analysis capabilities of Excel. PowerPivot is made up of the Excel free add-in and the SharePoint server component.
- Save time with ASAP Utilities for Excel “The most popular add-in for Excel users” ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel. Since 1999 it has grown to become probably one of the world's most popular add-ins for MS Excel. “A must have for anyone who spends time in Excel”.
Excel is a great product, but many users soon develop a wish-list of features that they would like to see added to the software. For example, some users prefer to turn off the dotted-line page break display, and they want a feature that toggles this attribute so that they don’t have to scroll through the Excel Options dialog box looking for the command. Users who work with dates might want a pop-up calendar feature to facilitate entering dates into cells. And some users desire an easier way to export a range of data to a separate file. These are all examples of features that aren’t currently available in Excel. You can, however, add these features by creating a utility.
Utilities ..