Details

Goals

Being able to use the advanced spreadsheet functionalities.

Prerequisite

Basic Excel skills.

Contents

Functions (refresh)

  • Insert Function using the wizard
  • Insert function manually, semi-automatic formula input

Use range names (refresh)

  • Create and use a range name
  • Edit and delete a range name, define its scope (file, spreadsheet)

Conditional formatting

  • Apply a predefined conditional formatting
  • Customize a conditional formatting

Advanced Functions

  • Use functions: SumIf, CountIf, Vlookup, If, And, Or, Match ….
  • Nested functions

Data Table

  • Create a data table (Insert Table)
  • Create formulas using references of a Data table

Managing Lists

  • Filter data: advanced filters
  • Remove duplicates
  • Use automatic totals (Subtotals)
  • Recommended Pivot Tables
  • Cross data into a table (PivotTable) or a graph (PivotChart)

Check data

  • Auditing tools
  • Achieve a target value (Goal seek)
  • Evaluate a formula

Consolidate Data

Sign up

Next session(s)

De

Mon. 13 Jul. Tue. 14 Jul. 2020

Fr

Mon. 13 Jul. Tue. 14 Jul. 2020

En

Thu. 23 Jul. Fri. 24 Jul. 2020

De

Thu. 13 Aug. Fri. 14 Aug. 2020

Fr

Thu. 20 Aug. Fri. 21 Aug. 2020

En

Thu. 27 Aug. Fri. 28 Aug. 2020

Fr

Thu. 24 Sep. Fri. 25 Sep. 2020

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!