Excel tutorials

Customizations

Custom shortcuts in Excel

Custom toolbar in Excel

Workbook

Create a new workbook from a workbook template in your library

Save As or Email selected sheets as an Excel workbook or PDF

Scan & Fix in Excel

Printing made easy in Excel

Manage sheets in the workbook

Re-use model templates, sheets, and cells using library

Protect certain cells or entire worksheet

Choose to calculate formulas automatically or manually

Clean the workbook to make it client ready

Format

Cycle bullet formats

Cycle font color

Autocolor sheet or selection according to company standards

Easily format spreadsheets with header styles

Format as tables – without using tables!

Quickly add borders to spreadsheets

Use shortcuts to quickly pick-up and apply cell styles

Number

Cycle frequently used number formats

Cycle company standard formats for percentages

Easily format multiples

Cycle frequently used currencies

Cycle company standard date formatting

Quickly add or remove decimal places to numbers

Cells

Quickly adjust column width and row height using cycles

Resize a selection of cells to exact measurements

Automatically adjust column width and row height to match selection

Quickly reverse order of columns or rows while preserving references

Swap position of selected cells, rows, or columns

Formulas

Full transparency of inner working of model with Inspect formulas!

Toggle formula visualization to easily audit worksheet

Insert advanced non-standard formulas

Convert formulas to direct cell references to improve readability

Trace all precedents or dependents for a cell selection in single click

Improved fast fill with intelligent pattern detection

Wrap formulas in IFERROR with a custom error message

Quick access to Compound Annual Growth Rate (CAGR) formula

Advanced F2 that selects all equal formulas

Insert

Insert, show, hide, and remove standard Excel comments

Custom paste function allowing cells to keep original references

Insert a one- or two- variable sensitivity table

Try free