Functions
— Filter function
— Make text all uppercase or lowercase
— Merge text from multiple cells into one
— Networdays
— Sort and SortBy
— TextBefore - TextAfter
Features
— Analyse Data
— Apply and customise themes
— Change colours set
— Check performance
— Checkbox
— Clipboard history
— Create a form in Excel
— Custom sort
— Filter columns
— Focus cell
— Import a table from a PDF file or website
— Merge multiple files from a folder
— Multi-selection with CTRL and/or SHIFT
— Sort data
— Sorting data by color
— Translate a document
— Use Microsoft 365 templates
PivotTable
— Create a PivotTable
— PivotChart
— Recommended PivotTables
Charts
— PivotChart
— Recommended Charts
Interface
— Compare 2 files simultaneously via synchronous scrolling
— Compare two tabs of the same file
— Rearrange your windows
Layout
— Create a custom shape
— Scale to fit printing
— Set print area
POWER QUERY
— Change the load options
— Comments in steps
— Import a table from a PDF file or website
— Import queries without leaving the editor
— Merge multiple files from a folder
— Multi-selection with CTRL and/or SHIFT