Excel - If Functions, Lookups and Pivot Tables

Focus4 Training

Training

In Lutterworth

£ 125 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Location

    Lutterworth

  • Duration

    1 Day

This course covers how to create and use If Statements, Lookups and PivotTables to improve your spreadsheets and efficiency. Topics include: If/Or/And/IsError/NestedIf/VLookups/HLookups/Conditional Functions/Countif/PivotTables and Charts. Suitable for: Excel users who, at intermediate or advanced level, want to learn how to utilise these advanced functions and features to improve the efficency of their spreadsheets.

Facilities

Location

Start date

Lutterworth (Leicestershire)
See map
Focus4 Training Ltd - 9 High Street, LE17 4AT

Start date

On request

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

Course programme

Learn how to create and use If Statements, Lookups and Pivot tables to improve your spreadsheets efficiency. Topics include: If/Or/And/IsError/NestedIf/VLookups/HLookups/Conditional Functions/Countif/Pivot Tables and Charts.

COURSE CONTENTS:

The IF function

If/Or/And

IsError

NestedIf

If Then Else

VLookups

HLookups

Conditional Functions

Countif

Sumif

Pivot Tables

Pivot Charts

Exercise 1: IF Functions
Exercise 2: Nested If Functions
Exercise 3: Count and Sum IF
Exercise 4: IF/Or/And Functions
Exercise 5: Vlookup
Exercise 6: Hlookup
Exercise 7: PivotTables
Exercise 8: PivotCharts

See related categories

Excel - If Functions, Lookups and Pivot Tables

£ 125 + VAT

The best Excel courses

See all

See all