Events

Training: Excel Pivot tables & data analysis

Training Excel
5/12 - 14/12
9 a.m. - 5 p.m.
Location, Veldkant 13, 2250 Kontich

Join our 2-day Basic T SQL training and get an introduction to the Set Theory and the basic SQL Internals.

Learnings:

Working with Tables

  • Difference between a list and a table (and switching between the two)
  • Table settings and formatting
  • Reference to columns and cells in a table
  • Sorting and filtering (the default options)
  • Creating more complex filters with the advanced filter
  • Sorting and filtering via the SORT, FILTER and UNIQUE functions

Extend tables

  • Extend tables using XLOOKUP, VLOOKUP, INDEX, MATCH
  • Extract and combine data via LEFT, MID, RIGHT, LEN, CONCATENATE, REPLACE and SUBSTITUTE

Tables Check

  • Controls via SUMIFS, COUNTIFS, COUNTA-RANK and conditional rank via COUNTIFS
  • Use conditional functions to improve your results: IF,IFERROR, AND, OR … FIND/SEARCH
  • Grouping and aggregating data via simple PivotTables

Power Query

Several of the above steps can also be done (better) using Power Query. Hence, we want to spend enough time on loading and transforming data through Power Query

  • Importing data from different sources
  • Working and correcting Data Types such as dates and commas
  • Deleting columns and rows-Adjusting data through transformations
  • Add conditional columns
  • Data load to Excel and/or the Data Model

Working in the Data Model

  • What is the data model-Calculating columns
  • Combining data from different tables via RELATED, RELATEDTABLE and LOOKUPVALUE
  • Creating simple measures

Save as

Saving files in different formats o. a.o.

  • CSV with custom encodings
  • CSV with custom delimiter (separator)

Pricing:

€250 excl. BTW for 1 day
€450excl. BTW for 2 days

Fill in this form to subscribe for the training:

P.S.: Don’t forget to check you spam folder if you haven’t reveived an email yet.

    Other events you might be interested in

    Cash Flow Forecasting
    21/02/2023
    Online
    Webinar: Cash Flow Forecasting

    Join our Webinar on the 21st of February to learn more about what cash flow forecasting is and how it can help your Finance team.

    Read more
    Training Query Plan
    18/04
    Veldkant 13, 2250 Kontich
    Training: Query Plan

    Do you like to know more about Query Planning? Then look no further and subscribe here.

    Read more
    Training T SQL
    21/03 & 28/03
    Veldkant 13, 2250 Kontich
    Training: Basic T SQL

    Join our 2-day Basic T SQL training and get an introduction to the Set Theory and the basic SQL Internals.

    Read more