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

42856 Learning courses in Glasgow delivered Online

70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE)

4.3(43)

By John Academy

Description: The 70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) course teaches you how to install and configure Windows Server 2012 R2. You will learn the basics of the server, server 2012 management, working with server core, and PowerShell examples for user management. Throughout the course, you will learn the system of configuring local storage. The method of file shares and permissions and configure print and document services will also be taught in the course. Apart from these, you will able to know about remote management and virtualization. The course also includes discussion on the components of network infrastructure, TCP/IP diagnostics and IPv6 over IPv4 tunneling. Finally, you will learn about the DHCP, DNS, Active Directory domain services and Windows security. 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-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) training 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-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) training 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. Server 2012 Overview On Premise vs Cloud FREE 00:30:00 Windows Server Installation 00:09:00 Windows Activation 00:15:00 Windows Server 2012 Management Server Manager 00:22:00 Working with Server Core Introduction to PowerShell 00:33:00 PowerShell Examples for User Management 00:12:00 Configuring Local Storage Key Features of Storage 00:45:00 Configure Basic Disks 00:19:00 Configure File and Print Access File Shares and Permissions 00:25:00 Configure Print and Document Services 00:10:00 Remote Management and Virtualization Remote Management 00:22:00 Virtualization 00:26:00 Differencing Disks 00:18:00 TCP/IP Protocol Suite Components of Network Infrastructure 00:52:00 TCP_IP Diagnostics 00:51:00 IPv6 Over IPv4 Tunneling 00:08:00 DHCP and DNS DNS 00:41:00 DHCP 00:22:00 Overview of Active Directory Domain Services Physical Components of Active Directory 00:59:00 Operations Master Roles 00:29:00 The AD DS Logon Process 00:13:00 User Accounts 00:50:00 Computer Accounts 00:22:00 Windows Security Windows Security 00:18:00 Group Policy 00:21:00 Software Restriction Policies 00:04:00 Windows Firewall 00:09:00 Mock Exam Mock Exam- 70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) 00:20:00 Final Exam Final Exam- 70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE) 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

70-410 - Installing and Configuring Windows Server 2012 R2 (MCSA/MCSE)
Delivered Online On Demand12 hours 5 minutes
£11.99

Certified Ethical Hacking - Complete Video Training

4.3(43)

By John Academy

Description: Hacking becomes very common nowadays. If it comes about the company information, it is one of the most dangerous problems. An ethical hacker helps an organisation to protect their data and increases the security of a computer system. Therefore, the demand for a certified ethical hacker is increasing day by day. The Certified Ethical Hacking - Complete Video Training course will help to meet your need if you want to build a stable career in ethical hacking. The course is taught in two parts. One part deals with the basic knowledge of ethical hacking and helps you to be an ethical hacker while the second section prepares you for the Certified Professional Ethical Hacker (CPEH). The bundle video course teaches the fundamental concepts of ethical hacking including access controls, protocols, cryptography, vulnerability assessments, vulnerability tools of the trade, reconnaissance, covering tracks, malware, buffer overflows, and password cracking, etc. You will also learn to implement the counter-response to protecting your information. In short, the Certified Ethical Hacking - Complete Video Training provides a complete guide to ethical hacking. 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? Certified Ethical Hacking - Complete Video Training 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 Certified Ethical Hacking - Complete Video Training 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. Overview Overview FREE 00:35:00 Reconnaissance Reconnaissance 00:25:00 Protocols Protocols 01:25:00 Windows Hacking Windows Hacking 01:19:00 Attacking Web Technologies Attacking Web Technologies 00:56:00 Pen Testing Wireless Networks Pen Testing Wireless Networks 01:34:00 Security Fundamentals Security Fundamentals FREE 00:51:00 Access Controls Access Controls 00:33:00 Protocols Protocols 00:36:00 Cryptography Cryptography 00:52:00 Why Vulnerability Assessments? Why Vulnerability Assessments? 00:36:00 Vulnerability Tools of the Trade Vulnerability Tools of the Trade 00:10:00 Output Analysis and Reports Output Analysis and Reports 00:13:00 Reconnaisance, Enumeration and Scanning Reconnaisance, Enumeration and Scanning 00:51:00 Gaining Access Gaining Access 00:31:00 Maintaining Access Maintaining Access 00:17:00 Covering Tracks Covering Tracks 00:18:00 Malware Malware 00:28:00 Buffer Overflows Buffer Overflows 00:22:00 Password Cracking Password Cracking 00:33:00 Mock Exam Mock Exam - Certified Ethical Hacking - Complete Video Training 00:20:00 Final Exam Final Exam - Certified Ethical Hacking - Complete Video Training 00:20:00 Order Your Certificates and TranscriptsOrder Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Certified Ethical Hacking - Complete Video Training
Delivered Online On Demand14 hours 5 minutes
£11.99

