Sessions were kindly funded by Novartis Pharmaceuticals. Novartis had no editorial input into the content the sessions.
Basic Excel training
In the first session, Nicky Stone of Happy Ltd covers some of the fundamentals of Excel including simple calculations, sorting and filtering, finding and replacing and useful shortcuts.
In the second session, Nicky focuses on on using some 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.
Building on the previous pivot tables session, 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.
Charts and conditional formatting
The final session in the Excel training series, focused 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.