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

3491 Office Skills & Productivity courses

Python Programming for Non Programmers Level 5

4.5(3)

By Studyhub UK

Welcome to 'Python Programming for Non Programmers Level 5,' a course specially designed for those new to the world of coding. This program starts with a comprehensive introduction to Python, a versatile programming language favored in numerous fields. Progressing to the second unit, participants will familiarize themselves with the initial steps of Python programming, setting a strong foundation for future learning. The course then advances to conditional branching in Python, an essential skill for logical problem-solving in coding. A highlight of this course is the practical project: building the game 'Rock Paper Scissors'. This engaging task not only consolidates learning but also adds a fun element to the process. The curriculum further includes critical topics like string operations, date and time functionalities, and the nuances of file handling in Python. Learners will navigate through the complexities of Python data structures-tuples, lists, and dictionaries-and learn to craft user functions, enhancing their coding capabilities. The course also covers email automation, ingenious import tactics, interfacing with operating systems, and handling exceptions with finesse. Furthermore, learners will get hands-on experience with package installation, scheduling tasks in Python, and managing databases using SQLite. The course wraps up with insights on running Python programs via command prompt and Jupyter Notebook, ensuring learners are well-equipped for real-world applications. Learning Outcomes Acquire foundational knowledge and setup skills in Python programming. Master conditional branching for effective problem-solving in code. Complete a practical coding project to solidify Python skills. Learn essential Python operations, including string handling and file management. Explore and apply advanced Python concepts for real-world applications. Why choose this Python Programming for Non Programmers Level 5 course? 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. Who is this Python Programming for Non Programmers Level 5 course for? Beginners eager to learn Python from scratch. Non-technical professionals desiring to add coding skills to their portfolio. Educators keen to integrate Python into their teaching methodologies. Businesspersons interested in understanding coding fundamentals for tech-based solutions. Enthusiasts exploring programming as a new hobby or career path. Career path Entry-Level Python Programmer: £25,000 - £40,000 Python-Enabled Data Analyst: £28,000 - £45,000 Python Automation Engineer: £30,000 - £50,000 Technical Support Analyst with Python Skills: £22,000 - £35,000 Python Web Developer: £26,000 - £42,000 Quality Assurance Analyst with Python Expertise: £24,000 - £38,000 Prerequisites This Python Programming for Non Programmers Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming for Non Programmers Level 5 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Unit 01: Introduction to Python Programming Section 01: Course Introduction 00:02:00 Unit 02: Getting Started with Python Section 01: Software Installation 00:02:00 Section 02: Hello World Program 00:06:00 Section 03: Input and Output 00:07:00 Section 04: Calculating Average of 5 Numbers 00:03:00 Unit 03: Conditional Branching with Python Section 01: If Loop In Python 00:06:00 Section 02: Program Using If Else part 1 00:03:00 Section 03: Program Using If Else part 2 00:08:00 Section 04: Program for Calculator 00:02:00 Section 05: Program Using For Loop 00:08:00 Section 06: For Table 00:05:00 Section 07: For loop and Mathematical Operator in Python 00:04:00 Section 08: Factorial of Number Using Python 00:06:00 Section 09: Program Using While 00:05:00 Section 10: While Loop Example 00:07:00 Section 11: Tasks for Practice 00:02:00 Unit 04: Importing external/internal library in python Section 01: Importing Library in Python 00:07:00 Unit 05: Project Rock Paper and Scissors Section 01: Rock Paper and Scissor Game 00:06:00 Unit 06: Strings Operation in Python Section 01: Program Using String part 1 00:05:00 Section 02: Program using String 2 00:06:00 Section 03: Program Using String 3 00:06:00 Section 04: Program Using String part 4 00:03:00 Unit 07: Date and time in Python Section 01: Use of Date and Time part 1 00:05:00 Section 02: Use of Date and Time part 2 00:05:00 Unit 08: File Handling, read and write using Python Section 01: File Handling Part 1 00:08:00 Section 02: File Handling Part 2 00:07:00 Unit 09: Data Storage Structures, Tuple, List and Dictionary Section 01: Tuple in Python Part 1 00:10:00 Section 02: Tuple in Python Part 2 00:07:00 Section 03: Using Lists part 1 00:07:00 Section 04: Using List part 2 00:12:00 Section 05: Using Lists part 3 00:06:00 Section 06: Using Lists part 4 00:08:00 Section 07: Using Lists part 5 00:02:00 Section 08: Use of Dictionary Part 1 00:04:00 Section 09: Use of Dictionary Part 2 00:05:00 Section 10: Use of Dictionary Part 3 00:08:00 Section 11: Use of Dictionary Part 4 00:07:00 Unit 10: Writing user functions in Python Section 01: Function in Python Part 1 00:06:00 Section 02: Function in Python Part 2 00:05:00 Section 03: Function in Python Part 3 00:04:00 Section 04: Function in Python Part 4 00:07:00 Section 05: Function in Python Part 5 00:08:00 Unit 11: Sending mail Section 01: Send Email 00:09:00 Unit 12: Import Tricks in Python Section 01: Import Study part 1 00:07:00 Section 02: Import Study part 2 00:03:00 Unit 13: Import Operating System and Platform Section 01: Importing OS 00:06:00 Section 02: Import Platform 00:05:00 Unit 14: Exceptions handling in python Section 01: Exception in Python part 1 00:11:00 Section 02: Exception in Python part 2 00:07:00 Section 03: Exception in Python part 3 00:05:00 Unit 15: Installing Packages and Scheduling In Python Section 01: Installing Packages using built in package manager 00:08:00 Section 02: Scheduler in Python 00:05:00 Unit 16: Data Base In Python using sqlite Section 01: Data Base 1 00:08:00 Section 02: Data Base 2 00:09:00 Section 03: Data Base 3 00:08:00 Section 04: Data base 4 00:07:00 Section 05: Data Base 5 00:06:00 Unit 17: Running Program from Command Prompt and jupyter Notebook Section 01: IDE_1 00:05:00 Section 02: IDE_2 00:07:00 Unit 18: Conclusion Section 01: Conclusion 00:02:00 Resources Resources - Diploma in Python Programming 00:00:00 Assignment Assignment - Diploma in Python Programming 00:00:00 Recommended Materials Workbook - Diploma in Python Programming 00:00:00

