612 Computer Skills courses

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner 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 spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner 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 • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

Overview This comprehensive course on Touch Typing Essentials will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Touch Typing Essentials 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? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Touch Typing Essentials. It is available to all students, of all academic backgrounds. Requirements Our Touch Typing Essentials 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 21 sections • 26 lectures • 02:01:00 total length •Promo: 00:04:00 •Course Overview: 00:12:00 •Resource - Touch Typing Essentials: 00:00:00 •Understanding the Keyboard Layout: 00:03:00 •How to set up input languages - for Mac: 00:09:00 •How to set up input langauges - for Windows: 00:12:00 •How to correctly place your fingers on the keyboard: 00:07:00 •How to type the letters F and J: 00:04:00 •How to type the letters D and K: 00:04:00 •How to type the letters S and L: 00:03:00 •How to type the letter A and semicolon: 00:04:00 •How to type the letters E and I: 00:04:00 •How to type the letters R and U: 00:04:00 •How to type the letters T and O: 00:04:00 •How to type CAPITAL letters: 00:05:00 •How to type the letter C and , (Comma): 00:04:00 •How to type the letters G and H: 00:03:00 •How to type the letters N and V: 00:03:00 •How to type the letters W and M: 00:04:00 •How to type the letters Q and P: 00:04:00 •How to type the letters B and Y: 00:03:00 •How to type the letters Z and X: 00:04:00 •How to type Colon and Semicolon: 00:03:00 •How to type Full Stop and Comma: 00:03:00 •How to type Question Mark and Exclamation Mark: 00:04:00 •How to type Dash, Parentheses and Quotation Marks: 00:07:00

Microsoft Excel assists you to perform with different programs such as calculation, macro program language, pivot tablets, graphics tools, and various applications within time. Learn much more precise use of these functions with the easiest and effective method thorough Microsoft Office 2016 Excel Beginners course. The course teaches you the basic functions of Excel. It instructs you how to open Excel files, make a simple calculation, and save it. It also teaches you how to put data, extract data, analyze actionable information, and perform in different ways. The purpose of the course is to enhance your ability to kick-start your career in a sound bite. Who is this Course for? Microsoft Office 2016 Excel Beginners is 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. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Microsoft office is used for documentation, writing, and many other activities. It brings a new dimension to this technology-based competitive world. It has vivid functions and much more use. If you want to learn all its advanced functions, look at our Microsoft Office 2016 Advanced course. This course introduces to the function of ribbon that incorporates many tabs such as Insert, design, animation, slides, show, review, and home. It also guides you step by step how to insert a picture, change design lay order, add a hyperlink, watch video from youtube, create CV, cash memo, payment sleep, many more things. Overall the course teaches you all the efficient use of Microsoft Office to be expert in it. Who is this Course for? Microsoft Office 2016 Advanced is 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. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Mock Exam Mock Exam - Microsoft Office 2016 Advanced 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Advanced 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Most of the standard white-collar jobs nowadays depend on the fastest skills and that most importantly includes the typing speed skill ranging from 35-200 words per minute. So, if you're facing problems with your typing speed and your job is highly dependent on that, we have the right solution for you in this Touch Typing Masterclass course. This Certificate in Touch Typing Masterclass course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 40 CPD points) to make your skill development & career progression more accessible than ever! Typing the wrong letters can be frustrating, especially when you're in a hurry. With the help of this touch typing course, you will be able to memorise the location of letters, numbers, and other characters on the keyboard. As a result, you will be able to type faster and more accurately. This touch typing course creates the ability for you to understand typing rules and how you should be placing your finger on the keyboard. Upon completing this touch typing course, you will develop the perception of proficiency in touch typing the alphabet, and how to type sentences of any length using signs, dash, and parenthesis. Moreover, you will be able to learn about keyboard shortcuts and many secrets for accelerating your typing speed. What will I learn from this Touching Typing Masterclass? Learn to touch-type in the most efficient way Correct placement of the hand on the keyboard How to type faster spelling accuracy Best way to practice capital letters Typing with all the fingers Typing without continuously referring to your keyboard This touch typing masterclass certificate will also help you to create an impression of self-reliance and dedication that will surely attract prospective employers to give priority to your job application. Enrol in this touch typing masterclass course today to open and build enchanting career opportunities ahead. Take a step toward a brighter future! Why Prefer this Touch Typing Masterclass Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPDQS Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. *** Course Curriculum *** Here is the curriculum breakdown of this course: *** Touch Typing Masterclass - Updated Version *** Module 1: Introduction Module 2: How to Set up Your Computer Module 3: How to type the letters F and J Module 4: How to type the letters D and K Module 5: How to type the letters S and L Module 6: How to type the letter A and ; (semicolon) Module 7: How to type the letters E and I Module 8: How to type the letters R and U Module 9: How to type the letters T and O Module 10: How to type CAPITAL letters Module 11: How to type the letter C and, (Comma) Module 12: How to type the letters G and H Module 13: How to type the letters N and V Module 14: How to type the letters W and M Module 15: How to type the letters Q and P Module 16: How to type the letters B and Y Module 17: How to type the letters Z and X Module 18: How to type Colon and Semicolon Module 19: How to type Full Stop and Comma Module 20: How to type Question Mark and Exclamation Mark Module 21: How to type Dash, Parentheses and Quotation Marks *** Touch Typing Masterclass - Old Version *** Module 1: Getting Started Module 2: DRILL 1 the home keys Module 3: DRILL 2 e and i, g and h Module 4: DRILL 3 o and n, shift keys and t Module 5: DRILL 4 extra practice . and y Module 6: DRILL 5, and w Module 7: DRILL 6 m and u Module 8: DRILL 7 v and x Module 9: DRILL 8-sentence drills Module 10: DRILL 9 figures Module 11: DRILL 10 alphabetical paragraphs Module 12: Recap Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Certificate in Touch Typing Masterclass exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? In the present era, typing is an essential skill for anyone who sees themselves working with a computer. Besides, this touch typing masterclass course is preferable for students, programmers, content writers, bloggers, researchers, and data entry operators. The touch typing masterclass course doesn't require any academic background and is open to everyone. HOW TO USE RESOURCES: To use the resources, just download them and open them using a browser. You can use Google Chrome to open them, but Safari or any other browser can also be used. Just make sure to enable javascript in the browsers for the automatic correction/ highlights. Requirements You will not need any prior background or expertise to enrol in this course. Career path Enroling on this Touch Typing Masterclass can lead to the following career paths: Data Entry Operator Customer Service Executives Email Marketing Executives Personal Assistant Administrative Executive And many more office job roles requiring you to type fast! Certificates CPDQS Accredited Certificate Digital certificate - £10 Certificate in Touch Typing Masterclass at QLS Level 1 Hard copy certificate - £59 Show off Your New Skills with a Certification of Completion After successfully completing the Certificate in Touch Typing Masterclass at QLS Level 1, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 59 GBP inside the UK 69 GBP (including postal fees) for international delivery CPDQS Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

