This course can be delivered face-to-face or online (although not at the same time 🙂). There are Public (open to all) or closed courses (just for your organisation). Please get in touch to find out more. TOPICS COVERED: Exploring Excel • Customising the ribbon • Using templates Managing Workbooks • Formatting & worksheet techniques • Page set-up and print options Working with Data • Sorting (2 or more fields) / custom sorts • Auto & Advanced filtering • Filling data quickly Basic Formulas • Adding, subtracting, multiplying & dividing Basic Functions • Autosum, average, count, max & min Summarising Data • Using subtotal (to quickly find sum, average, count etc on sorted data) • Using 3D formulas (totaling data from identical sheets into a master sheet) • Using the consolidate function (totaling data from non-identical sheets into a master sheet) • Linking data from different workbooks Tables • Creating and editing tables (adding rows, columns & formulas and using slicers to find information quickly) Data Validation • Drop down menus (creating lists to help with accurate data input) • Basic data validation & error messages (to help with accurate data input) Absolute cell referencing & named cells • Absolute (using $ to fix reference cell into position) • Named cells (naming individual cells and ranges) Conditional Formatting • Basic conditional formatting (colour-based formatting to highlight, emphasise & differentiate data) Basic Pivot Tables • Introduction to PT’s (quickly summarise large amounts of data without changing the layout of the original data) Introduction to the IF Function • IF Statements (to evaluate certain conditions) • Introduction to the IFERROR function (to stop error messages such as #Null! #N/A! etc)