Microsoft Excel - Beyond Advanced

Learning Management Systems

Learning Platforms

Microsoft Excel - Beyond Advanced

This course is aimed at attendees who want to expand their knowledge into some of the more complex functions, build reports using form controls, work with Power Pivots and use built-in automation offered by Microsoft Excel.

Suitable for:

Advanced Excel users

Duration:

1 day

Learning style:

Virtual Classroom

Assured by:

Resources Included:

About this course

This course is aimed at attendees who want to expand their knowledge into some of the more complex functions, build reports using form controls, work with Power Pivots and use built-in automation offered by Microsoft Excel.

PRE REQUISITIES

Attendees who wish to attend this Microsoft Excel course should have attended our Excel Advanced course or be competent with the following advanced functions: IF, VLOOKUP, HLOOKUP, SUMIF and COUNTIF and have created and edited Pivot Tables.

Download Course Overview

Course dates

We are currently accepting admissions for the following upcoming cohorts:

24th April 2025

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

On completion of this course, you will be able to

Use Statistical, Lookup, Date, and text functions
Working with Form Controls
Carry out "What-If Analysis" using Scenario Manager and Goal Seek
Use advanced features of Pivot Tables
Get and load data from CSV/Text file
Work with Power Pivots and Power Queries

You may also like

View all courses

Train the Trainer

Who trains the Trainer? Training is not just about what you know; it is also about how you communicate that knowledge to an audience.

Virtual Classroom

Microsoft Power BI Introduction

You will learn to use Power BI (Business Intelligence) Desktop to create visual reports and dashboards. You will also understand how the reports and dashboards can interact with each other and the great level of interactivity the audience can use to drill, filter, sort and create calculations.

Virtual Classroom

Bringing Presentations Alive

Transform your presentations into an engaging and memorable experience, fostering effective communication that captures attention, evoke emotions that make your presentations memorable.

Self-Led Online

Resolving Meeting Challenges

When faced with a meeting that encounters challenges, it's essential to diagnose and resolve the issues promptly. You will learn strategies to bring the meeting back on track which involve a combination of five techniques to address specific problems.

Self-Led Online

Get in touch

Teaching 4 Business provides online courses and learning management systems to businesses across a range of industries.

+44 3700 800 800

hello@teaching4business.com

155 Wellingborough Road
Rushden
Northamptonshire
NN10 9TB

Thank you for your message, it has been received and we will respond shortly.

Oops! Something went wrong while submitting the form.

Popular Courses

Company

Teaching 4 Business is part of the We Teach You Group

© 2024 Teaching 4 Business

Designed & developed by Finn Elliott.