Python Programming for Non Programmers Level 5
Delivered Online On Demand5 hours 58 minutes
£10.99

Learn How to Build a Computer Course from Scratch

4.5(3)

By Studyhub UK

Embarking on the journey of constructing a personal computer can be a transformative experience, blending the art of technology with practical ingenuity. 'Learn How to Build a Computer Course from Scratch' is your gateway to mastering this skill. This course isn't just about assembling parts; it's a holistic approach to understanding the intricacies of computer hardware and software.  Whether you're intrigued by the mechanics of PCs or aspiring to create an elite gaming system, this programme offers a comprehensive curriculum that guides you through each step of the process. From identifying the core components in Module 01 to the specialized focus on gaming systems in Module 07, every session is crafted to enhance your knowledge and confidence in building a computer. Learning Outcomes: Acquire the foundational knowledge of computer assembly, including selecting and handling various hardware components. Develop the ability to construct a high-performance gaming computer, incorporating advanced hardware suitable for demanding games. Gain proficiency in software installation and configuration, ensuring optimal performance and compatibility. Understand computer networking principles, enabling you to integrate your PC into various network environments effectively. Learn essential maintenance techniques to ensure the long-term reliability and performance of your custom-built computer. Why buy this Learn How to Build a Computer Course from Scratch? 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 Learn How to Build a Computer Course from Scratch 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 Learn How to Build a Computer Course from Scratch for? Enthusiasts seeking to create their custom PC from scratch. Gamers looking to construct a high-performance gaming system. Individuals interested in learning about computer hardware and software. Hobbyists wanting to upgrade their technical skills in PC assembly. Career seekers aiming to develop skills in computer hardware maintenance and repair. Prerequisites This Learn How to Build a Computer Course from Scratch does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn How to Build a Computer Course from Scratch 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 Computer Technician: £20,000 - £30,000 Per Annum Network Administrator: £25,000 - £40,000 Per Annum System Administrator: £30,000 - £50,000 Per Annum IT Support Specialist: £22,000 - £35,000 Per Annum Hardware Engineer: £28,000 - £50,000 Per Annum Gaming PC Builder: £18,000 - £35,000 Per Annum Course Curriculum Module 01: Introduction to Computer & Building PC Introduction to Computer & Building PC 00:17:00 Module 02: Overview of Hardware and Parts Overview of Hardware and Parts 00:27:00 Module 03: Building the Computer Building the Computer 00:25:00 Module 04: Input and Output Devices Input and Output Devices 00:22:00 Module 05: Software Installation Software Installation 00:35:00 Module 06: Computer Networking Computer Networking 00:21:00 Module 07: Building a Gaming PC Building a Gaming PC 00:19:00 Module 08: Maintenance of Computers Maintenance of Computers 00:20:00 Assignment Assignment - Learn How to Build a Computer Course from Scratch 00:00:00

