IT Training

Excel 2019/365 – Level 2

Dealing with the important basic functions. Nesting functions. Using the powerful analysis tools. Creating automated templates and macros. The new Office interface, using the File tab (“Backstage”).

Who should attend this course?

This course is designed to train advanced users concerned with complex accounting, financial or scientific applications

Prerequisites

Know the basic features of Excel (Formulas, Functions)

  • Working with the most important functions.
  • Nesting functions.
  • Mas
    • Working with the most important functions.
    • Nesting functions.
    • Mastering powerful analysis tools.
    • Create models.

    tering powerful analysis tools.

  • Create models.

Review tips & tricks to optimize calculation operations

  • Managing the principle of calculated cell addresses (Absolute, relative and mixed references)
  • Inserting functions by using the Assistant or by inserting manually (inserting text in a function, using criteria and equations, using range names, …)
  • Nesting functions

Manipulating categories of functions

  • Working with “Statistical functions” (Average, Max, Median, …)
  • “Logical” functions
    • Using conditional formatting with values and formulas
    • Using logical functions (Countif, Sumif, If, And, Or, …)
  • Using “Text” functions (Left, Find, Upper, Concatenate, …)
  • Using Date and Time functions
    (Now, Today, Year, Month, Day, …)

Automating worksheets by using Formulas and Functions

  • Validating data in lists
  • Using and optimizing the “Vlookup” function

Introduction to databases

  • Using the vocabulary which is specific for databases
  • Learning to create a database file which enables an efficient analysis of the information
  • Managing personalized toolbars to analyse data
  • Tips to guarantee data integrity
  • Using range names

Simple analysis tools

  • Being able to sort: simple sort, sort criteria and first key sort order
  • Using the autofilters
  • Using Group and Outline to improve the visibility of data

Analyzing data by using Pivot tables

  • Knowing the features which are needed for the creation of pivot tables
    • Hiding elements
    • Using the integrated calculations (average, count, max, min…)
    • Sub-totals
    • Updating data
  • Grouping items (manually, automatically)
  • Consolidating data from multiple tables

Creating customized charts

Working with templates

Recording macros

Tips and tricks / exercises

Practical information

Duration

2 Days

Languages

FR / NL

Price

€700,00 + 3% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

French courses
27/1 - 28/1Book
24/2 - 25/2Book
24/3 - 25/3Book
28/4 - 29/4Book
30/5 - 31/5Book
23/6 - 24/6Book
28/7 - 29/7Book
25/8 - 26/8Book
29/9 - 30/9Book
27/10 - 28/10Book
24/11 - 25/11Book
15/12 - 16/12Book

Share this course on

Book your training

Enter your information to confirm your booking.

    Prerequisite test

    Looking for a tailor made solution?