Kurz vývoje událostně řízených aplikací a komponent v klientském JavaScriptu. ...

Školení je určené pro uživatele programu Excel, kteří chtějí svoji práci zefektivnit a zrychlit. Posluchači si prohloubí své znalosti, naučí se používat podmíněné formátovaní, zadávat složitější vzorce a funkce (např. funkce KDYŽ, SVYHLEDAT, SUMIF, COUNTIF atd.), propojovat listy a sešity, vytvářet složitější typy grafů, pracovat s databázemi, vyhodnocovat data pomocí kontingenčních tabulek a grafů a dokument zabezpečit. * Kurz Excel pokročilý probíhá v malé skupině účastníků. Kurzu Excel pokročilý se účastní maximálně 8 osob. Kurz Excel pokročilý probíhá v plně vybavené počítačové učebně. V průběhu kurzu Excel pokročilý 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 pokročilý 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 pokročilý se uskuteční i pokud se něj přihlásí pouze jeden zájemce. V takovém případě probíhá kurz Excel pokročilý jako individuální, cena kurzu se nezmění. Doplnění a shrnutí pojmů klávesové zkratky pro usnadnění práce nabídka Vložit jinak, Nalézt a Nahradit přesouvání sloupců možnosti dynamického doplňování Formátování buněk formát čísla (datum, čas vysvětlení) vlastní formát (barvy, kombinace formátů datum a čas, formát 0, #, oddělovače, podmínky) základy funkce Formátovat jako tabulku, výhody dynamické oblasti Vzorce zadávání složitějších vzorců pojmenování buněk a oblastí vliv přesunů a kopírování při absolutním adresování dynamická oblast (oblast, celý sloupec, formátovaná tabulka) Funkce textové funkce (ZLEVA, ZPRAVA, ČÁST, MALÁ,VELKÁ,VELKÁ2, PROČISTIT, DÉLKA, NAJÍT, CONCAT, &) datumové a časové funkce (DNES, NYNÍ, DEN, MĚSÍC, ROK, HODINA, MINUTA, SEKUNDA) funkce KDYŽ (IF), vnořená KDYŽ, A_NEBO databázové funkce (SVYHLEDAT, SUMIF, COUNTIF, SUBTOTAL) matematické funkce (MOD, CELÁ.ČÁST, ZAOKR.NAHORU, ZAOKR.DOLŮ) převod čísel uložených jako text na čísla (HODNOTA) ošetření chybových hlášení, IFERROR Grafy kombinované typy grafů pokročilé formátovaní grafu (nastavení hodnoty os, atd.) vytváření grafů v buňce Podmíněné formátování (Conditional Formatting) pomocí hodnoty buňky pomocí vzorce (zvýraznění celého řádku, využití časových funkcí) rychlé styly v podmíněném formátování Propojení propojení listů, sešitů sloučení dat z více tabulek Databáze v Microsoft Excel základní příprava dat ...

• 12.05.2025 Praha



• 11.05.2025 Kolín



• 11.05.2025 Praha



• 07.04.2025 Praha



• 07.04.2025 Kolín

SPECIAL CONCRETE AND COMPOSITES 2018 15th International Conference organised in cooperation with The Experimental Centre, Faculty of Civil Engineering, Czech Technical University in Prague. The conference focused on Special Concrete and Composites will be held in Hotel Skalsky Dvur, Czech Republic during 11-12 October 2018. Selected papers will be published in ACTA POLYTECHNICA CTU PROCEEDINGS, (electronic version), indexed in DOAJ database, see below. Special Concrete and Composites 2017, Key Engineering Materials Vol. 760, indexed in SCOPUS. Special Concrete and Composites 2016, Key Engineering Materials Vol. 722 is indexed in SCOPUS. Special Concrete and Composites 2015, Key Engineering Materials Vol. 677 is indexed in SCOPUS. Special Concrete and Composites 2014, Advanced Materials Research Vol. 1054 is indexed in the Thomson Reuters (ISI) Web of Science and SCOPUS. Conference Topics Concrete in severe conditions Additives and admixtures Advanced binder systems Sustainable concrete and composites Experimental methods and measurement High performance concrete Other special concrete and composites Scientific Committee Prof. Petr Konvalinka Czech Technical University in Prague, Czech Republic – Conference Chairs Lenka Bodnárová, Ph.D. Brno University od Technology, Czech Republic Petr Huňka, Ph.D. STACHEMA CZ s.r.o., Czech Republic Assoc. Prof. Tomáš Klečka Klokner Institute, Czech Technical University in Prague, Czech Republic Assoc. Prof. Karel Kolář Faculty of Civil Engineering, Czech Technical University in Prague, Czech Republic Assoc. Prof. Jiří Litoš Faculty of Civil Engineering, Czech Technical University in Prague, Czech Republic Pavel Reiterman, Ph.D. Faculty of Civil Engineering, Czech Technical University in Prague, Czech Republic Assoc. Prof. Jan Vodička Faculty of Civil Engineering, Czech Technical University in Prague, Czech Republic CALL FOR PAPERS Topics of interest for submission: Concrete in severe conditions Additives and admixtures Advanced binder systems Sustainable concrete and composites Experimental methods and measurement High performance concrete Other special concrete and composites PUBLISHING in ACTA POLYTECHNICA CTU PROCEEDINGS, electronic version. For Registration click HERE IMPORTANT DATES September 7, 2018 Full Paper Submission Deadline pavel.reiterman fsv.cvut.cz subrtova September 15, 2018 Peer Review Report Notification September 20, 2018 Final Reviewed Paper Submission October 11-12, 2018 Conference Dates INSTRUCTION FOR AUTHORS Only full and registered paper will be accepted to review. Pap ...

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 ...

SPECIAL CONCRETE AND COMPOSITES 2016 13th International Conference held under the auspices of prof. Ing. Petr Konvalinka, CSc., Rector of the Czech Technical University in Prague, Czech Republic and organised by SEKURKON s.r.o. Selected scientific papers will be published in the scientific international journal Key Engineering Materials indexed in the major academic databases. Special Concrete and Composites 2015, Key Engineering Materials Vol. 677 is indexed in SCOPUS. Special Concrete and Composites 2014, Advanced Materials Research Vol. 1054 is indexed in the Thomson Reuters (ISI) Web of Science and SCOPUS. The conference focused on Special Concrete and Composites will be held in Hotel Skalsky Dvur, Czech Republic during 13-14 October 2016. Conference Topics * Concrete in severe conditions * Additives and admixtures * Advanced binder systems * Sustainable concrete and composites * Experimental methods and measurement * High performance concrete * Other special concrete and composites Scientific Committee Prof. Petr Konvalinka Rector of the Czech Technical University in Prague, Czech Republic – Conference Chairs Lenka Bodnárová, Ph.D. Brno University od Technology, Czech Republic Petr Huňka, Ph.D. STACHEMA CZ s.r.o. Assoc. Prof. Tomáš Klečka Klokner Institute, Czech Technical University in Prague, Czech Republic Assoc. Prof. Karel Kolář Faculty of Civil Engineering, Czech Technical University in Prague, Czech Republic Assoc. Prof. Jiří Litoš Faculty of Civil Engineering, Czech Technical University in Prague, Czech Republic Pavel Reiterman, Ph.D. Faculty of Civil Engineering, Czech Technical University in Prague, Czech Republic Assoc. Prof. Jan Vodička Faculty of Civil Engineering, Czech Technical University in Prague, Czech Republic Call For Papers Topics of interest for submission: * Concrete in severe conditions * Additives and admixtures * Advanced binder systems * Sustainable concrete and composites * Experimental methods and measurement * High performance concrete * Other special concrete and composites Important dates June 15, 2016 Abstract Submission Deadline subrtova pavel.reiterman fsv.cvut.cz Registration of scientific paper publication (see below) June 20, 2016 Abstract Acceptance Notification June 30, 2016 Full Paper Submission Deadline July 31, 2016 Peer Review Report Notification August 31, 2016 Final Reviewed Paper Submission October 13-14, 2016 Conference Dates Paper Page Limit and Requirement: 1, Regular Papers: minimum lenght is 6 pages, including all figures, tables, and references. 2, Papers should be written in English. The format should be in accordance with the criteria of template. Ins ...

This course prepares you to deliver clustered Data ONTAP system installation services—meeting NetApp® quality standards and using NetApp best practices. Using your laptop, and the appropriate tools, you practice all installation tasks and set up NetApp equipment in a clustered configuration. You lea> how to set up and test access to the system and the AutoSupport Connection, and conduct a customer briefing. Audience NetApp and partner PSEs who are responsible for sy ...

This Oracle Database: Program with PL - SQL training starts with an introduction to PL - SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you ll lea> to develop stored procedures, functions, packages and more. Audience Application Developers Database Administrators Developer Forms Developer PL - SQL Developer Portal Developer System Analyst ...

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 should be able to perform these tasks: Install and configure Puppet. Install Puppet servers. Install Puppet nodes. Register Puppet nodes to a Puppet server. Create and maintain Puppet manifests. Create new Puppet manifests. Debug existing Puppet manifests. Create Puppet modules. Create reusable modules. Create modules with classes, name spaces, variables, and conditionals. Create modules that install software on target nodes and deploy configuration files. Use facter to obtain system information. Create custom facts. Use facts to change Puppet behavior. Create Git repositorie * These audiences may be interested in earning the Red Hat Certificate of Expertise in Configuration Management with Puppet: Experienced Linux system administrators responsible for the planning, deployment, and management of multiple physical or virtualized servers Experienced Linux systems administrators responsible for implementing DevOps practices An RHCE interested in earning a Red Hat Certificate of Expertise or Red Hat Certified Architect (RHCA) credential 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 should be able to perform these tasks: Install and configure Puppet. Install Puppet servers. Install Puppet nodes. Register Puppet nodes to a Puppet server. Create and maintain Puppet manifests. Create new Puppet manifests. Debug existing Puppet manifests. Create Puppet modules. Create reusable modules. Create modules with classes, name spaces, variables, and conditionals. Create modules that install software on target nodes and deploy configuration files. Use facter to obtain system information. Create custom facts. Use facts to change Puppet behavior. Create Git repositories. Create and perform simple management of a Git repository. Add files to a Git repository. Apply changes and commit changed files to a Git repository. Implement Puppet in a Red Hat Satellite 6 environment. Create a Puppet repository on Red Hat Satellite. Install, configure, and deploy Puppet modules using Red Hat Satellite. Register Puppet clients to a Red Hat Satellite server. As with all Red Hat performance-based exams, configurations must persist after restart without intervention. 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 total scores. Red Hat does not report performance on individual items, nor will it provide additional information upon request. Prerequisites Exam candidates should: Hold a current RHCE certification at exam time Have Red Hat Configuration Management with Puppet (DO405) or equivalent experience Understand that actual system administration experience is also an important aspect of preparation for the exam Review exam objectives for the Red Hat Certificate of Expertise in Configuration Management with Puppet exam Recommended courses DO405 - Configuration Management with Puppet ...

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 should have the following skills and abilities: Understand core components of Ansible Inventories Modules Variables Facts Plays Playbooks Configuration files Run ad-hoc Ansible commands Use both static and dynamic inventories to define groups of hosts Utilize an existing dynamic inventory script Create Ansible plays and playbooks Know how to work with commonly used Ansible modules Use variables to retrieve the results of running a commands Use conditionals to control play execution Configure error handling Create playbooks to configure systems to a specified state Selectively run specific tasks in playbooks * The following audiences may be interested in earning the Red Hat Certificate of Expertise in Ansible Automation : System administrators who need to manage large numbers of systems System administrators who work in a DevOps environment and who wish to automate a large part of their day-to-day workload Developers who have some basic systems administration background and who wish to incorporate automation into their development process A Red Hat Certified Engineer (RHCE) interested in earning a Red Hat Certificate of Expertise or RHCA credential . 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 should have the following skills and abilities: Understand core components of Ansible Inventories Modules Variables Facts Plays Playbooks Configuration files Run ad-hoc Ansible commands Use both static and dynamic inventories to define groups of hosts Utilize an existing dynamic inventory script Create Ansible plays and playbooks Know how to work with commonly used Ansible modules Use variables to retrieve the results of running a commands Use conditionals to control play execution Configure error handling Create playbooks to configure systems to a specified state Selectively run specific tasks in playbooks using tags Create and use templates to create customized configuration files Work with Ansible variables and facts Create and work with roles Download roles from an Ansible Galaxy and use them Manage parallelism Use Ansible Vault in playbooks to protect sensitive data Install Ansible Tower and use it to manage systems Use provided documentation to look up specific information about Ansible modules and commands 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 total scores. Red Hat does not report performance on individual items, nor will it provide additional information upon request. Prerequisites Candidates for this exam should: Red Hat recommends that candidates for the Red Hat Certificate of Expertise in Ansible Automation exam (EX407) have taken Automation with Red Hat Ansible I (DO407) or have equivalent experience working with Ansible to configure systems. Red Hat also recommends candidates have earned Red Hat Certified System Administrator (RHCSA) or higher or have equivalent systems administration experience. Recommended courses Automation with ...

22nd INTERNATIONAL SYMPOSIUM BRIDGES 2017 held in the accompanying programme of the 22nd International Building Fair IBF SYMPOSIUM MOTTO Bridges– Constructions– Connecting Nations and Generations MAIN TOPICS 1. Bridges in the Czech Republic – Construction, Administration and Maintenance, Standards Planning and Financing of Bridges Significant Realization of Bridges Current Legislation, Regulations and their Relation to European Standards Condition of Road and Railway Bridges in the CR, their Administration and Maintenance 2. A Bridges Abroad Information on Specialised Events Abroad Examples of Realised Significant New and Reconstructed Bridge Structures Innovation of Technologies, Materials, Products for Bridge Objects Bridge Failures - Examples 3. Bridges in the Czech Republic – Research and Development New Scientific Knowledge in the Field of Bridge Structures, Research Tasks Service Life of Bridges – Influence of Selected Materials and Construction Systems Innovation of Technologies, Materials, Products for Bridge Objects 4. Bridges in the Czech Republic – Projects and Realisations Projects of New Constructions, Re-Constructions and Repairs of Bridges Realisation of New Constructions, Re-Constructions and Repairs of Bridges Bridge Accessories Causes of Faults and Failures of Bridge Objects and their Consequences In the course of the symposium there will be granted the diplomas Bridge Work 2015 in the category I. New Construction and in category II. Repair or Re-Construction and honorary mentions for all-life-long work in the field of bridges. Professional guarantor Chairman of the Preparatory Committee doc. Ing. Tomáš Rotter, CSc. Ing. Jiří Chládek, CSc. email: rotter fsv.cvut.cz email: inprekin volny.cz Tel.: +420 602 811 401 Tel.: +420 602 237 180 Mandatory application form is available here. For Company presentation click here. If you want to participate with your paper, contact the coordinator of symposium. PRELIMINARY PROGRAMME 26. 4. 2017 - Wednesday 14.00 - Accompanying programme for international guests, members of Preparatory Committee, Honorary representatives, General and Main partners 27. 4. 2017 - Thursday 08.00 Registration of Participants 09.00 Opening Ceremony, Greeting guests * Bridge Works of 2015 * Honorable Mentions 10.00 - 13.00 Presentations and discussion - Session I. and II. 13.00 - 14.00 Lunch break 14.00 - 17.30 Presentations and discussion - Session I. and II. 15.30 - 17.30 Presentations and discussion - Session III. 18.00 Conclusion of the first day of the Symposium 19.30 Social evening at Brewery Restaurant Starobrno 28. 4. 2017 - Friday 08.00 Opening of the 2. symposium day 08.05 - 14.00 Presentations and discussion – Session IV. 14.00 Conclusions of Symposium – Resolutions Lunch Accommodati ...