We hosted expert facilitators Happy Ltd to develop a series of bespoke Excel training sessions to help upskill subscribers and enable them to work more effectively.
Sessions were kindly funded by Novartis Pharmaceuticals. Novartis had no editorial input into the content the sessions.
Covers some of the fundamentals including simple calculations, sorting and filtering, finding and replacing and useful shortcuts.
Covers more advanced and highly useful functions - IF, VLOOKUP, HLOOKUP and CONCATENATE - in order to manipulate data and link different datasets together.
Pivot tables are an easy way to summarise and present data. This session focuses on cross-referencing and analysing datasets with a few clicks of the mouse. It also covers filtering, formatting, adding a second data field, and adjusting the look-and-feel.
This session looked at more powerful pivot features including pivot charts, grouping into months or quarters, how to hide/display elements, calculate fields, and break out into separate sheets.
Focuses on effective data presentation including the use of conditional formatting for colour coding and easy extraction of key data, as well as the creation of charts, and understanding which charts are most effective with which types of data.
