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

4438 Courses

Microsoft Office 2016 Access Advanced - Complete Video Course

4.3(43)

By John Academy

Description: Released by Microsoft, Microsoft Access 2016 is a data-based organization program created to help users analyze data and information. This application deals with managing related data being more efficient compared to other spreadsheet applications. It is impossible to become expert in using this application if you don't know how to use Access 2016 works which this Microsoft Office 2016 Access Advanced - Complete Video Course is all about. Dealing with large amount of data can be stressful if you don't know how to use this Office application in the first place. Using data validation, macros, and implementing advanced form design are some of the features of Access 2016 so take the opportunity to take this course will help you utilize these and more. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Access Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Access Advanced - Complete Video Course 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. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 01 Add Controls to Forms FREE 00:11:00 Enhance Navigation and Organization of Forms 00:14:00 Apply Conditional Formatting 00:04:00 Module 02 Import Data into Access 00:08:00 Export Access Data 00:06:00 Link Tables to External Data Sources 00:05:00 Create a Mail Merge 00:02:00 Module 03 Create a Macro 00:08:00 Restrict Records by Using a Condition 00:04:00 Validate Data by Using a Macro 00:05:00 Automate Data Entry by Using a Macro 00:04:00 Module 04 Manage a Database 00:08:00 Determine Object Dependency 00:04:00 Module 05 Manage a Database 00:07:00 Determine Object Dependency 00:04:00 Document a Database 00:04:00 Module 06 Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:03:00 Convert an Access Database to an ACCDE File 00:04:00 Package a Database with a Digital Signature 00:01:00 Module 07 Create a Database Switchboard 00:05:00 Modify a Database Switchboard 00:02:00 Set Start up Options 00:04:00 Mock Exam Mock Exam- Microsoft Office 2016 Access Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Access Advanced - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Access Advanced - Complete Video Course
Delivered Online On Demand2 hours 42 minutes
£24

CompTIA Linux+ Certification - Complete Video Course

4.3(43)

By John Academy

Description 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 - Complete Video 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. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our CompTIA Linux+ Certification - Complete Video Course 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. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Installation Linux Introduction FREE 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 - Complete Video Course 00:20:00 Final Exam Final Exam- CompTIA Linux+ Certification - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

CompTIA Linux+ Certification - Complete Video Course
Delivered Online On Demand19 hours 16 minutes
£23.99

70-662 - Deploying Microsoft Exchange Server 2010 S

4.3(43)

By John Academy

Description: The 70-662 - Deploying Microsoft Exchange Server 2010 S course prepares you for the exam 70-662 - Deploying Microsoft Exchange Server 2010 S. The purpose of the MCTS: Microsoft Exchange Server 2010 certification is to validate your skills in support for the maintenance and administration of the Exchange servers in an enterprise environment. In the course, you will learn how to use active directory and support infrastructure, use active directory components, and the network-based services. The course also teaches you about the server roles in Exchange Server 2010, and infrastructure requirements for Exchange Server 2010. You will learn about mailbox servers and recipients, securing the server, mailbox database update process, public folder process for MAPI clients, and e-mail address policies. The course will focus the ways of managing client access, POP3 and IMAP4 options, and Outlook client connectivity troubleshooting. Finally, the course will teach you how to manage Message Transports, Exchange Security and how to implement High Availability. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? 70-662 - Deploying Microsoft Exchange Server 2010 S is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-662 - Deploying Microsoft Exchange Server 2010 S 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. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Active Directory and Supporting Infrastructure 70-662-Active Directory and Supporting Infrastructure FREE 00:15:00 70-662-Active Directory Components 00:24:00 70-662-Network Based Services 00:21:00 70-662-Server Roles in Exchange Server 2010 00:21:00 70-662-Infrastructure Requirements for Exchange Server 2010 00:21:00 Mailbox Servers and Recipients 70-662-Mailbox Servers and Recipients 00:58:00 70-662-Secure the Server 00:38:00 70-662-Mailbox Database Update Process 00:26:00 70-662-Public Folder Process for MAPI Clients 00:29:00 70-662- E-Mail Address Policies 00:17:00 Managing Client Access 70-662-Managing Client Access 00:46:00 70-662-POP3 and IMAP4 Options 00:35:00 70-662-Outlook Client Connectivity Troubleshooting 00:23:00 Managing Message Transports 70-662-Managing Message Transports 00:49:00 70-662-How S MIME Works 00:39:00 70-662- Back Pressure - System Monitoring 00:15:00 70-662-Edge Transport Server Security 00:36:00 Exchange Security 70-662-Exchange Security 00:36:00 70-662-Management Role Assignment Policies 00:26:00 70-662-Messaging Policy and Compliance 00:34:00 70-662-Message Classifications 00:21:00 70-662-Considerations for Managing the Message Journal Mailbox 00:37:00 70-662-Managed Folders 00:19:00 Implementing High Availability 70-662-Implementing High Availability 00:18:00 70-662-Database Availability Group 00:32:00 70-662-Transport Dumpster 00:27:00 70-662-Backup and Restore Scenarios 00:26:00 70-662-Database Mobility 00:21:00 70-662-Network and Performance Guidelines 00:18:00 Mock Exam Mock Exam- 70-662 - Deploying Microsoft Exchange Server 2010 S 00:20:00 Final Exam Final Exam- 70-662 - Deploying Microsoft Exchange Server 2010 S 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

