Excel Intermediate

person icon Stephen Saxton

Excel Intermediate

Get the best out of the most common and useful features in Microsoft Excel

updated on icon Updated on Nov, 2023

language icon Language - English

person icon Stephen Saxton

architecture icon Excel Formulas and Functions,Excel,Microsoft,Office Productivity

Lectures -39

Resources -12

Duration -6 hours


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 8,500+ top Tutorials Point courses anytime, anywhere.

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
  • Linking Sheets and Workbooks
  • Using Array Formulae
  • Using Group and Outline/Saving Views
  • Naming Worksheets
  • Using the Subtotals Feature
  • Creating Templates
  • Basic Lookups/Basic IF


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


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.  
Excel Intermediate


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

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

Instructor Details

Stephen Saxton

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.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us