Excel Data Analysis Course Overview The Excel Data Analysis course is designed to equip learners with the essential skills needed to analyse and interpret data using Microsoft Excel. This course covers a range of tools and techniques that are vital for processing, summarising, and visualising data. Learners will explore functions, pivot tables, charts, and data manipulation strategies that will enable them to work efficiently with data sets. By the end of the course, learners will be able to transform raw data into meaningful insights, making it an invaluable skill for professionals across various industries. Whether you're looking to improve your data skills or progress in your career, this course offers the foundational knowledge required for data analysis in Excel. Course Description This course delves into the core aspects of Excel Data Analysis, starting with basic functions and advancing to complex data manipulation techniques. Learners will explore how to create and manage pivot tables, perform data filtering, and apply functions such as VLOOKUP and INDEX MATCH. Visualisation tools like charts and graphs will be covered, enabling learners to present their findings in a clear and impactful way. Additionally, learners will be introduced to data modelling, conditional formatting, and advanced formula techniques that will enhance their data analysis capabilities. The course is structured to provide a comprehensive understanding of Excel’s data analysis features, building competency for a wide range of practical applications in both personal and professional settings. Excel Data Analysis Curriculum Module 01: Introduction to Excel for Data Analysis Module 02: Using Excel Functions for Data Manipulation Module 03: Working with Pivot Tables and Pivot Charts Module 04: Data Visualisation: Creating Charts and Graphs Module 05: Advanced Excel Functions for Complex Data Analysis Module 06: Data Filtering and Sorting Techniques Module 07: Conditional Formatting for Data Insights Module 08: Introduction to Data Modelling and Forecasting Module 09: Data Analysis Best Practices and Case Studies (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to advance in data-centric roles. Beginners with an interest in data analysis and Excel. Anyone looking to improve their Excel knowledge for career development. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Administrative Assistant Project Manager Research and Development Analyst
Child Playwork Course Overview This comprehensive course on Child Playwork provides a deep understanding of the key principles and practices involved in the development and implementation of playwork for children. The programme explores the educational, developmental, and social benefits of play, while also addressing the importance of creating inclusive and safe play environments. Learners will gain valuable insights into playwork theory, the impact of play on child development, and the role of legislation in safeguarding children. By the end of the course, participants will be equipped with the knowledge to support children's play in various contexts, improving their well-being and social skills, and promoting a positive, inclusive learning environment. Course Description The Child Playwork course offers an in-depth exploration of the fundamental theories and practices of playwork, highlighting its essential role in child development. Learners will explore topics such as the developmental and educational benefits of play, inclusive play, the design of play spaces, and the impact of play deprivation. The course also covers the economic and social benefits of playwork, alongside the legislative framework surrounding safeguarding children. Through engaging modules, learners will develop a strong understanding of how play influences children's physical, emotional, and social growth. The course will provide a professional foundation for those wishing to pursue a career in playwork, equipping them with the tools to promote children's well-being and inclusion in a variety of settings. Child Playwork Curriculum Module 01: Introduction to Child Playwork Module 02: Playwork Theory, Principles and Practices Module 03: The Educational and Learning Benefits of Playwork Module 04: Play and Playwork in a Health and Well-Being Context Module 05: The Economic and Social Benefits of Playwork Module 06: The Developmental Benefits of Playwork Module 07: The Negative Results of Play Deprivation Module 08: Inclusive Play and Play Environment Module 09: Designing Play Spaces Module 10: The Administrative Context of a Playwork Provision Module 11: Legislation for Safeguarding Children and Child Playwork Module 12: Reflective Playwork Practice (See full curriculum) Who is this course for? Individuals seeking to support children's play development. Professionals aiming to expand their knowledge of playwork. Beginners with an interest in child development and education. Those seeking a career in child welfare and playwork provision. Career Path Playworker Play Supervisor Child Welfare Officer Early Years Practitioner Social Care Worker Educational Support Worker
Microsoft Office Basic to Advance Course Overview The "Microsoft Office Basic to Advanced" course provides comprehensive training on the essential applications in the Microsoft Office Suite. From Excel to Word, PowerPoint, and Access, this course equips learners with the skills needed to navigate and master each program's features. Whether you are looking to improve efficiency in everyday tasks or enhance your career prospects, this course covers everything from basic functions to advanced techniques, ensuring a thorough understanding of each program's capabilities. Upon completion, learners will be proficient in using Microsoft Office applications for personal, academic, and professional purposes, enhancing productivity and employability. Course Description This course dives into all key components of the Microsoft Office suite, offering in-depth coverage of Excel, Word, PowerPoint, and Access. Starting with the fundamentals, learners will gain expertise in managing data, creating documents, designing presentations, and managing databases. The course also covers advanced topics such as complex Excel functions, detailed document formatting in Word, effective presentation techniques in PowerPoint, and data management in Access. Through a blend of engaging activities and expert guidance, learners will acquire valuable skills to increase their productivity and confidently use these programs in any professional setting. Microsoft Office Basic to Advance Curriculum Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Microsoft Word 2019 Module 09: Microsoft Word 2019 New Features Module 10: Getting Started with Word Module 11: Formatting Text and Paragraphs Module 12: Working More Efficiently Module 13: Managing Lists Module 14: Adding Tables Module 15: Inserting Graphic Objects Module 16: Controlling Page Appearance Module 17: Preparing to Publish a Document Module 18: Workbooks - Microsoft Word 2016 (Beginner) Module 19: Microsoft PowerPoint 2019 Module 20: Microsoft PowerPoint 2019 New Features Module 21: PowerPoint Interface Module 22: Presentation Basics Module 23: Formatting Module 24: Inserting Options Module 25: Working with Objects Module 26: Table Module 27: Charts Module 28: Review and Presentation Module 29: Microsoft Access 2019 Module 30: Microsoft Access 2019 New Features Module 31: Introduction to Access Module 32: Modify Data Module 33: Working with Queries Module 34: Access Forms Module 35: Working with Reports (See full curriculum) Who is this course for? Individuals seeking to improve their Microsoft Office skills. Professionals aiming to enhance their software proficiency for career advancement. Beginners with an interest in office administration or data management. Those wishing to upgrade their knowledge of Microsoft Office for better job opportunities. Career Path Office Administrator Data Analyst Administrative Assistant Project Manager Executive Assistant IT Support Specialist
Touch Typing Essentials Course Overview The "Touch Typing Essentials" course is designed to help learners develop efficient and accurate typing skills. Covering all aspects of typing from basic finger positioning to typing punctuation and capital letters, this course is perfect for those who want to improve their typing speed and accuracy. Learners will gain a solid foundation in touch typing, enabling them to type confidently without looking at the keyboard. Whether you're a student, a professional, or anyone looking to improve your typing ability, this course will equip you with the skills necessary to type efficiently, leading to increased productivity and confidence in digital communication. Course Description This course provides a structured approach to mastering touch typing. It covers everything from setting up your computer for optimal typing to learning how to type individual letters, punctuation, and even capital letters. Each module focuses on building muscle memory for each key, ensuring learners develop speed and accuracy with each finger movement. Throughout the course, learners will be encouraged to practice regularly to improve typing speed while maintaining correct posture and ergonomics. By the end of the course, learners will have gained the skills needed to type quickly and efficiently, improving their overall digital literacy. Whether for personal development or professional purposes, this course prepares learners for success in today's fast-paced digital world. Touch Typing Essentials Curriculum Module 01: Introduction Module 02: How to Set up Your Computer Module 03: How to type the letters F and J Module 04: How to type the letters D and K Module 05: How to type the letters S and L Module 06: How to type the letter A and ; (semicolon) Module 07: How to type the letters E and I Module 08: How to type the letters R and U Module 09: How to type the letters T and O Module 10: How to type CAPITAL letters Module 11: How to type the letter C and , (Comma) Module 12: How to type the letters G and H Module 13: How to type the letters N and V Module 14: How to type the letters W and M Module 15: How to type the letters Q and P Module 16: How to type the letters B and Y Module 17: How to type the letters Z and X Module 18: How to type Colon and Semicolon Module 19: How to type Full Stop and Comma Module 20: How to type Question Mark and Exclamation Mark Module 21: How to type Dash, Parentheses and Quotation Marks (See full curriculum) Who is this course for? Individuals seeking to improve typing speed and accuracy. Professionals aiming to enhance productivity and efficiency. Beginners with an interest in improving digital literacy. Students preparing for academic or professional typing requirements. Career Path Administrative Assistant Data Entry Clerk Executive Assistant Virtual Assistant Customer Service Representative Content Writer Transcriptionist
Duration 5 Days 30 CPD hours This course is intended for Administrators, implementers and managers who are responsible for implementing, configuring and administering Service Manager 9.30. Overview At the end of the course, you will be able to:? Describe Service Manager environment andarchitecture? Install the various components of Service Manager? Learn the various implementation options (i.e.default ports, load balancing, components)? Perform tasks and set-up activities that are generallyperformed prior to moving the system to Production.? Perform daily administrative tasks such asperforming backups and monitoring log files,background processor activity, email activity, andschedule record activity.? Perform weekly administrative tasks such asarchiving and purging data? Perform monthly administrative tasks such ascleaning up the audit record, monitoring serverperformance statistics? Perform quarterly and annual administrative taskssuch as regenerating the work and holiday schedulerecords.? Additional administrative tasks, such as importing orexporting records.RECOMMENDED This class is targeted at system administrators responsible for the day to day management of the Service Manager application. The course focuses on the daily, weekly, monthly, quarterly, and annual tasks required to keep the system running efficiently. This class is targeted at system administrators responsible for the day to day management of the Service Manager application. The course focuses on the daily, weekly, monthly, quarterly, and annual tasks required to keep the system running efficiently. Additional course details: Nexus Humans SM320 - Service Manager 9.x Administration 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 SM320 - Service Manager 9.x Administration 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 2.5 Days 15 CPD hours This course is intended for This course is designed for administrators who configure and manage web-based applications on WebSphere Application Server. Web administrators, application developers and deployers, security specialists, and application architects can also benefit from this course.Prerequisite(s) Overview After completing this course, you should be able to:Relate WebSphere Application Server to the WebSphere family of productsDescribe the features and standards in WebSphere Application Server V9Describe the use of WebSphere Application Server in cloud, hybrid cloud, and on-premises environmentsDescribe the architectural concepts that are related to WebSphere Application ServerAssemble and install server-side Java enterprise applicationsUse WebSphere administrative tools to configure and manage enterprise applicationsUse wsadmin scriptingConfigure WebSphere Application Server securityView performance information about server and application componentsTroubleshoot problems by using problem determination tools and log files In this course, you learn how to configure and maintain IBM WebSphere Application Server V9 in a single-server environment. Course Outline Course introduction WebSphere product family overview WebSphere Application Server architecture - stand-alone Exercise: Profile creation WebSphere Application Server administrative console Exercise: Exploring the administrative console Introduction to the PlantsByWebSphere application Application assembly Exercise: Assembling an application Application installation Exercise: Installing an application Problem determination Exercise: Problem determination Introduction to wsadmin and scripting Exercise: Using wsadmin WebSphere security Exercise: Configuring WebSphere Application Server security Exercise: Configuring application security Performance monitoring Exercise: Using the performance monitoring tools Course summary Additional course details: Nexus Humans WA590 IBM WebSphere Application Server V9 Administration 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 WA590 IBM WebSphere Application Server V9 Administration 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 2 Days 12 CPD hours This course is intended for This course is intended for network administrators, operators, and engineers responsible for managing the normal day-to-day operation and administration of a BIG-IP application delivery network. This course presents the prerequisite knowledge for many other of F5's BIG-IP instructor-led training courses. Overview Getting started with the BIG-IP system Traffic processing with BIG-IP Local Traffic Manager (LTM) Using the TMSH (TMOS Shell) command line interface Using NATs and SNATs Monitoring application health and managing object status Modifying traffic behavior with profiles, including SSL offload and re-encryption Modifying traffic behavior with persistence, including source address affinity and cookie persistence Troubleshooting the BIG-IP system, including logging (local, high-speed, and legacy remote logging), and using tcpdump User roles and administrative partitions vCMP concepts Customizing application delivery with iRules This course gives network administrators, network operators, and network engineers a functional understanding of the BIG-IP system as it is commonly deployed in an application delivery network. The course introduces students to the BIG-IP system, its configuration objects, how it processes traffic, and how typical administrative and operational activities are performed. The course includes lecture, hands-on labs, interactive demonstrations, and discussions. Setting Up the BIG-IP System Introducing the BIG-IP System Initially Setting Up the BIG-IP System Configuring the Management Interface Activating the Software License Provisioning Modules and Resources Importing a Device Certificate Specifying BIG-IP Platform Properties Configuring the Network Configuring Network Time Protocol (NTP) Servers Configuring Domain Name System (DNS) Settings Configuring High Availability Options Archiving the BIG-IP Configuration Leveraging F5 Support Resources and Tools Traffic Processing Building Blocks Identifying BIG-IP Traffic Processing Objects Configuring Virtual Servers and Pools Load Balancing Traffic Viewing Module Statistics and Logs Using the Traffic Management Shell (TMSH) Understanding the TMSH Hierarchical Structure Navigating the TMSH Hierarchy Managing BIG-IP Configuration State and Files BIG-IP System Configuration State Loading and Saving the System Configuration Shutting Down and Restarting the BIG-IP System Saving and Replicating Configuration Data (UCS and SCF) Using NATs and SNATs Address Translation on the BIG-IP System Mapping IP Addresses with NATs Solving Routing Issues with SNATs Configuring SNAT Auto Map on a Virtual Server Monitoring for and Mitigating Port Exhaustion Monitoring Application Health Introducing Monitors Types of Monitors Monitor Interval and Timeout Settings Configuring Monitors Assigning Monitors to Resources Managing Pool, Pool Member, and Node Status Using the Network Map Modifying Traffic Behavior with Profiles Introducing Profiles Understanding Profile Types and Dependencies Configuring and Assigning Profiles Introducing SSL Offload and SSL Re-Encryption Managing Object State Modifying Traffic Behavior with Persistence Understanding the Need for Persistence Introducing Source Address Affinity Persistence Managing Object State Administering the BIG-IP System Configuring Logging Legacy Remote Logging Introducing High Speed Logging (HSL) High-Speed Logging Filters HSL Configuration Objects Configuring High Speed Logging Using TCPDUMP on the BIG-IP System Leveraging the BIG-IP iHealth System Viewing BIG-IP System Statistics Defining User Roles and Administrative Partitions Leveraging vCMP Configuring High Availability Introducing Device Service Clustering (DSC) Preparing to Deploy a DSC Configuration Configuring DSC Communication Settings Establishing Device Trust Establishing a Sync-Failover Device Group Synchronizing Configuration Data Exploring Traffic Group Behavior Understanding Failover Managers and Triggers Achieving Stateful Failover with Mirroring
Coming soon! Embark on a dynamic journey towards administrative mastery with our Level 3 Business Administrator course. Tailored for individuals stepping into the vibrant world of business administration, be it through recent recruitment or a well-deserved promotion, this program is crafted to instil a distinctive set of skills and insights essential for success in the administrative landscape.
Duration 5 Days 30 CPD hours This course is intended for Network Administrators Network security Administrators Network Security Engineer Network Defense Technicians CND Analyst Security Analyst Security Operator Anyone who involves in network operations Overview A dedicated focus on IoT security Network virtualization practices for the remote workforce Enhanced Cloud Security & IoT and Operational Technology (OT) Modules Introduction to threat intelligence In-depth Attack Surface Analysis Certified Network Defender (CND) is a vendor-neutral, hands-on, instructor-led comprehensive network security certification training program. It is a skills-based, lab intensive program based on the security education framework and work role task analysis presented by the National Infocomm Competency Framework (NICF) as well as a job-task analysis and cybersecurity education framework by the National Initiative of Cybersecurity Education (NICE). The course has also been mapped to global job roles and to the Department of Defense (DoD) job roles for system/network administrators. The program prepares network administrators how to identify what parts of an organization need to be reviewed and tested for security vulnerabilities and how to reduce, prevent, and mitigate risks in the network. CND covers the protect, detect, respond and predict approach to network security. Course Outline Network Attacks and Defense Strategies Administrative Network Security Technical Network Security Network Perimeter Security Endpoint Security-Windows Systems Endpoint Security-Linux Systems Endpoint Security- Mobile Devices Endpoint Security-IoT Devices Administrative Application Security Data Security Enterprise Virtual Network Security Enterprise Cloud Network Security Enterprise Wireless Network Security Network Traffic Monitoring and Analysis Network Logs Monitoring and Analysis Incident Response and Forensic Investigation Business Continuity and Disaster Recovery Risk Anticipation with Risk Management Threat Assessment with Attack Surface Analysis Threat Prediction with Cyber Threat Intelligence