70-662 - Deploying Microsoft Exchange Server 2010 S
Delivered Online On Demand14 hours 28 minutes
£24

CompTIA Security+ Certification - Complete Video Course

4.3(43)

By John Academy

Description: The CompTIA Security+ (SY0-401) certification course provides information about the corporate security which is recognised as one of the fastest-growing fields in IT. Every institution even small business invests in IT security to secure their confidential data. The course covers the security fundamentals including the information security cycle, information security controls, authentication methods, cryptography fundamentals, and security policy fundamentals. Throughout the course, you will learn the Security Threats and vulnerabilities, Managing data, Application and Host Security, and the system of implementing Networking Security, implementing access control, authentication and Account Management, and implementing Compliance and Operating Security. Finally, the course will teach you how to manage certificates, how to manage risk, how to troubleshoot and manage security incidents, and the proper Business Continuity and Disaster Recovery Planning. In short, the course helps you to acquire competency in network infrastructure, system security, organizational security and access control. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our CompTIA Security+ Certification - Complete Video Course 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. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Security Fundamentals The Information Security Cycle FREE 00:37:00 Information Security Controls 00:35:00 Authentication Methods 00:09:00 Cryptography Fundamentals 00:56:00 Security Policy Fundamentals 00:11:00 Identifying Security Threats and Vulnerabilities Social Engineering 00:31:00 Malware 00:25:00 Software-Based Threats 00:21:00 Based Threats 00:38:00 Wireless Threats and Vulnerabilities 00:43:00 Physical Threats and Vulnerabilities 00:09:00 Managing Data, Application, and Host Security Manage Data Security 00:47:00 Manage Application Security 00:56:00 Manage Device and Host Security 01:07:00 Manage Mobile Security 00:10:00 Implementing Network Security Configure Security Parameters on Network Devices and Technologies 00:49:00 Network Design Elements and Components 00:26:00 Implement Networking Protocols and Services 01:09:00 Apply Secure Network Administration Principles 00:12:00 Secure Wireless Traffic 00:31:00 Implementing Access Control, Authentication, and Account Management Access Control and Authentication Services 00:42:00 Implement Account Management Security Controls 00:33:00 Managing Certificates Install a CA Hierarchy 00:25:00 Enroll Certificates 00:13:00 Secure Network Traffic by Using Certificates 00:03:00 Renew Certificates 00:01:00 Back Up and Restore Certificates and Private Keys 00:05:00 Revoke Certificates 00:07:00 Implementing Compliance and Operational Security Physical Security 00:20:00 Legal Compliance 00:10:00 Security Awareness and Training 00:11:00 Integrate Systems and Data with Third Parties 00:08:00 Risk Management A Risk Analysis 00:17:00 Implement Vulnerability Assessment Tools and Techniques 00:04:00 Scan for Vulnerabilities 00:27:00 Mitigation and Deterrent Techniques 00:19:00 Troubleshooting and Managing Security Incidents Respond to Security Incidents 00:23:00 Recover from a Security Incident 00:09:00 Business Continuity and Disaster Recovery Planning Business Continuity 00:17:00 Plan for Disaster Recovery 00:17:00 Execute DRPs and Procedures 00:13:00 Mock Exam Mock Exam- CompTIA Security+ Certification - Complete Video Course 00:20:00 Final Exam Final Exam- CompTIA Security+ Certification - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

CompTIA Security+ Certification - Complete Video Course
Delivered Online On Demand17 hours 26 minutes
£24

Certified Kubernetes Security Specialist (CKS) Course

By Packt