Microsoft Office 2016 Word Advanced Level - Complete Video Course

4.3(43)

By John Academy

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

Microsoft Office 2016 Word Advanced Level - Complete Video Course
Delivered Online On Demand3 hours 38 minutes
£11.99

MS Access 2016 Advanced

4.3(43)

By John Academy

Description Access 2016 is a software development and graphical user interface tool that assist you to collect, report, and analyze information for the reference. To become better at MS Access take a look at our well designed MS Access 2016 Advanced course. It will help you in understanding all you need to know about the MS Access. The course aims at the students' efficiency to improve their skill in the functions of an Access database. It teaches the learners how to form joint table and use table analyzer wizard effectively. The course incorporates the fundamental issues of MS Access such as automation process with the help of VBA, creation, and modification of switchboards, and function of table events. It enables the students to configure security and access for different environments providing knowledge with the multiple uses of tools and backup system. 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 Access 2016 Advanced 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 Access 2016 Advanced 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 Improving the Structure of a Database Using the Table Analyzer Wizard 00:05:00 Append Querying to Normalize a Table 00:08:00 Creating a Junction Table 00:06:00 Maintaining a Database Backing Up a Database 00:02:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:02:00 Using the Database Documenter Too 00:02:00 Using the Performance Analyzer Tool 00:02:00 Working with Access Switchboards Understanding the Access Switchboard 00:03:00 Using The Switchboard Manager 00:09:00 Modifying a Switchboard 00:05:00 Setting the Startup Options 00:04:00 Configuring Access for Multiple Users Using the database Splitter 00:04:00 Configuring Trusted Locations 00:02:00 Password Protecting a Database 00:03:00 Password Protecting Modules 00:01:00 Converting a Database to an ACCDE file 00:01:00 Automating Processes with VBA Understanding VBA Basics 00:06:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:06:00 Converting a Macro to VBA 00:02:00 Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:04:00 Using the After Change Event Command 00:04:00 Conclusion Course Recap 00:04:00 Resources Resources - MS Access 2016 Advanced 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

MS Access 2016 Advanced
Delivered Online On Demand1 hour 41 minutes
£11.99

Cisco CCNP Troubleshoot and Maintain Cisco IP Switched Networks (TSHOOT) v2.0 Training

4.3(43)

By John Academy

