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

Primavera P6 - Building an EPS Structure and Creating Projects: 31st March (09.00 – 9.45)

  • Creating EPS elements
  • Defining the programme structure
  • Navigating the EPS structure
  • Finding programmes
  • Creating projects
  • Setting project properties
  • Validating projects
  • Assigning project codes

Primavera P6 - Building a Work Breakdown Structure and Setting Top Down Budgets: 31st March (10.00 – 10.45)

  • Creating a Work Breakdown Structure (WBS)
  • Creating WBS elements
  • Work package management
  • Allocating top down budgets

Primavera P6 - Detailed Activity Planning: 31st March (11.00 – 11.45)

  • Creating activities
  • Task types
  • Relationship types
  • Creating relationships
  • Adding milestones
  • Assigning activity codes
  • Using steps
  • Using the schedule function

Primavera P6 - Resourcing: 31st March (12.00 – 12.45)

  • Resource types
  • Creating resources
  • Resource attributes
  • Assigning resources
  • Switching resources
  • Split load resource assignment
  • Reduced hours resource assignment
  • Using roles

Primavera P6 - Checking Workload and Baselining: 31st March (13.15 – 14.00)

  • Reviewing workload
  • Dealing with resource conflicts
  • Assignments view
  • Creating baselines
  • Assigning baselines

Primavera P6 - Working With Layouts: 31st March (14.15 – 15.00)

  • Creating layouts
  • Customising columns
  • Setting filters
  • Sorting and grouping
  • Changing the timescale
  • Customising the Gantt
  • Creating activity code breakdown structures

Primavera P6 - Progressing the Schedule: 31st March (15.15 – 16.00)

  • Updating task status and remaining duration
  • Setting the data date

Primavera P6 - Printing and Reporting: 31st March (16.15 – 17.00)

  • Printing your schedule
  • Printing to other packages
  • Exporting and importing information
  • Primavera standard reports
  • Creating custom reports

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

Microsoft Project - Setting up your project: 8th April (9.15 – 10.00)

  • Project defaults
  • Project start date
  • Setting default hours per day/week
  • Setting daily working times

Microsoft Project - Building a Project Plan: 8th April (10.15 – 11.00)

  • Creating a work breakdown structure
  • Adding tasks and durations
  • Estimated durations
  • Setting milestones
  • Recurring tasks
  • Linking activities
  • Setting start dates and dependencies

Microsoft Project - Resourcing Your Project: 8th April (11.15 – 12.00)

  • Assigning resources
  • Filtering available resources
  • Managing resources
  • Resource properties

Microsoft Project - Task information: 8th April (13.00 – 13.45)

  • Constraint dates
  • Setting deadlines
  • Assigning task specific calendars
  • Task types

Microsoft Project - Updating Your Project: 8th April (14.00 – 14.45)

  • Completing work
  • Completing work per resource
  • Updating tasks
  • Updating the project
  • Rescheduling work
  • Change highlighting