Microsoft Excel

Na kurzech skupiny Microsoft Excel vás naučíme vytvářet tabulky v programu Microsoft Excel, pohybovat se po tabulkách, plnit je daty, formátovat vzhled buněk a textu a celé tabulky graficky upravovat. Budete provádět výpočty pomocí vlastních vzorců a funkcí a seznámíte se s tvorbou a formátováním grafů. Naučíte se i pokročilejším technikám zpracování údajů v Excelu jako je zamykání, používání šablon a rozšířené kopírování. Budete sestavovat složitější vzorce a naučíte se filtrovat seznamy na listu, vytvářet kontingenční tabulky a pracovat s pokročilými funkcemi Microsoft Excelu pro manipulaci a analýzu dat.

Microsoft Excel – Basic Course

MSEX1 | Duration 1 day | 17 terms

Complete this course and get 90 days access to practice in e-learning version for free. You can choose the e-learning course in Czech, Slovak or English. This course is recommended for users, who need to learn quickly the basics [...]

Microsoft Excel – In Practice

MSEX2 | Duration 2 days | 20 terms

Complete this course and get 90 days access to practice in e-learning version for free. You can choose the e-learning course in Czech, Slovak or English. This course is assigned for users, who already work with Microsoft Excel on [...]

Microsoft Excel & Copilot workshop: data analysis with AI

MSCOP_EX | Duration 1 day | 8 terms

Join us for a one-day workshop "Microsoft 365 Copilot in Excel" where you will learn how to make your work more efficient with the help of the revolutionary tool Copilot. This course is for anyone who uses Excel 365 and wants to [...]

Microsoft Excel – In Practice – Workshop

MSEX2W | Duration 3 days | 16 terms

The course teaches users who already know the basics of working with spreadsheets how to make full use of its capabilities and create documents containing tables and charts to a professional standard. Participants are expected to [...]

Microsoft Excel – Advanced Methods and Functions

MSEX3 | Duration 3 days | 19 terms

Complete this course and get 90 days access to practice in e-learning version for free. You can choose the e-learning course in Czech, Slovak or English. This course is assigned for skilled Microsoft Excel users, who want to use [...]

Microsoft Excel – for Economists

MSEXE | Duration 2 days | 5 terms

Kurz je určen pro pokročilé uživatele programu Microsoft Excel a zaměřen na vysvětlení a procvičení ekonomických funkcí a výpočtů na konkrétních příkladech. U účastníků kurzu se předpokládají předchozí znalosti v rozsahu kurzu [...]

Microsoft Excel – Data Analysis and Statistic Calculations

MSEXST1 | Duration 2 days | 4 terms

At the course participants meet advanced data analysis methods. All standard statistical - analytic functions are discussed especially the Analysis ToolPack Add-Inn which is used for demanding statistical analyses. Listeners learn [...]

Beyond Excel I.

MSEXNL | Duration 3 days | 10 terms

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? [...]

Beyond Excel II.

MSEXNL2 | Duration 2 days | 10 terms

Family of PowerBI (self-service BI) tools is rapidly expanding (PowerMap,PowerBI Desktop, DAXStudio, BI included Office 365, ...). Each of the tools is a deep set of functionalities. As a response to feedback from participants in our [...]

DAX in Power Pivot Add-in

DAXPP | Duration 1 day | 5 terms

This one-day training will help you understand the new types of functions in Excel, particularly in Power Pivot Add-in. We will learn to distinguish computed columns from measures, we will find out which is more suitable for various [...]

Microsoft Power BI Desktop

PBID | Duration 3 days | 16 terms

Microsoft Power BI Desktop is a full featured alternative to the Power BI addins / features that can be integrated into Microsoft Excel. Both alternatives are intended for the creation of corporate decision-making reports in whole [...]

Microsoft Power BI Desktop - Advanced Techniques

PBID2 | Duration 2 days | 9 terms

Do you have slow Power BI reports even on a more powerful machine? Do you want to know how to make a data model correctly and how to secure it correctly? How to think when creating reports and teamwork from the ground up? Come to [...]

Microsoft Excel for Project Managers

MSEXPM | Duration 2 days | 4 terms

Máte na starosti menší projekt a hledáte vhodný nástroj pro jeho řízení a rádi pracujete s MS Excelem? Ukážeme si, jak v něm vytvořit časový harmonogram a vhodně nasimulovat Ganttův diagram. Poté pokročíme dál k přiřazení úkolů [...]

Microsoft Excel – Macros for Users

MSMAK1 | Duration 1 day | 9 terms

This training is suitable for experienced users of Microsoft Excel, who want to learn about how to use a mechanism called macros as a tool that allows you to automate routine activities (formats, data transformation, preparation of [...]

Microsoft Excel – Developing Applications I

MSEX5 | Duration 5 days | 6 terms

This course covers the basics of Visual Basic for Application (VBA), which is used for creating macros and automating work in Microsoft Excel. Participants will learn to work with Microsoft Excel object model, using the basic objects [...]

Microsoft Excel – Developing Applications II

MSEX6 | Duration 4 days | 5 terms

In this course you get a lot of practical skills that are needed for developing applications for MS Excel. You learn how to access the file system and write their own procedures for Import / Export, you access an SQL database server [...]

Microsoft Excel

Top courses

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details