• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5826 Computing courses in Rugby delivered Online

Mastering JEE Web Development (TT5100)

By Nexus Human

Duration 5 Days 30 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 JEE, or who need to reinforce sound Java for Web / JEE coding practices. Attendees should have a working knowledge of developing basic Java software applications. Overview Students who attend Mastering JEE Web Application Development will leave the course armed with the required skills to design and build scalable, secure, maintainable web applications - leveraging our extensive experience in the delivery of scalable enterprise applications with complex web interfaces based on JEE technologies. Throughout this training, you will be confronted with common web application design problems and given the tools you will need to solve them, such as JEE design patterns. You will also be exposed to a range of JEE and web technologies such as Servlets, JSPs, JSF, JNDI, CDI and advice on when and how to use them. Students will also learn about the capabilities of servlets, their advantages, servlet architecture, and session management. Developers will also learn about managing resources, deployment, and application models, how to use custom tags, and how to build robust and capable web applications using servlets and other components. The course begins with a discussion of web application architecture. A major part of the course is spent on the various web components that are used to implement dynamic web applications. Students will learn not only specific topics and APIs but also how to fit the pieces together into a complete application. Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will learn to: Design and build web applications from both business and technical requirements Build web interfaces with JSF, JSPs and Servlets, using the latest technologies in JEE. Write maintainable web applications that separate HTML and Java Understand the design and development of web applications using Servlets, JSPs, web fragments, and JSF Work JEE's version of dependency injection (CDI) Make Servlets cooperate and share data Store and process session information Deal with concurrency issues Access databases with JPA Work with annotations included in JEE Work with WebSockets as well as asynchronous servlets Use Java Bean validation in a web application Properly handle various types of exceptions This course is for experienced Java developers who are new to JEE and need to get up and running with essential dynamic web development skills. You will gain core JEE knowledge and skills that can be used as the foundation for developing production-quality web applications to a basic level. Developing Java EE applications Enterprise Development Java EE Core Components JEE Dynamic Web Applications Introduction to Servlets Form processing using Servlets Java Server Pages Implementing MVC in JEE Session Management JEE Servlet Filters and Listeners Servlet Filters Expression Language 3.0 (EL) Overview of EL The EL language Custom Tags Introduction to Custom Tags The Java Standard Tag Library Contexts and Dependency Injection (CDI) Introduction to CDI Using CDI CDI and Java EE Using Resources JEE DataSources Overview of JPA Java API for WebSocket Introduction to WebSocket Implementing WebSocket Endpoint Extending WebSockets Java Bean Validation (JSR 349) Introduction to Bean Validation Bean Validation Managing Web Applications Web Fragments Error Handling Asynchronous Servlets Web Security Introduction to Java Server Faces Introduction to JSF JSF Components Facelets Facelets Facelets Templating and Resources Additional course details: Nexus Humans Mastering JEE Web Development (TT5100) 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 Mastering JEE Web Development (TT5100) 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.

Mastering JEE Web Development (TT5100)
Delivered OnlineFlexible Dates
Price on Enquiry

