Excel - Formulas Review: 30th March (9.00 - 9.45)
- Building formulas
- Ordering calculations
- Absolute cell references
- Using functions
Excel - Managing Multiple Worksheets and Linking Data Within a Workbook: 30th March (10.00 - 10.45)
- Moving and copying worksheets
- Inserting and deleting worksheets
- Grouping worksheets
- Changing the worksheet tab colour
- Linking between worksheets
Excel - Transferring and Linking Data Between Workbooks: 30th March (11.00 - 11.45)
- Linking between workbooks
- Using copy and paste link
- Creating formulas between workbooks
- Updating and managing links
- Changing source data
- Breaking links
Excel - Conditional Formatting: 30th March (12.00 - 12.45)
- Changing the cell format depending on set criteria
- Databars, Top/Bottom Rules, Colour Scales and Icon Sets
- Creating custom formula rules
Excel - Working With Data: 30th March (13.15 - 14.00)
- Organising data using Excel tables
- Sorting and filtering information
- Table formatting
- Adding calculations into table columns
- Adding total rows
- Removing duplicates
- Converting to an ordinary range
Excel - Setting up Data Validation: 30th March (14.15 - 15.00)
- Setting number and date validation
- Setting drop down list validation
- Setting custom validation
Excel - Analysing Information Using Pivot Tables: 30th March (15.15-16.00)
- Creating and modifying a Pivot Table
- Recalculating the Pivot Table
- Filtering the Pivot Table
- Searching the Pivot Table
- Drilling down to underlying data
Excel - Pivot Table Customisation: 30th March (16.15 - 17.00)
- Customising field names
- Changing field formatting
- Creating separate worksheet data from page/report fields
- Pivot Charts
- Using Slicers
VLOOKUP and HLOOKUP: 3rd April (10.00 - 10.45)
- Constructing a simple VLOOKUP function to draw information from another source
- Using HLOOKUP
Introduction to Macros: 3rd April (14.00 - 14.45)
- Macro concepts
- Recording macros
- Example macros
- Adding buttons to run macros
Logical Functions in Excel: 7th April (09.30 - 10.15)
- Creating an IF statement
- Using the AND plus OR functions
- Nesting functions