Learn How to Build a Computer Course from Scratch
Delivered Online On Demand3 hours 6 minutes
£10.99

Complete Python Scripting for Automation

By Packt

Get up to speed with automating repetitive tasks with Python

Complete Python Scripting for Automation
Delivered Online On Demand24 hours 39 minutes
£13.99

Medical Secretary and Office Skills

4.7(160)

By Janets

Register on the Medical Secretary and Office Skills today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Medical Secretary and Office Skills course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Medical Secretary and Office Skills course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Assessment To successfully complete the Medical Secretary and Office Skills course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for a CPD-accredited certificate as proof of your subject-knowledge. 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. Who is this course for? The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Medical Secretary and Office Skills course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Medical Secretary and Office Skills Module 01- Introduction to Medical Secretary 00:17:00 Module 02- Organise Schedules 00:22:00 Module 03- Maintaining Medical Records 00:20:00 Module 04- Effective Filing Systems in Medical Offices 00:17:00 Module 05- Confidentiality in a Medical Environment 00:15:00 Module 06- Controlling Stocks and Supplies 00:10:00 Module 07- Medical Jargon and Terminology 00:26:00 Module 08- Communication Skills 00:27:00 Module 09- Legal aspects and Ethics 00:20:00 Mock Exam Mock Exam - Medical Secretary and Office Skills 00:20:00 Final Exam Final Exam - Medical Secretary and Office Skills 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Medical Secretary and Office Skills
Delivered Online On Demand3 hours 34 minutes
£25

Minute Taking Diploma for PA & Office Secretary

4.7(160)

By Janets

The Minute Taking Diploma for PA & Office Secretary is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Minute Taking Diploma for PA & Office Secretary consists of several modules that take around 1 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. 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 Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Minute Taking Diploma for PA & Office Secretary Module 01: Introduction and Background of Minute Taking 00:10:00 Module 02: Sections of Meeting 00:10:00 Module 03: Agenda 00:10:00 Module 04: Roles and Responsibility of Minute Takers 00:10:00 Module 05: Note Taking Methods and Skill Development 00:10:00 Module 06: Main Parts of Meeting Minutes, Recording Decisions and Actions 00:10:00 Module 07: The Freedom of Information Act 00:05:00 Module 08: Making Minute Interesting and Building Confidence 00:05:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Minute Taking Diploma for PA & Office Secretary
Delivered Online On Demand1 hour 10 minutes
£25

Minute Taking for PA and Admin Assistants

4.7(160)

By Janets

Register on the Minute Taking for PA and Admin Assistants today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Minute Taking for PA and Admin Assistants is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Minute Taking for PA and Admin Assistants Receive an e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Minute Taking for PA and Admin Assistants, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Minute Taking for PA and Admin Assistants Module 01: Introduction to Minute Writing 00:06:00 Module 02: Preparation for Minute Taking 00:05:00 Module 03: The Meeting Structure 00:04:00 Module 04: Minute Meetings, Decisions and Actions 00:03:00 Module 05: Minute Taking Techniques 00:04:00 Module 06: Building Confidence 00:05:00 Additional Reading Materials Additional Reading Materials - Minute Taking For PA And Admin Assistants 02:00:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Minute Taking for PA and Admin Assistants
Delivered Online On Demand2 hours 27 minutes
£25

Microsoft Excel Advanced

By Microsoft Office Training

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 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 classrom, one to one, tailored and bespoke courses. Tailored In Company training: 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

Microsoft Excel Advanced
Delivered OnlineFlexible Dates
£550

Level 3 Certificate in Transcription

By Compliance Central