The 'Diploma in CompTIA A+' course provides comprehensive training on essential computer hardware, networking, and security topics. Students will learn about various components, peripherals, and technologies involved in building and maintaining computer systems, as well as securing them. Learning Outcomes: Understand the fundamentals of CompTIA A+ certification and its significance in the IT industry. Gain knowledge about computer hardware, including CPUs, RAM, motherboards, power supplies, and mass storage technologies. Acquire skills in networking concepts, local area networking, wireless networking, and internet technologies. Learn about virtualization, portable computing, mobile devices, printers, and multifunction devices. Develop an understanding of computer security practices and how to secure computers and networks effectively. Why buy this Diploma in CompTIA A+? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Diploma in CompTIA A+ there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Diploma in CompTIA A+ course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Diploma in CompTIA A+ does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diploma in CompTIA A+ was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Diploma in CompTIA A+ is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: All about the CompTIA A+ CompTIA A+ 2019 Core 1 (220-1001) Course Introduction 00:02:00 What is the CompTIA A+? 00:02:00 Why Get A+ Certified? 00:03:00 What is on the CompTIA A+ Core 1 (220-1001) Exam? 00:09:00 How to Pass the A+ Exam 00:04:00 How to Use This Video Course 00:03:00 Section 02: Safety and Professionalism Tools of the Trade 00:06:00 Troubleshooting Theory 00:10:00 Section 03: The Visible Computer Primary PC Connections 00:05:00 External Connections 00:11:00 Inside the PC 00:08:00 What is a Computer? 00:07:00 Section 04: CPUs What is a CPU? 00:15:00 CPU Speeds and Cores 00:12:00 Caching 00:00:00 CPU Sockets 00:12:00 Installing a CPU 00:11:00 Liquid Cooling 00:04:00 Section 05: RAM RAM Technology 00:11:00 RAM Capacity 00:08:00 RAM Features 00:07:00 Installing RAM 00:07:00 Section 06: Firmware What is the BIOS? 00:06:00 POST 00:09:00 System Setup 00:09:00 Troubleshooting Firmware 00:12:00 Section 07: Motherboards Form Factors 00:06:00 Chipsets 00:05:00 Touring the Motherboard 00:14:00 Touring the Case 00:07:00 Installing a Motherboard 00:09:00 Section 08: Power Supplies The Power Supply 00:09:00 Mounting a Power Supply 00:05:00 Choosing a Power Supply 00:08:00 Cooling Your PC 00:11:00 Troubleshooting Power Supplies 00:09:00 Troubleshooting Core Components 00:14:00 Section 09: Mass Storage Technologies Introduction to Mass Storage 00:13:00 Magnetic Disk Drives 00:08:00 Solid State Drives 00:08:00 SCSI 00:03:00 Boot Order 00:07:00 Section 10: Implementing Mass Storage New Installation - First Drive 00:05:00 RAID 00:11:00 Hardware RAID 00:07:00 Mass Storage Troubleshooting 00:08:00 Section 11: Essential Peripherals Optical Media 00:10:00 USB Standards 00:10:00 Understanding USB 00:11:00 Configuring USB 00:07:00 Thunder and Lightning 00:06:00 Keyboards and Mice 00:08:00 Sight and Sound 00:07:00 Readers and Scanners 00:08:00 Using Expansion Cards 00:08:00 Section 12: Building a PC The Right PC for the Job 00:13:00 Section 13: Display Technologies Monitor Technologies 00:08:00 LCD Breakdown 00:04:00 Graphics Cards and Connections 00:13:00 Installing a Graphics Card 00:07:00 Projectors 00:05:00 Troubleshooting Monitors 00:06:00 Section 14: Essentials of Networking Introduction to Networking 00:08:00 Hubs vs. Switches 00:05:00 Hexadecimal 00:07:00 WANs and Routers 00:09:00 Cables and Connectors 00:11:00 Crimping Cables 00:10:00 Structured Cabling 00:11:00 Section 15: Local Area Networking Introduction to TCP/IP 00:14:00 Network IDs and Subnet Masks 00:05:00 Special IP Addresses 00:09:00 NAT 00:07:00 Dynamic IP Addressing 00:10:00 IPv6 00:07:00 Port Numbers 00:12:00 TCP, UDP, and ICMP 00:06:00 Understanding DNS 00:09:00 Working with DNS 00:07:00 Windows Naming 00:08:00 Routers 00:12:00 Basic Router Configuration 00:12:00 Advanced Router Configuration 00:06:00 VLANs 00:07:00 Network Troubleshooting 00:05:00 Section 16: Wireless Networking Wireless Network Hardware 00:11:00 Wi-Fi Standards 00:10:00 Basic WAP Setup 00:11:00 Connecting to a Wi-Fi Network 00:09:00 It's a Huge Mesh 00:04:00 Beyond Wi-Fi 00:07:00 Troubleshooting Wireless Connections 00:07:00 Section 17: The Internet Beyond the LAN 00:03:00 Internet Tiers 00:06:00 Dial-up Connections 00:08:00 Broadband Connections 00:10:00 Firewalls and Servers 00:06:00 FTP 00:07:00 E-Mail 00:08:00 Proxy Servers 00:06:00 Virtual Private Networks (VPNs) 00:10:00 Internet of Things (IoT) 00:04:00 Section 18: Virtualization Understanding Virtualization 00:10:00 Your First Virtual Machine 00:11:00 Advanced Virtualization Setup 00:10:00 Cloud Computing 00:08:00 Cloud Ownership 00:03:00 Cloud-Based Applications 00:06:00 Section 19: Portable Computing Laptop Features 00:08:00 Laptop Hardware Troubleshooting - The Tools 00:05:00 Laptop Hardware - Core Hardware 00:04:00 Laptop Hardware - CPU and Motherboard 00:07:00 Touring Your Laptop Display 00:04:00 Section 20: Understanding Mobile Devices What is a Mobile Device? 00:09:00 Mobile Connections 00:10:00 Touring Android 00:10:00 Touring iOS 00:08:00 Virtual Reality 00:03:00 Section 21: Care and Feeding of Mobile Devices Maintaining Mobile Devices 00:11:00 Mobile Devices and E-mail 00:10:00 Mobile Synchronization 00:08:00 Section 22: Printers and Multifunction Devices Laser Printers 00:13:00 Inkjet Printers 00:08:00 Impact Printers 00:04:00 Thermal Printers 00:04:00 Installing a Local Printer 00:14:00 Sharing Printers 00:08:00 Installing Wireless and Cloud Printers 00:10:00 Troubleshooting Printers 00:10:00 3D Printing 00:07:00 Section 23: Securing Computers Dealing with Threats 00:07:00 Assignment Assignment - Diploma in CompTIA A+ 00:00:00

