Description: This course will enable you to learn useful PC attributes that are required for your regular work with PC. The course will teach you the essential standards of equipment and how to utilise adequately. You will learn about the parts and how to update and upgrade your PC, investigating your PC to dodge issues when you are working. You will learn essential computer operating system. Who is the course for? Beginner to advanced level users can benefit from the lessons we provide People who have an interest in learning about computer and computer maintenance Entry Requirement: This course is available to all learners of all academic backgrounds. However, having an educational background and experience in computer operating system will be an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Certificate Course to Computer Operating System is a very useful qualification to possess, and will be very helpful to have especially for these careers: Computer Maintenance Staff IT Department Manager Computer Engineer Computer Specialist And Other Computer Operation-related jobs! Computer Fundamentals Basic Terms 00:15:00 Types of Computers 00:15:00 Anatomy of a PC 00:30:00 How a PC Works 00:15:00 CPU and Memory 00:30:00 Input Devices 00:15:00 Output Devices 00:15:00 Secondary Storage Devices 00:30:00 The Basics 00:15:00 Operating Systems and Applications 00:30:00 How is Software Built 00:15:00 Types of Software 00:15:00 Legal Issues 00:15:00 Computer Operating System Introduction 00:15:00 What is an Operating System? 00:30:00 History of Operating System 00:30:00 What an Operating System Does 01:00:00 Microsoft Windows 00:15:00 MAC OS 01:00:00 UNIX 00:30:00 LINUX 00:30:00 GNU 00:30:00 Other Operating Systems999 01:00:00 Installing an Operating System 00:30:00 Defining The Processes 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam- Certificate in Computer Operating System 00:20:00 Final Exam Final Exam- Certificate in Computer Operating System 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: This Windows 10: New Developments - Video Training Course has been designed deliberately designed to help you go through a regiment of training which will prepare you and teach you about all the features of Windows 10. This operating system is the culmination of all the good features of previous versions and it will go through a continuous revision and updates for the next upcoming years. Windows 10 has been designed for multi-device platform operating system which incorporates cloud-based services and online helpline management. In this course, you will learn about the user experiences, use the settings app for your own modification and Cortana. Since many organizations are moving towards making a centralized cloud based services for their company, it is imperative for any employee to know how to use these applications on Windows 10. 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? Windows 10: New Developments - Video Training 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 Windows 10: New Developments - Video 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. 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 Navigating and Using Windows 10 00:40:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Become a Microsoft Certified Excel Expert - includes lectures, test exercises, and video solutions
Designing your own customized form has never been easier using Microsoft Infopath. Using this useful software to its full potential however is something very few can do. But don't worry, this course will allow you to use microsoft infopath to its full extent. Use infopath to write your own expense report with offline support, increased accuracy and higher efficiency. Fill out your own insurance claim, permit application and other forms at your own convenience. Other benefits include inventory management and market research. Use this software to design, distribute, and to fill and submit electronic forms containing structured data. This course consists of units designed to teach you to use infopath at its highest capacity. This course can teach people want to learn how to design their own forms for professional purposes. At the end of the course you will be tested on your knowledge on infopath. All the important features will taught to you so that you can operate infopath smoothly. Course Highlights Certificate in Microsoft InfoPath 2007 is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certificate in Microsoft InfoPath 2007 into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certificate in Microsoft InfoPath 2007 Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certificate in Microsoft InfoPath 2007 is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certificate in Microsoft InfoPath 2007 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Opening and Closing InfoPath 01:00:00 Module Three - Filling Out a Form 01:00:00 Module Four - Designing a Form Framework 01:00:00 Module Five - Adding Labels 01:00:00 Module Six - Adding Controls 01:00:00 Module Seven - Formatting Controls 01:00:00 Module Eight - Working with Data Sources 01:00:00 Module Nine - Creating a View 01:00:00 Module Ten - Finishing the Form 01:00:00 Module Eleven - Distributing Your Form 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Certificate in Microsoft InfoPath 2007 00:00:00 Mock Exam Final Exam
Microsoft Office 2016 Complete Course Did you ever struggle with MS Office 2016? Do you feel like you need to learn more about MS Office skills? Well, if you want to increase your productivity to the highest level in your workplace, our Microsoft Office 2016 Complete Course is the perfect one for you. This course is a power-packed course that covers everything about Microsoft Office 2016. In this Microsoft Office 2016 Complete Course course, learners will gain proficiency in sharing documents, comparing changes, and reviewing papers collaboratively with others. Plus, you will learn advanced document formatting techniques, such as adding captions, cross-references, footnotes, endnotes, and bibliographies to enhance document structure and readability. This course will teach you how to manage user information effectively within Microsoft Word 2016 documents, including modifying and updating user details. Moving deeper into the Microsoft Office 2016 Complete Course, you will gain in-depth knowledge about Microsoft Excel 2016 in detail. After completing this course, you will develop the skills to troubleshoot formula errors, trace cells, and evaluate formulas to ensure data integrity and reliability in Excel 2016. You will also be able to apply conditional formatting and data validation criteria to organise and visualise data, ensuring accuracy and consistency efficiently. Moreover, in this Microsoft Office 2016 Complete Course course, you will learn to customise the Microsoft PowerPoint 2016 user interface and manage presentation sections for improved organisation and navigation. This course will make you an expert in presenting slideshows online, leveraging PowerPoint's remote collaboration and engagement capabilities. Furthermore, you will learn to insert advanced characters and objects, modify message settings, and utilise automatic replies to manage email communication effectively using Microsoft Outlook 2016. The last part of the course will elevate your mastery of Microsoft Access 2016. Ernol in the Microsoft Office 2016 Complete Course course to boost your work-life efficiency. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.
Have you ever faced a situation where you wanted to note something down but you didn't have your diary or notebook because you didn't want to carry the extra load? With Microsoft One Note you don't need to face this situation again. Write anything down anywhere, whenever you feel like. Store your drawings, screen clippings and audio commentaries on this useful app. This application can be used on your mobile phones. One note can be downloaded on any platform. It is very easy to use and very useful for anyone living a busy life. One note is beneficial for improved workflow and daily organization. It has an easy access and improves transparency. The app itself can also be downloaded for free. This course will give you the general idea on how to operate microsoft one note. After completion you will be able to learn most functions of this useful application and store all your thoughts and writings on it while also organizing your daily life. Course Highlights Accredited Microsoft One Note for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft One Note for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft One Note for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft One Note for Beginners is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Microsoft One Note for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Your First Notebook 01:00:00 Module Three - Working with Text 01:00:00 Module Four - Working with Pages and Sections 01:00:00 Module Five - Staying Organized 01:00:00 Module Six - Tagging and Searching Notes 01:00:00 Module Seven - Using Send to OneNote 01:00:00 Module Eight - Inserting Basic Objects 01:00:00 Module Nine - Drawing in OneNote 01:00:00 Module Ten - Reviewing Your Notes 01:00:00 Module Eleven - Sharing Your Notes 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Accredited Microsoft One Note for Beginners 00:00:00 Mock Exam Mock Exam- Accredited Microsoft One Note for Beginners 00:20:00 Final Exam Final Exam- Accredited Microsoft One Note for Beginners 00:20:00
Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included
Description: InfoPath is a powerful solution made my Microsoft for collecting data from users on a variety of platforms. In this course, you will learn the necessary skills, knowledge, and information about the advanced functions and features of Microsoft InfoPath and learn the new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms. Find out how to use InfoPath in conjunction with SharePoint for a variety of additional features. Who is the course for? Professionals who want to learn about the Microsoft InfoPath 2010. People who have an interest in the advanced features of Microsoft InfoPath 2010. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft InfoPath Advanced Level course is a useful qualification to possess and would be beneficial for any type of professions or career from any type of industry such as: Administrative Officer Project Management Officer Project Assistant Project Support Secretary. Microsoft Infopath Advanced Level Module One - Getting Started 00:30:00 Module Two - Types of Controls 01:00:00 Module Three - Repeating and Optional Controls 01:00:00 Module Four - Control Tool Properties and Table Tools Tabs 01:00:00 Module Five - Actions 01:00:00 Module Six - Importing Form Designs 01:00:00 Module Seven - Advanced Topics 01:00:00 Module Eight - Understanding Code 01:00:00 Module Nine - Publishing Forms 01:00:00 Module Ten - SharePoint Integration 01:00:00 Module Eleven - Publishing Forms for Use with SharePoint 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Infopath Advanced Level 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Windows 8 is the latest version of Microsoft's widely used Windows operating system. This version of Windows incorporates hundreds of new features as well as improvements to existing tools. This Microsoft Windows 8 Foundation Training is intended to help both novice and experienced users become familiar with the many changes that have been made to Windows with this release. This manual will also help users with previous Windows experience become more familiar with the new Start screen. If, you want to learn detail about Microsoft Windows 8 you can join this course now. Learning Outcomes: Introduction to Windows 8 start up screen and desktop Windows power options and basic keyboard, mouse and touch techniques Guide to basic elements of the Windows 8 start screen and Windows Store Customize app tiles and notifications, while learning to open and manage apps and Charms bar Local and Microsoft Account creation and customization Windows 8 features like Mail, Calendar, People, Messaging and Photos Discover more Windows 8 apps like Internet Explorer, General News, Bing, Finance, Travel, Sports, Maps and SkyDrive Desktop display and components Window management features, jump lists and basic desktop applications Understanding basic file structure in Windows 8 Open, use and customizing File Explorer, discovering Recycle Bin, help & support tools 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 Windows 8 Foundation 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 Microsoft Windows 8 Foundation 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. Microsoft Windows 8 Foundation Training The Basics of Windows 8 00:30:00 Interacting with the Computer Using a Mouse and Keyboard 00:15:00 Interacting with the Computer Using Touch Gestures, Part One 00:15:00 Interacting with the Computer Using Touch Gestures, Part Two 00:15:00 Exiting Windows 8 00:30:00 Introducing the Windows 8 Start Screen 00:30:00 Using the Windows 8 Start Screen 00:30:00 Working with Windows 8 Apps 00:30:00 Using the Charms Bar 00:30:00 Using the Windows Store 00:15:00 Getting Started - The Basic Windows 8 Applications, Part One 00:30:00 Managing Accounts 00:15:00 Using Mail 00:30:00 Using Calendar 00:30:00 Using People and Messaging 00:30:00 Using Photos 00:30:00 Using Windows 8 Internet Explorer, Part One 00:15:00 Using Windows 8 Internet Explorer, Part Two 00:15:00 Using News Apps 01:00:00 Using Maps 00:15:00 Using SkyDrive 00:30:00 Introducing the Windows 8 Desktop 00:30:00 Managing Desktop Windows 00:30:00 Using Desktop Features 00:15:00 Using Jump Lists 00:15:00 Desktop Application Basics 00:30:00 Interface Basics 00:30:00 The Basic Components 00:30:00 The File Explorer Tabs 00:30:00 Customizing File Explorer 00:30:00 Using the Recycle Bin 00:15:00 Getting Help in Windows 8 00:15:00 Mock Exam Mock Exam- Microsoft Windows 8 Foundation Training 00:20:00 Final Exam Final Exam- Microsoft Windows 8 Foundation Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00