Held in April 2020 this Q&A session covered tips and trick and then went on to the questions. The manual has the tips and tricks.

Tips and Tricks included in manual

• Rounding formulas with ROUND function

• Warning on MROUND function

• Inserting a note in a formula

• Using AutoCorrect to reduce typing

• Inserting line breaks using a formula

• Linking a Textbox to a cell

• Finding colours and formats

Questions answered include

• Fixing different date structures

• Extracting the sheet name

• Inserting sub-totals in a table structure

• File size increase and fixes

• Charts for multiple categories

• XOR function

• Wildcards and SUMPRODUCT

• Rounding and formats

• TRANSPOSE function

• Checkboxes

• Splitting names

• Following links