Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code
Develop the commercial awareness, financial knowledge and strategic thinking capabilities, to influence the direction of the business Course overview Duration: 2 days (13 hours) This course is aimed at managers who want to develop their commercial awareness, financial knowledge and strategic thinking capabilities, so that they can influence the direction of their business and deliver to their full potential. Day one of the course provides the skills and insights to make sense of your company’s financial position and performance. Day two helps delegates to consider the strategic thinking tools required to plot the forward course needed to maximise the potential of the business. As well as looking at how to make effective business decisions, this course gives a good grounding in finance and profitability. As a two day programme, day one provides the skills and insights to make sense of the company’s financial position and performance. Day two then considers the strategic thinking tools needed to plot the forward course needed to maximise the potential of the business. Objectives By the end of the course you will be able to: An understanding of the balance sheet, profit and loss account, cash flow and statutory and management accounts Learnt to correctly employment key financial ratios to analyse your business A practical definition of strategy analysis tools to examine the current environment and capabilities Steps to devise a mission and vision statement Recognition of the skills and resources needed to achieve the vision Generation of appropriate strategic and tactical commercial objectives Content What is Strategy Defining Strategy Strategic thinking Strategic models Commercial thinking – what is money? Where are we now STEEPLE analysis SWOT Analysis P&E forces at work Political distortions in capitalist markets Where are we trying to get to Setting the mission and vision Creating a BHAG Strategies for deflation and inflation The role of banks Commercial and investment banking Fractional reserving Securitisation How to get there Skill gap analysis Business Process Re engineering The role of creativity How to get there Getting the team on board Individual and team motivation The power of the brand Overcoming challenges Debt and deleveraging Change management Creating value Discounted Cash Flows Building the business case Asset Valuation techniques Making it happen Turning Strategic Thinking into Strategic Plans Scenario planning for an uncertain future Creating commitments and lock in Discussion and review Time will be set aside during the course for review sessions with time for questions, answers and action learning.
Course Overview This course, "Logo Animation Fundamentals," provides a comprehensive introduction to the essential concepts of logo animation. It covers the tools, techniques, and principles needed to create impactful animated logos. Learners will explore animation software, with a focus on the use of effects to bring logos to life, making them engaging and visually striking. By the end of the course, learners will be able to produce high-quality logo animations that can enhance branding efforts across digital platforms. The course also offers valuable insights into industry practices, enabling learners to develop a solid foundation in this creative field. Course Description In this course, learners will delve into the basics of logo animation, starting with an understanding of the key principles of animation. They will explore the process of animating logos using advanced tools such as Adobe After Effects and the Saber plugin. The course also covers the history and evolution of animation, providing context to its current use in modern branding. With each module, learners will enhance their skills in design and animation, enabling them to create dynamic and professional logo animations. This course is ideal for those who wish to incorporate animation into branding or add this valuable skill to their creative toolkit. Learners will gain a thorough understanding of logo animation techniques and develop a portfolio-ready project. Course Modules: Module 01: Introduction Overview of logo animation Importance of logo animation in branding Module 02: Logo Animation Basic principles of animation Tools for animating logos Exploring different animation styles Module 03: Logo Animation Using Saber Introduction to the Saber plugin Step-by-step guide to creating glowing logo effects Integrating advanced effects into logo animation Module 04: Background of Animation The history and evolution of animation The role of animation in modern media Module 05: Outro Key takeaways and next steps for further learning Final thoughts and project wrap-up (See full curriculum) Who is this course for? Individuals seeking to enhance their branding skills with animation. Professionals aiming to expand their expertise in motion graphics and design. Beginners with an interest in animation and digital design. Marketing and branding specialists looking to integrate animated logos into campaigns. Career Path Motion Graphic Designer Animation Specialist Branding Consultant Visual Designer Digital Marketing Professional
Course Overview: This course on Decision Making and Critical Thinking offers a comprehensive exploration of how to develop and apply critical thinking skills in both personal and professional contexts. Learners will gain the ability to analyse complex situations, make well-informed decisions, and approach problems with a logical mindset. By the end of this course, participants will have a clear understanding of critical thinking principles, decision-making processes, and how to apply these techniques effectively in various scenarios. The course is designed to enhance problem-solving capabilities and promote more thoughtful, reasoned approaches to decision-making. Course Description: The Decision Making and Critical Thinking course covers a wide range of essential topics, including understanding the key components of critical thinking, identifying and overcoming common barriers, and exploring decision-making strategies. Learners will delve into how to evaluate claims, the benefits of critical thinking, and the practical applications of these skills in real-world situations. With engaging lessons and interactive content, participants will develop the cognitive tools needed to think critically, solve problems, and make decisions that are both informed and objective. Key areas of focus include problem-solving techniques, critical thinking strategies, and the structured decision-making process. Upon completion, learners will be equipped to make more effective decisions and analyse situations with a critical mindset. Course Modules: Module 01: Introduction to Critical Thinking Module 02: Critical Thinking and the Judgment of Claims Module 03: Benefits and Barriers of Critical Thinking Module 04: Importance of Critical Thinking Module 05: Recognising a Critical Thinker Module 06: What Are the Critical Thinking Steps? Module 07: Critical Thinking Strategies Module 08: Problem-Solving Through Critical Thinking Module 09: Decision Making with Critical Thinking (See full curriculum) Who is this course for? Individuals seeking to improve their decision-making skills. Professionals aiming to enhance their critical thinking abilities. Beginners with an interest in logic, problem-solving, and decision-making. Anyone looking to develop a more analytical and structured approach to challenges. Career Path: Analyst roles in business, marketing, and consulting. Leadership positions requiring strategic decision-making. Project management and operations management positions. Careers in education, research, or policy analysis. Roles in human resources, where critical thinking is key to recruitment and development.
Process Improvement Course Overview: This course on Process Improvement provides a comprehensive foundation for learners to understand and apply key principles of process management and optimisation. Participants will explore various strategies, tools, and methodologies to streamline processes, enhance efficiency, and reduce waste. Emphasising real-world applicability, the course equips learners with the knowledge to analyse, design, and implement process improvements in a variety of professional settings. By the end, learners will be able to identify inefficiencies, propose targeted improvements, and contribute effectively to organisational performance enhancement. Course Description: In this course, learners will delve into the essentials of process improvement, covering fundamental concepts and frameworks used to optimise operations. Topics include the types of processes, the methodologies for process analysis, and the steps for implementing effective process improvements. Learners will gain a deep understanding of key process improvement techniques, such as Six Sigma and Lean, and develop the skills to assess and refine processes. The course also includes a LIVE demonstration, allowing learners to see the implementation of improvements in action, ensuring they are well-equipped to contribute to the efficiency of their organisations. Process Improvement Curriculum: Module 01: Introduction Module 02: The Fundamentals of Process Improvement Module 03: Types of Process in Process Improvement Module 04: The Process of Delivering Process Improvement Module 05: LIVE Demonstration of a Process Improvement Module 06: Close Out (See full curriculum) Who is this course for? Individuals seeking to enhance operational efficiency. Professionals aiming to advance their career in process management. Beginners with an interest in process improvement or management. Anyone looking to understand key strategies for process optimisation. Career Path: Process Improvement Specialist Business Process Analyst Operations Manager Lean Six Sigma Consultant Continuous Improvement Coordinator
"Self Care" - A Key To Happiness Course Overview: "Self Care: A Key To Happiness" is a comprehensive course designed to provide learners with essential strategies and techniques to improve their well-being and mental health. Focusing on the importance of self-care in maintaining happiness, this course equips participants with practical tools to manage stress, set boundaries, and enhance their emotional resilience. It explores various self-care practices, including mindfulness, relaxation techniques, and the significance of a balanced lifestyle. By the end of the course, learners will gain the ability to integrate self-care into their daily routines, leading to increased overall happiness, productivity, and life satisfaction. Course Description: This course delves deeper into the concept of self-care, exploring the connection between mental and physical health. Participants will learn effective methods for self-awareness, stress management, and emotional well-being. Key topics include mindfulness practices, relaxation exercises, understanding emotional triggers, and cultivating a positive mindset. The course also examines the role of nutrition, sleep, and exercise in maintaining a balanced and happy life. Learners will be guided on how to create personalised self-care plans tailored to their unique needs, ensuring long-term success. Upon completion, students will have gained valuable skills in self-regulation, resilience-building, and sustainable happiness. "Self Care" - A Key To Happiness Curriculum: Module 01: About this Course Module 02: Full Course Module 03: Next Steps Module 04: Extra Content for YOU (See full curriculum) Who is this course for? Individuals seeking to enhance their well-being and happiness Professionals aiming to improve their stress management and mental resilience Beginners with an interest in mental health and self-care Those seeking balance and mindfulness in their daily lives Career Path Mental Health Support Worker Wellness Coach Health and Well-being Consultant Personal Development Trainer Employee Wellness Program Manager
Event Planning Course Overview This comprehensive Event Planning course offers learners an in-depth understanding of the key principles and techniques involved in planning successful events. Covering all aspects from event management and classification to marketing, catering, and security, the course provides the necessary skills for effective event coordination. Whether you're interested in organising corporate events, weddings, or large public gatherings, this course equips you with the knowledge and expertise to plan, execute, and manage events with confidence. Learners will also explore how to build an event planning business, ensuring long-term success in the industry. Course Description This course delves into the various stages of event planning, from conceptualising an event to its final execution. Key topics include understanding the role of an event planner, classifying different types of events, developing client relationships, marketing events, and overseeing logistics such as catering, decorations, and waste disposal. You will gain insights into event security, legal requirements, and effective communication with clients and vendors. Through this learning journey, you will develop the critical skills needed to plan a range of events and potentially start your own event planning business. Event Planning Curriculum Module 1: Introduction to Event Management Module 2: Role of an Event Planner Module 3: Event Classification Module 4: Events and Clients Module 5: Steps to Plan an Event Module 6: Invitation to the Event Module 7: Event Marketing Module 8: Catering at Events Module 9: Event Decorations Module 10: Cleaning and Waste Disposal Module 11: Event Security Module 12: Developing an Event Planning Business (See full curriculum) Who is this course for? Individuals seeking to become professional event planners Professionals aiming to expand their event management skills Beginners with an interest in event organisation Entrepreneurs looking to enter the event planning industry Career Path Event Planner Corporate Event Coordinator Wedding Planner Conference Organiser Event Marketing Specialist Event Operations Manager
Duration 3 Days 18 CPD hours This course is intended for This in an intermediate and beyond-level course is geared for experienced Python developers looking to delve into the exciting field of Natural Language Processing. It is ideally suited for roles such as data analysts, data scientists, machine learning engineers, or anyone working with text data and seeking to extract valuable insights from it. If you're in a role where you're tasked with analyzing customer sentiment, building chatbots, or dealing with large volumes of text data, this course will provide you with practical, hands on skills that you can apply right away. Overview This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll: Master the fundamentals of Natural Language Processing (NLP) and understand how it can help in making sense of text data for valuable insights. Develop the ability to transform raw text into a structured format that machines can understand and analyze. Discover how to collect data from the web and navigate through semi-structured data, opening up a wealth of data sources for your projects. Learn how to implement sentiment analysis and topic modeling to extract meaning from text data and identify trends. Gain proficiency in applying machine learning and deep learning techniques to text data for tasks such as classification and prediction. Learn to analyze text sentiment, train emotion detectors, and interpret the results, providing a way to gauge public opinion or understand customer feedback. The Hands-on Natural Language Processing (NLP) Boot Camp is an immersive, three-day course that serves as your guide to building machines that can read and interpret human language. NLP is a unique interdisciplinary field, blending computational linguistics with artificial intelligence to help machines understand, interpret, and generate human language. In an increasingly data-driven world, NLP skills provide a competitive edge, enabling the development of sophisticated projects such as voice assistants, text analyzers, chatbots, and so much more. Our comprehensive curriculum covers a broad spectrum of NLP topics. Beginning with an introduction to NLP and feature extraction, the course moves to the hands-on development of text classifiers, exploration of web scraping and APIs, before delving into topic modeling, vector representations, text manipulation, and sentiment analysis. Half of your time is dedicated to hands-on labs, where you'll experience the practical application of your knowledge, from creating pipelines and text classifiers to web scraping and analyzing sentiment. These labs serve as a microcosm of real-world scenarios, equipping you with the skills to efficiently process and analyze text data. Time permitting, you?ll also explore modern tools like Python libraries, the OpenAI GPT-3 API, and TensorFlow, using them in a series of engaging exercises. By the end of the course, you'll have a well-rounded understanding of NLP, and will leave equipped with the practical skills and insights that you can immediately put to use, helping your organization gain valuable insights from text data, streamline business processes, and improve user interactions with automated text-based systems. You?ll be able to process and analyze text data effectively, implement advanced text representations, apply machine learning algorithms for text data, and build simple chatbots. Launch into the Universe of Natural Language Processing The journey begins: Unravel the layers of NLP Navigating through the history of NLP Merging paths: Text Analytics and NLP Decoding language: Word Sense Disambiguation and Sentence Boundary Detection First steps towards an NLP Project Unleashing the Power of Feature Extraction Dive into the vast ocean of Data Types Purification process: Cleaning Text Data Excavating knowledge: Extracting features from Texts Drawing connections: Finding Text Similarity through Feature Extraction Engineer Your Text Classifier The new era of Machine Learning and Supervised Learning Architecting a Text Classifier Constructing efficient workflows: Building Pipelines for NLP Projects Ensuring continuity: Saving and Loading Models Master the Art of Web Scraping and API Usage Stepping into the digital world: Introduction to Web Scraping and APIs The great heist: Collecting Data by Scraping Web Pages Navigating through the maze of Semi-Structured Data Unearth Hidden Themes with Topic Modeling Embark on the path of Topic Discovery Decoding algorithms: Understanding Topic-Modeling Algorithms Dialing the right numbers: Key Input Parameters for LSA Topic Modeling Tackling complexity with Hierarchical Dirichlet Process (HDP) Delving Deep into Vector Representations The Geometry of Language: Introduction to Vectors in NLP Text Manipulation: Generation and Summarization Playing the creator: Generating Text with Markov Chains Distilling knowledge: Understanding Text Summarization and Key Input Parameters for TextRank Peering into the future: Recent Developments in Text Generation and Summarization Solving real-world problems: Addressing Challenges in Extractive Summarization Riding the Wave of Sentiment Analysis Unveiling emotions: Introduction to Sentiment Analysis Tools Demystifying the Textblob library Preparing the canvas: Understanding Data for Sentiment Analysis Training your own emotion detectors: Building Sentiment Models Optional: Capstone Project Apply the skills learned throughout the course. Define the problem and gather the data. Conduct exploratory data analysis for text data. Carry out preprocessing and feature extraction. Select and train a model. ? Evaluate the model and interpret the results. Bonus Chapter: Generative AI and NLP Introduction to Generative AI and its role in NLP. Overview of Generative Pretrained Transformer (GPT) models. Using GPT models for text generation and completion. Applying GPT models for improving autocomplete features. Use cases of GPT in question answering systems and chatbots. Bonus Chapter: Advanced Applications of NLP with GPT Fine-tuning GPT models for specific NLP tasks. Using GPT for sentiment analysis and text classification. Role of GPT in Named Entity Recognition (NER). Application of GPT in developing advanced chatbots. Ethics and limitations of GPT and generative AI technologies.
Duration 5 Days 30 CPD hours This course is intended for Cloud architects, systems engineers, data center administrators, and cloud administrators with experience in a service provider or managed services environment. Overview By the end of the course, you should be able to meet the following objectives: Describe how VMware Integrated OpenStack fits into the VMware SDDC and its use cases List the deployment options and how to install VMware Integrated OpenStack Describe the architecture of VMware Integrated OpenStack and its components Configure tenancy and manage user authentication Integrate the OpenStack Neutron Networking service with VMware NSX-T⢠Data Center networking platform Deploy and manage virtual machine instances Monitor VMware Integrated OpenStack with OpenStack monitoring services Design an auto-scale, multitier application using built-in automation tools Manage a VMware Integrated OpenStack control plane using Kubernetes Use the HTML5 Web UI and CLI commands to view and edit the configuration, monitor log files, and view database tables used by VMware Integrated OpenStack components This five-day course provides you with the skills to build a private cloud using VMware© Integrated OpenStack on a proven VMware SDDC. Through a combination of lecture and hands-on labs, this course builds your skills in installing, configuring, and managing VMware Integrated OpenStack. You learn how to offer IaaS and PaaS with advanced networking and security features to end users using VMware Integrated OpenStack. Course Introduction Introductions and course logistics Course objectives References and resources Introduction to VMware Integrated OpenStack Describe what an OpenStack is Describe the services that make up VMware Integrated OpenStack Describe what VMware Integrated OpenStack is Describe what is NFV and how does VIO fit in Understand the licensing model of VIO Understand the use cases of VMware Integrated OpenStack VMware Integrated OpenStack Deployment Understand the role of Kubernetes in the VIO control plane List the VMware Integrated OpenStack deployment models How to perform VIO high-availability deployment How to perform VIO compact installation Pre-requisites for installing VMware Integrated OpenStack How to use the HTML5 web UI / VIOCLI to check the deployment configurations and deployment running status Explain steps involved in patching VIO high availability setup VMware Integrated OpenStack Architecture List the VMs deployed after a VMware Integrated OpenStack high-availability installation Describe the overall architecture of the VIO HA setup List the VIO services running within Kubernetes pods Describe the role of each service Understand ssl certificates in VIO Keystone Authentication Understand keystone use cases and services List the features offered by keystone in VIO How to integrate keystone with LDAP List the configuration, view logs, and database tables related to keystone Glance Images Understand Glance use case and its services List the features offered by Glance in VIO Explain how to create flavors and images Describe how to set up metadata, for example SPBM storage policy List the custom resources/logs and database tables related to Glance Networking with Neutron Understand the Neutron use case and its services Integrate Neutron with NSX-T Data Center List the custom resources, logs, and database tables related to Neutron Managing Instances with Nova Understand Nova use cases and services Understand regions, availability zones, and host aggregates Understand the concept of tenant VDC Nova support for multiple vCenter instances How to deploy an instance using Nova How to resize an instance and view the console logs Configuration and logs related to Nova service Cinder Block Storage Understand Cinder use cases and services List the features offered by Cinder Adding a persistent volume to an instance Explain the Snapshot of a Cinder volume and attach it to another instance List the custom resources, log files, and database tables related to Cinder Monitoring with Ceilometer List the Telemetry use cases and services How to enable Ceilometer in VIO How to monitor the VIO environment using Ceilometer Configuration and log files related to Ceilometer service Automating with Heat Define Heat use cases templates and services Describe use cases of Heat Troubleshooting Concepts List common issues in VMware Integrated OpenStack Use troubleshooting tools Describe simple troubleshooting procedures List and explain Day-2 operations Advanced Features Describe Load Balancer as a Service (Octavia) Explain Firewall as a Service Describe Designate (DNS as a Service) Demonstrate automating scaling Describe selective vCPU pinning Explain SRIOV network redundancy support Describe network trunk services support Describe Live resize Describe hardware passthrough (GPU pass through) Describe external REST API Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Integrated Openstack: Install, Configure, Manage [V7] 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 VMware Integrated Openstack: Install, Configure, Manage [V7] 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.
Course Overview This comprehensive course on "Complete After Effects for Graphic Design" is designed to equip learners with the skills necessary to use After Effects effectively in graphic design. Covering everything from creating visual effects and patterns to generating artwork from scratch, this course helps learners develop a deep understanding of After Effects tools and techniques. Learners will gain the confidence to create sophisticated animations and special effects that enhance their design projects. With practical lessons and a focus on industry-relevant skills, this course provides invaluable value to anyone looking to strengthen their graphic design capabilities using After Effects. Course Description In this course, learners will dive deep into the essential features of After Effects, including creating special effects, working with patterns and textures, and generating artwork from minimal input. The course takes a structured approach, starting with a solid introduction to After Effects, followed by advanced techniques for creating visually engaging content. By the end of the course, learners will be able to produce impressive animations and effects for use in graphic design projects. Throughout the course, learners will refine their understanding of animation principles and the software's advanced features, equipping them with the skills to implement creative ideas in a professional context. Course Modules Module 01: Introduction Introduction to After Effects interface Understanding key concepts in animation and motion design Navigating the timeline and workspace Module 02: Creating Special Effects Using effects and presets Creating cinematic effects for design Layering techniques and animation adjustments Module 03: Creating Patterns and Textures Working with textures and patterns Developing seamless loops and animated backgrounds Customising effects to suit design projects Module 04: Generating Artwork from (Almost) Nothing Techniques for generating artwork using basic shapes Exploring fractal animations and procedural design Using plugins to expand creative possibilities Module 05: Where to Go from Here Understanding next steps in advancing your After Effects skills Recommended resources for further learning Tips for building a professional portfolio (See full curriculum) Who is this course for? Individuals seeking to enhance their graphic design expertise. Professionals aiming to integrate animation and effects into their design projects. Beginners with an interest in digital design and animation. Designers wishing to improve their proficiency with After Effects. Career Path Graphic Designer Motion Graphics Designer Visual Effects Artist Animation Artist Digital Content Creator