Intermediate Excel Course (Two Days)

Course topic

PivotTables
You need to know them so that you can quickly find the information you are looking for in large tables and display it clearly. In addition to common examples, we will also show calculated fields, setting up a PivotTable source, or conditional formatting in a PivotTable.

Logical functions and their use in practice
It' s good to know - to be able to edit data using the WHEN, IFS, AND, OR functions. For these functions, it is very important to be able to combine them with each other - so we will focus on this area.

Linking tables (SEARCH, XLOOKUP)
Because it is not possible to work in Excel without a well-managed SEARCH function, which links tables. But even better (and newer) is XLOOKUP.

Text functions
The data you process often needs to be modified. And there are good features like CONCATENATE, CLEAN, DISCOUNT, FIND, REPLACE. We will show how to combine these functions with each other.

SUMIFS, COUNTIFS
Need to count totals and counts for only some items in large spreadsheets, and don' t want to frantically filter and copy? Then you need to master SUMIFS and COUNTIFS functions perfectly.

Date functions
Working in Excel with calendar data is easy and functions such as MONTH, YEAR, DAY OF THE WEEK, EDATE or NETWORKDAYS are very practical. So why not learn them properly?

Conditional formatting
It is not enough to have the right numbers. It is also necessary to be able to display them so that everyone can easily find their way around them. Conditional formatting is irreplaceable in this. We will learn the most basic procedures, but also a little more complicated cases where a formula is used for conditional formatting.

Power Query
Power Query is a new, very practical tool in Excel. It solves the connection to external data sources and thanks to it the user gets rid of frequent copying.

Keyboard shortcuts
It is not enough to work well with Excel - you also need to work quickly. And it' s not possible without clever keyboard tweaks.