251 Microsoft AZ-104 courses delivered Online

Description: The 70-744 - Securing Windows Server 2016 (MCSE) course explains how to secure Windows Server 2016 environments. It covers methods and technologies for hardening server environments and securing virtual machine infrastructures using Shielded and encryption-supported virtual machines and Guarded Fabric. After completing the course, you will be able to manage the of Active Directory and Identity infrastructures. You will able to handle privileged identities using Just in Time (JIT), and Just Enough Administration (JEA) approaches, as well as implement Privileged Access Workstations (PAWs) and secure servers using the Local Administrator Password Solution (LAPS). The course will also help you to use threat detection solutions such as auditing access, implementing Advanced Threat Analytics (ATA), deploying Operations Management Suite (OMS) solutions, and identifying solutions for specific workloads. Finally, the purpose of the course is to prepare you for the exam Securing Windows Server 2016 ( MCSE). 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-744 - Securing Windows Server 2016 (MCSE) 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-744 - Securing Windows Server 2016 (MCSE) 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 to Attacks, Breaches, and Detection Understanding Types of Attacks FREE 00:33:00 Detecting Security Breaches 00:06:00 Using Sysinternals Tools 00:30:00 Protecting Users and Workstations User Rights and Privileges 01:28:00 Working with Computer and Service Accounts 00:19:00 Protecting User Credentials 00:20:00 Using Privileged Access Workstations 00:12:00 Managing Administrative Access Understanding and Deploying JEA 00:32:00 Using Enhanced Security Administrative Environments (ESAE) Forests 00:12:00 Using Microsoft Identity Manager 00:08:00 Using JIT Administration and PAM 00:16:00 Configuring Anti-Malware and Patch Management Configuring and Managing Windows Defender 00:18:00 Restricting Software 00:28:00 Using Device Guard 00:12:00 Patch Management with WSUS 00:29:00 Auditing and Advanced Threat Analytics Configuring Auditing for Windows Server 2016 00:21:00 Advanced Auditing and Management 00:42:00 Deploying and Configuring ATA 00:15:00 Deploying and Configuring Operations Management Suite 00:07:00 Securing the Infrastructure Secure the Virtualization Infrastructure 00:15:00 Deploying Security Baselines 00:20:00 Deploying Nano Server 00:08:00 Configuring Data Protection Planning and Implementing File Encryption 00:29:00 Planning and Implementing BitLocker 00:32:00 Advanced File Server Management Using File Server Resource Manager 00:58:00 Implementing Classification and File Management Tasks 00:16:00 Working with Dynamic Access Control 00:39:00 Securing the Network Infrastructure Using the Windows Firewall with Advanced Security 00:33:00 Datacenter Firewall 00:08:00 Utilizing IP Security 00:29:00 Configuring Advanced DNS Settings 00:42:00 Monitoring Network Traffic 00:09:00 Securing SMB Traffic 00:07:00 Mock Exam Mock Exam- 70-744 - Securing Windows Server 2016 (MCSE) 00:20:00 Final Exam Final Exam- 70-744 - Securing Windows Server 2016 (MCSE) 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The 70-647 - Windows Server Enterprise Administration course explains how to maintain the Windows Server 2008 R2 environment and prepare you for the Exam 70-647 - Windows Server Enterprise Administration Throughout the course, you will learn the system of planning for active directory, network infrastructure, active directory issues, and active directory administration. You will also learn the ways of deploying Windows 2008 to the small and medium-sized offices, using remote desktop services and application setup. The course will also teach you how to secure the network, how to support PKI (Public Key Infrastructure) and the CA hierarchy. Finally, the course explains various virtualisation solutions by using virtualisation and planning virtualisation for applications, windows updates and how to protect the environment by making data security that still available to the user. 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-647 - Windows Server Enterprise Administration 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-647 - Windows Server Enterprise Administration 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. Planning for Active Directory Logical Design 01:14:00 Physical Topology 00:50:00 Network Infrastructure DNS 01:01:00 Planning IP Distribution 00:49:00 Advanced Active Directory Issues Migration Strategies 00:13:00 Working with Other Forests 00:18:00 Active Directory Administration Active Directory Administration 01:07:00 Using Group Policies 00:38:00 Deploying Windows 2008 to the Small/Medium Office Small/Medium Office 00:44:00 Small/Medium Server Security 00:43:00 Using Remote Desktop Services and Application Setup Planning for Remote Desktop Services 00:19:00 License Server 00:10:00 Deploying Applications 00:34:00 Securing the Network Designing a Secure Perimeter 01:03:00 Introducing NAP 00:26:00 Domain and Server Isolation 00:04:00 Supporting PKI What is PKI? 00:30:00 The CA Hierarchy 00:28:00 Managing Certificates 00:26:00 Virtualization Solutions Using Virtualization 00:41:00 Planning Virtualization for Applications 00:08:00 Windows Updates WSUS 00:39:00 Software Update Compliance 00:22:00 Making Data Secure and Available Sharing and Collaborating Your Data 00:32:00 Protecting Data at Rest 00:27:00 System Recoverability and Availablity 00:34:00 Mock Exam Mock Exam- 70-647 - Windows Server Enterprise Administration 00:20:00 Final Exam Final Exam- 70-647 - Windows Server Enterprise Administration 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview: Microsoft 365 Mastery Welcome to Microsoft 365 Mastery, a comprehensive course designed to empower individuals with the skills and knowledge needed to leverage the full potential of Microsoft 365 and its suite of applications. In this course, you will explore the diverse functionalities of Microsoft 365, covering its key components and applications through a structured series of modules. Module 1: Overview of Microsoft 365 and Its Applications Gain a comprehensive understanding of Microsoft 365, including its core components and applications. Explore how Microsoft 365 enhances productivity and collaboration in modern workplaces. Module 2: OneDrive and SharePoint Online Delve into OneDrive and SharePoint Online, powerful cloud-based storage and collaboration platforms. Learn how to efficiently manage files, collaborate on documents, and organize content using these tools. Module 3: Microsoft Teams and Outlook Discover the collaborative power of Microsoft Teams and the productivity features of Outlook. Explore how Teams facilitates seamless communication and collaboration, while Outlook helps manage emails, calendars, and tasks effectively. Module 4: Microsoft Planner and Forms Master Microsoft Planner for task management and project coordination, and learn to create surveys and quizzes using Microsoft Forms. Explore how these tools streamline workflow and gather valuable insights. Module 5: Power Automate and 365 Security Features Unlock the potential of automation with Power Automate, and explore essential security features within Microsoft 365. Learn to automate repetitive tasks and safeguard sensitive data effectively. Module 6: Admin Center and Accessibility Navigate the Microsoft 365 Admin Center and understand its role in managing user accounts, licenses, and security settings. Learn about accessibility features to ensure inclusivity and compliance within your organization. Module 7: Collaborative Editing and Integration with Other Tools Explore collaborative editing features across Microsoft 365 applications and discover how they enhance teamwork and productivity. Learn about integration possibilities with third-party tools to extend the capabilities of Microsoft 365. Module 8: Best Practices and Migration Strategies Acquire best practices for deploying and managing Microsoft 365 within your organization. Understand migration strategies to seamlessly transition from legacy systems to Microsoft 365 while minimizing disruptions.   Throughout the course, you will engage in hands-on exercises, case studies, and practical demonstrations to reinforce your learning and develop valuable skills applicable to real-world scenarios. By the end of this course, you will emerge as a proficient Microsoft 365 user equipped to drive productivity, collaboration, and innovation within your organization. Join us on this journey to Microsoft 365 mastery! Course Curriculum Module 1_ Overview of Microsoft 365 and Its Applications Overview of Microsoft 365 and Its Applications 00:00 Module 2_ OneDrive and SharePoint Online OneDrive and SharePoint Online 00:00 Module 3_ Microsoft Teams and Outlook Microsoft Teams and Outlook 00:00 Module 4_ Microsoft Planner and Forms Microsoft Planner and Forms 00:00 Module 5_ Power Automate and 365 Security Features Power Automate and 365 Security Features 00:00 Module 6_ Admin Center and Accessibility Admin Center and Accessibility 00:00 Module 7_ Collaborative Editing and Integration with Other Tools Collaborative Editing and Integration with Other Tools 00:00 Module 8_ Best Practices and Migration Strategies Best Practices and Migration Strategies 00:00

