Excel (Intermediate)

Current Status

Price

Closed

Get Started

This course is currently closed

Excel (Intermediate)

This intermediate Excel course is designed for users who are comfortable with the basics and ready to take their spreadsheet skills to the next level. Through a structured, practical approach, this course covers customisation, data manipulation, formatting, functions, and visualisation techniques that boost productivity and confidence in Excel.

Duration: 5 - 6 Hours
Publisher: LearnHUB, Powered by Regent Business School
Certification: A Certificate of Completion will be issued to all candidates who successfully complete the requirements of the programme.
Take your time and ensure to carefully engage with every aspect of this course, to ensure adequate preparation for the final assessment. A minimum of 80% is required to pass.

Learning Outcomes

Customise the Excel interface by modifying the Ribbon, Quick Access Toolbar, and Excel Options to streamline their workflow.
Manage and manipulate worksheets efficiently, including selecting cells, moving sheets, autofitting content, and using AutoFill for repetitive tasks.
Improve navigation and visibility of large datasets by applying freeze panes, hiding/unhiding rows and columns, and using split panes effectively.
Apply advanced formatting techniques such as conditional formatting, number alignment, borders, and table styles to enhance spreadsheet readability.
Create and modify charts and functions, including text and database functions, combo graphs, and dynamic data ranges for better data analysis and visualisation.