Solution Development

• A Pivot Table is used to summarise, sort, reorganize data stored in a table.
• Lookup Functions in Excel mean referencing a cell to match values in another row or column against the cell and as a result retrieving the value.
• A Macro is a series of commands and instructions that you put together as a single command to accomplish a task automatically.
• Ctrl + a = Select All Text
• Ctrl + q = Removes all formatting from a highlighted paragraph.