This practical training will ensure that employees understand the nature of the computer software they are using, know the shortcuts and can produce professional documentation using the various software tools.
Our studios are equipped with the most popular versions of the software – earlier or later versions can be offered on demand.
Who should attend?
Basic: Intended for students who want to learn basic Excel skills, such as performing calculations, modifying worksheets, formatting, printing and managing workbooks.
Intermediate: Designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher level functionality that Excel has to offer.
Advanced: Designed for the student who uses Excel extensively in their role and is familiar with its functions and formulas but has encountered a few challenges which they would like to overcome.
Course Outline
Basic Excel Training
- Getting started with Microsoft Excel
- Performing calculations
- Modifying a worksheet
- Formatting a worksheet
- Printing workbooks
- Managing workbooks
Intermediate Excel Training
- Customise the Excel environment
- Create advanced formulas
- Analyse data by using functions and conditional formatting
- Organise and analyse data sets and tables
- Visualise data by using basic charts
- Analyse data by using Pivot Tables, slicers and Pivot Charts
Advanced Excel Training
- Working with multiple worksheets and workbooks simultaneously
- Sharing and protecting workbooks
- Automating workbook functionality
- Applying conditional logic
- Auditing worksheets
- Using Automated Analysis tools
- Presenting your data visually
Accreditation and Certification
On completion of 1 days training, learners receive a UniCollege Certificate of Attendance.
On completion of 2 days training, learners receive a UniCollege Short Learning Programme Certificate – this is subject to learners passing an assessment.