Excel tips by Misty'tips

Functions

— Basic Formulas – IF, AND, OR, XOR

— DATEDIF calculates the difference between two dates

— Filter function

— Find and replace a text or a format

— Make text all uppercase or lowercase

— Merge text from multiple cells into one

— Nesting Functions

— Networdays

— Sort and SortBy

— TextBefore - TextAfter

— Textsplit

— Translate

— Trim : Remove all unnecessary spaces from a text string

— Vstack : Consolidate several tables into one

— Xlookup

Features

— Analyse Data

— Apply and customise themes

— Change a document's header and footer

— Change colours set

— Change the display language

— Check performance

— Checkbox

— Clipboard history

— Copy a chart as a picture

— Create a form in Excel

— Custom sort

— Customize the number format

— Display an amount in $K

— Extract data from a picture

— Filter by color

— Filter columns

— Focus cell

— Freeze panes or split screen

— Hyperlink: change the displayed text

— Import a table from a PDF file or website

— Merge multiple files from a folder

— Multi-selection with CTRL and/or SHIFT

— Set different headers and footers for each page

— Show all cells containing formula (or other)

— Sort data

— Sorting data by color

— Translate a date to a week number

— Translate a document

— Use Microsoft 365 templates

PivotTable

— Counting Distinct Values

— Create a PivotTable

— Filter a PivotTable with slicers and timeline

— 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

— Switch to dark mode

Layout

— Create a custom shape

— Scale to fit printing

— Set print area

POWER QUERY

— Calculate age using Power Query or DAX

— Change the load options

— Choose columns

— Comments in steps