Microsoft Excel: Intermediate

TRAINING COURSE

Microsoft Excel: Intermediate

RELATED COURSES

Analysing Data with Excel
Microsoft Excel Fundamentals
Microsoft Excel: Advanced
Microsoft Power Automate
Microsoft Power BI Boot Camp
Microsoft PowerApps

Details

You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

This course is designed for students who already have foundation knowledge and skills in Microsoft Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

 

Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method Duration Price (excl. VAT)
Live Virtual Training 1 days GBP 485.00 Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Download Brochure


Information may change without notice.

Audience

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web

Pre-Requisites

Microsoft Office Excel Fundamentals

Course Outline / Curriculum

Lesson 1: Working with Functions

    • Work with Ranges
    • Use Specialized Functions
    • Work with Logical Functions
    • Work with Date & Time Functions
    • Work with Text Functions

Lesson 2: Working with Lists

    • Sort Data
    • Filter Data
    • Query Data with Database Functions
    • Outline and Subtotal Data

Lesson 3: Analyzing Data

    • Create and Modify Tables
    • Apply Intermediate Conditional Formatting
    • Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts 

    • Create Charts
    • Modify and Format Charts
    • Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts  

    • Create a PivotTable
    • Analyze PivotTable Data
    • Present Data with PivotCharts
    • Filter Data by Using Timelines and Slicers

Schedule Dates and Booking

There are currently no scheduled dates.

Please note that this course needs a minimum of 4 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.

Add me to the waiting list

Should you need this course urgently, the following options are available:

  1. Pay for 4 delegates (whether you have them or not) and we will schedule the course as soon as possible.
Submit Enquiry