Efficiency Tools - Excel
Excel functions designed to increase your efficiency.
Each function should save you few seconds. These seconds accumulate over time!
Pricing plan
Each function should save you few seconds. Sometimes it is the little things that matter.
All prices shown include VAT. If your organisation is interested in unlimited seats or perpetual license, contact us to discuss the pricing.
Selected Features
See some of the Efficiency Tools features in action:
Create ToC (Table of Content)
Report Last Cell
Format Dynamic Range
Add IFERROR
Other Features
Toggle Gridlines
Toggle gridlines in all worksheets
Zoom to 100%
Set zoom to 100% for all worksheets
Format Theme Color
Reformat Theme Colors into RGB color for selected worksheets
Copy Sheet as Values
Copy selected worksheets as value
Copy Sheet as Link
Duplicate current worksheet with a direct link to it
Make Delta Sheet
Copy selected worksheet as value and as delta
Multiply by -1
Multiply selected range by minus 1
Multiply by 1,000
Multiply selected range by 1,000
Divide by 1,000
Divide selected range by 1,000
Hardcode Formula
Hard-code formulas which contain input term across the entire worksheet if a single cell is selected, otherwise hard-code only the selected range
Transpose
Transpose selected range into destination cell of current worksheet
View to A1
Set view to A1 for all worksheets
Pivot Table - Classic View
Transform a selected pivot table into a classic view, remove all subtotals and repeat all row labels
Pivot Table - Add Subtotal
Add subtotals on top of selected pivot table
Pivot Table - Remove Autofit
Remove autofit of selected pivot table
Hidden Ranges
Unhide all hidden name ranges
Hidden Worksheets
Unhide all hidden and very hidden worksheets
Group All
Group all rows and columns in selected worksheets
“Streamline your day with ease.”
From data modeling and reporting to end-to-end automation, let us simplify your processes and help you focus on what matters most. Contact us today to get started!
