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