Functions

— Filter function

— Make text all uppercase or lowercase

— Make text from multiple cells into one

— Networdays

— Sort and SortBy

— TextBefore - TextAfter

Features

— Apply and customise themes

— Change colours set

— Clipboard history

— Custom sort

— Filter columns

— 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 queries without leaving the editor