Microsoft Excel Intermediate

Infero Training Ltd

Short course

In Nottingham

Save 5%
£ 188 VAT exempt

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Intermediate

  • Location

    Nottingham

  • Duration

    1 Day

  • Start date

    Different dates available

You will learn a lot of things about Excel, including how to create advanced formulas and organize your data into tables. You'll discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons.

This course is suitable for anybody wanting to learn 2016, 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.

Facilities

Location

Start date

Nottingham (Nottinghamshire)
See map
Gothic House, Barker Gate, The Lace Market, NG1 1JU

Start date

Different dates availableEnrolment now open

About this course

Upon successful completion of this course, students will be able to:

Create advanced formulas.
Analyse data with logical and lookup functions.
Organize worksheet data with tables.
Visualize data by using charts.
Analysing data with PivotTables, slicers, and PivotCharts.
Insert graphic objects.
Enhance workbooks

This course is designed for individuals who already have foundational knowledge and skills in Excel and are ready to advance their data analysis skills and abilities through the application of advanced Excel functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts

Prerequisites

Before taking this course, students are recommended to take the following course, or have equivalent knowledge:
Microsoft Excel Introduction

The Infero Training Website at:
http://www.inferotraining.com/training-courses/microsoft-excel-courses_4.html

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft Excel
  • Excel Advanced Formulas
  • Organize table data
  • Present data as charts
  • Excel
  • MS Excel
  • Microsoft excel training
  • Excel 2013
  • Excel 2010

Teachers and trainers (1)

Richard Blackmore

Richard Blackmore

Trainer

Course programme

Lesson 1: Creating Advanced Formulas

Topic 1A: Apply Range Names
Topic 1B: Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions

Topic 2A: Leverage Questions and Testing to Write Formulas
Topic 2B: Use Logical and Lookup Functions to Find Answers to Questions

Lesson 3: Organizing Worksheet Data with Tables

Topic 3A: Create and Modify Tables
Topic 3B: Sort and Filter Data
Topic 3C: Use Summary and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Charts

Topic 4A: Create Charts
Topic 4B: Modify and Format Charts
Topic 4C: Create a Trendline
Topic 4D: Create Advanced Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

Topic 5A: Create a PivotTable
Topic 5B: Filter Data by Using Slicers
Topic 5C: Analyze Data by Using PivotCharts

Lesson 6: Inserting Graphics

Topic 6A: Insert and Modify Graphic Objects
Topic 6B: Layer and Group Graphic Objects
Topic 6C: Incorporate SmartArt

Lesson 7: Enhancing Workbooks

Topic 7A: Customize Workbooks
Topic 7B: Manage Themes
Topic 7C: Create and Use Templates
Topic 7D: Protect Files

Additional information

Clients receive Microsoft Approved courseware, 100% cash back satisfaction guarantee, free refreshments, pub lunch, certificate & 12 months post-course support.

See related categories

Microsoft Excel Intermediate

£ 188 VAT exempt

The best Excel courses

See all

See all