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