Praha (12 000 Kč)
Brno (12 000 Kč)
Bratislava (510 €)
The use of MS Excel is your bread and butter? Do you want to learn how to create advanced analysis without programming? Do you want to look beyond the horizon and use Excel to its maximum with the cooperation of other applications? Do you analyze large volumes of data and wait for the recalculation of formulas with VLOOKUP function? Do you download data using MS Query tool , but the amount of JOIN operations in queries from time to time betrays you? Using a pivot table, but their expressive power is not good enough for you? It is high time to use Excel IN DIFFERENT WAY. Our new training is designed for all experienced users who want to use the analytical capabilities of data-oriented Microsoft server products from MS Excel 2013. Excel itself is a powerful analytical tool. But when using MS Excel as the client tools for MS SQL Server, the possibilities are gaining a new dimension. When traveling outside the Excel await PowerPivot, Power Query or DAX (Data Analysis Expressions).
Training for all Excel users with advanced knowledge and experience (Excel 3), who want to use Excel more efficiently in combination with other applications, with main focus on PowerPivot. Suitable training for business users, who need to perform advanced analysis in Excel and create reports. Everything without programming.
Good knowledge of MS Excel in the scope of MSEX313 course. Basic knowledge of databases concepts are suitable, but not required.
The prices are without VAT.