Školení je určené pro pokročilé uživatele programu excel. Účastníci se na praktických příkladech seznámí s možnostmi využití různých pokročilých vyhledávacích a maticových funkcí a s novými funkcemi excelu v Microsoft 365. Zjistí, jaké jsou pokročilé možnosti podmíněného formátování. Rozšíří si znalosti pro práci s rozsáhlými daty a s nástroji pro citlivostní analýzu. Prohloubí si znalosti v oblasti kontingenčních tabulek a naučí se zautomatizovat opakované postupy pomocí záznamu maker. * Kurz excel expert probíhá v malé skupině účastníků. Kurzu excel expert se účastní maximálně 8 osob. Kurz excel expert probíhá v plně vybavené počítačové učebně. V průběhu kurzu excel expert je pro účastníky zajištěn pitný režim a drobné občerstvení. U nás máte jistotu, že vám objednaný kurz nezrušíme. Poté co u nás kurz excel expert objednáte a my vám potvrdíme účast, garantujeme, že se kurz uskuteční. Kurz nerušíme z důvodu malého počtu zájemců. Kurz excel expert se uskuteční i pokud se něj přihlásí pouze jeden zájemce. V takovém případě probíhá kurz excel expert jako individuální, cena kurzu se nezmění. Funkce pro experty vyhledávací funkce (INDEX, MATCH, OFFSET, INDIRECT, HYPERLINK, CELL) maticové funkce (podmíněný součet, FREQUENCY, TRANSPOSE) vzorce a souhrny v pojmenovaných tabulkách snímek Nové funkce v Microsoft 365 Logické funkce (LAMBDA, LET, MAP) Vyhledávací funkce (FILTER, HSTACK, SORT, SORTBY, UNIQUE, VSTACK, XLOOKUP, XMATCH) Matematické a trig. funkce (RANDARRAY, SEQUENCE) Textové funkce (TEXTJOIN, TEXTSPLIT, VALUETOTEXT) Podmíněné formátování pomocí složitějších vzorců (zvýraznění celého řádku) dynamické podmíněné formátování pomocí seznamu hodnot nastavení priorit mezi sadou pravidel Práce s rozsáhlými daty zásady při vytváření databáze import externích dat a Power Query Kontingenční tabulky (Pivot Tables) výchozí rozložení kontingenčních tabulek nastavení kontingenční tabulky podmíněné formátování Kontingenční tabulka funkce Zobrazit hodnoty jako funkce ZískatKontData napojení vzorců na kontingenční tabulku výpočty v kontingenční tabulce export dat z kontingenční tabulky do jednotlivých listů (hloubková analýza dat) význam Power Pivot při tvorbě sady KT z jednoho datového zdroje Tvorba maker úvod do problematiky maker absolutní a relativní záznam Citlivostní analýza hledání řešení scénáře List prognózy Analytické doplňky excelu Histogram Klouzavý průměr Regrese ...

• 25.06.2025 Praha



• 25.06.2025 Kolín



• 07.06.2025 Kolín



• 07.06.2025 Praha



• 16.04.2025 Praha

Study points for the exam Using Red Hat JBoss Enterprise Application Platform and Red Hat JBoss Developer Studio, you should be able to accomplish the tasks below without assistance. The tasks have been grouped into categories to assist your preparation. Configure and create enterprise-ready web projects Configure database connection and persistence details Include existing components and entities Generate views and view beans from entities Choose between war and ear applications Generate the application scaffold Handle web and enterprise application project structures, including possible configuration file locations Generate and deploy the application using maven or JBoss Tools Work with contexts (CDI) Use the best context lifecycle for a given use case Make good use of Conversation by understanding: Context order used by the container to resolve components and contex * Java™ EE application developers Study points for the exam Using Red Hat JBoss Enterprise Application Platform and Red Hat JBoss Developer Studio, you should be able to accomplish the tasks below without assistance. The tasks have been grouped into categories to assist your preparation. Configure and create enterprise-ready web projects Configure database connection and persistence details Include existing components and entities Generate views and view beans from entities Choose between war and ear applications Generate the application scaffold Handle web and enterprise application project structures, including possible configuration file locations Generate and deploy the application using maven or JBoss Tools Work with contexts (CDI) Use the best context lifecycle for a given use case Make good use of Conversation by understanding: Context order used by the container to resolve components and context variables Temporary versus long running Conversation promotion Conversation demarcation and propagation Relation between conversations, transactions, and persistence context flushmode Debugging a CDI application (potentially with Arquillian) Manage context content Work with POJO - JEE components Differences between EJB3-based components and POJO-based components Component definition Apply @Named Configure beans.xml Component lifecycle Component - contexts interaction Use of @Inject Understand interceptors Understand events Use @Alternative Use @Decorator Apply qualifier Apply producer Apply dispose Setting component and context variable in particular context using CDI APIs Implement the observer or observed patte> using CDI Implement a transactional conversation having in mind the relation between conversations, transactions, and persistence context flushmode JAAS security-related features, including (list not exhaustive) authentication restriction security events bind authentication methods Access and manage identity information through API Work with web - JSF components and web navigation Understand Postback lifecycle Use exhaustive navigation capabilities using faces-config Handling of RESTFul approach with JSF2 (viewparam) Use common Richfaces components Configure navigation based on application state Set up JSF input validation Set up JSF input conversion Use Expression Language (EL) Understand message bundle and locales Choose and configure JSF components Efficiently handle exceptions Implement success and error messages ...