SS84 IBM DFSMS Implementation

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate course for individuals responsible for developing and implementing effective storage management techniques. Overview Establish a DFSMS configuration to automatically enforce your installation's storage management policies Convert service level requirements into appropriate parameters for data class, storage class, management class, and storage groups Create and test Automatic Class Selection (ACS) routines Convert volumes and move data to system-managed volumes with DFSMS Data Set Services (DFSMSdss) Specify appropriate management class and storage group parameters for DFSMS Hierarchical Storage Management (DFSMShsm) processing of system-managed data sets Plan to maintain your DFSMS environment using Naviquest Establish procedures to control, manage, and recover the storage management subsystem with ISMF and operator commands Develop a DFSMS implementation plan In this course you will learn how to plan and implement DFSMS and learn how to manage temporary and permanent data sets with an emphasis on disk storage. Course introduction and DFSMS overview Specify the storage administration functions that can be automatically performed by the system Identify the types of data set services that need to be established by negotiating service level agreements Correlate data set service requirements to the SMS configuration components: data class, storage class, management class, storage group, and automatic class selection routines Activating SMS Identify the functions eligible for exploitation with the installation of DFSMS Data Facility Product (DFSMSdfp) and the activation of SMS Create SMS control data sets Code SYS1.PARMLIB operands necessary to bring up SMS Create a minimal configuration Activate a configuration Writing ACS routines Identify the purpose of the ACS routines Develop an understanding of the statements Differentiate between literals and masks Describe the read variables available in the ACS routines Managing temporary data sets Create/alter storage classes and storage groups Identify steps to install and use the starter set Write ACS routines to handle temporary data sets Activate a system to manage temporary data sets Code commands to change volume/group SMS status Issue operator commands to display current status Exploiting DFSMS Describe the purpose of the data class Identify the features that the data class can exploit Create data sets using the space parameter Define Virtual Storage Access Method (VSAM) and volume attributes for data class Identify special data sets and their exploitation through the data class Managing permanent data sets Create/alter data classes, storage classes, management classes, and storage groups Translate current (DFSMShsm) service level agreements to management class parameters Identify alternatives and concerns for standard naming conventions Establish the controls for automatic backup of data sets Establish the controls for automatic volume dump Write ACS routines to manage permanent data Create a configuration that manages permanent data sets Create a new managed data set Identify function of storage class exit provided by Custom-Built Installation Process Offering (CBIPO) and resulting System Management Facility (SMF) records Using Naviquest Create test cases using Naviquest Perform storage administration tasks in batch Create online DFSMS reports Create model commands using Naviquest Use the COPYFILT macro Device preparation and data movement Initialize volumes as system-managed Move data into/out from system-managed control Convert volumes to/from system-managed Move data to utilize new hardware capabilities Controlling DFSMS Code commands to change SMS volume/group status Issue commands to save configurations and use alternate Active Control Data Set (ACDS) Issue command to use alternate Communication Data Set (COMMDS) Issue VARY SMS commands Communicate with the security administrator about storage management requirements Additional considerations Establish a plan for implementing SMS Locate sources of implementation planning checklists Identify the tools available to document the current system Identify multiple site considerations for recovery and exploitation Additional course details: Nexus Humans SS84 IBM DFSMS Implementation 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 SS84 IBM DFSMS Implementation 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.

SS84 IBM DFSMS Implementation
Delivered OnlineFlexible Dates
Price on Enquiry

