Date Manipulation Functions
Date Manipulation Functions How it works These functions allow manipulate dates within a selection of cells to convert them between […]
Number Manipulation Functions
Number Manipulation Functions How it works These functions allow manipulate numbers within a selection of cells to either convert between
Text Manipulation Functions
Text Manipulation Functions How it works These functions allow manipulate text within a selection of cells to either convert the
Split Column
Split Column How it works This function allows the user to split the contents of each cell in a column
Split Sheet
Split Sheet How it works This function allows a user to split a table into multiple sheets based on the
Spell Check
Spell Check How it works This is a shortcut to the Excel Spell Check function. How to use it: Step
Posted By
Posted By How it works This function generates a pivot table showing the number of transactions processed per individual. How
Flip Signs
Flip Signs How it works This function will swap a selection of values from negative to positive and from positive
Combine Active Workbook
Combine How it works This function allows users to combine tables within multiple sheets in the same document into one
Remove Ins and Outs
Remove Ins and Outs How it works The function allows you to remove transactions that share a reference number but