Excel Intermediate

person icon Stephen Saxton

Buy Now

Excel Intermediate

Name: Excel Intermediate
Price: 9.99 USD
Author: Stephen Saxton

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

Add to Cart Buy Now

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

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

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

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.