Salesforce Link Your Salesforce Data using Marketing Cloud Connect (MCC201)

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This course is ideal for email digital marketers responsible for managing the email channel for their organization, Salesforce Admins responsible for supporting users when Marketing Cloud Connect is installed, and customers who will be connecting their Salesforce org to Marketing Cloud using Marketing Cloud Connect. Overview When you complete this course, you will be able to: Explain Marketing Cloud Connect. Connect a Marketing Cloud account to a Salesforce org. Create individualized content blocks to leverage Salesforce CRM data using personalization strings and dynamic content. Create an email in Content Builder. Utilize the various sending methods to send to a Lead, Contact, Report, or Campaign in Marketing Cloud and Sales and Service Clouds. Automate sending emails using a Triggered Email, Automation Studio, and Journey Builder. Configure Synchronized CRM Sources to bring CRM data into Marketing Cloud. Segment data using Reports, Filter Activity, and Query Activity. Create journeys using Salesforce Activities in Journey Builder. Review tracking data in Marketing Cloud and Sales and Service Clouds. Create analytics reports in Marketing Cloud. Create and customize Marketing Cloud reports in Sales and Service Clouds. Create a dashboard based on Marketing Cloud reports. Unify and analyze your data in one place with Marketing Cloud Connect. In this 4-day class, you'll learn how to link your Marketing, Sales, and Service Clouds to seamlessly engage with your customers. Discover how to segment Salesforce data to create personalized, targeted emails. Track and report on those emails to see what resonates most with your customers so you can strengthen your relationships with them. Salesforce Marketing Cloud Overview Review the Customer Success Platform Get to Know Marketing Cloud Marketing Cloud Connect Review Marketing Cloud Connect Review the Various Ways to Connect the Clouds Marketing Cloud Connect Configuration Explore How to Connect the Clouds Review the Prerequisites for Marketing Cloud Connect Review Salesforce Terminology Connect a Marketing Cloud Account to a Salesforce Org Review Prework Personalized Digital Marketing Review What Functionality Can Be Accomplished in Each Cloud Create a Personalized Email Leveraging Salesforce CRM Data Using Content Builder Use Testing Tools Send a Marketing Cloud Email Manually to a Lead, Contact, Report, and Campaign Automate the Sending of an Email via a Triggered Email, Automation Studio, and Journey Builder Understand What Happens When an Email Is Sent Understand Subscriber Statuses Synchronized CRM Data Explain How and Why to Bring Salesforce CRM Data into Marketing Cloud Synchronize Data Sources in Contact Builder Create Segments Using Filters and the Query Activity Create a Salesforce Data Extension for Sending Create a Journey Using Synchronized Data Sources Test a Journey Journey Builder Explain Sales and Service Cloud Activities Create a Journey Using Sales and Service Cloud Activities Tracking and Reporting Understand the Tracking Data Available in Marketing Cloud Create and Automate Tracking Reports in Marketing Cloud Understand the Tracking Data Available in Sales and Service Cloud Create and Customize Marketing Cloud Reports in Sales and Service Cloud Create a Dashboard for Marketing Cloud Tracking Reports Additional course details: Nexus Humans Salesforce Link Your Salesforce Data using Marketing Cloud Connect (MCC201) 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 Link Your Salesforce Data using Marketing Cloud Connect (MCC201) 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.

Salesforce Link Your Salesforce Data using Marketing Cloud Connect (MCC201)
Delivered OnlineFlexible Dates
Price on Enquiry

C)HISSP-Certified Health Information Systems Security Practitioner Mile 2

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for IS Security Officers Privacy Officers Health IS Managers Risk Managers Information Security Managers Compliance and Privacy Officers Overview Upon completion, the student will be ready to take the Certified Healthcare Information Systems Security Practitioner exam by mile2. In addition, at the end of the CHISSP course, the student will be versed with best practices in the healthcare industry and will be able to establish a framework with current best practices in respects to privacy, regulation and risk management. The Certified Healthcare IS Security Practitioner, C)HISSP certification course covers the skills and knowledge to implement the best IT healthcare practices, as well as, regulatory compliance and standards in the healthcare industry. Because of growing industry regulations and privacy requirements in the healthcare industry, the C)HISSP was developed by Mile2. Graduates of this course have become vital in managing and protecting healthcare data and are tasked to protect patient information by implementing, managing, and assessing proper IT controls for patient health information integrity. Course Outline Intro to the Healthcare Industry Regulatory Environment Healthcare Privacy and Security Policies Information Governance Risk Management Third-Party Risk Management

C)HISSP-Certified Health Information Systems Security Practitioner Mile 2
Delivered OnlineFlexible Dates
Price on Enquiry

Beginning API Development with Node.js

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is targeted towards developers looking to build a career as a Node.js developer. This course offers you a deep but gentle dive into Node.js. You will start off by discovering the basic building blocks of the modern JavaScript language, which are necessary for you to have a good grasp of Node.js, before delving into the fundamentals of Node.js.Most courses quickly dive into Node.js forgetting that, at the end of the day, Node.js is still JavaScript. This can be challenging for JavaScript newbies who are then trying to build a solid house on a shaky foundation.This course overcomes that obstacle by beginning with a quick introduction to the modern JavaScript language (ES6+). You will then discover Node's asynchronous programming model and examine Node's module system, including built-in modules and application modularization, as well as the NPM third-party module registry. We will finish off by working on a simple web application API using the Hapi.js and Knex.js frameworks. Introduction to Node.js The Basics of Node.js The Module System Asynchronous Programming with Node.js Building the API: Part 1 Building a Basic HTTP Server Setting up Hapi.js Understanding Requests Building the API: Part 2 Working with the DB Using Knex.js Authenticating Your API with JWT Testing Your API with Lab Additional course details: Nexus Humans Beginning API Development with Node.js 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 Beginning API Development with Node.js 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.

