ONLINE
25 and 26 March 2025 (9.30am-1.30pm)
This course is for those people who really want to find out how Excel can help them perform better. Gain the skills to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.
Upon successful completion of this course, students will be able to:
- Enhance productivity and efficiency by streamlining the workflow.
- Collaborate with other workbook users
- Protect and Secure worksheets
- Analyse data using various techniques
- Work with Pivot Tables
- Import and export data
- Integrate Excel data with the web
- Effectively use macros
Course content:
- Further Functions and Formulas: Naming a range: Working with dates: Complex Excel functions: Conditional functions
- Other features: Conditional formatting: Data validation
-
- Manipulating data within lists: Advanced data filtering: Advanced data sorting: Data analysis with subtotals: Pivot Tables
- Protecting information: Protecting worksheets: Protecting workbooks: File protection
- Macros: Understanding Macros: Creating Macros: Working with Macros
- The future of Excel. A look at Visual Basic
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 all UNISON members.
Application Details
This course is now fully booked.