The CompTIA ITF+ (FCO-U61) course provides foundational knowledge and skills in IT fundamentals. It covers various aspects of computer usage, hardware, data storage, operating systems, network connectivity, security, troubleshooting, and software development. This course is designed to equip learners with a comprehensive understanding of IT concepts to prepare for entry-level IT roles. Learning Outcomes: Acquire an understanding of diverse computer uses in various scenarios. Gain insights into the components and operations of system hardware. Develop proficiency in managing device ports, peripherals, and mobile configurations. Enhance knowledge in data storage, file management, and application software usage. Master the essentials of network connectivity, IT security, and computer maintenance. Why buy this CompTIA ITF+ (FCO-U61)? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the CompTIA ITF+ (FCO-U61) there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Individuals starting their journey in the IT field. Students seeking foundational knowledge in computing. Career changers aiming to enter the IT sector. Aspiring IT professionals desiring a comprehensive understanding of computers. Individuals interested in acquiring a broad IT skill set. Prerequisites This CompTIA ITF+ (FCO-U61) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This CompTIA ITF+ (FCO-U61) was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path IT Support Specialist: £20,000 - £30,000 per annum Network Administrator: £25,000 - £40,000 per annum Systems Analyst: £30,000 - £50,000 per annum Database Administrator: £30,000 - £50,000 per annum Software Developer: £25,000 - £45,000 per annum Cybersecurity Analyst: £30,000 - £55,000 per annum Course Curriculum Section 01: How People Use Computers Introduction to IT Fundamentals 00:03:00 The Case for Computer Literacy 00:03:00 Features Common to Every Computing Device 00:02:00 Common General-Purpose Computing Devices 00:02:00 Networks of Computing Devices 00:04:00 Remotely-Accessed Computer Systems 00:04:00 Specialized Computer Systems 00:02:00 Specialty I/O Devices 00:01:00 Section 02: System Hardware CPUs 00:03:00 Passive and Active Cooling 00:03:00 RAM and Active Memory 00:05:00 Motherboards 00:03:00 Power Supplies 00:03:00 AMA - Ask Me Anything about System Hardware 00:07:00 Section 03: Device Ports and Peripherals Ports and Connectors 00:03:00 General Use I/O Devices 00:02:00 AMA - Ask Me Anything about I/O, Ports and Peripherals 00:07:00 Section 04: Data Storage and Sharing Basics of Binary 00:04:00 Storage Technologies 00:04:00 Mass Storage Variation 00:03:00 AMA - Ask Me Anything about Data Storage and Sharing 00:07:00 Section 05: Understanding Operating Systems Operating System Functions 00:04:00 Operating System Interfaces 00:05:00 AMA - Ask Me Anything about Understanding OS's 00:05:00 Section 06: Setting Up and Configuring a PC Preparing the Work Area 00:02:00 Setting up a Desktop PC 00:01:00 Completing PC Setup 00:04:00 AMA - Ask Me Anything about Setting up and Configuring a PC 00:09:00 Section 07: Setting Up and Configuring a Mobile Device Personalizing a Tablet 00:08:00 AMA - Ask Me Anything about Mobile Devices Part 1 00:07:00 AMA - Ask Me Anything about Mobile Devices Part 2 00:07:00 Section 08: Managing Files File Management Tools 00:02:00 File Manipulation 00:06:00 Backups 00:03:00 AMA - Ask Me Anything about Managing Files 00:08:00 Section 09: Using and Managing Application Software Walking Survey of Applications 00:03:00 Managing Applications 00:03:00 Applications and Extensions 00:04:00 AMA - Ask Me Anything about Working with Applications 00:07:00 Section 10: Configuring Network and Internet Connectivity Wi-Fi Setup 00:06:00 Going High Speed 00:03:00 Setting Up and Sharing Printers 00:05:00 AMA - Ask Me Anything about Networks and Internet Connectivity Part 1 00:07:00 AMA - Ask Me Anything about Networks and Internet Connectivity Part 2 00:05:00 Section 11: IT Security Threat Mitigation Physical Security 00:05:00 Dealing with Malware 00:03:00 Password Management 00:03:00 Clickworthy 00:03:00 Perils of Public Internet 00:02:00 AMA - Ask Me Anything about IT Threat Mitigation Part 1 00:07:00 AMA - Ask Me Anything about IT Threat Mitigation Part 2 00:08:00 Section 12: Computer Maintenance and Management Power Management 00:03:00 Cleaning and Maintaining Computers 00:03:00 Trash it or Stash it? 00:02:00 AMA - Ask Me Anything about Computer Maintenance and Management 00:11:00 Section 13: IT Troubleshooting Troubleshooting 00:03:00 AMA - Ask Me Anything about Troubleshooting Computers Part 1 00:10:00 AMA - Ask Me Anything about Troubleshooting Computers Part 2 00:11:00 Section 14: Understanding Databases Introduction to Databases 00:06:00 Database Details 00:06:00 AMA - Ask Me Anything about Databases 00:06:00 Section 15: Developing and Implementing Software Introduction to Programming 00:04:00 Programming with a PBJ Sandwich 00:08:00 AMA - Ask Me Anything about Programming 00:04:00

