3075 Office Skills courses delivered On Demand

Description Take your networking knowledge to the next level with the MS Azure - Networking course. The course familiarizes you to virtual network configuration through the Microsoft Azure Portal. You will learn how to use network services to configure and load balance network traffic using tools such as Azure DNS. The course teaches you about IP Address space and shows you the procedures for creating a Vnet or virtual networking. You will understand Vnet peering and DNS in Azure Vnet. The course guides you to configure a Point to Site VPN and a Site to Site VPN. Lastly, the course focuses on the procedures of Azure Vnet peering, and shows you how peering between Vents can reduce the need to build Vnet-to-Vnet VPN gateways. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS Azure - Networking 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 MS Azure - Networking 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. Introduction Introduction FREE 00:02:00 Virtual Networks Virtual Network Overview 00:02:00 IP Address Space 00:03:00 DNS in Azure Vnets 00:03:00 Creating a VNet 00:03:00 VPNs with VNets 00:04:00 Configuring a Point to Site VPN 00:12:00 Configuring a Site to Site VPN 00:05:00 Azure Vnet Peering 00:05:00 Conclusion Course Recap 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Learn to optimize your cloud application containers with Microsoft Azure. Enrol the MS Azure - Containers course and be an expert user of Azure Containers. Microsoft Azure helps you to develop, update, and manage your containerized applications faster with an end to end developer and CI/CD tools. You can store images in Docker Hub or Azure Container. You will also able to the registry and deploy to your preferred targets. The course teaches all these applications of the software chronologically. Throughout the course, you will be acquainted with the procedures of using the application. The course shows you how to deploy containers using widely adopted orchestrator, or choose a fully-managed container platform. The course describes what containers are within Azure. You will learn how to use docker host to manage both on-premises and Azure containers. To recapitulate, you will be confident enough to use Azure Containers by the end of the course. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS Azure - Containers 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 MS Azure - Containers 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. Introduction Introduction FREE 00:01:00 Introduction to Containers Introduction to Containers 00:04:00 Docker 00:04:00 Deploying Containers 00:08:00 Multi-container Applications 00:02:00 Azure Container Registry 00:03:00 Azure Container Clustering Options 00:02:00 Installing ACS 00:04:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Learn to leverage Azure Storage in your applications with the intensive course MS Azure - Azure Storage. Microsoft Azure Storage is the durable, highly available, massively scalable, secure, durable, and redundant cloud storage solution of Microsoft. It includes Azure Blobs (objects), Azure Data Lake Storage Gen2, Azure Files, Azure Queues, and Azure Tables. In the course, you will learn how to work with Azure storage accounts. You will learn how to expose file shares to multiple VMs in Azure at the same time. The course guides you the procedures of using Blob storage, File Storage, and Content Delivery Network. Additionally, you will know how to monitor the storage and look at Azure File Sync. Finally, the course teaches you how to work with Backup Vault and site Recovery. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS Azure - Azure Storage 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 MS Azure - Azure Storage 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. Introduction Introduction FREE 00:03:00 Working with Storage Azure Storage Overview 00:03:00 Working with Azure Storage Accounts 00:09:00 Storage Access 00:05:00 Using Azure Blob Storage 00:06:00 Using Azure File Storage 00:04:00 Azure File Sync 00:10:00 Monitoring Storage 00:03:00 Content Delivery Network 00:03:00 CDN Profile 00:06:00 Azure Backup Vault 00:04:00 Azure Site Recovery 00:03:00 Conclusion Course Recap 00:03:00

Compliance Management Course will guide you to understand child psychology issues and development, including its various stages.

