Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE
Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE
Looking to build websites that don't just work—but win clients and pass audits? The WordPress Website Training Mini Bundle is your fast-track into one of the most in-demand spaces in digital careers. Whether you’re targeting agency roles, freelance gigs, or compliance-conscious businesses, this bundle makes you instantly hireable. Employers and clients alike are demanding professionals who understand WordPress, deliver seamless UX, write clean CSS, build with PHP, and keep everything compliance-friendly. This is your edge—and it’s available now. Description In today’s digital economy, you’re either visible or invisible. The WordPress Website Training Mini Bundle gives you the visibility employers want. Professionals fluent in WordPress, UX, CSS, PHP, and compliance are dominating the job boards, freelance platforms, and agency rosters—and this bundle puts you right in that lane. Whether you’re applying for your first junior developer role or scaling up as a freelancer, knowing how to build professional sites with WordPress, optimize UX, customize styles through CSS, code backend features in PHP, and maintain compliance standards makes you a must-hire. Businesses today are hyper-aware of user experience and legal risks—and if you can handle compliance alongside PHP-driven builds, they want you. Don’t wait for “someday.” While others delay, you could be developing job-ready fluency in WordPress, UX, CSS, PHP, and compliance—skills that translate into real income, real offers, and real results. FAQ Who should take the WordPress Website Training Mini Bundle? Anyone looking to become job-ready in web design or development roles where WordPress, UX, CSS, PHP, and compliance are key hiring criteria. How will this make me more hireable? Employers value applicants who understand how to build with WordPress, design clean UX, write responsive CSS, program in PHP, and meet compliance requirements. This combo is rare—and valuable. Is this bundle beginner-friendly? Absolutely. Whether you’re just starting or brushing up your stack, the WordPress, UX, CSS, PHP, and compliance blend ensures you're seen as capable and versatile.
Linux has grown into an industry-leading software and service delivery platform that is used for everything from super computers and Web servers to virtualized systems and your Android phone. This growth creates a high demand for qualified Linux professionals. This CompTIA Linux+ Certification Certified Training Course is designed to prepare you for the CompTIA Linux+ certification exam. It will provide you a comprehensive look at common tasks performed by system administrators. This includes installation, Management of Linux systems from the command line and the GUI, user administration, file permissions, customization, software configuration, Management of Linux-based clients, troubleshooting, and much more. Expanded coverage of networking and security are covered, which is in step with the CompTIA exam objectives. With this course, you'll acquire the fundamental skills and knowledge you need to successfully configure, manage and troubleshoot Linux systems. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then CompTIA Linux+ Certification Certified Training Course is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the accredited qualification. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £50,700. The sky really is the limit. Course Curriculum Installation Linux Introduction 00:25:00 Pre-installation Tasks 00:09:00 Linux Installation 00:18:00 Using Linux Graphical User Interfaces 00:26:00 Command Line Linux 00:56:00 File and Directory Management Directory Organization 00:33:00 File Management 00:58:00 Removable Storage 00:19:00 System Administration Users and Groups 00:57:00 File and Directory Permissions 00:53:00 User Environment Configuration 00:29:00 GUI Configuration 00:18:00 Application Management Packages and Package Managers 00:30:00 Source Code Software 00:20:00 System Configuration Disk Management 00:46:00 File System Management 00:29:00 Device Management 00:13:00 Process and Module Management Process Management 00:35:00 Process Priority and Execution 00:12:00 Kernel Modules 00:24:00 System Maintenance Backup and Restore 00:38:00 Scheduling Tasks 00:14:00 Performance Monitoring 00:26:00 Logging 00:39:00 Networking Networking Basics 00:58:00 Network Services 00:36:00 Domain Name Services 00:29:00 File Sharing and Printing Network File Resources 00:25:00 Printing 00:16:00 Interoperability Network Interoperability 00:18:00 Remote Desktop Access 00:08:00 Security System Security 00:23:00 Network Security 00:32:00 Web Environment Web Services 00:43:00 MySQL Services 00:13:00 FTP and Email Services FTP Services 00:36:00 Mail Services 00:05:00 Troubleshooting and Maintenance Booting Linux 00:28:00 Network Troubleshooting 00:11:00 Scripting Basics 00:08:00 Mock Exam Mock Exam - CompTIA Linux+ Certification Certified Training Course 00:20:00 Final Exam Final Exam - CompTIA Linux+ Certification Certified Training Course 00:20:00
The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City & Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners). During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning. We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course. (The kits may also be purchased by the learner….see the Kits Page Link for more details). The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.
Keep your drivers informed, compliant, and confident behind the wheel. Toolbox Talks are designed to improve driver knowledge, reduce risks, and support ongoing transport compliance. Each course tackles real-world challenges with clear, practical guidance drivers can apply immediately. 📲 24/7 online access for 3 months – start anytime, on any device!
CLASS SURVEYOR ADVANCED CERTIFICATE PROGRAM is CPD ACCREDITED ✔️- The course content is aimed at providing newly appointed surveyors and those as yet limited practical experience with solid technical knowledge about classification and statutory matters and thus allows participants to obtain "work-ready" knowledge. The training program is specifically structured for those looking to taking up the role of a Non-exclusive surveyor enabling them to properly undertake the duty imposed under the relevant Classification rules, it is intended to facilitate access to the knowledge and skills demanded by increasingly sophisticated maritime technology while meeting the requirements of: - Mandatory parts of the code for Recognized Organizations (IMO RO Code) and IMO Resolution A.1120(30), - IACS Proc Req. 2009/Rev.2 2019, - ISO 9001:2015, - ISO/IEC 17020:2012 standards.
Duration 4 Days 24 CPD hours This course is intended for This is an introductory-level Java programming course, designed for experienced developers who wish to get up and running with Java, or who need to reinforce sound Java coding practices, immediately. Overview Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Understand not only the fundamentals of the Java language, but also its importance, uses, strengths and weaknesses Understand the basics of the Java language and how it relates to OO programming and the Object Model Learn to use Java exception handling features Work with the Modular system (Project Jigsaw) Understand and use classes, inheritance and polymorphism Understand and use collections, generics, autoboxing, and enumerations Process large amount of data using Lambda expressions and the Stream API Abstract, static and private methods in interfaces Take advantage of the Java tooling that is available with the programming environment being used in the class Specific Java 11 features covered: Using the Local Variable Type in Lambda expressions; Updates made to the String AP Time Permitting: Quick look ahead - Java 12, Java 13, Java 14 and Beyond If you're an experienced OO developer (coming from a C# or C++ background, etc.) who needs to transition to programming in Java, this fast-paced, hands-on course will get you there quickly. Fast Track to Java Programming for OO Experienced Developers is a four-day, lab-intensive class where you'll quickly be immersed in working with the latest Java 11 programming techniques, using best practices for writing solid, robust (and well-written!) modern object-oriented applications. In addition to learning excellent, current coding skills in Java, you'll explore the new improved features for better performance and new capabilities for addressing rapid application development that Java 11 brings to the table. This course includes several key aspects that were introduced in Java 9, Java 10, and Java 11 including the Java Modular System, Local Variable Type Inference, and several API updates. This course also includes a Quick Look at what?s next in Java ? Java 12, Java 13, Java 14 and beyond. The Java Platform Java Platforms Lifecycle of a Java Program Responsibilities of JVM Documentation and Code Reuse Using the JDK Setting Up Environment Locating Class Files Compiling Package Classes Source and Class Files Java Applications The Eclipse Paradigm Workbench and Workspace Views Editors Perspectives Projects Writing a Simple Class Classes in Java Class Modifiers and Types Class Instance Variables Primitives vs. Object References Creating Objects Adding Methods to the Class Passing Parameters into Methods Returning a Value from a Method Overloaded Methods Constructors Optimizing Constructor Usage Language Statements Operators Comparison and Logical Operators Looping Continue and Break Statements The switch Statement The for-each() Loop Using Strings Create an instance of the String class Test if two strings are equal Get the length of a string Parse a string for its token components Perform a case-insensitive equality test Build up a string using StringBuffer Contrast String, StringBuffer, and StringBuilder Specializing in a Subclass Extending a Class Casting The Object Class Default Constructor Implicit Constructor Chaining Fields and Variables Instance vs. Local Variables: Usage Differences Data Types Default Values Block Scoping Rules Final and Static Fields Static Methods Using Arrays Arrays Accessing the Array Multidimensional Arrays Copying Arrays Variable Arguments Local-Variable Type Inference Type inference Infering Types of Local Variables The var Reserved Type name Benefits of Using var Backward Compatibility Java Packages and Visibility Class Location of Packages The Package Keyword Importing Classes Executing Programs Visibility in the Modular System Java Naming Conventions Inheritance and Polymorphism Polymorphism: The Subclasses Upcasting vs. Downcasting Calling Superclass Methods from Subclass The final Keyword Interfaces and Abstract Classes Separating Capability from Implementation Abstract Classes Implementing an Interface Abstract Classes vs. Interfaces Introduction to Exception Handling Exception Architecture Throwing Exceptions Checked vs. Unchecked Exceptions Exceptions Handling Multiple Exceptions Automatic Closure of Resources Creating Your Own Exceptions Utility Classes Wrapper Classes Autoboxing/Unboxing Enumeration Syntax Using Static imports Introduction to Generics Generics and Subtyping Bounded Wildcards Generic Methods Legacy Calls to Generics When Generics Should Be Used Lambda Expressions and Functional Interface Lambda Expression Syntax Functional Interfaces Type Inference in Java 8 Method references Collections Characterizing Collections Collection Interface Hierarchy The Set, List and Queue Interfaces Map Interfaces Using Collections Collection Sorting Comparators Using the Right Collection Lambda expressions in Collections Streams Processing Collections of data The Stream interface Reduction and Parallelism Filtering collection data Sorting Collection data Map collection data Find elements in Stream Numeric Streams Create infinite Streams Sources for using Streams Collectors Creating Collections from a Stream Group elements in the Stream Multi-level grouping of elements Partitioning Streams Introduction to the Module System Introduce Project Jigsaw Classpath and Encapsulation The JDK internal APIs Java 9 Platform modules Defining application modules Define module dependencies Implicit dependencies Implied Readability Exporting packages Java Date/Time The Date and Calendar classes Introduce the new Date/Time API LocalDate, LocalDateTime, etc. Formatting Dates Working with time zones Manipulate date/time values Java 12 and beyond Provide an overview of changes since Java 11 Introduce Preview Features Records (Java 14) Switch Expressions (Java 12, Java 13, Java 14) Text Blocks (Java 13, Java 14) Helpful NullPointerExceptions (Java 14) Pattern Matching for instanceof (Java 14) Additional course details: Nexus Humans Fast Track to Core Java Programming for Object Oriented Developers (TT2104-J11) 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 Fast Track to Core Java Programming for Object Oriented Developers (TT2104-J11) 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.
In the fiercely competitive tech job market, standing out is more than just writing code—it’s about mastering a versatile skill set that employers demand. The Software Developer & Programmer Career Path Mini Bundle is designed to boost your hireability by sharpening your expertise in Python, Go Lang, UX, DevOps, and leadership skills as a Team Leader. Whether you’re aiming to land your first developer role or climb into management, companies across industries—from fintech to health tech—are actively searching for professionals fluent in Python and Go Lang, adept in UX principles, proficient in DevOps, and ready to lead teams confidently as a Team Leader. Description Software development today isn’t just about coding. Mastery in Python and Go Lang gives you the technical backbone to build scalable applications, while strong UX knowledge ensures that what you build truly serves users. Add to that the operational savvy of DevOps and the interpersonal and strategic skills of a Team Leader, and you become a powerhouse hire. Employers value candidates who blend these competencies because they can drive projects from concept to delivery, collaborate across departments, and inspire teams to success. Whether working for startups, large corporations, or remote-first teams, your command of Python, Go Lang, UX, DevOps, and Team Leader skills puts you ahead of the curve. Don’t let the competition pass you by. This bundle bundles everything recruiters are demanding—from core programming languages to leadership traits—into one job-focused package. FAQ Who benefits most from this bundle? Aspiring and current software developers, programmers, tech leads, and anyone seeking to step into a leadership role. If you want to excel with Python, Go Lang, understand UX, manage infrastructures with DevOps, or grow as a Team Leader, this bundle is for you. Why include leadership in a programming bundle? Because modern software teams need developers who can lead. Being a Team Leader means managing people, timelines, and expectations—all vital for career growth beyond coding. Is this bundle beginner-friendly or advanced? It suits all levels. Beginners can build solid foundations in Python and Go Lang, while intermediate users gain skills in UX, DevOps, and Team Leader practices to boost hireability.
Spring Boot 3.0 and MongoDB make quite the duo—clean architecture meets agile data management, with none of the usual chaos. This course has been crafted for those who appreciate structured logic, lightning-fast performance, and the occasional sense of relief when code behaves as expected. Whether you're designing microservices or working with APIs, Spring Boot 3.0 brings clarity to complex Java development. Paired with MongoDB’s flexible document model, this course gives you a deep technical grounding without ever overcomplicating the process. You’ll be walked through essential configurations, RESTful services, and powerful integration patterns with MongoDB—all with a focus on cleaner code, scalable solutions, and secure deployments. From dependency injection to working seamlessly with Spring Data, every step is designed to make the backend behave. No fluff, just solid development principles with the latest tools in your hands. If you’re looking to sharpen your backend logic using two of the most talked-about technologies in modern application development, this course ticks that box—elegantly, of course. Learning Outcomes: Gain a solid understanding of the Spring Boot and MongoDB frameworks and their capabilities. Learn how to set up and configure a MongoDB environment, and integrate it with a Spring Boot application. Understand the CRUD operations and how to perform them using both MongoDB and Spring Boot. Discover the advanced concepts of DBRef and Collections Relationships, OpenAPI integration, and Documents Queries. Learn how to use Query Methods to access and manipulate data in MongoDB. The Master Spring Boot 3.0 and MongoDB course is the ultimate guide to mastering these two powerful technologies. Designed for both newcomers and seasoned professionals, this course will provide you with a comprehensive understanding of the Spring Boot and MongoDB frameworks and their capabilities. You'll learn how to set up and configure a MongoDB environment, and integrate it with a Spring Boot application. The course covers a range of topics, from the basics of CRUD operations to the advanced concepts of DBRef and Collections Relationships, OpenAPI integration, and Documents Queries. By the end of the course, you'll be equipped with the skills and knowledge you need to succeed in this dynamic and competitive field. Master Spring boot 3.0 and MongoDB Course Curriculum Section 01: Introduction Section 02: Prepare the Mongo Environment Section 03: Mongo Terms Section 04: Bootstrapping the Application Section 05: CRUD Operations Section 06: DBRef and Collections Relationships Section 07: OpenApi integration Section 08: Documents Queries and Mongo Template Section 09: Query Methods How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Software developers who want to enhance their skills and knowledge in Spring Boot and MongoDB. Professionals who want to stay up-to-date with the latest technologies and trends in software development. Individuals who are new to the field and want to learn about Spring Boot and MongoDB. Entrepreneurs who want to build scalable and reliable software applications using Spring Boot and MongoDB. Anyone who wants to develop their skills in the software development industry. Career path Full-Stack Developer: £27,000 - £71,000 Software Engineer: £25,000 - £62,000 Senior Software Engineer: £43,000 - £90,000 Technical Lead: £53,000 - £119,000 Solutions Architect: £63,000 - £150,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.