Description Troubleshooting and Maintaining Cisco IP Switched Networks is a qualifying exam for the Cisco Certified Network Professional CCNP, certification. This Cisco CCNP Troubleshoot and Maintain Cisco IP Switched Networks (TSHOOT) v2.0 Training will help you to be certified successfully with all the important knowledge and skills necessary to (1) plan and perform regular maintenance on complex enterprise routed and switched networks and (2) use technology-based practices and a systematic ITIL-compliant approach to perform network troubleshooting. This Cisco CCNP Troubleshoot and Maintain Cisco IP Switched Networks (TSHOOT) v2.0 Training designed for you, if you are a network engineer with at least one year of professional work experience. You will learn to plan and perform regular maintenance on complex enterprise routed and switched networks and use technology-based practices and a systematic ITIL-compliant approach to perform network troubleshooting. At the end of the course, you will get increased skill level and developed as set of best practices based on your own. 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 Cisco CCNP Troubleshoot and Maintain Cisco IP Switched Networks (TSHOOT) v2.0 Training 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 Maintenance for Complex Networks Planning Maintenance for Complex Networks FREE 00:14:00 Network Maintenance Tools, Applications, and Resources 00:32:00 Troubleshooting Processes for Complex Enterprise Networks Troubleshooting Processes for Complex Enterprise Networks 00:09:00 Implementing Troubleshooting Procedures 01:15:00 Using Maintenance and Troubleshooting Tools and Applications Using Maintenance and Troubleshooting Tools and Applications 00:12:00 Collecting Real-time Information Using Cisco IOS debug Commands 00:10:00 Gathering Information with SNMP 00:15:00 Maintaining and Troubleshooting Campus Switched Solutions Maintaining and Troubleshooting Campus Switched Solutions Troubleshooting Tools and Applications 00:12:00 Spanning Tree Failures 00:12:00 Troubleshooting Multi-layer Switches 00:43:00 Maintaining and Troubleshooting Routing Solutions Maintaining and Troubleshooting Routing Solutions 00:25:00 OSPF Review Network Areas and LSAs 00:27:00 OSPF to EIGRP Redistribution Troubleshooting Process 00:32:00 Troubleshooting Addressing Services Troubleshooting Addressing Services 00:24:00 DHCP Overview Client-Server Communication 00:23:00 IPv6 Troubleshooting - show Commands 00:40:00 Troubleshooting Network Performance Issues Troubleshooting Network Performance Issues 00:25:00 AutoQoS Troubleshooting Example 00:24:00 Spanning-Tree Issues 00:44:00 Troubleshooting Converged Networks Troubleshooting Converged Networks 00:16:00 Section 2 Overview 00:16:00 Section 3 Overview 00:26:00 Maintaining and Troubleshooting Network Security Implementations Maintaining and Troubleshooting Network Security Implementations 00:13:00 IOS SPI Example 00:14:00 BORW TSHOOT Example 2 Crypto Map ACL Error 00:10:00 Review and Preparation for Troubleshooting Complex Enterprise Network Review and Preparation for Troubleshooting Complex Enterprise Networks 00:09:00 Section 2 Overview 00:46:00 Mock Exam Mock Exam- Cisco CCNP Troubleshoot and Maintain Cisco IP Switched Networks (TSHOOT) v2.0 Training 00:20:00 Final Exam Final Exam- Cisco CCNP Troubleshoot and Maintain Cisco IP Switched Networks (TSHOOT) v2.0 Training 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Cisco CCNP Troubleshoot and Maintain Cisco IP Switched Networks (TSHOOT) v2.0 Training
Delivered Online On Demand11 hours 28 minutes
£11.99

Payroll Management and Systems Diploma

4.3(43)

By John Academy