Want to learn about Kubernetes security or need to pass the Certified Kubernetes Security Specialist (CKS) exam? You are at the right place. A hands-on course to help you develop your Kubernetes security skills. You need to have a basic understanding of Kubernetes Administrator to get the best out of this course.

Certified Kubernetes Security Specialist (CKS) Course
Delivered Online On Demand6 hours 5 minutes
£19.99

Excel 2016 Advanced

By iStudy UK

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification

Excel 2016 Advanced
Delivered Online On Demand2 hours 21 minutes
£25

Excel 365 Advanced

By iStudy UK

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00

Excel 365 Advanced
Delivered Online On Demand4 hours 55 minutes
£25

70-417 - Upgrading Your Skills to MCSA Windows Server 2012

4.3(43)

By John Academy

Description: The 70-417 - Upgrading Your Skills to MCSA Windows Server 2012 course provides all the essential topics and skills that you need to know for MCSA Windows Server. The course will upgrade your skills to MCSA Windows Server 2012. Throughout the course, you will learn how to install and configure servers, configure server roles, features and Hyper-V, install and administer Active Directory, configure network services and access, configure a network policy server infrastructure, and deploy, manage, and maintain servers. The course will also show you how to configure and manage Active Directory, group policy and high availability, configure file and storage solutions, implement business continuity and disaster recovery, configure network services, identity and access solutions. If you pass the exam, you will be qualified as a Microsoft Certified Solutions Associate (MCSA) in Windows Server 2012. The purpose of the course is to prepare you for the Exam. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? 70-417 - Upgrading Your Skills to MCSA Windows Server 2012 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-417 - Upgrading Your Skills to MCSA Windows Server 2012 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. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Install and Configure Servers Install and Configure Servers FREE 00:17:00 Features with Windows Server 2012 00:11:00 Installing Windows 2012 Enterprise 00:09:00 Windows Server Installation 00:12:00 Introduction to Server Manager 00:07:00 Post Server Installation Tasks 00:11:00 Configure Server Roles and Features Configure Server Roles and Features 00:08:00 Add Roles Server Manager 00:16:00 Event Viewer 00:04:00 Best Practice Analyzer 00:06:00 Administrative Tools Available 00:08:00 Delegation of Domain Administration 00:09:00 Advanced Services 00:11:00 Introduction to PowerShell 00:16:00 Installing Server Core 00:07:00 PowerShell 00:11:00 Server Core Tools 00:16:00 Recover from Closing Command Prompt 00:01:00 Netsh-Firewall 00:04:00 Sconfig on Server Core 00:08:00 PowerShell Examples for User Management 00:12:00 Configure Hyper-V Configure Hyper-V 00:12:00 Enable Remote Management 00:05:00 Remote Desktop 00:08:00 Server Groups 00:01:00 Virtualization 00:17:00 Create a VM 00:07:00 Hyper-V Settings 00:03:00 Virtual Hard Disk 00:17:00 Managing VHD's 00:12:00 Virtual Networks 00:08:00 Hyper-V Network Settings33 00:06:00 Creating Network Adapters66 00:02:00 Considerations for VM Network Configuration 00:12:00 Install and Administer Active Directory Install and Administer Active Directory 00:48:00 Overview of Domain Controllers 00:19:00 Best Practices - FSMO and GC 00:25:00 RODC 00:11:00 Install Domain Controllers 00:31:00 Active Directory Management Tools 00:20:00 Groups 00:39:00 Delegate Management of Active Directory Objects 00:11:00 Deploy, Manage, and Maintain Servers Deploy, Manage, and Maintain Servers 00:32:00 Types of Images 00:43:00 Unattended Installations 00:18:00 WSUS 00:40:00 Monitoring Servers 01:30:00 Configure Network Services and Access Configure Network Services and Access 00:40:00 How DNS Forwarding Works 00:21:00 Zone Transfers 00:24:00 DNS Caching 00:04:00 Configure a Network Policy Server Infrastructure Configure a Network Policy Server Infrastructure 00:46:00 VPN Access ss 00:37:00 Components of Network Policy 00:07:00 Direct Access Features 00:18:00 Troubleshooting Tools 00:29:00 Certificates 00:03:00 Configure and Manage Active Directory Configure and Manage Active Directory 01:02:00 Managed Service Accounts 00:16:00 Create Account Policies and User Rights Assignments 00:40:00 Maintain Active Directory Domain Services 00:42:00 Configure and Manage Group Policy Configure and Manage Group Policy 00:22:00 Windows Client Policy Processing 00:08:00 Starter GPO's 00:30:00 Group Policy Links 00:20:00 Other Group Policy Options 01:07:00 Configure and Manage High Availability Configure and Manage High Availability 00:36:00 Server 2012 Failover Clustering 00:19:00 Quorum Definitions 00:20:00 Multi-Site Failover Cluster 00:10:00 Management Tools 00:11:00 Configure File and Storage Solutions Configure File and Storage Solutions 00:17:00 Discretionary Access Control 00:10:00 Creating Claims 00:19:00 File Classification 00:34:00 iSCSI 00:35:00 Implement Business Continuity and Disaster Recovery Implement Business Continuity and Disaster Recovery 00:15:00 Backup Types 00:16:00 System Restore 00:26:00 Windows RE 00:17:00 Configure Network Services Configure Network Services 00:20:00 Super Scopes and Multinetting 00:21:00 DNS Solutions s 00:23:00 DNS Cache Locking 00:26:00 IPAM (IP Address Management) 00:13:00 IPAM Abilities s 00:10:00 GPO Provisioning 00:29:00 Configure Identity and Access Solutions Configure Identity and Access Solutions 00:13:00 Web Services 00:09:00 C AD FS Components 00:16:00 Mock Exam Mock Exam- 70-417 - Upgrading Your Skills to MCSA Windows Server 2012 00:20:00 Final Exam Final Exam- 70-417 - Upgrading Your Skills to MCSA Windows Server 2012 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

