Excel Intermediate

Updated on Nov, 2023

Language - English

Lectures -39

Resources -12

Duration -6 hours

30-days Money-Back Guarantee

Training 5 or more people ?

Course Description

You will learn how to use some of the more common functions like IF statements, CountIF , Vlookup, Hlookup and SumIf.  You will also see how you can create create superb visualisations using charts and maps.  The Pivot tables and charts feature will enable you to manage and report on large data sets and remain in control of your data no matter how complicated the raw data set looks.

Outline is below:

• Conditional formatting
• Average function/Count
• Maximum function/Sum
• Minimum function/SumIF
• Basic Scenarios
• Sheet Layout and design
• Named Cells/Ranges
• Absolute Referencing/ percentages
• Basic Pivot Tables
• Using 3-D Referencing
• Goal Seek
• Data Tables
• Sheet and cell Protection
• Using Array Formulae
• Using Group and Outline/Saving Views
• Naming Worksheets
• Using the Subtotals Feature
• Creating Templates
• Basic Lookups/Basic IF

Goals

What will you learn in this course:

• Understand how to automate Microsoft Excel using formulae and functions
• Use engaging and dynamic charts and graphs
• Understand how Data Analysis tools work
• Understand how Pivot tables work and how to use them
• Use database tools, Outline and Subtotals

Prerequisites

What are the prerequisites for this course?

• It is advisable to complete the Excel Introduction course before attempting this course. If you have used Excel for some time, this course is suitable. The course is not dependent on the Introduction course as it is a standalone course.

Curriculum

Check out the detailed breakdown of what’s inside the course

Overview
1 Lectures
• Overview 07:18 07:18
2 Lectures
Names, Ranges and Conditional formatting
7 Lectures
Group and Outline
6 Lectures
SmartArt
4 Lectures
Dynamic Charts
8 Lectures
Lookups
4 Lectures
Pivot Tables
4 Lectures
Data Analysis
2 Lectures
Final Exercise
1 Lectures

Instructor Details

Stephen Saxton

IT's Easy Training

I have delivered computer based training for over twenty five years. Training delivery takes three main formats, one to one, online and classroom based.  All courses have free training manuals and access to training examples if requested.  Course content is based on best practise commonly used in business. Topics, cover Microsoft Office, Project, Visio, Office 365 Apps and much more.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.