Description: Payroll is the process by which employers pay an employee for the work they have completed. Any business with employees should have a payroll process established; payroll is often the largest expense for a business. If you want to learn how to perform payroll, gross pay, RTI and more, then this will be the perfect choice for you. This Payroll Management and Systems Diploma is all about payroll management, how to calculate the payroll and general overall understanding about what payroll is and the legal requirements in place, the forms, the deadlines, the process and procedures. The course will develop your skills in how to effectively perform a payroll run, understand statutory deductions, PAYE and real time income. Whether you currently work in finance, or wanting to work in finance, run your own business or simply want to gain a new skills then you should join us today! 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? Payroll Management and Systems Diploma 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 Payroll Management and Systems Diploma 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 to the Course and Instructor FREE 00:10:00 An Overview of Payroll 00:17:00 The UK Payroll System Running the payroll - Part 1 00:14:00 Running the payroll - Part 2 00:18:00 Manual payroll 00:13:00 Benefits in kind 00:09:00 Computerised systems 00:11:00 Total Photo scenario explained 00:01:00 Brightpay Brightpay conclude 00:03:00 Find software per HMRC Brightpay 00:03:00 Add a new employee 00:14:00 Add 2 more employees 00:10:00 Payroll settings 00:04:00 Monthly schedule - Lana 00:14:00 Monthly schedule - James 00:08:00 Directors NI 00:02:00 Reports 00:02:00 Paying HMRC 00:05:00 Paying Pensions 00:04:00 RTI Submission 00:02:00 Coding Notices 00:01:00 Journal entries 00:07:00 102 Schedule 00:03:00 AEO 00:06:00 Payroll run for Jan & Feb 2018 00:13:00 Leavers - p45 00:03:00 End of Year p60 00:02:00 Installing Brightpay 00:13:00 Paye, Tax, NI PAYE TAX 00:13:00 NI 00:11:00 Pensions 00:06:00 Online calculators 00:07:00 Payslips 00:03:00 Conclusion and Next Steps Conclusion and Next Steps 00:07:00 Assessment Assignment - Payroll Management and Systems Diploma 00:00:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Payroll Management and Systems Diploma
Delivered Online On Demand4 hours 19 minutes
£11.99

70-647 - Windows Server Enterprise Administration

4.3(43)

By John Academy

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

70-647 - Windows Server Enterprise Administration
Delivered Online On Demand15 hours 40 minutes
£11.99

Microsoft Office 2013 Excel Beginners - Complete Video Course

4.3(43)

By John Academy

[vc_row][vc_column][vc_column_text] Description: In this course, you will be able to identify the elements of the Microsoft Excel interface. You will learn how to create a basic worksheet and to get comfortable with the parts of the screen. This Microsoft Office 2013 Excel Beginners - Complete Video Course covers the basic functions and features of Excel 2013. You will learn about calculations and how to modify and format a worksheet. You will also learn how to customize the Excel environment and how to manage and print workbooks. In this course, you will take your knowledge up a notch as you get acquainted with Microsoft Excel 2013's most sophisticated features. If you think you know Excel 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Excel tips and tricks out there. 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 Beginners - 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 Beginners - 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.[/vc_column_text][/vc_column][/vc_row] Getting Started with Microsoft Excel 2013 Identify the Elements of the Excel Interface FREE 00:14:00 Create a Basic Worksheet 00:16:00 Use the Help System 00:04:00 Performing Calculations Create Formulas in a Worksheet 00:15:00 Insert Functions in a Worksheet 00:13:00 Reuse Formulas 00:15:00 Modifying a Worksheet Manipulate Data 00:13:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:08:00 Search for and Replace Data 00:12:00 Spell Check a Worksheet 00:06:00 Formatting a Worksheet Modify Fonts 00:11:00 Add Borders and Color to Cells 00:10:00 Apply Number Formats 00:10:00 Align Cell Contents 00:10:00 Apply Cell Styles 00:08:00 Printing Workbook Contents Define the Basic Page Layout for a Workbook 00:16:00 Refine the Page Layout and Apply Print Options 00:13:00 Managing Large Workbooks Format Worksheet Tabs 00:03:00 Manage Worksheets 00:09:00 Manage the View of Worksheets and Workbooks 00:10:00 Customizing the Excel Environment Customize General and Language Options 00:08:00 Customize Formula Options 00:04:00 Customize Proofing and Save Options 00:04:00 Customize the Ribbon and Quick Access Toolbar 00:04:00 Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2013 Excel Beginners - Complete Video Course
Delivered Online On Demand4 hours 47 minutes
£11.99

Microsoft Office 2007 Outlook Beginners - Complete Video Course

4.3(43)

By John Academy