70-417 - Upgrading Your Skills to MCSA Windows Server 2012
Delivered Online On Demand29 hours
£24

Diploma in Spiritual & Mental Development

4.3(43)

By John Academy

Are you interested in dealing with your spiritual development? How about mental development? Are you curious how your spiritual mental development is going? If so, then this diploma course will help you and your needs. Description: Considering your practices, convictions, contemplation and so forth and transforming those agnostic musings into helpful implies that you are propelling yourself to exchange. Handle what is overloading your mental, physical, and spiritual states. Take the terrible dilemma and direct it into something suitable. A little diversion to your circumstance now and again, affiliation play does an incredible arrangement for our psyche, soul, and body. You also have to bear in mind that spiritual is your arrangement of convictions, standards, values, ethics, benchmarks, and so on. Attempt to avoid over being invigorated. Build up your interests, convictions, ethics, measures, standards, values, exercises, fellowships and begin figuring out how to carry on with the enthusiastic torment to demand to vanquish your own inconveniences and further settle your reasoning propensities. Advancing overthrow will put you making progress toward accomplishment by setting aside the opportunity to build up your abilities, inspiration, and so on. You need to develop inborn status, re-establishing your faculties back to its unique states to feel your spiritual, mental, and physical being feel restored that you will be able to understand in this course. Who is the course for? Anyone regardless if they have prior knowledge or not in spiritual and mental health development Anyone who thinks they possess a maturity to reflect their own development as a person, both mentally and spiritually. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Spiritual Mental Development will be very beneficial and helpful, especially to health and mental-related careers like: Clinical Psychologists Counsellors Mental Health Experts Music Therapists Psychologists Psychotherapists And Much More! Module-1 Introduction 00:15:00 Understanding your Mental and Physical Mind to Development of Self Spiritual 00:30:00 Spiritual Acceleration Mental Learning in Physical Self Development 00:15:00 Physical Acceleration Mental Learning in Spiritual Self Development 00:30:00 Self Development through Speed Learning in Mental Physical and Spiritual Awakenings 00:30:00 Motivation Self Development Techniques for Mental Physical and Spiritual States 01:00:00 Module-2 Self Development in Improving Mental Physical and Spiritual High Court 00:30:00 Growing in Mental Physical Spiritual through Self Development 00:30:00 Relationships in Self Development of Mental Physical and Spiritual States 00:30:00 Planning your Future in Mental Physical and Spiritual Self Development 01:00:00 Benefiting from Subliminal Mental Physical and Spiritual Self Development 00:30:00 Benefiting from Mind Attitude Fleshly and Spiritual Aplomb Development 00:30:00 Module-3 Innate Mental Physical and Spiritual Self Development Intimate Positive self-image in Personality Physical and Glorified Inner strength Development 01:00:00 Self Development Tactics in Mental Physical and Spiritual Subliminal Training 01:00:00 Concentrating on Self Development of Mental Physical and Spiritual Improvement 00:30:00 Suggestology in Self Development of Spiritual Mental and Physical States 00:30:00 Optimism Strengths in Self Development of Mental Spiritual and Physical States 00:15:00 Self Development of Awareness in Mental Spiritual and Physical Learning 01:00:00 Module-4 Routine Self Development in Mental Spiritual and Physical Recovery 00:30:00 Viewpoints in Mental Spiritual and Physical Self Development 00:15:00 Breaking Down Mental Spiritual and Physical Self Development 00:15:00 Logic in Mental Spiritual and Physical Self Development 00:15:00 Aspects in Mental Spiritual and Physical Self Development 00:15:00 Emotions in Development Mental Spiritual and Physical Self 00:15:00 Module-5 Self Development of Mental Spiritual and Physical Meditation 00:15:00 Development of Mental Untainted and Physical Self 00:15:00 Battle Common Problems in Mental Spiritual and Physical Self Development 00:30:00 Exploring the Past in Mental Spiritual and Physical Self Development 00:15:00 Reducing Stress in Mental Spiritual and Physical Self Development 01:00:00 Reviewing You in Mental Spiritual and Physical Self Development 00:15:00 Module-6 Discovering Humanity in Mental Spiritual and Physical Self Development 01:00:00 Self-Headway Tactics in Mind Physical and Spiritual 00:15:00 Mental Structures in Physical and Spiritual Self Development 00:30:00 Mental Spiritual and Physical Self Development Processes 00:15:00 Unzipping the Subliminal in Mental Spiritual and Physical Self Development 00:15:00 Beneficial of Positive Mental Spiritual and Physical Self Development 00:30:00 Module-7 Success in Mental Spiritual and Physical Self Development 00:15:00 Abolishing the Master of Failure in Mental Spiritual and Physical Self Development 00:15:00 Suggestions in Mental Spiritual and Physical Self Development Suggestions 00:15:00 Hypnosis in Mental Spiritual and Physical Self Development 00:15:00 Thinking Processes in Mental Spiritual and Physical Self Development 00:15:00 Mental Power in Spiritual and Physical Self Development 00:15:00 Module-8 Optimising your Power to Mental Spiritual and Physical Self Development 00:30:00 Diaries of the Mind in Mental Spiritual and Physical Self Development 00:15:00 Persuading Resources in Mental Spiritual and Physical Self Development 00:15:00 Building Inner Strengths in Mental Spiritual and Physical Self Development 00:15:00 Reforming your Mental Spiritual and Physical Self through Development 00:15:00 Brain Enhancers in Mental Spiritual and Physical Self Development 00:30:00 Module-9 Innate Relaxation Control to Mental Spiritual and Physical Self Development 00:15:00 Enhancing Techniques in Mental Spiritual and Physical Self Development 00:15:00 Holistic Training in Mental Spiritual and Physical Self Development 00:30:00 Commonsense Practices in Mental Spiritual and Physical Self Development 00:15:00 Conclusion 00:15:00 Mock Exam Mock Exam- Diploma in Spiritual & Mental Development 00:20:00 Final Exam Final Exam- Diploma in Spiritual & Mental Development 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Spiritual & Mental Development
Delivered Online On Demand23 hours 25 minutes
£23.99

