This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.
Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments
This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.
Java Front-ends for desktop and mobile With Java FX Programming Java Front-ends for desktop and mobile With Java FX In this course we create attractive, functional Front-ends using JavaFX. Prerequisites: Delegates already have basic Java Skills. Duration: 2 consecutive days, the first date shows as the booking date Where: Online with Gotomeeting.com Download: Download Java JDK and Eclipse IDE. London classroom: on request locations, bring you own device Location: Online Interactive Instructor-led Webinar. Our Style: This is a very practical course giving you hands-on practice. Included: Course exercises, notes, examples, computers, evaluations Certification: PCWorkshops JavaFX Qualification Java Intermediate and Front-end Course Description Database Concepts Revision: DataBase SQL, database principles and JDBC GUI's with Java FX Building Java FX GUI's Course Contents: GUI's with JavaFX Building Java GUI's. Create a front-end form interface for an application. Working with nodes, labels, inputboxes, prgress bars, etc. Formatting your front-end. Import a Java package to interact with the front-end. Interact with a database via the front-end. Practical Examine the Java SE event model. What is an event. What is event handling. Develop event handlers. Develop Lambda-style event handlers. Practical Create a quotation app. Create a movie booking app. How to create your installer and upload your app Webservices Java Web services What are Web Services? Why Java Web Services? Web Services - Characteristics Web Services - Architecture Web Services - Examples and exercises What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java Intermediate and Front-end Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments
Duration 1 Days 6 CPD hours This course is intended for Certification Preparation for Service Cloud Consultant is designed for individuals who have experience designing Service Cloud solutions and are preparing to take the Salesforce Service Cloud Consultant Certification exam. You should have the following experience before attending this class: Attainment and maintenance of the Salesforce Administrator Certification Knowledge of the topics discussed in the Service Cloud Consultant Overview When you complete this course, you will be able to: Review the different exam objectives and their weighting on the exam Understand the product areas to focus on to best prepare for the exam Discuss how to design Service Cloud solutions to meet specific business needs Assess your exam readiness by answering practice questions Are you ready to take the next step in your career by becoming a Salesforce Certified Service Cloud Consultant? Instructors will present scenarios that will help reinforce your knowledge of Service Cloud functionality by thinking through requirements and design considerations. The course provides an overview of the exam objectives to help you focus your efforts to prepare for the Salesforce Service Cloud Consultant Certification exam. Review the different exam objectives and their weighting on the examUnderstand the product areas to focus on to best prepare for the examDiscuss how to design Service Cloud solutions to meet specific business needsAssess your exam readiness by answering practice questions Additional course details: Nexus Humans Salesforce Certification Preparation for Service Cloud Consultant (CRT261) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Salesforce Certification Preparation for Service Cloud Consultant (CRT261) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 3 Days 18 CPD hours This course is intended for Individuals preparing for the Cisco Customer Success ManagerSpecialist certification Individuals who have experience working with customers to determine, measure, and deliver business outcomes through the implementation of technology Overview After taking this course, you should be able to: Describe the role of the Customer Success Manager Describe the tools that the Customer Success Manager uses to ensure customer experience Describe the lifecycle approach to customer experience The Cisco Customer Success Manager (DTCSM) v2.2 course gives you the confidence and competence to fulfill the Customer Success Manager (CSM) role successfully, helping your customers realize value from their solutions and achieve their business outcomes. The course offers experiential learning through practical exercises using situations based on real-life use cases and case studies. In this highly interactive course, you can practice and gain confidence in fulfilling core tasks using best-practice tools and methodologies while receiving feedback from the facilitator and your peers.This course is based on understanding the customer lifecycle and how to optimize that journey, increasing the value realized by the customer, and maximizing your likelihood to maintain their loyalty and renew or expand their business opportunities. The course helps you prepare for the 820-605 Cisco Customer Success Manager (CSM) exam. By passing this exam, you earn the Cisco Customer Success Manager Specialist certification. Course Outline Transition to Subscription Economy Customer and Industry Trends Defining Customer Success and the CSM Role Engaging the Customer for Success Engaging the Customer for Success Addressing Barriers Customer Success Management Activities Success Plan Elements Customer Success Management Activities Additional course details: Nexus Humans Cisco Customer Success Manager v2.2 (DTCSM) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Customer Success Manager v2.2 (DTCSM) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 5 Days 30 CPD hours This course is intended for Students preparing to take the CCNP Collaboration certification Network administrators Network engineers Systems engineers Overview After taking this course, you should be able to: Describe the Cisco Collaboration solutions architecture Compare the IP Phone signaling protocols of Session Initiation Protocol (SIP), H323, Media Gateway Control Protocol (MGCP), and Skinny Client Control Protocol (SCCP) Integrate and troubleshoot Cisco Unified Communications Manager with LDAP for user synchronization and user authentication Implement Cisco Unified Communications Manager provisioning features Describe the different codecs and how they are used to transform analogue voice into digital streams Describe a dial plan, and explain call routing in Cisco Unified Communications Manager Implement Public Switched Telephone Network (PSTN) access using MGCP gateways Implement a Cisco gateway for PSTN access Configure calling privileges in Cisco Unified Communications Manager Implement toll fraud prevention Implement globalized call routing within a Cisco Unified Communications Manager cluster Implement and troubleshoot media resources in Cisco Unified Communications Manager Describe Cisco Instant Messaging and Presence, including call flows and protocols Describe and configure endpoints and commonly required features Configure and troubleshoot Cisco Unity Connection integration Configure and troubleshoot Cisco Unity Connection call handlers Describe how Mobile Remote Access (MRA) is used to allow endpoints to work from outside the company Analyze traffic patterns and quality issues in converged IP networks supporting voice, video, and data traffic Define QoS and its models Implement classification and marking Configure classification and marking options on Cisco Catalyst switches The Implementing and Operating Cisco Collaboration Core Technologies (CLCOR) v1.1 course helps you prepare for advanced-level roles focused on implementation and operation of Cisco collaboration solutions. You will gain the knowledge and skills needed to implement and deploy core collaboration and networking technologies, including infrastructure and design, protocols, codecs, and endpoints, Cisco Internetwork Operating System (IOS©) XE gateway and media resources, call control, Quality of Service (QoS), and additional Cisco collaboration applications.This course helps prepare you to take the exam:350-801 Implementing and Operating Cisco Collaboration Core Technologies (CLCOR)After you pass this exam, you earn Cisco Certified Specialist - Collaboration Core certification and satisfy the core requirement for these certifications:CCNP CollaborationCCIE CollaborationThis course prepares you for the 300-435 Automating Cisco Enterprise Solutions (ENAUTO) certification exam. Introducing Automation for Cisco Solutions (CSAU) is required prior to enrolling in Implementing Automation for Cisco Enterprise Solutions (ENAUI) because it provides crucial foundational knowledge essential to success. Course Outlines Describing the Cisco Collaboration Solutions Architecture Exploring Call Signaling over IP Networks Integrating Cisco Unified Communications Manager LDAP Implementing Cisco Unified Communications Manager Provisioning Features Exploring Codecs Describing Dial Plans and Endpoint Addressing Implementing MGCP Gateways Implementing Voice Gateways Configuring Calling Privileges in Cisco Unified Communications Manager Implementing Toll Fraud Prevention Implementing Globalized Call Routing Implementing and Troubleshooting Media Resources in Cisco Unified Communications Manager Describing Cisco Instant Messaging and Presence Enabling Cisco Jabber© Configuring Cisco Unity Connection Integration Configuring Cisco Unity Connection Call Handlers Describing Collaboration Edge Architecture Analyzing Quality Issues in Converged Networks Defining QoS and QoS Models Implementing Classification and Marking Configuring Classification and Marking on Cisco Catalyst Switches
Duration 5 Days 30 CPD hours This course is intended for network professionals who are looking to build their foundational knowledge of the ClearPass product portfolio This training combines the following classes into one five day workshop, preparing you for the ACCP certification: ACF-Aruba ClearPass Fundamentals IAC-Implementing Aruba ClearPass Overview Ability to setup ClearPass as a AAA server Demostrate Configuration Guest, Ongurad, Onboard and Profiling features Integrate with External AD Server Understand Monitoring and Reporting Demostrate Scaling and deployment of best practices It prepares participants with foundational skills in Network Access Control using the ClearPass product portfolio. This 5-day classroom session includes both modules and labs to teach participants about the major features of the ClearPass portfolio Intro to ClearPass BYOD High Level Overview Posture and Profiling Guest and Onboard ClearPass for AAA Policy Service Rules Authentication Authorization and Roles Enforcement Policy and Profiles Authentication and Security Concepts Authentication Types Servers Radius COA Active Directory Certificates Intro to NAD NAD Devices Adding NAD to ClearPass Network Device Groups Network Device Attributes Aruba Controller as NAD Aruba Switch Aruba Instant Monitoring and Troubleshooting Monitoring Troubleshooting Logging Policy Simulation ClearPass Insight Insight Dashboard Insight Reports Insight Alerts Insight Search Insight Administration Insight Replication Active Directory Adding AD as Auth Source Joining AD domain Using AD services External Authentication Multiple AD domains LDAP Static Host Lists SQL Database External Radius Server Guest Guest Account creation Web Login pages Guest Service configuration Self-registration pages Configuring NADS for Guest Guest Manager Deep Dive Web Login Deep Dive Sponsor Approval MAC Caching Onboard Intro to Onboard Basic Onboard Setup Onboard Deepdive Single SSID Onboarding Dual SSID Onboarding Profiling Intro to Profiling Endpoint Analysis Deep Dive Posture Intro to Posture Posture Deployment Options OnGuard Agent Health Collection OnGuard workflow 802.1x with Posture using Persistent/dissolvable agent OnGuard web LoginMonitoring and Updates Operation and Admin Users Operations Admin Users Clustering and Redundancy Clustering Redundancy LAB Licensing ClearPass Licensing Base License Applications Single Sign-On Deployment Options ClearPass Admin Login SSO Access Network SSO ASO-Auto-Sign On Configuration and Demo ClearPass Exchange Intro Examples General HTTP Palo Alto Firewall Configuration Case Study Objectives Discussion Advanced Labs Overview
Duration 5 Days 30 CPD hours This course is intended for Students preparing to take the CCNP Collaboration certification Network administrators Network engineers Systems engineers Overview After taking this course, you should be able to: - Define collaboration and describe the main purpose of key devices in a Cisco collaboration on-premise, hybrid, and cloud deployment model - Configure and modify required parameters in Cisco Unified Communications Manager (CM) including service activation, enterprise parameters, CM groups, time settings, and device pool - Deploy and troubleshoot IP phones via auto registration and manual configuration within Cisco Unified CM - Describe the call setup and teardown process for a SIP device including codec negotiation using Session Description Protocol (SDP) and media channel setup - Manage Cisco Unified CM user accounts (local and via Lightweight Directory Access Protocol [LDAP]) including the role/group, service profile, UC service, and credential policy - Configure dial plan elements within a single site Cisco Unified CM deployment including Route Groups, Local Route Group, Route Lists, Route Patterns, Translation Patterns, Transforms, SIP Trunks, and SIP Route Patterns - Configure Class of Control on Cisco Unified CM to control which devices and lines have access to services - Configure Cisco Unified CM for Cisco Jabber and implement common endpoint features including call park, softkeys, shared lines, and pickup groups - Deploy a simple SIP dial plan on a Cisco Integrated Service Routers (ISR) gateway to enable access to the PSTN network - Manage Cisco UCM access to media resources available within Cisco UCM and Cisco ISR gateways - Describe tools for reporting and maintenance including Unified Reports, Cisco Real-Time Monitoring Tool (RTMT), Disaster Recovery System (DRS), and Call Detail Records (CDRs) within Cisco Unified CM - Describe additional considerations for deploying video endpoints in Cisco Unified CM - Describe the integration of Cisco Unity with Cisco Unified CM and the default call handler The Understanding Cisco Collaboration Foundations (CLFNDU) v1.1 course gives you the skills and knowledge needed to administer and support a simple, single-site Cisco© Unified Communications Manager (CM) solution with Session Initiation Protocol (SIP) gateway. The course covers initial parameters, management of devices including phones and video endpoints, management of users, and management of media resources, as well as Cisco Unified Communications solutions maintenance and troubleshooting tools. In addition, you will learn the basics of SIP dial plans including connectivity to Public Switched Telephone Network (PSTN) services, and how to use class-of-service capabilities. Course Outline Exploring The Path To Collaboration Introducing Cisco Unified Communications Manager And Initial Parameters Xploring Endpoints And The Registration Process Exploring Codecs And Call Signaling Managing Users In Cisco Unified Communication Manager Describing A Basic Dial Plan Describing Class Of Service Enabling Endpoints And Features Describing The Cisco Isr As A Voice Gateway Exploring Cisco Unified Communication Manager Media Resources Reporting And Maintenance Exploring Additional Requirements For Video Endpoints Describing Cisco Unity Connection
Duration 5 Days 30 CPD hours This course is intended for This course is intended for: Solutions architects and cloud architects seeking their AWS Certified Solutions Architect - Associate certification Customers and APN Partners who have 6 to 12 months of experience with AWS including a strong architecture background and experience Individuals who prefer an instructor led course for training and exam readiness Individuals who have not taken the Architecting on AWS course in the last ~6 months Overview In this course, you will learn to: Make architectural decisions based on AWS architectural principles and best practices Leverage AWS services to make your infrastructure scalable, reliable, and highly available Leverage AWS Managed Services to enable greater flexibility and resiliency in an infrastructure Make an AWS-based infrastructure more efficient to increase performance and reduce costs Use the Well-Architected Framework to improve architectures with AWS solutions Navigate the logistics of the examination process, exam structure, and question types Identify how questions relate to AWS architectural concepts Interpret the concepts being tested by an exam question This five-day, instructor-led course helps busy architects get away from the day-to-day to get focused and ready for their AWS Certified Solutions Architect ? Associate exam. Attendees learn the fundamentals of building IT infrastructure on AWS, so they can build scalable and resilient solutions in the cloud, by spending the first 3 days on the Architecting on AWS course. They?ll start getting in the exam readiness mindset with bonus end of module quizzes. Next, they?ll learn strategies to answer exam questions and avoid common mistakes with the Exam Readiness: AWS Certified Solutions Architect ? Associate half-day course. The course broadens attendees? knowledge of AWS services with deep dives into Amazon Redshift, Amazon Kinesis, and AWS Key Management Service, and then concludes with two quizzes and an instructor guided review of the AWS Certified Solutions Architect ? Associate practice exam. Architecting on AWS Module 1: Introduction Module 2: The Simplest Architectures Hands-On Lab 1: Hosting a Static Website Module 3: Adding a Compute Layer Module 4: Adding a Database Layer Hands-On Lab 2: Deploying a Web Application on AWS Module 5: Networking in AWS Part 1 Hands-On Lab 3: Creating a Virtual Private Cloud Architecting on AWS (continued) Module 6: Networking in AWS Part 2 Module 7: AWS Identity and Access Management (IAM) Module 8: Elasticity, High Availability, and Monitoring Hands-On Lab 4: Creating a Highly Available Environment Module 9: Automation Hands-On Lab 5: Automating Infrastructure Deployment with AWS CloudFormation Module 10: Caching Architecting on AWS (continued) Module 11: Building Decoupled Architectures Module 12: Microservices and Serverless Architectures Hands-On Lab 6: Implementing a Serverless Architecture with AWS Managed Services Module 13: RTP/RPO and Backup Recovery Setup Module 14: Optimizations and Review Exam Readiness: AWS Certified Solutions Architect -- Associate Module 0: The Exam Module 1: Design Resilient Architectures Module 2: Design Performant Architectures Module 3: Specify Secure Applications and Architectures Module 4: Design Cost-Optimized Architectures Module 5: Define Operationally Excellent Architectures Exam Readiness Additional deep dive of AWS services Quiz #1 Practice exam: AWS Certified Solutions Architect ? Associate Quiz #2 Wrap-up