Gourmet Excel Course (One Day)

Course topic

Gadgets in PivotTables
Can you use calculated fields, calculated items, cross-sections in PivotTables? Or append a table directly above the data model or above a Power Query query? Do you know how to prepare a PivotTable data source so that you don' t have to change it manually as the data grows?

Linking tables
Can you use the Power Query tool to link Excel files to it? Or easily evaluate outputs from SAP or other ERP systems with it? And can you create even more complex queries in Power Query?

Data model
Can you work with the data model of Excel files? Do you know in which situations you helped you? And can you present data from it well?

Conditional formatting at a higher level
How do conditional formatting and formulas, such as FIND or COUNTIFS, relate? How can conditional formatting rules be set in detail? And how to format a PivotTable?

Evaluation of dependencies between data
Do you know from your data if one quantity affects another? So e. g. How does an advertising campaign affect sales? Or the price of your products for profit? Do you know how to make simple statistical models in Excel, and especially how to understand them and use them for decision-making?

The solver
The solver vám pomůže i v situacích, kde běžné vzorce nestačí. It plans the distribution of employees in shifts or the optimal production plan. Can you use it?

Processing of large tables
If your spreadsheets have a few hundred records, that' s fine. If they have a few million records, it can be done. All you have to do is set up Excel correctly and choose the right features and tools.