Tue 9 and Wed 10 July (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 UNISON members
Application Details
This course is now fully booked.