Accredited Diploma in Professional Chef

By iStudy UK

Follow your passion and become a Professional Chef Are interested in cooking and want to be in charge of your own kitchen? Do you often find yourself in the kitchen trying to invent your own signature dishes? Then you have the skills to be a professional chef. This course will the perfect platform for you to learn what is expected and how to be a professional chef. Chefs and head cooks use a variety of kitchen and cooking equipment, including step-in coolers, high-quality knives, meat slicers, and grinders. They also have access to large quantities of meats, spices, and produce. Some chefs use scheduling and purchasing software to help them in their administrative tasks. Some chefs run their own restaurant or catering business. These chefs are often busy with kitchen and office work and have little time to interact with diners. If you want to have your own business, then you also need to learn how to manage your restaurant. All of these qualities will be taught in this diploma course on how to be a professional chef. Course Highlights Accredited Diploma in Professional Chef is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Diploma in Professional Chef into 92 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 2 days, 20 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Diploma in Professional Chef Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Diploma in Professional Chef is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Diploma in Professional Chef 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. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Becoming a Chef Can TV Chefs Teach You To Cook? FREE 01:00:00 Improving Cooking And Food Preparation Skills FREE 00:30:00 Catering To Unique Tastes 00:30:00 Qualities Of A Successful Chef 00:30:00 Achieve Perfection As A Saucier 00:30:00 Becoming The Perfect Chef 01:00:00 Equipment For Perfect Chefs 00:30:00 How To Become The Perfect Chef: Attending School 00:30:00 The Keys To Getting and Using Feedback 00:30:00 What Can You Do With A Culinary Degree 01:00:00 Knife Skills For The Perfect Chef 00:30:00 Making Meals Easy to Eat Healthy 01:00:00 Plating for the At Home Chef 00:30:00 Perfect Chefs Choose A Speciality 00:30:00 Finding Local Cooking Classes 00:30:00 How Can You Become a Professional Chef 00:30:00 The Physical Qualities of the Perfect Chef 00:30:00 The Importance of Testing Recipes 00:30:00 The Chefs Important Baking Tools 01:00:00 The Learning Curve To Becoming The Perfect Chef 00:30:00 The Job of a Professional Chef 00:30:00 The Mix of Sweet, Spicy and Savory 00:30:00 The Perfect At Home Chef 01:00:00 The Perfect Chef Opens A Restaurant 00:30:00 The Physical Demand of Being a Chef 00:30:00 Kitchen Management Buying Kitchen Equipment: Tips And Tricks To Save Money FREE 01:00:00 The Well Equipped Kitchen FREE 00:15:00 Take Inventory 01:00:00 Be Wary Of The Latest Trends 01:00:00 Inexpensive Vs. Cheap 00:15:00 Needing Vs. Wanting 01:00:00 Comparison Shopping 01:00:00 How To Find The Best Deals 01:00:00 Secrets Of Outdoor Cooking Recipes 01:00:00 Once A Month Cooking Recipes 00:15:00 Mother's Day Cooking Made Easy 01:00:00 Mardi Gras Cooking Cajun Style 00:30:00 Learn To Cook Italian Food On Vacation 01:00:00 Cooking With A Dutch Oven 01:00:00 Recipes Of Italian Vegetarian Cooking 01:00:00 Home Cooking Network: An Array Of Recipes 00:30:00 America's Home Cooking: The Television Program 01:00:00 A Wonderful Experience With Outdoor Cooking Burners 00:30:00 Cooking For Sunday Dinner 01:00:00 Healthy Cooking Oils 01:00:00 Cooking Cajun Food 01:00:00 Paula's Home Cooking Recipes 00:30:00 The Importance Of Eating A Healthful Vegetarian Diet 01:00:00 Italian Food On A Date 00:30:00 The History Of Pasta In Italian Food 01:00:00 Review Of Different Vegetarian Cooking Shows 00:30:00 Italian Cooking Brochutto 01:00:00 Cooking Christmas Cookies 01:00:00 Back To Beginning For President's Day Cooking 00:30:00 Microwave Bacon Cooking Equipment 00:30:00 Cheap Italian Food In Milan 01:00:00 Chinese Cooking Wok 01:00:00 7 Useful Cooking Tips And Hints 01:00:00 Down Home Cooking 00:30:00 Italian Cooking School 00:30:00 Cooking Games 00:30:00 Italian Cooking Recipes 00:30:00 French Cooking Holidays 00:30:00 Managing Restaurant Food Business Basics 01:00:00 Put Together Your Business Concept 00:30:00 Identify your Target Market 00:30:00 Identify Your Competition 00:30:00 Write A Mission Statement 00:30:00 Downline Basics 01:00:00 Equipment And Supplies 00:30:00 Marketing And Quality Control 00:30:00 Wrapping Up 00:15:00 Recipes Recipe - I 01:00:00 Recipe - II 01:00:00 Recipe - III 01:00:00 Recipe - IV 01:00:00 Recipe - V 01:00:00 Recipe - VI 01:00:00 Recipe - VII 01:00:00 Recipe - VIII 01:00:00 Recipe - IX 01:00:00 Recipe - X 01:00:00 Recipe - XI 00:30:00 Recipe - XII 00:30:00 Recipe - XIII 00:15:00 Recipe - XIV 00:30:00 Recipe - XV 00:30:00 Recipe - XVI 01:00:00 Recipe -XVII 01:00:00 Recipe -XVIII 01:00:00 Recipe -XIX 01:00:00 Recipe -XX 01:00:00 Mock Exam Mock Exam- Accredited Diploma in Professional Chef 00:30:00 Final Exam Final Exam- Accredited Diploma in Professional Chef 00:30:00

Accredited Diploma in Professional Chef
Delivered Online On Demand3 days
£25