Excel training

Excel

We have worked with expert facilitators Happy Ltd to develop and host a series of bespoke Excel training sessions to help upskill subscribers and enable them to work more effectively. Recordings of the sessions and accompanying training materials can now be viewed by subscribers below.

Sessions were kindly funded by Novartis Pharmaceuticals. Novartis had no editorial input into the content the sessions. 

 

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. 

element locked This element is only available to subscribers - if you're a subscriber then please  LOGIN or register to view.

Useful functions

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.  

element locked This element is only available to subscribers - if you're a subscriber then please  LOGIN or register to view.

Pivot tables

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. 

element locked This element is only available to subscribers - if you're a subscriber then please  LOGIN or register to view.

Advanced pivots

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. 

element locked This element is only available to subscribers - if you're a subscriber then please  LOGIN or register to view.

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. 

element locked This element is only available to subscribers - if you're a subscriber then please  LOGIN or register to view.

Tags: