6191 Productivity courses

A Computer Maintenance Specialist keeps computers in a good state of repair. They may run diagnostic programs to determine the causes of and help to resolve problems. The Computer Maintenance Specialist Training Level 2 course is designed for the people who want to pursue the lucrative career of computer maintenance specialists. Topics included in the course are the types of computer, computer basics, the anatomy of a PC, how a PC works, input and output devices, and more. In short, the course covers almost everything that you need to know about becoming a computer specialist. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

Overview This comprehensive course on Building Your Own Computer will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Building Your Own Computer comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Building Your Own Computer. It is available to all students, of all academic backgrounds. Requirements Our Building Your Own Computer 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 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 2 sections • 9 lectures • 03:06:00 total length •Module 01: Introduction to Computer & Building PC: 00:17:00 •Module 02: Overview of Hardware and Parts: 00:27:00 •Module 03: Building the Computer: 00:25:00 •Module 04: Input and Output Devices: 00:22:00 •Module 05: Software Installation: 00:35:00 •Module 06: Computer Networking: 00:21:00 •Module 07: Building a Gaming PC: 00:19:00 •Module 08: Maintenance of Computers: 00:20:00 •Assignment - Building Your Own Computer: 00:00:00

Overview This comprehensive course on Workshop Technology: Machine Shop Theory will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Workshop Technology: Machine Shop Theory 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test 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 Workshop Technology: Machine Shop Theory. It is available to all students, of all academic backgrounds. Requirements Our Workshop Technology: Machine Shop Theory 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 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 9 sections • 41 lectures • 02:20:00 total length •Scope of the Course: 00:10:00 •Metal Cutting Processes: 00:02:00 •Cutting Tools: 00:03:00 •Nomenclature of Single Point Cutting Tool: 00:04:00 •Tool Signature: 00:02:00 •Mechanics of Metal Cutting: 00:04:00 •Types of Chips: 00:03:00 •Coolant or Cutting Fluids: 00:03:00 •Types of Lathe Machine: 00:09:00 •Construction of A Lathe: 00:09:00 •Accessories and Attachments: 00:07:00 •Specification of Lathe: 00:02:00 •Lathe Operations: 00:02:00 •Taper and Taper Turning: 00:04:00 •Thread Cutting: 00:03:00 •Cutting Speed and Feed: 00:02:00 •Construction of A Drilling Machine: 00:04:00 •Types of Drilling Machine: 00:09:00 •Types of Drills: 00:03:00 •Twist Drill Geometry: 00:04:00 •Drilling Operations: 00:05:00 •Size of Drilling Machine: 00:01:00 •Cutting Speed and Feed: 00:02:00 •Working Principle: 00:03:00 •Types of Shaper: 00:01:00 •Parts of Shaper: 00:05:00 •Shaper Mechanism: 00:04:00 •Shaper Operations: 00:01:00 •Types of Planer: 00:01:00 •Working Principle: 00:02:00 •Difference Between Shaper and Planer: 00:02:00 •Principle Parts of Slotter: 00:03:00 •Slotter Operations: 00:02:00 •Working Principle: 00:02:00 •Milling Methods: 00:03:00 •Types of Milling Cutters: 00:01:00 •Types of Milling Machines: 00:07:00 •Size of Milling Machine: 00:01:00 •Indexing and Dividing Head: 00:02:00 •Milling Operations: 00:03:00 •Assignment - Workshop Technology: Machine Shop Theory: 00:00:00

For a solid understanding of comprehensive ASP.Net MVC and Entity Framework and to kickstart your career as a

Certified Diploma in Admin Assistant is an essential qualification for those who want to work in the administrative support field. Even if you are already working as a support engineer in the admin section, you will eventually need a better qualification to get promotion. This will greatly help you to receive the advancement that you always deserve. This course is accredited from CPD and you will learn important aspects of admin support. The first and foremost thing while working in the admin field is dealing with the clients and users. Email is the best form of communication these days and managing huge amount of emails requires extensive level of skill sets. An admin support must keep their workspace organised. So, this course will teach you how to use to-do lists and manage milestones. You will also learn time management, maintaining schedules, prioritising and empowering yourself. You will be able to acquire enough knowledge required to perform as a top level professional Admin support with the help of this well structured course. Course Highlights Certified Diploma in Admin Assistant 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 Certified Diploma in Admin Assistant into 72 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 2 days, 20 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 Certified Diploma in Admin Assistant 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? Certified Diploma in Admin Assistant 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 Certified Diploma in Admin Assistant 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. Admin Support Module One - Getting Started FREE 00:30:00 Module Two - Getting Organized (I) FREE 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Management Module One - Getting Started FREE 01:00:00 Module Two - Why Your Office Needs Administrative Procedures FREE 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 01:00:00 Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 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 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access FREE 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Certified Diploma in Admin Assistant 00:20:00 Final Exam Final Exam- Certified Diploma in Admin Assistant 00:20:00

Overview The transcription industry in the UK is booming, with an expected growth rate of 15% over the next 5 years. With the rise of remote work and AI technology still developing, skilled human transcriptionists are in high demand across multiple sectors. This comprehensive 12-module course provides intensive training on core transcription skills needed to begin a successful career in the field. Beyond surface-level instruction, the advanced modules empower you to handle complex specialist transcription work precisely and efficiently. With translators receiving an average salary of £22,000 per year in the UK, this transcription skills course opens up diverse, well-paid work options you can do from anywhere at your own pace. Join the high-growth transcription industry today with in-depth training tailored for real job readiness. Enrol today and take your first step towards a successful career in transcription! You Will Learn Following Things: Produce accurate transcriptions with confidence. Apply essential transcription techniques effectively. Enhance transcription speed and efficiency. Identify and pursue transcription opportunities successfully. Deliver professional-quality transcriptions consistently. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Transcription Skills. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Transcription Skills course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? Individuals seeking a flexible, home-based career option. Those with strong attention to detail and a keen ear. People with excellent typing skills and a passion for language. Individuals are eager to learn new skills and explore the world of transcription. Those looking to supplement their income or transition into a new field. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Transcription Skills course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Transcriptionist: £18K to £30K/year. Medical Transcriptionist: £22K to £35K/year Legal Transcriptionist: £24K to £40K/year Captioner: £20K to £32K/year Subtitler: £22K to £35K/year Course Curriculum Transcription Module 1: Introduction 00:05:00 Module 2: Transcription Comprehension 00:04:00 Module 3: A Comprehension Example 00:07:00 Module 4: Transcription Accuracy 00:05:00 Module 5: Accuracy Examples 00:08:00 Module 6: Common Homophones 00:05:00 Module 7: Transcription Formatting 00:07:00 Module 8: Speaker Labeling 00:04:00 Module 9: Spelling 00:03:00 Module 10: Advanced Module 00:20:00 Module 11: Useful Transcription Tools 00:03:00 Module 12: Where & How to Find Transcription Opportunities 00:08:00