Prior knowledge: Basic Excel skills equivalent to Excel1 Format: One hour hands on This course builds on Excel1 to make spreadsheets that are more robust for data entry and that help to analyse the data that they hold. This course includes: Using conditional formatting to highlight data Validating entries using […]
Uncategorized
3 posts
Prior knowledge: A good knowledge of common Excel features Format: One hour hands on This course will help you understand and build more complex formulae to create active worksheets. This course includes: Understanding different cell references Using named ranges Order of evaluation for formulae Using IF and CountIf formulae Using concatenate (&) String […]
Prior knowledge: A good knowledge of common Excel features Format: One hour hands on Pivot tables can be used to summarise large tables of data in Excel. They are simpler to use than they first may appear and are a really useful tool to have an understanding of. This course includes: […]