Study points for the exam To help you prepare, the exam objectives highlight the task areas you can expect to see covered in the exam. Red Hat reserves the right to add, modify, and remove exam objectives. Such changes will be made public in advance. Candidates for the Red Hat Certificate of expertise in Camel Development should be able to: Create and maintain Camel routes Use the Java ™ language Use the CamelContext XML Exchange messages Body In - out Headers Attachments Consume and produce files CSV format XML format Work with databases and the Camel JPA component Understand transactional routes Use EIPs Content-based routing Wire Tap Splitter Aggregator RecipientList Use Camel components File2 FTP JPA2 JMS Direct Use Camel Test Mock endpoints JUnit 4 integration and CamelTest * The following audiences may be interested in earning the Red Hat Certificate of expertise in Camel Development: Enterprise Java developers who are familiar with service-oriented architecture (SOA) principles and are responsible for integrating enterprise applications. Enterprise SOA architects with some Java development experience and knowledge of enterprise integration. Study points for the exam To help you prepare, the exam objectives highlight the task areas you can expect to see covered in the exam. Red Hat reserves the right to add, modify, and remove exam objectives. Such changes will be made public in advance. Candidates for the Red Hat Certificate of expertise in Camel Development should be able to: Create and maintain Camel routes Use the Java ™ language Use the CamelContext XML Exchange messages Body In - out Headers Attachments Consume and produce files CSV format XML format Work with databases and the Camel JPA component Understand transactional routes Use EIPs Content-based routing Wire Tap Splitter Aggregator RecipientList Use Camel components File2 FTP JPA2 JMS Direct Use Camel Test Mock endpoints JUnit 4 integration and CamelTest APIs Dynamically route messages Use conditional routes Use data-driven routes Handle exceptions Catch and handle exceptions Use the dead-letter queue Scores and reporting Official scores for exams come exclusively from Red Hat Certification Central. Red Hat does not authorize examiners or training partners to report results to candidates directly. Scores on the exam are usually reported within 3 U.S. business days. Exam results are reported as section scores. Red Hat does not report performance on individual items, nor will it provide additional information upon request. Prerequisites Red Hat recommends that candidates for this exam ea> EX225 - Red Hat Certified JBoss Developer (RHCJD) before attempting this exam, but it is not required. Exam candidates should: Have taken the Camel Development with Red Hat JBoss Fuse (AD421) course or have extensive work experience in enterprise integration using Apache Camel Have familiarity working in a Red Hat Enterprise Linux ® environment Review the Red Hat Certificate of expertise in Camel Development exam (EX421) objectives Recommended courses AD421 - Camel Development with Red Hat JBoss Fuse ...

This course is held in English. NLP Extra Practitioner is designed to develop highly skilled NLP Practitioners by blending New Code and Classic Code NLP. Attend this special course and lea> how to use the most powerful tools from NLP to help yourself and others to get more from life. You will get the skills that help you to achieve excellence in your own life and enabling others to absorb those skills for their own use. Moreover you will receive the expertise, confidence and knowledge of practical application to make you a first class NLP Practitioner. You will have the opportunity to take the first NLP Extra Practitioner course in the Czech Republic. The course integrates these two schools of thoughts: Classic Code NLP and New Code NLP which means that you lea> the latest ideas and techniques while understanding the roots of the discipline and remaining faithful to the original ideas of NLP. Successful participants will receive N ...

