Upcoming training dates

Loading Events

« All Events

  • This event has passed.

CIPHR Report Designer – Aug 8-9 2019

8th August 2019 - 9th August 2019

[fusion_separator style_type=”single solid” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” sep_color=”” top_margin=”25″ bottom_margin=”25″ border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”100%” alignment=”center”][/fusion_separator]

← Return to Training Calendar | View all available dates for this Course

[fusion_separator style_type=”single solid” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” sep_color=”” top_margin=”25″ bottom_margin=”25″ border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”100%” alignment=”center”][/fusion_separator]

This two-day course is designed to introduce users to the functionality of CIPHR Report Designer. The emphasis during the two days will be to equip the delegates with the knowledge to create new reports to sort, analyse and investigate data held in the CIPHR product.

Attendance on this training event equates to 5.5 CPD hours.

[fusion_separator style_type=”single solid” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” sep_color=”” top_margin=”25″ bottom_margin=”25″ border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”100%” alignment=”center”][/fusion_separator]

Preconditions

It is expected that delegates will have previous knowledge of CIPHR and/or have attended the CIPHR HR Administration course.

[fusion_separator style_type=”single solid” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” sep_color=”” top_margin=”25″ bottom_margin=”25″ border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”100%” alignment=”center”][/fusion_separator]

Objectives

Delegates should complete the course able to:

  • Demonstrate a comprehensive knowledge of the subset function in CIPHR
  • Identify and use the various steps involved in the production of a CIPHR report template
  • Compare the different output types that are available in the CIPHR Report Designer product
  • Demonstrate knowledge in using the various Microsoft Excel analysis tools on the CIPHR data
  • Define and use the function of embedding a chart into the report based on the selected data

[fusion_separator style_type=”single solid” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” sep_color=”” top_margin=”25″ bottom_margin=”25″ border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”100%” alignment=”center”][/fusion_separator]

Course Content

The CIPHR Report Designer course will cover:

  • The use of the subset form in order to classify groups of people to be displayed on a report
  • Using the step-by-step approach to creating a new report and the implications of checking out and checking in a new and existing template report
  • Ordering, sorting and filtering the data once it has been exported to Microsoft Excel
  • Placing data into bands and totalling and subtotalling the various bands
  • Creating and scheduling reports to be generated, in a selected format, on a recurring day, date and time
  • Using Microsoft Excel’s summarisation tool, pivot tables, to turn the data in order to view it from different perspectives
  • Using functions and formulae in Microsoft Excel to calculate and return values using the specified CIPHR data
  • Producing a graphical representation of the data as a component of the report
  • Adding created reports to the CIPHR menu tree for ease of access

Please note that the training will be conducted on the latest version of the product. If any differences exist between this and previous versions, these will be highlighted by the trainer.

This outline represents the topics which are usually covered on this event. The actual course work may be adjusted to suit the individual needs of the delegates.

[fusion_separator style_type=”single solid” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” sep_color=”” top_margin=”25″ bottom_margin=”25″ border_size=”” icon=”” icon_circle=”” icon_circle_color=”” width=”100%” alignment=”center”][/fusion_separator]

Submit booking request

    Your name (required)

    Your organisation (required)

    Your work email address (required)

    By submitting this enquiry form you accept the terms of our Privacy Notice

    Details

    Start:
    8th August 2019
    End:
    9th August 2019
    Event Category:

    Venue

    Organiser