Excel for Intermediate

person icon Stephen Saxton

3.9 ★★★ ★ ★

Buy Now

Excel for Intermediate

Name: Excel for Intermediate
Rating: 3.9 (56 reviews)
Author: Stephen Saxton

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

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Stephen Saxton

English [CC]

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

Lectures -39

Resources -12

Duration -6 hours

3.9 ★★★ ★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ 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

Goals

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

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

Linking Sheets and Files
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

Course Certificate

Use your certificate to make a career change or to advance in your current career.