In the age of rapid technological advancement, the skill of typing swiftly and accurately is not just an advantage; it's a necessity. Dive into the 'Advanced Typing Training: Enhance Your Typing Speed and Accuracy' course, a comprehensive curriculum aimed at elevating your keyboard mastery. Through engaging modules, learners explore cutting-edge techniques, speed-building strategies, and delve deep into the realm of error reduction, ensuring every keystroke counts. Furthermore, with a spotlight on specialised typing tasks and an overview of the latest software and tools, this course stands out as a beacon for those aspiring to type with precision and flair. Learning Outcomes Upon completion of this course, participants will be able to: Gain a profound understanding of advanced typing methodologies and their significance. Develop strategies to increase typing speed without compromising on accuracy. Master the art of proofreading to minimise errors in typed content. Acquire the knowledge to handle specialised typing assignments with finesse. Familiarise oneself with the latest typing software and tools, and effectively assess one's typing speed and accuracy. Why buy this Advanced Typing Training: Enhance Your Typing Speed and Accuracy? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Advanced Typing Training: Enhance Your Typing Speed and Accuracy there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Advanced Typing Training: Enhance Your Typing Speed and Accuracy course for? This Advanced Typing Training: Enhance Your Typing Speed and Accuracy does not require you to have any prior qualifications or experience. You can just enrol and start learning. Individuals aiming to enhance their keyboard skills for personal or professional growth. Job seekers looking to add a valuable skill to their CV. Writers, journalists, and content creators keen on improving their efficiency. Administrative and office professionals who manage extensive documentation. Students or researchers who frequently draft lengthy pieces. Prerequisites This Advanced Typing Training: Enhance Your Typing Speed and Accuracy does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced Typing Training: Enhance Your Typing Speed and Accuracy was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Typist: Average salary of £20,000 - £25,000 Per Annum. Data Entry Clerk: Average salary of £18,000 - £22,000 Per Annum. Transcriptionist: Average salary of £25,000 - £30,000 Per Annum. Administrative Assistant: Average salary of £18,000 - £23,000 Per Annum. Content Creator: Average salary of £24,000 - £29,000 Per Annum. Office Manager: Average salary of £25,000 - £35,000 Per Annum. Course Curriculum Module 01: Introduction to Advanced Typing Introduction to Advanced Typing 00:17:00 Module 02: Advanced Typing Techniques Advanced Typing Techniques 00:15:00 Module 03: Speed Building Strategies Speed Building Strategies 00:14:00 Module 04: Error Reduction and Proofreading Error Reduction and Proofreading 00:16:00 Module 05: Specialised Typing Tasks Specialised Typing Tasks 00:16:00 Module 06: Typing Software and Tools Typing Software and Tools 00:15:00 Module 07: Typing Speed and Accuracy Assessment Typing Speed and Accuracy Assessment 00:16:00

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Introduction is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Introduction is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Introduction Introduction 00:01:00 Section 01 What is Excel 00:04:00 Opening Excel 00:07:00 Navigating the Excel User Interface 00:10:00 Using the Excel Ribbon 00:07:00 Understanding Excel Worksheet Components 00:07:00 Using the Backstage View 00:09:00 Section 02 Creating a New Workbook 00:06:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using the Accessibility Checker 00:04:00 Section 03 Navigating a Worksheet by Mouse or Keyboard 00:05:00 Understanding Excel Data Types 00:06:00 Using the Inking Tools 00:06:00 Working with Cell and Range Addressing 00:03:00 Using various Data Selection Techniques 00:03:00 Working with Common Excel Commands 00:05:00 Using the Autofill Handle 00:04:00 Using Flash Fill 00:02:00 Section 04 What are Formulas and Functions 00:04:00 Understanding the Components of a Formula 00:06:00 Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Creating Basic Formulas 00:03:00 Working with Basic Functions and AutoSum 00:06:00 Using Cell References 00:05:00 Using the Quick Analysis Tools 00:03:00 Section 05 Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:04:00 Section 06 Formatting and Aligning Data 00:11:00 Merging Data 00:08:00 Wrapping Text and Adjusting Orientation 00:07:00 Formatting Numbers 00:08:00 Using Borders and Shading 00:07:00 Using the Format Painter 00:04:00 Removing Formatting Quickly 00:05:00 Section 07 Using Cell Styles 00:06:00 Applying Themes 00:04:00 Section 08 Inserting and Formatting Images 00:06:00 Inserting and Formatting Shapes 00:06:00 Inserting and Formatting SmartArt 00:09:00 Working with Icons 00:06:00 Working with 3-D Models 00:05:00 Inserting Screenshots 00:05:00 Inserting Hyperlinks 00:05:00 Inserting Symbols and Equations 00:05:00 Inserting WordArt and Text Boxes 00:08:00 Inserting Other Excel Objects 00:06:00 Arranging Objects 00:05:00 Section 09 Using Find and Replace 00:03:00 Using Go To and Go To Special 00:03:00 Using the Spell Checker 00:05:00 Using the Thesaurus and Translation Features 00:05:00 Section 10 Printing and Previewing Excel Files 00:05:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:05:00 Exporting to PDF and XPS 00:04:00 Section 11 Renaming and Coloring Worksheet Tabs 00:04:00 Adding, Deleting, and Navigating Worksheets 00:05:00 Section 12 Viewing Workbooks 00:05:00 Using Zoom Tools 00:02:00 Configuring Sheet Options 00:04:00 Using the Freeze Panes and Split Commands 00:06:00 Working with Window Commands 00:03:00 Adjusting Workbook Properties 00:06:00 Recap Recap 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

