Excel for CamSIS Users

Delegates will learn how to use shortcuts in Excel to improve their productivity, and also techniques for analysing complex data quickly by using pivot tables.

• Anyone who needs to process data exported from CamSIS Search
• Further details regarding CamSIS' eligibility criteria are available

NOTE: Not relevant to students

Number of sessions: 1

• Sheet navigation – keyboard shortcuts
• Changing column width - shortcut
• Deleting data
• Formatting data – Dates
• Formatting data – Text
• Formatting data –conditional formatting
• Using and protecting formulae
• Freezing panes
• Sorting and filtering
• Pivot Tables
• Inserting, colouring and renaming worksheets

To be able to:

• Quickly navigate around an Excel spreadsheet
• Format the data
• Sort and filter the data
• Use Pivot Tables to view the data in a different and clearer way

To become familiar with shortcuts in Excel, and the use of Pivot Tables for analysing data.

Presentations, demonstrations and practicals

One half day session

Monthly

• CamSIS
• CamSIS Reporting
• Reporting