Notice: Failed to detect the JavaScript function. Some pages may not display correctly. ×

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

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.

Show more

Microsoft Excel – Basic Course

MSEX1 | Duration 1 day | 21 terms

Microsoft Excel – In Practice

MSEX2 | Duration 2 days | 20 terms

Microsoft Excel & Copilot workshop: data analysis with AI

MSCOP_EX | Duration 1 day | 13 terms

Microsoft Excel – In Practice – Workshop

MSEX2W | Duration 3 days | 14 terms

Microsoft Excel – Advanced Methods and Functions

MSEX3 | Duration 3 days | 18 terms

Microsoft Excel – for Economists

MSEXE | Duration 2 days | 8 terms

Microsoft Excel – Data Analysis and Statistic Calculations

MSEXST1 | Duration 2 days | 8 terms

Beyond Excel

MSEXNL | Duration 3 days | 10 terms

Beyond Excel II.

MSEXNL2 | Duration 2 days | 8 terms

DAX in Power Pivot Add-in

DAXPP | Duration 1 day | 7 terms

Microsoft Power BI Desktop

PBID | Duration 3 days | 14 terms

Microsoft Power BI Desktop - Advanced Techniques

PBID2 | Duration 2 days | 9 terms

Microsoft Excel for Project Managers

MSEXPM | Duration 2 days | 6 terms

Microsoft Excel – Macros for Users

MSMAK1 | Duration 1 day | 14 terms

Microsoft Excel – Developing Applications I

MSEX5 | Duration 5 days | 8 terms

Microsoft Excel – Developing Applications II

MSEX6 | Duration 4 days | 7 terms

Top courses

Software Architecture

GOC272

Duration 2 days

ITIL® 4 Foundation

ITIL4FPT

Duration 3 days

UML Language I

GOC26

Duration 2 days

Microsoft Azure Fundamentals

MOC AZ-900

Duration 1 day

Microsoft Copilot - AI in the Office

MSCOP1

Duration 1 day

Microsoft Excel – Basic Course

MSEX1

Duration 1 day

Modelling with Enterprise Architect in [...]

GOC260

Duration 3 days

Practical cryptography for IT pro as [...]

GOC161

Duration 3 days

PRINCE2® 7 Foundation

PRINCE2F7

Duration 3 days

Python I - introduction to programming

PYTHON_INTRO

Duration 5 days

System Center Endpoint Manager - [...]

GOC234

Duration 5 days

Introduction to SQL in MySQL

GOC660

Duration 3 days

Windows 11/10 - effective [...]

GOC214

Duration 5 days

Beyond Excel

MSEXNL

Duration 3 days

Generative AI - for Managers (Basics, [...]

AI_MANAGERS

Duration 1 day

Programming with C# Language I

GOC2124

Duration 5 days

Microsoft Azure Administrator

MOC AZ-104

Duration 4 days

Microsoft Excel – In Practice

MSEX2

Duration 2 days

Windows Server - administering [...]

GOC205

Duration 5 days

Programming with C# Language II

GOC2125

Duration 5 days

Business process modeling in BPMN

GOC270

Duration 3 days

Data Engineering on Microsoft Azure

MOC DP-203

Duration 4 days

Microsoft Power BI Data Analyst

MOC PL-300

Duration 3 days

Complete Administration of Microsoft [...]

GOC6345

Duration 5 days

Networking and TCP/IP Basics and [...]

GOC2

Duration 5 days

Microsoft Excel – Advanced Methods and [...]

MSEX3

Duration 3 days

Network Security – Ethical Hacking

GOC3

Duration 5 days

Windows Server - Active Directory SAE, [...]

GOC159

Duration 3 days

Windows Server - Active Directory [...]

GOC171

Duration 5 days

Windows Server - Implementing and [...]

GOC175

Duration 5 days

Elastic Stack: Elasticsearch, Logstash [...]

ELASTICSTACK

Duration 3 days

CISSP - Certified Information Systems [...]

CISSP

Duration 5 days

PowerShell and PowerShell Core basics

GOC216

Duration 5 days

Web Application Vulnerabilities - [...]

GOC541

Duration 5 days

CompTIA Security+

CTSEC

Duration 5 days

Web Application Vulnerabilities - [...]

GOC542

Duration 5 days

Azure Active Directory for Active [...]

GOC218

Duration 4 days

Spring Boot Microservices

JSPRINGBOOT1

Duration 5 days

Linux – Administration

LXI2

Duration 3 days

Linux Networking

LXI3

Duration 3 days

ANSIBLE – Instrument for Collective [...]

ANSIBLE

Duration 2 days

DOCKER - Linux containers

DOCKER

Duration 2 days

OSINT investigation

GOC60

Duration 5 days

Windows Server - implementing Active [...]

GOC220

Duration 5 days