Online Intermediate Excel Training

Microsoft Excel is one of the most widely used tools for professional, educational and personal use. If your role involves anything with numbers then intermediate Excel knowledge is essential for your career development. Employers regularly test Microsoft Excel skills during interview stages, and many will only consider candidates who can demonstrate strong level expertise in Excel.

Course Aim

This programme is designed to give learners intermediate-level proficiency in Microsoft Excel. Delivered by a Microsoft Certified Academy, the course ensures you receive up-to-date, professional-level training. Once completed successfully, you will earn a CPD Accredited Certificate. The course is ideal for those who prefer the flexibility of studying Excel online at an intermediate level.

Course Delivery

The training is completed via our online portal. The virtual tutor provides demonstrations, feedback, and corrections, closely replicating the experience of learning with a personal trainer. This interactive approach makes the learning process practical and effective.

Course Topics

• Working with Data and Tables
• Create and manage tables
• Present and sort data in a table
• Automatic calculations in a table, filtering
• Blank cells and duplicates
• Advanced filtering and statistics with a criteria range
• Copy rows filtered using a criteria range
• Summarise data with an outline
• Formulas and Functions
• Absolute reference in a formula
• Use cell ranges in functions
• Calculate with copied values
• Convert data; Create a data series
• Formatting and Validation
• Apply and manage conditional and custom formats
• Validation criteria
• Attach a comment to a cell
• Charts and Data Visualisation
• Create and customise charts
• Format chart items
• Modify chart’s text items
• Legend and plot area
• Data series and chart axes
• Manage series, chart templates
• Create and manage sparklines
• Objects and Layout
• Select, delete, copy and move objects
• Modify a text box, drawing
• Rotate, align, stack and group objects
• Sheets and Data Management
• Move, copy, hide sheets
• Copy values, copy with a link, transposing
• Display several lines of data in one cell

The average completion time is three months, although faster progress is possible for those who study more intensively. Learners are given up to 12 months to complete the course, allowing for full flexibility. Training can begin at any time.

Perquisites

This is an intermediate-level programme. Learners should already be comfortable with basic Excel. If you are not yet confident in those skills, we recommend completing the Beginner Excel Course first.

Why Choose This Course?

• Designed by Microsoft trainers at a Certified Academy
• Delivered on a live server with a Virtual Tutor for interactive learning
• Fully CPD Accredited, with certificate awarded upon successful completion
• Practical with plenty of exercises for hands-on experience
• Recognised internationally