Transcription skills are essential in various industries like legal, medical, and media. In the UK, a transcriptionist can earn between £18K to £35K annually. Do you ever wished you could create flawlessly composed writing out of spoken words? Of hearing voices vibrate on paper, of deciphering hidden messages? Turn your love of language into a rewarding career with the Level 3 Certificate in Transcription. Dive into the intricacies of Transcription and master its nuances across various contexts. From honing your comprehension skills to perfecting transcription accuracy, our comprehensive course equips you with essential techniques and strategies. Explore common homophones, unravel the mysteries of transcription formatting, and learn the art of speaker labelling. Delve into the realm of spelling intricacies and elevate your expertise with advanced modules. Discover invaluable tools and uncover lucrative transcription opportunities, paving your path towards a rewarding career in transcription. Ready to turn your passion for language into a lucrative career? Enrol now and unlock the world of transcription with our Level 3 Certificate course! Learning Outcomes: Acquire comprehensive understanding of transcription techniques. Enhance transcription comprehension skills. Master transcription accuracy and precision. Develop proficiency in formatting and spelling. Gain insight into advanced transcription tools and opportunities. Prepare for diverse roles in transcription-related fields. Level 3 Certificate in Transcription Module 01: Introduction. Module 02: Transcription Comprehension Module 03: A Comprehension Example Module 04: Transcription Accuracy Module 05: Accuracy Examples Module 06: Common Homophones Module 07: Transcription Formatting Module 08: Speaker Labeling Module 09: Spelling Module 10: Advanced Module Module 11: Useful Transcription Tools Module 12: Where & How to Find Transcription Opportunities Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for Free to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Who is this course for? Level 3 Certificate in Transcription Who is this course for: Transcriptionist Audio Typist Language Transcriber Text Editor Data Entry Specialist Proofreading Specialist Closed Captioning Specialist Requirements Level 3 Certificate in Transcription To enrol in this Level 3 Certificate in Transcription course, all you need is a basic understanding of the English Language and an internet connection. Career path Level 3 Certificate in Transcription Career Path: Transcriptionist Medical Transcriptionist Legal Transcriptionist Captioner/Subtitle Podcast Transcription Specialist Court Transcriptionist Certificates CPD Accredited PDF Certificate Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Level 3 Certificate in Transcription
Delivered Online On Demand2 hours
£100

Computer Maintenance Diploma (Online) - CPD Certified