Beginning API Development with Node.js
Delivered OnlineFlexible Dates
Price on Enquiry

Scrum Product Owner Certified (SPOC)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This certification is for anyone who interfaces with stakeholders or works as a Product Owner in a Scrum Team. Scrum Product Owner Certified (SPOC?) certification exam is designed to confirm applicants practical and working knowledge of Scrum that equips them to handle the business aspects and stakeholders in a Scrum environment. Successful candidates will be awarded the Scrum Product Owner Certified (SPOC?)certification by SCRUMstudy after passing the included certification exam. The certification exam voucher is included in this course so you can take the exam at your convenience. Agile & Scrum Overview What is Agile? Why use Agile? The Agile Manifesto Principles of the Agile Manifesto Agile Methods Other Agile Methods Scrum Overview Scrum Summary Scrum Roles Scrum Roles The Product Owner The Scrum Team The Scrum Master Advantages of Cross-functional Teams Planning in Scrum Scrum Flow Requirements in Scrum Prioritizing the Product Backlog Adaptive Project Management Scrum Planning User Stories The Concept of Persona Acceptance Criteria Generic Done Criteria Criteria for a Good User Story Estimation Importance of Value Risk Burndown Graphics Scrum Board Sprint Planning Sprints (from Product Owner?s point of view) Sprint Planning Meeting Planning Game Task Estimation The Sprint Backlog Implementation of Scrum Daily Stand-up Meeting Sprint Review Meeting Sprint Retrospective Meeting Product Backlog Grooming Scrum for Large Projects Scrum for Large Projects The Chief Product Owner Distributed teams in Scrum Transition to Scrum Mapping Traditional Roles to Scrum Maintaining Stakeholder Involvement Note SCRUMstudy has authored the SBOK? Guide as a comprehensive guide to deliver successful projects using Scrum. SCRUMstudy works through its large global partner network of Authorized Training Providers (A.T.P.s) to deliver trainings and certifications. New Horizons is a proud Authorized Training Provider of SCRUMstudy.

Scrum Product Owner Certified (SPOC)
Delivered OnlineFlexible Dates
Price on Enquiry

Sierra 101 - OS X Support Essentials 10.12

By Nexus Human

Duration 3 Days 18 CPD hours Overview ?The OS X Sierra troubleshooting process?How to use OS X Sierra tools and resources to troubleshoot OS X Sierra?OS X Sierra features and functionality, including how to find more information about OS X Sierra?How to prepare for Apple Certified Support Professional (ACSP) 10.12 certification In this course students will receive an in-depth exploration of troubleshooting on OS X Sierra. Installation and Configuration Install OS X Sierra Setup and Configuration OS X Recovery OS X Software Updates User Accounts User Accounts User Home Folders System Security Keychain Management File Systems File Systems and Storage FileVault 2 Permissions and Sharing File System Troubleshooting SIP Data Management Hidden Items and Shortcuts System resources Metadata and Spotlight File Archives Time Machine Applications and Processes Application Installation Document Management Application Management and Troubleshooting Network Configuration Network Essentials Advanced Network Configuration Network Troubleshooting Network Services Network Services Host Sharing and Personal Firewall System Management Peripherals and Drivers Print and Scan System Troubleshooting Additional course details: Nexus Humans Sierra 101 - OS X Support Essentials 10.12 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 Sierra 101 - OS X Support Essentials 10.12 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.

Sierra 101 - OS X Support Essentials 10.12
Delivered OnlineFlexible Dates
Price on Enquiry