Highlights of the Course Course Type: Online Learning Duration: 2 Hours 26 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Fusion 360 graphic designing Understand the core competencies and principles of Fusion 360 graphic designing Explore the various areas of Fusion 360 graphic designing Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert graphic designer Microsoft Office Excel 2016: Part 2 (Intermediate Level) Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel 2016 intermediate level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel 2016 intermediate leve course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel 2016 intermediate leve course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive excel 2016 intermediate leve course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This excel 2016 intermediate leve course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This excel 2016 intermediate leve course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This excel 2016 intermediate leve course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Course Overview Introduction and Course Overview 00:02:00 Working with Functions Working and Function - Introduction 00:01:00 Work with Ranges - Introduction 00:01:00 Name and Edit Ranges 00:05:00 Use Defined Names in a Formula 00:03:00 Locate and Use Specialized Functions 00:05:00 Work with Logical Functions - Introduction (02:13) 00:02:00 IF Function 00:04:00 AND, OR and NOT Function 00:05:00 Combine Functions 00:06:00 Functions Similar to the IF Function 00:05:00 Work with Date and Time Functions - Introduction 00:01:00 TODAY, NOW and DATE Functions 00:03:00 NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions 00:05:00 Work with Text Functions - Introduction 00:01:00 LEFT, RIGHT and MID Functions 00:02:00 FIND Function 00:03:00 Text to Columns Feature 00:03:00 CONCATENATE Function 00:03:00 UPPER, LOWER and PROPER Functions 00:02:00 Practice File Working with Functions Practice File Working with Functions 00:00:00 Working with Lists Sort Data - Introduction 00:01:00 Sort Data 00:03:00 Filter Data - Introduction 00:01:00 Filter Data 00:02:00 Query Data with Database Functions 00:01:00 Database Functions 00:03:00 Outline and Subtotal Data - Introduction 00:01:00 Use Subtotals to Summarize Data 00:03:00 Practice File Working with Lists Practice File Working with Lists 00:00:00 Assessment Mock 1 Assessment Mock 1 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Analyzing Data Create and Modify Tables - Introduction 00:01:00 Create and Modify Tables 00:06:00 Use Summary Functions in Tables 00:03:00 Apply Intermediate Conditional Formatting - Introduction 00:01:00 Apply Intermediate Conditional Formatting 00:02:00 Apply Advanced Conditional Formatting - Introduction 00:01:00 Use Logical Functions to Apply Conditional Formatting 00:03:00 Practice File Analyzing Data Practice File Analyzing Data 00:00:00 Visualizing Data with Charts Create Charts - Introductions 00:01:00 Create Charts 00:04:00 Modify and Format Charts - Introduction 00:01:00 Modify and Format Charts 00:05:00 Use Advanced Chart Features - Introduction 00:01:00 Create a Dual-Axis Chart 00:04:00 Create a Chart Template 00:03:00 Visualizing Data with Charts - Best Practice 00:04:00 Practice File Visualizing Data with Charts Practice File Visualizing Data with Charts 00:00:00 Using PivotTables and PivotCharts Create a PivotTable - Introductions 00:01:00 Create a PivotTable 00:04:00 Analyze PivotTable Data - Introduction 00:01:00 Analyze PivotTable Data 00:04:00 Present Data with PivotCharts - Introduction 00:01:00 Present Data with PivotCharts 00:05:00 Filter Data by Using Timelines and Slicers - Introduction 00:01:00 Filter Data by Using Slicers and Timelines 00:04:00 Bonus Lecture 00:01:00 Practice File Using PivotTables and PivotCharts Practice File Using PivotTables and PivotCharts 00:00:00 Assessment Mock 2 Assessment Mock 2 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Final Assessment Final Assessment - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00

Overview This comprehensive course on Hewlett Packard Application Life Cycle Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Hewlett Packard Application Life Cycle Management comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Hewlett Packard Application Life Cycle Management. It is available to all students, of all academic backgrounds. Requirements Our Hewlett Packard Application Life Cycle Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 8 lectures • 03:51:00 total length •Module 01: Introduction on HP Application Life Cycle Management (HP ALM): 00:35:00 •Module 02: Requirements Module: 00:34:00 •Module 03: Test Plan Module: 00:47:00 •Module 04: Test Lab Module: 00:49:00 •Module 05: Defects Module: 00:31:00 •Module 06: Uploading Test cases using MS Excel: 00:18:00 •Module 07: Using Reports in HP ALM: 00:17:00 •Assignment - Hewlett Packard Application Life Cycle Management: 00:00:00

In today’s fast-paced business environment, effective material management is a cornerstone for operational efficiency. This CPD Accredited course offers a comprehensive exploration of the core principles and best practices involved in managing materials within any organisation. From procurement and inventory control to forecasting and distribution, you will gain valuable insights that will directly contribute to streamlining operations and reducing costs. Designed for professionals across various industries, this course delves into key aspects that will enhance your ability to manage materials with precision and foresight. By completing this course, you’ll build a solid foundation in material management, learning how to optimise stock levels, improve supplier relationships, and implement strategies that contribute to a smoother supply chain. Whether you’re looking to improve processes within your current role or looking to advance your career, this course offers a flexible and effective approach to mastering material management. With its clear structure and in-depth content, it provides the knowledge you need to navigate the complexities of this vital area with confidence. Course Curriculum: Module 01: Introduction to Material Management Module 02: Purchasing and Supply Chain Management Module 03: Inventory Management, Planning and Control Module 04: Stores Management and Control Module 05: Forecasting Module 06: Material Requirements Planning Module 07: Materials Handling Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Material Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Material Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Material Management - CPD Accredited training.

Description: Explore all that you need at an advanced level to become a proficient Microsoft OneNote 2010 user. This course will help you learn more advanced skills for working with your Notebooks. It demonstrates the new and enhanced features in Microsoft OneNote 2010 for gathering and sharing information. Students will explore OneNote 2010 interface features, including creating switchboards, macros, original reports, custom buttons, and in-depth custom queries for detailed data analysis. Students will also explore the best practices to employ during initial design and creation steps. In this course you will learn the necessary skills, knowledge and information of Microsoft One Note 2010.  Who is this course for? This course would be ideal for Microsoft Office users, students, and office workers. This course is designed for anyone who wants to learn Microsoft one note 2010 at an advanced level. 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 the cost of £39 or in PDF format at the 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 Microsoft One Note 2010 Advanced Level will be very beneficial and helpful, especially to the following professionals: Event planner Project manager Real estate agent Travel agent Teacher Lawyer Microsoft One Note 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - Upgrading from One Note 2007 or 2003 01:00:00 Module Three - Staying Organized 01:00:00 Module Four - Note Taking Tools 01:00:00 Module Five - Text and Page Formatting 01:00:00 Module Six - Drawing and Handwriting Notes 01:00:00 Module Seven - Office Integration 01:00:00 Module Eight - Researching a Topic 01:00:00 Module Nine - Linked Notes 01:00:00 Module Ten - Collaborating 01:00:00 Module Eleven - Other Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft One Note 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft one note 2010 advanced level 00:20:00 Final Exam Final Exam- Microsoft one note 2010 advanced level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00