Description: The 70-697 - Configuring Windows Devices course teaches you how to configure Windows devices. Throughout the course, you will learn about the new features of Windows 10 and how to deploy it. You will be introduced to the basic introduction to Client Hyper-V, and learn about creating virtual machines and managing virtual machine storage and snapshots. The course will teach you the system of configuring device settings by configuration tools, common configuration options, managing user accounts, using control panel, using Windows administrative tools, and using Windows PowerShell. You will learn how to connect Windows 10 to networks, how to share data and printers, and how to manage apps. You will also learn about the techniques of securing Windows 10 devices, monitoring and maintaining Windows 10, managing users in the enterprise, managing desktops and applications in the enterprise, and managing devices in the enterprise. 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-697 - Configuring Windows Devices 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-697 - Configuring Windows Devices 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. What's New in Windows 10 What Makes Windows 10 Different? FREE 00:14:00 Primary Feature Overview 00:14:00 Navigating and Using Windows 10 00:34:00 Windows 10 Deployment Standard Windows 10 Deployment 01:11:00 Enterprise Deployment Strategies 00:52:00 Deploying Virtual Windows 10 Desktops Introduction to Client Hyper-V 00:12:00 Creating Virtual Machines 00:15:00 Managing Virtual Machine Storage and Snapshots 00:09:00 Configuring Device Settings Overview of Configuration Tools 00:14:00 Common Configuration Options 00:17:00 Managing User Accounts 00:20:00 Using Control Panel 00:10:00 Using Windows Administrative Tools 00:28:00 Using Windows PowerShell 00:41:00 Connecting Windows 10 to Networks TCPIP Network Connectivity 00:40:00 Name Resolution 00:10:00 Wireless Connectivity 00:21:00 Remote Access Overview 00:18:00 Troubleshooting Connectivity 00:20:00 Sharing Data and Printers Managing Hard Disks 00:37:00 Managing Storage Spaces 00:06:00 Overview of Data Access 00:09:00 Configuring and Managing File Access 00:24:00 Managing Shared Folders 00:12:00 Understanding Work Folders 00:05:00 Managing Printers 00:12:00 Managing Apps Installing and Configuring Applications 00:08:00 Managing Apps From the Windows Store 00:05:00 Managing Web Browsers 00:19:00 Securing Windows 10 Devices Security Overview 00:11:00 Configuring Local Security 00:20:00 Securing Network Communications 00:31:00 Configuring Data Security 00:25:00 Monitoring and Maintaining Windows 10 Working with Updates 00:08:00 Monitoring and Optimizing 00:35:00 Managing Devices and Drivers 00:14:00 Recovering Files and Devices 00:19:00 Managing Users in the Enterprise Managing User Profiles 00:20:00 User State Virtualization 00:09:00 User Profile Migration 00:11:00 Managing Desktops and Applications in the Enterprise Using Group Policy to Manage Windows 10 Devices 00:44:00 Using Group Policy to Manage Applications 00:18:00 Managing Devices in the Enterprise The Enterprise Mobility Suite 00:27:00 Managing Desktops and Mobile Clients 00:07:00 Managing Updates and Endpoint Protection 00:04:00 Managing Applications 00:03:00 Mock Exam Mock Exam- 70-697 - Configuring Windows Devices 00:20:00 Final Exam Final Exam- 70-697 - Configuring Windows Devices 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The comprehensive Basic Microsoft SQL Server Development has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Basic Microsoft SQL Server Development today, and learn from the very best the industry has to offer! This best selling Basic Microsoft SQL Server Development has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Basic Microsoft SQL Server Development is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Basic Microsoft SQL Server Development is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The Basic Microsoft SQL Server Development is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Basic Microsoft SQL Server Development , you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Basic Microsoft SQL Server Development will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Basic Microsoft SQL Server Development to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Description: This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions. Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more. If you want to take your Microsoft Excel 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. 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 2013 Excel Intermediate - 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 2013 Excel Intermediate - 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. Creating Advanced Formulas Apply Range Names FREE 00:18:00 Use Specialized Functions 00:14:00 Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas 00:01:00 Use Logical and Lookup Functions to Find Answers to Questions 00:25:00 Organizing Worksheet Data with Tables Create and Modify Tables 00:09:00 Sort and Filter Data 00:27:00 Use Summary and Database Functions to Calculate Data 00:25:00 Visualizing Data with Charts Create Charts 00:05:00 Modify and Format Charts 00:25:00 Create a Trendline 00:10:00 Create Advanced Charts 00:09:00 Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable 00:24:00 Filter Data by Using Slicers 00:09:00 Analyze Data by Using PivotCharts 00:07:00 Inserting Graphics Insert and Modify Graphic Objects 00:10:00 Layer and Group Graphic Objects 00:12:00 Incorporate SmartArt 00:06:00 Enhancing Workbooks Customizing Workbooks 00:08:00 Manage Themes 00:06:00 Create and Use Templates 00:06:00 Protect Files 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Explore all that you need at an advanced level to become a proficient Microsoft OneNote 2013 user. This course will help you learn more advanced skills for working with your Notebooks. It demonstrates the new and enhanced features in Microsoft one note 2013 for gathering and sharing information. Students will explore OneNote 2013 interface features, including the Ribbon and Backstage View, and workflow enhancements such as quick filing, linked notes, and Word styles. They will also be introduced to the new and improved ways to collaborate on notebooks with others. 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 OneNote 2013 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 recognised 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 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 Advanced Level Module One - Getting Started 01:00:00 Module Two - Working with Notebooks 01:00:00 Module Three - Using Additional Notebooks 01:00:00 Module Four - Formatting and Editing Your Notes 01:00:00 Module Five - Working with Audio and Video 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Working with Equations and Excel Spreadsheets 01:00:00 Module Eight - Researching a Topic 01:00:00 Module Nine - Advanced Review Tasks 00:30:00 Module Ten - Collaborating 01:00:00 Module Eleven - Advanced Sharing Options 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft One Note Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft One Note Advanced Level 00:20:00 Final Exam Final Exam- Microsoft One Note Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: By this Microsoft Office 2016 Word Advanced Level - Complete Video Course you will be introduce with the advanced level of Microsoft Word 2016. This advanced level will help you to broad up your knowledge which you got from the intermediate level. Here you will learn how to work with tables of content, footnotes and endnotes, how to insert bibliographies and indexes, how to use comments, track changes including accepting and rejecting changes, compare and combine documents, how to use mail merge and create envelope and labels, protect document ,use bookmarks, add watermarks, and customize the Ribbon, and more. You can join this course, if you have intermediate skills and knowledge with Microsoft Word 2016 and want to take another step forward or want to learn the topics covered in this course in the 2016 interface. So, don't be late, come and join this course now. 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 Word Advanced Level - 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 Word Advanced Level - 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. Manipulating Images Integrate Pictures and Text FREE 00:15:00 Adjust Image Appearance 00:09:00 Insert Other Media Elements 00:02:00 Using Custom Graphic Elements Create Text Boxes and Pull Quotes 00:06:00 Add WordArt and Other Text Effects 00:05:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt 00:08:00 Collaborating on Documents Prepare a Document for Collaboration 00:09:00 Mark Up a Document 00:06:00 Review Markups 00:04:00 Merge Changes from Other Documents 00:06:00 Adding Document References and Links Add Captions 00:06:00 Add Cross References 00:08:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:05:00 Add Citations and a Bibliography 00:11:00 Securing a Document Suppress Information 00:07:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:02:00 Add a Digital Signature to a Document 00:04:00 Using Forms to Manage Content Create Forms 00:09:00 Modify Forms 00:03:00 Automating Repetitive Tasks with Macros Automate Tasks by Using Macros 00:10:00 Create a Macro 00:19:00 Mock Exam Mock Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2013 Word Advanced - Complete Video Course covers the advanced functions and features of Word 2013. With this advanced level, you will learn advanced skills in using Microsoft Word 2013 and be able to demonstrate the use of advanced and specialized features within the application. You should be able to create, manage, and distribute professional documents for a variety of specialized purposes and situations, and be able to customize Word 2013 environment to meet specific needs to enhance productivity. By this series, you will learn about collaborating on documents and adding reference marks and notes. You will also learn how to manage long documents, secure a document and work with forms, and more. If you already have a good grounding in Microsoft Word, this course will provide you with the knowledge and skills to use Word 2013 at an expert level. 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 2013 Word 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 2013 Word 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. Collaborating on Documents Modify User Information FREE 00:06:00 Share a Document 00:03:00 Compare Document Changes 00:09:00 Review a Document 00:11:00 Merge Document Changes 00:01:00 Review Tracked Changes 00:09:00 Coauthor Documents 00:10:00 Adding Reference Marks and Notes Add Captions 00:07:00 Add Cross-References 00:09:00 Add Bookmarks 00:08:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:06:00 Add Citations and a Bibliography 00:14:00 Simplifying and Managing Long Documents Insert Blank and Cover Pages 00:06:00 Insert an Index 00:12:00 Insert a Table of Contents 00:05:00 Insert an Ancillary Table 00:09:00 Manage Outlines 00:08:00 Create a Master Document 00:08:00 Securing a Document Suppress Information 00:08:00 Set Formatting and Editing Restrictions 00:04:00 Add a Digital Signature to a Document 00:09:00 Restrict Document Access 00:03:00 Forms Create Forms 00:14:00 Manipulate Forms 00:04:00 Mock Exam Mock Exam- Microsoft Office 2013 Word Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Word Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. 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 2013 Excel 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 2013 Excel 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. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00