Tuesday 11 and Wednesday 12 June (9.30am – 1.30pm)
If you have some existing knowledge of Excel functions and wish to enhance and refresh your skills, this course is for you.
Learn to organise table data, present data as charts and enhance the look and appeal of workbooks by adding graphic objects.
Upon successful completion of this course, students will have the necessary skills to:
- Organise worksheet and table data using various techniques
- Create and modify charts
- Manipulate more complex formulas and functions
- Insert and modify graphic objects in a worksheet
- Customise and enhance workbooks and the MS Excel environment
Course content:
- Review of formulas and functions: further formulas and functions; working with dates and percentages; functions and the formula palette; absolute cell addressing; displaying underlying formula
- Printing and formatting: custom formatting; hiding columns and outlining
- Worksheets and workbooks: working with multiple worksheets; creating a workspace
- Working with lists: filtering data; sorting data; analysing data using subtotals
- Creating charts: modifying charts; printing charts; further customisation
- Other features: sharing workbooks; worksheet auditing; adding comments
- We finish by building our own spreadsheet using the knowledge we have gained.
Places on the course are limited and learners are expected to take part in hands-on activities. To get the best out of this online course the attendees should have access to a large screen device.
The course will be delivered online using MS Teams and it will take place over two morning sessions. Participants need to join both sessions.
YOU MUST ATTEND BOTH SESSIONS TO COMPLETE THE COURSE
This course is free for UNISON members
Application Details
This course is now fully booked.