Courses
Learning Platforms
About us
Get in touch
Excel Advanced
This Excel Advanced course is aimed at people who want to expand their knowledge into some of the more advanced functions. The course also covers the creation, editing, and formatting of pivot tables and pivot charts, enabling dynamic data analysis and visualization. By the end, participants will possess a versatile skill set for efficient data management and analysis in Excel.
Get in touch
Suitable for:
Duration:
1 Day
Learning style:
Virtual Classroom
Assured by:
Resources Included:
About this course

In this Excel training course, learners will explore advanced functions such as lookup and error functions for precise data retrieval and error handling.

The training includes logical and statistical functions for effective data analysis, and learners will acquire skills in creating and using range names in formulas for improved organisation and data validation techniques are taught to set restrictions on data entry, promoting consistency.

Automation is introduced through basic macro recording, allowing users to streamline repetitive tasks.

COURSE PRE-REQUISITES:

Learners who wish to attend this course must have a good knowledge of Excel and be competent at working with formulas using absolute cell references, use basic functions like sum, average, max, min, count and be able to write formulas across multiple sheets and multiple workbooks.

Download Course Overview
Course dates
We are currently accepting admissions for the following upcoming cohorts:
  • 27th August 2024
  • 9th October 2024
Make an enquiry
Self-led online courses include
Support for over 100 languages
Mobile-friendly design for playback on any device
Progress tracking and pass/fail tests
Automatic, remote updates to keep content fresh
Playback speed controls to speed up/slow down the video
Closed captions which can be turned on/off
This course covers
  • Use lookup and error functions
  • Use auditing tools
  • Protect an Excel cell, worksheet and workbook
  • Use logical and statistical functions
  • Create range names and use range names in formulas
  • Set restrictions on data entry using data validation
  • Automate common task by recording a basic macro
  • Create, edit, format Pivot Tables and Pivot Charts
You may also like
View all courses
Get in touch
Teaching 4 Business provides online courses and learning management systems to businesses across a range of industries.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Teaching 4 Business is part of the We Teach You Group
© 2024 Teaching 4 Business
Designed & developed by Finn Elliott.