[vc_row][vc_column][vc_column_text] Description: Improve your competency in Microsoft Office with this Microsoft Excel Complete Course - Beginners, Intermediate, Advanced. Microsoft Excel is the most widely used spreadsheet program in the world. It allows businesses to conduct data analysis, record expenditures and carry out simple to complex maths calculations. Want to master Excel? This complete training course will help you gain the practical skills and knowledge you need to perform everyday data-based tasks faster and more efficiently. This course is designed to help you familiarise with the major functionalities of Excel, with step-by-step guidance. You will start with simple tasks like viewing excel data, working with the interface, using quick analysis and more. At an intermediate skill level, you will learn about macros, forms, slicers, timelines etc. Finally, at an advanced level, you will learn how to create charts, pivot tables, solve formula errors and manage your data more effectively. This online course is the ultimate online guide for learning MS Excel. Certify your skills in this leading office software and gain maximum career progression! Who is the course for? Professionals who want to learn how to use Microsoft Office Excel. People who have a need to analyze and organise large amounts of data. 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 hardcopy 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: Microsoft Excel Complete Course - Beginners, Intermediate, Advanced is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accounting Management consultant Investment Banking Analyst Marketing Engineering Researchering [/vc_column_text][/vc_column][/vc_row] Microsoft Excel - Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Excel for Newbies - Activities 00:00:00 Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel - Intermediate Level 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel Complete Course - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Excel Complete Course - Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00