“We make you the company's Excel guru!”
Quick Start: 48 Practical Tricks to Save Hours in Excel with ASAP Utilities
These short tutorials show you how to benefit from the tools in ASAP Utilities and are guaranteed to save you time and speed up your work in Excel. Enjoy!
- Tip 1: Quickly perform a calculation on all selected cells at once
- Tip 2: Quickly deselect cells from a selected range
- Tip 3: Get rid of unwanted spaces in your data
- Tip 4: Quickly add a prefix or suffix to your data
- Tip 5: Select cells automatically based on their contents, formatting, etc.
- Tip 6: Quickly change the text-case in all selected cells at once
- Tip 7: Quickly (un)protect all sheets at once
- Tip 8: Save and create a timestamped backup
- Tip 9: Insert a border or blank row after repeating cell values in a column
- Tip 10: Save Chart or Range as picture (JPG, PNG, vector etc.)
- Tip 11: Save time with keyboard shortcuts
- Tip 12: Quickly sort your sheets by their value or tab-color
- Tip 13: Quickly insert multiple sheets at once
- Tip 14: Quickly edit or export cell comments
- Tip 15: Quickly make numbers positive or negative
- Tip 16: Quickly extend your selection down to the end without scrolling
- Tip 17: Quickly toggle Full Screen with the F11 key
- Tip 18: Quickly remove blank rows from a long list
- Tip 19: Easily strip leading zeros from your numbers
- Tip 20: 'AutoFit Row Height' on merged cells too
- Tip 21: Quickly fill blank cells with value above in Excel
- Tip 22: Easily remove certain or several characters at once
- Tip 23: Fast calculation on selected cells
- Tip 24: Easily remove leading characters
- Tip 25: Quickly save worksheets as separate files
- Tip 26: Easily count and/or color duplicate values
- Tip 27: Sort your data on anything that you can think of
- Tip 28: Quickly close multiple workbooks at once
- Tip 29: Quickly copy page layout settings from one sheet to other sheets
- Tip 30: Quickly re-start the last used tool
- Tip 31: Test your model/template in different screen resolutions
- Tip 32: Quickly find the tool you need
- Tip 33: Easily change the text in selected cells to UPPERCASE
- Tip 34: Easily insert an English formula in your non-English Excel version
- Tip 35: Easily transpose 1 column into multiple rows, creating a table
- Tip 36: Quickly select or filter by strikethrough formatted text
- Tip 37: Easily keep only the filtered results
- Tip 38: Quickly fix the trailing minus sign for negative numbers
- Tip 39: Easy ways to combine the contents of multiple cells
- Tip 40: Auto numbering on steroids
- Tip 41: Quickly reset the last cell and minimize the used range
- Tip 42: Quickly round the numbers in selected cells
- Tip 43: Easily COUNT or SUM cells based on their Color
- Tip 44: Quickly remove spaces from the beginning and end of your data
- Tip 45: An easier way to fix the numbers that Excel doesn't recognize
- Tip 46: Quickly clean up your data in Excel
- Tip 47: Quickly save just your selection or sheet as a new file
- Tip 48: Easily move and resize your range selection(s) in Excel (Video Tutorial)