Tento kurz se zaměřuje na nejnovější řešení od společnosti Microsoft a jeho praktické využití. Poskytne nejprve základní přehled o Self-Services BI a porovnání s tradičními přístupy k BI, dále bude popsán základ doplňku PowerPivot a PowerVIew. Zaměření bude kladené na PowerPivot – na používání různých datových zdrojů, jejich vzájemné propojení a další kroky, které je možné provádět po získání dat, tedy vlastní sloupce, výpočty a analytické operace s daty. Cílová sku ...

Seminář je určen pro vedoucí účetní pracovníky. Lektor kurzu : Prof. Ing. Jiří STROUHAL, Ph.D. Škoda Auto Vysoká škola, účetní expert, president Asociace profesních účetních ČR, autor odborných publikací v oblasti účetnictví a podnikových financí. Další informace: Účastníci školení obdrží certifikát o absolvování kurzu a podkladový materiál. Součástí školení je občerstvení a nápoje zdarma. ...

In this three-day practical course you will discover new features and enhancements in VMware vCenter Server® 6.5 and VMware ESXi ™ 6.5 Thanks to realistic scenarios deployment, practical guides and exercise skills you gain experience to effectively set up and configure VMware vSphere® 5.6 This course is recommended to all who want to deploy vSphere 6.5 on their existing vSphere environment. Audience This course is intended for: System architects, system admin ...

In this 2-day class, you will lea> how to use basic FortiGate UTM. In interactive labs, you will explore firewall policies, basic VPNs, virus detection, web filtering, application control, user authentication, and more. These administrative fundamentals will provide you with a solid understanding of how to integrate basic network security. Audience Anyone who is responsible for day-to-day management of a FortiGate appliance. You must master this course before atten ...

Předpokládané znalosti Pokročilá úroveň znalosti programu Microsoft Word odpovídající obsahu kurzu Microsoft Word - kurz pro pokročilé. Cíl kurzu Automatizovat a zjednodušit práci uživat ...

• 12.02.2025 Brno



• 01.04.2025 Brno



• 20.06.2025 Brno



• 24.02.2025 Praha



• 07.04.2025 Praha

This course is held in English. NLP Premier Practitioner is designed to develop highly skilled NLP Practitioners by blending New Code and Classic Code NLP. Attend this special course and lea> how to use the most powerful tools from NLP to help yourself and others to get more from life. You will get the skills that help you to achieve excellence in your own life and enabling others to absorb those skills for their own use. Moreover you will receive the expertise, confidence and knowledge of practical application to make you a first class NLP Practitioner. You will have the opportunity to take the first NLP Premier Practitioner course in the Czech Republic. The course integrates these two schools of thoughts: Classic Code NLP and New Code NLP which means that you lea> the latest ideas and techniques while understanding the roots of the discipline and remaining faithful to the original ideas of NLP. Successful participants will receive NLP Practitioner and New Code Practitioner certificates signed by NLP and New Code co-creator John Grinder, New Code co-creator Carmen Bostic St. Clair and Master Trainer Michael Carroll. The format of the course is thirteen days that are divided into 5 modules which ensures your new knowledge is compounded by revision of theory and practical exercises. NLP Training of Classic Code & New Code NLP The original works of Dr. John Grinder and his colleague Richard Bandler is known as Classic Code NLP which lays the foundations for the theory and practice of NLP. New Code NLP develops these early ideas and focuses on powerful but easy to apply processes to instigate change work and personal evolution. New Code achieves this at a much more advanced level than Classic Code by aligning ones unconscious mind for choosing which states are appropriate in any given context and ensuring that change be manifested at the level of state - intention, not the level of behavior. Also with NLP training in New Code NLP you will be able to gain access to high performance states which can benefit individuals in all areas of their life. Why attend NLP Premier Practitioner course? The course is beneficial for everybody who are looking to achieve excellence in their chosen field. As an NLP Practitioner you will be able to connect easier with your inner resources and live a life that resonates with your deepest personal values. At this course you will lea> Core NLP patterns NLP Epistemology - a model that explains how human beings know what they know Rapport skills - NLP techniques to gain trust and non verbal influence Calibration - NLP techniques to read verbal and non verbal communication and behaviour of other people Representational systems - the structure of information in the human mind; tools for reading non verbal accessing cues, eye patterns etc. Perceptual positions - recognition and utilisation perception of self, ot ...