4.7(26)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Computer Maintenance Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Do you ever feel frustrated by your computer running slow, crashing unexpectedly or showing error messages? According to a recent study by YouGov, nearly 70% of UK adults have experienced a computer problem they couldn't fix themselves. This comprehensive Computer Maintenance Bundle equips you with the skills to not only troubleshoot these everyday issues but potentially pursue a career in IT support. Are you ready to take control of your technology and maybe even help others with theirs? This extensive bundle offers a one-stop shop for everything computer maintenance related. Whether you're a complete beginner or an experienced IT professional, you'll find a course to suit your needs. Learn how to build your own PC, troubleshoot Windows 10 issues, and become a certified computer maintenance specialist. Power up your knowledge of electrical systems and network security. The bundle even covers essential soft skills like communication and critical thinking, making you a well-rounded IT professional. Courses are Included in This Computer Maintenance Bundle: Course 01: Building Your Own Computer Course 02: Electronic & Electrical Devices Maintenance Course 03: PAT Level 4 Course 04: Complete Windows 10 Troubleshooting for IT Helpdesk Course 05: Computer Maintenance Specialist Training Course 06: Certificate in Computer Operating System and Troubleshooting Course 07: Display Screen Equipment (DSE) Course 08: Basic Electricity Course Course 09: Computer Hacking Forensic Investigator Course 10: IT Support Technician Course 11: Internet and Computing - Tools & Networking Guide Course 12: Information Technology and Networking Course 13: Cyber Security Awareness Training Course 14: Cyber Security Incident Handling and Incident Response Course 15: IT Administration and Networking Course 16: CompTIA Network+ Certification Course 17: CompTIA Security+ Certification Course 18: Cisco ASA Firewall Training Course 19: Digital Risk Protection Training Course 20: Data Protection Assistant Course 21: Data Center Training Essentials: Power & Electrical Course 22: Workplace Confidentiality Course 23: Information Management Course 24: Effective Communication Skills Course 25: Network Security Level 2 Course 26: Encryption Course 27: Decision Making and Critical Thinking Course 28: Internet of Things Course 29: Functional Skills IT Course 30: Web Application Penetration Testing Course Take control of your technology and open doors to exciting new career opportunities. This computer maintenance bundle equips you with the knowledge and skills to diagnose, solve, and prevent computer problems. Enrol today and take the first step towards a successful IT career! Learning Outcomes of Computer Maintenance Gain proficiency in building, maintaining, and troubleshooting computer systems. Master essential IT support skills for resolving common Windows 10 issues. Prepare for industry-recognized certifications like CompTIA Network+ and Security+. Develop a strong understanding of network security principles and data protection practices. Enhance your communication and decision-making skills for a successful IT career. Explore emerging technologies like the Internet of Things (IoT) and web application security. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Computer Maintenance Get a free student ID card with Computer Maintenance Training program (£10 postal charge will be applicable for international delivery) The Computer Maintenance is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Computer Maintenance course materials The Computer Maintenance comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Building Your Own Computer Module 01: Introduction To Computer & Building PC Module 02: Overview Of Hardware And Parts Module 03: Building The Computer Module 04: Input And Output Devices Module 05: Software Installation Module 06: Computer Networking Module 07: Building A Gaming PC Module 08: Maintenance Of Computers Course 02: Electronic & Electrical Devices Maintenance Section 1: Introduction & Getting Started Section 2: Electronic And Electrical Maintenance Repair Section 3: Tools Needed Section 4: Electronic Components Section 5: Testing Section 6: Troubleshooting Section 7: Introduction To Electronic Components: A Step By Step Guide Course 03: PAT Level 4 Module 01: Introduction To PAT Module 02: Relevant Statutory Provisions For PAT Module 03: Safety Responsibilities & Maintenance Provisions Module 04: Risk Assessment Module 05: Reducing And Controlling Risks Module 06: Electrical Units And Appliance Classification Module 07: Equipment Coverage & Maintenance Needs Module 08: Initial Visual Examination Module 09: Instruments For Testing And Equipment Inspection Module 10: Electrical Installation Testing Module 11: Lead & RCD Testing Module 12: Safety Precautions In Electrical Testing Module 13: Reporting And Record-Keeping Module 14: Testing For New Or Used Equipment Module 15: British Standards And Latest Changes =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £389) CPD Hard Copy Certificate: Free ( For The First Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: DIY Tech Enthusiasts IT Support Aspirants Cybersecurity Professionals Network Administrators Data Protection Specialists Career Changers Career Path Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. IT Technician Helpdesk Analyst Network Engineer Security Analyst Data Center Specialist IT Consultant Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Computer Maintenance Diploma (Online) - CPD Certified
Delivered Online On Demand5 days
£209

Administrative Secretary and Personal Assistant Diploma

By SkillWise

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Administrative Secretary and Personal Assistant Diploma Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Administrative Secretary and Personal Assistant Diploma Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Administrative Secretary and Personal Assistant Diploma Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Administrative Secretary and Personal Assistant Diploma Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Administrative Secretary and Personal Assistant Diploma ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 Administrative Secretary and Personal Assistant Diploma 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Administrative Secretary and Personal Assistant Diploma course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Administrative Secretary and Personal Assistant Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Administrative Secretary and Personal Assistant Diploma was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Administrative Secretary and Personal Assistant Diploma is a great way for you to gain multiple skills from the comfort of your home. Executive and Personal Assistant Training Course Module One - Getting Started 00:30:00 Module Two - Working with Your Manager 01:00:00 Module Three - Administrative Soft Skills 01:00:00 Module Four - Effective Time Management 01:00:00 Module Five - Meeting Management 01:00:00 Module Six - Tools of the Trade (I) 01:00:00 Module Seven - Tools of the Trade (II) 01:00:00 Module Eight - Being an Effective Gatekeeper 01:00:00 Module Nine - Organizational Skills 01:00:00 Module Ten - Confidentiality Guidelines 01:00:00 Module Eleven - Special Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Executive and Personal Assistant Training Course- Activities Recommended Reading Recommended Reading: Administrative Secretary and Personal Assistant Diploma Mock Exam Final Exam

Administrative Secretary and Personal Assistant Diploma
Delivered Online On Demand
£29