Red Hat Linux Diagnostics and Troubleshooting with Exam (RH343)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The Red Hat Enterprise Linux Diagnostics and Troubleshooting course is aimed at senior system administrators who wish to learn more about troubleshooting. Overview As a result of attending this course, students should be able to analyze the operational state of computer systems and identify potential issues. When problems appear, students will be able to successfully resolve the issue, returning it to a secure and stable working condition. Students should be able to demonstrate the following skills: Diagnostic and analysis procedures Preventive maintenance planning and implementation System recovery using proven tools and techniques This course enriches your skills by providing the tools and techniques that you need to successfully diagnose, and fix, a variety of potential issues. You will work through hands-on problems in various subsystems to diagnose and fix common issues.You will learn develop the skills to apply the scientific method to a structured form of troubleshooting. You will then apply this approach in troubleshooting various types of problems, including boot issues, hardware issues, storage issues, RPM issues, network issues, third-party application issues, security issues, and kernel issues. At the end of the course, you will be empowered to complete various comprehensive review labs to test your skills.This course covers the same material as RH342, but includes the Red Hat Certified Specialist in Linux Diagnostics and Troubleshooting exam (EX342) Introduction to troubleshooting Describe a generalized strategy for troubleshooting. Take proactive steps to prevent small issues Prevent small issues from becoming large problems by employing proactive system administration techniques. Troubleshoot boot issues Identify and resolve issues that can affect a system's ability to boot. Identify hardware issues Identify hardware problems that can affect a system?s ability to operate. Troubleshoot storage issues Identify and fix issues related to storage. Troubleshoot RPM issues Identify and fix problems in, and using, the package management subsystem. Troubleshoot network issues Identify and resolve network connectivity issues. Troubleshoot application issues Debug application issues. Deal with security issues Identify and fix issues related to security subsystems. Troubleshoot kernel issues Identify kernel issues and assist Red Hat Support in resolving kernel issues. Red Hat Enterprise Linux Diagnostics and Troubleshooting comprehensive review Practice and demonstrate knowledge and skills learned in Red Hat Enterprise Linux Diagnostics and Troubleshooting. Additional course details: Nexus Humans Red Hat Linux Diagnostics and Troubleshooting with Exam (RH343) 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 Red Hat Linux Diagnostics and Troubleshooting with Exam (RH343) 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.

Red Hat Linux Diagnostics and Troubleshooting with Exam (RH343)
Delivered OnlineFlexible Dates
Price on Enquiry

Excel 2007 Simplified

By iStudy UK

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

Excel 2007 Simplified
Delivered Online On Demand8 hours 4 minutes
£25

Critical Thinking, Problem Solving and Decision Making: Part 2

By iStudy UK

Course Description The Critical Thinking, Problem Solving and Decision Making: Part 2 course is designed to enhance your problem-solving and decision-making skills through developing critical thinking. In this course, you will learn about the standards and steps of critical thinking. The course will help you to enhance and boost your critical thinking skills. You will also learn about the characteristics and qualities of a critical thinker. This bite-size course will help you to make better decisions and solve problems with critical thinking. Enrol the course now if you want to develop these skills. Learning outcome  Gain knowledge about the standards and steps of critical thinking Enhance your critical thinking skills Learn about the characteristics of a critical thinker Make better decisions with critical thinking How Much Do Managers Earn? Senior - £70,000(Appx.) Average - £46,000(Appx.) Starting - £36,000(Appx.) Requirement Our Critical Thinking, Problem Solving and Decision Making: Part 2 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Critical Thinking, Problem Solving and Decision Making: Part 2 Module 01: What Are the Critical Thinking Steps 00:17:00 Module 02: Critical Thinking Strategies 00:25:00 Module 03: Recognising a Critical Thinker 00:23:00 Module 04: Decision Making with Critical Thinking 00:26:00 Module 05: Problem-Solving Through Critical Thinking 00:25:00 Assignment Assignment - Critical Thinking, Problem Solving and Decision Making: Part 2 00:00:00

Critical Thinking, Problem Solving and Decision Making: Part 2
Delivered Online On Demand1 hour 56 minutes
£25