Monday, November 3, 2014

ASAP Utilities for Excel

ASAP Utilities is and always will be the best hands-down add-on for Excel day-to-day users.

http://www.asap-utilities.com/blog/

I used the "Copy values to empty cells below filled cells selection" function twice and it told me I saved 2 minutes using ASAP Utilities.  I believe it too!

Another command that a couple finance people I worked with in the past could have used is "Export worksheet as separate files", especially when dealing with 500 franchise worksheets.

Convert Text? to numbers, quick numbering, random numbering...

Not to mention a few other tricks...

Please do not remove this header 
Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com)
Title Active Name Full name Type
Analysis ToolPak FALSE analys32.xll C:\Program Files\Microsoft Office 15\root\office15\LIBRARY\ANALYSIS\analys32.xll Add-In
Analysis ToolPak - VBA FALSE atpvbaen.xlam C:\Program Files\Microsoft Office 15\root\office15\LIBRARY\ANALYSIS\atpvbaen.xlam Add-In
ASAP Utilities TRUE ASAP Utilities.xla C:\Program Files (x86)\ASAP Utilities\ASAP Utilities.xla Add-In
Euro Currency Tools FALSE eurotool.xlam C:\Program Files\Microsoft Office 15\root\office15\LIBRARY\eurotool.xlam Add-In
Solver Add-in FALSE solver.xlam C:\Program Files\Microsoft Office 15\root\office15\LIBRARY\SOLVER\solver.xlam Add-In
Power View TRUE AdHocReportingExcelClientLib.AdHocReportingExcelClientAddIn.1 not available COM Add-In
ASAP Utilities Library Package (is needed for ASAP Utilities) TRUE ASAP_Utilities.adConnect not available COM Add-In
Microsoft Power Map for Excel TRUE ExcelPlugInShell.PowerMapConnect not available COM Add-In
Microsoft Power Query for Excel TRUE Microsoft.Mashup.Client.Excel not available COM Add-In
Inquire TRUE NativeShim.InquireConnector.1 not available COM Add-In
Microsoft Office PowerPivot for Excel 2013 TRUE PowerPivotExcelClientAddIn.NativeEntry.1 not available COM Add-In

No comments:

Post a Comment