Description: Outlook helps you communicate faster with more ways to organize your professional email, contacts, and calendar. Learn about Outlook 2007 features, support options, and tips to help you get more out of your email. In this Microsoft Office 2007 Outlook Beginners - Complete Video Course you will learn the basic components and functions of Microsoft Outlook 2007. You will be introduced with Outlook 2007 Window. It will provide you with an overview of the features and functions of Microsoft Office Outlook 2007. You will learn to connect to your primary e-mail account, troubleshoot the startup wizard, personalize your outlook workspace, explore the advanced toolbar, work in the contact window, save and update contact information, and more. This basic series is designed for them who want to learn beginning-level Outlook 2007 skills. So, if you are interested to learn all the basics of Microsoft Office Outlook 2007, then you should 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 2007 Outlook Beginners - 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 2007 Outlook Beginners - 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. Getting Started The Program Window FREE 00:15:00 Outlook Today 00:02:00 Getting Help 00:02:00 E-mail E-mail Accounts 00:07:00 Creating and Sending E-mail Messages 00:10:00 Creating and Sending E-mail Messages 00:10:00 Working with Messages 00:07:00 Attachments 00:07:00 E-mail Management Message Options 00:13:00 E-mail Security 00:14:00 Junk E-mail 00:06:00 Search Folders 00:02:00 Printing Messages 00:03:00 Contact Management Managing Contacts 00:17:00 Distribution Lists 00:04:00 Electronic Business Cards 00:10:00 Tasks Working with Tasks 00:14:00 Managing Tasks 00:08:00 Appointments and Events Creating and Sending Appointments 00:14:00 Modifying Appointments 00:03:00 Calendar Views 00:08:00 Events 00:05:00 Meeting Requests and Responses Meeting Requests 00:12:00 Meeting Request Responses 00:04:00 Managing Meeting Responses 00:03:00 Mock Exam Mock Exam- Microsoft Office 2007 Outlook Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Outlook Beginners - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 Outlook Beginners - Complete Video Course
Delivered Online On Demand4 hours
£11.99

Microsoft Office 2016 Word Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: If you are already able to create, edit, and print word 2016 documents, then this next level is designed for you. In this Microsoft Office 2016 Word Intermediate - Complete Video Course you will learn advanced formatting, how to use word 2016's advanced editing tools, work with image, including placing and sizing images, wrapping text around images, and using borders and effects, how to adjust page orientation and layout, work with columns, work with page and section breaks, document views, using the navigation pane, and viewing multiple windows, and more. You can join this course, if you have basic 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 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 2016 Word 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. Organizing Content Using Tables and Charts Sort Table Data FREE 00:07:00 Control Cell Layout 00:08:00 Perform Calculations in a Table 00:10:00 Create a Chart 00:11:00 Add an Excel Table to a Word Document 00:05:00 Customizing Formats Using Styles and Themes Create and Modify Text Styles 00:17:00 Create Custom List or Table Styles 00:07:00 Apply Document Themes 00:09:00 Inserting Content Using Quick Parts Insert Building Blocks 00:10:00 Create and Modify Building Blocks 00:07:00 Insert Fields Using Quick Parts 00:10:00 Using Templates to Automate Document Formatting Create a Document Using a Template 00:09:00 Create a Template 00:10:00 Manage Templates with the Template Organizer 00:05:00 Controlling the Flow of a Document Control Paragraph Flow 00:07:00 Insert Section Breaks 00:04:00 Insert Columns 00:05:00 Link Text Boxes to Control Text Flow 00:09:00 Simplifying and Managing Long Documents Insert Blank and Cover Pages 00:05:00 Insert an Index 00:09:00 Insert a Table of Contents 00:06:00 Insert an Ancillary Table 00:10:00 Manage Outlines 00:06:00 Create a Master Document 00:09:00 Using Mail Merge to Create Letters, Envelopes, and Labels The Mail Merge Feature 00:23:00 Merge Envelopes and Labels 00:08:00 Mock Exam Mock Exam- Microsoft Office 2016 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Word Intermediate - Complete Video Course
Delivered Online On Demand4 hours 26 minutes
£11.99