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