3441 Office Skills & Productivity courses in Castleford delivered Online

Get started with WordPress hassle-free! Our beginner-friendly guide covers everything you need to know about creating, managing, and customizing your WordPress website. Learn the basics, master essential tools, and launch your online presence confidently with expert tips and step-by-step tutorials.

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00

Most medical and clinical administrators' work is done behind the scenes. Nonetheless, their significance in the healthcare industry cannot be overstated. They are in charge of the strings that keep the system running smoothly. With this Diploma in Medical & Clinical Administration, you can start a promising career in this in-demand industry. This Diploma in Medical & Clinical Administration course is designed by industry experts to provide you with a thorough understanding of the subject. The course covers the fundamentals of Medical and Clinical Administration, Organise Schedules, Effective Filing Systems in Medical Offices, Maintaining Medical Records, Confidentiality in a Medical Environment, Medical Jargon and Terminology, Medical (Clinical) Coding and Billing and much more. Whether you are an aspirant looking to begin your dream career, a professional looking to increase your knowledge, or someone in between, this Diploma in Medical & Clinical Administration course has you covered. This course's rudimentary knowledge will add tremendous value and allow you to establish the meaningful Medical & Clinical Administration career you have always wanted. Learning Outcomes After completing this Diploma in Medical & Clinical Administration Bundle course, the learner will be able to: Understand the basics of Medical and Clinical Administration. Know how to organise schedules. Know how to maintain medical records. Gain in-depth knowledge about the filing systems in medical offices. Understand the concept of patient confidentiality. Know how to control stocks and supplies. Gain a solid understanding of medical jargon and terminology. Know how to maintain workplace safety. Understand medical (clinical) coding and billing. Why Choose Diploma in Medical & Clinical Administration Bundle Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. **Courses are included in this Diploma in Medical & Clinical Administration Course Course 01: Level 5 Diploma in Medical & Clinical Administration Course 02: Clinical Psychology Diploma Course 03: Level 2 Certificate in Understanding Safeguarding and Prevent **Other Benefits of Level 5 Diploma in Medical & Clinical Administration Course Free 3 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Diploma in Medical & Clinical Administration course] Course Curriculum of- *** Diploma in Medical & Clinical Administration *** Module 01: An Overview of Medical and Clinical Administration Module 02: Ways of Organising Schedules Module 03: How to Maintain Medical Records Module 04: Understanding the Filing Systems in Medical Offices Module 05: Maintaining Confidentiality in a Medical Environment Module 06: The Ways of Controlling Stocks and Supplies Module 07: Medical Jargon and Terminology Module 08: Ensuring Safety at Workplace Module 09: The Use of Information Technology in Health Care Module 10: Medical (Clinical) Coding and Billing -------------- Assessment Method After completing each module of the Diploma in Medical & Clinical Administration Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Diploma in Medical & Clinical Administration course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Diploma in Medical & Clinical Administration course is designed for people who want to gain an accredited qualification that will allow them to start or advance their careers in Medical Reception and Medical Administration roles. Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Career path This qualification Diploma in Medical & Clinical Administration course will allow you to pursue a variety of careers, including: Healthcare Administrator GP Receptionist Patient Coordinator Medical Assistant Medical Receptionist Certificates Certificate of completion Digital certificate - Included

Level 5 Diploma in Medical & Clinical Administration Most medical and clinical administrators' work is done behind the scenes. Nonetheless, their significance in the healthcare industry cannot be overstated. They are in charge of the strings that keep the system running smoothly. With this Level 5 Diploma in Medical & Clinical Administration, you can start a promising career in this in-demand industry. This Level 5 Diploma in Medical & Clinical Administration course is designed by industry experts to provide you with a thorough understanding of the subject. The Level 5 Diploma in Medical & Clinical Administration course covers the fundamentals of Medical and Clinical Administration, Organize Schedules, Effective Filing Systems in Medical Offices, Maintaining Medical Records, Confidentiality in a Medical Environment, Medical Jargon and Terminology, Medical (Clinical) Coding and Billing and much more. This Level 5 Diploma in Medical & Clinical Administration course's rudimentary knowledge will add tremendous value and allow you to establish the meaningful Medical & Clinical Administration career you have always wanted. Course Included Level 5 Diploma in Medical & Clinical Administration Course 01: Nursing Assistant Diploma Course 02: Healthcare Management Training Other Benefits of Level 5 Diploma in Medical & Clinical Administration Free 3 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate will provide as soon as completing the Level 5 Diploma in Medical & Clinical Administration course] Level 5 Diploma in Medical & Clinical Administration This Level 5 Diploma in Medical & Clinical Administration course consists of 10 modules. Assessment Method After completing each module of the Level 5 Diploma in Medical & Clinical Administration Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Level 5 Diploma in Medical & Clinical Administration course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Level 5 Diploma in Medical & Clinical Administration This Level 5 Diploma in Medical & Clinical Administration course is designed for people who want to gain an accredited qualification that will allow them to start or advance their careers in Medical Reception and Medical Administration roles. Requirements Level 5 Diploma in Medical & Clinical Administration Students who intend to enrol in this Level 5 Diploma in Medical & Clinical Administration course must meet the following requirements: Medical & Clinical Administration: Good command of the English language Medical & Clinical Administration: Must be vivacious and self-driven Medical & Clinical Administration: Basic computer knowledge Medical & Clinical Administration: A minimum of 16 years of age is required. Career path Level 5 Diploma in Medical & Clinical Administration Certificates Certificate of completion Digital certificate - Included

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010, 2013, or 2016 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Delve. Collaborate and work with colleagues using the Yammer and Planner apps. Use email and manage contacts with Outlook on the web. Collaborate using Teams. Configure Teams. This course introduces working with shared documents in the familiar Office 365 online apps?Word, PowerPoint©, and Excel©?as an alternative to installing the Microsoft© Office desktop applications. This course also introduces several productivity apps including Yammer?, Planner, and Delve© that can be used in combination by teams for communication and collaboration. Getting Started with Office 365 Topic A: Sign In to Office 365 Topic B: Navigate the Office 365 Environment Collaborating with Shared Files Topic A: Work with Shared Documents in SharePoint Topic B: Edit Documents in Office Online Topic C: Collaborate on the SharePoint Site Topic D: Work with OneDrive for Business Topic E: Find Shared Resources Using Productivity Apps Topic A: Work with Productivity Apps in Combination Topic B: Broadcast Messages with Yammer Using Outlook on the Web Topic A: Send and Receive Email Topic B: Manage Contacts Topic C: Schedule Appointments Topic D: Personalize Outlook on the Web Collaborating with Teams Topic A: Overview of Microsoft Teams Topic B: Converse and Share in Teams Topic C: Call and Meet in Teams Topic D: Collaborate with Microsoft 365 Apps and Teams Configuring Teams Topic A: Configure Teams Topic B: Configure Channels Topic C: Configure Tabs Additional course details: Nexus Humans Microsoft 365 Office for the Web (with Teams) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft 365 Office for the Web (with Teams) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for The course is targeted at professionals who have never worked with Microsoft 365 before, or who have yet to move beyond its basic functions. The target audience typically includes individuals, professionals, and organizations who are looking to improve their productivity, collaboration, and communication using the suite of applications and services provided by Microsoft 365. This could include office workers, project managers, IT professionals, and small to large-scale businesses who want to maximize the benefits of cloud-based solutions for their daily operations.  Overview Upon successfully completing this course, students will have confidence in using the Microsoft 365 applications. Students will increase their work productivity and decrease time on completing tasks. In this course, students will learn how to use different tools of Microsoft 365 for better online collaboration, including OneDrive, SharePoint, Teams, Excel, Outlook, Word, and PowerPoint. First Steps in Office 365 The Difference Between Office 365 and Microsoft 365 Pros and cons of Microsoft 365 First Steps on mobile devices OneDrive Introduction - What is Microsoft OneDrive? How To Access Microsoft OneDrive? Upload Files Share Files Sync Files Recycle Bin Using OneDrive How To Access Onedrive On Phone? Teams - Simplify Collaboration within Companies Discover new ways to collaborate and communicate An introduction to your central place in Office 365 How to launch and install Teams The Interface of Microsoft Teams Use the Teams window to structure your organization Use Channels to structure the Teams window Use Tabs to access tools and information Communicate with others via Chat Keep track of activities Meetings, video conferencing and screen sharing Share files effectively Manage teams and permissions for organizational structuring Use Teams effectively on mobile devices Final remarks SharePoint Sites Introduction First Steps Document Library - First Steps Document Library - Set and Manage Alerts Document Library - Understanding Versioning Sync Libraries Share a Site Picture Library Lists Calendar Tasks Discussion Board Outlook First Steps in Mail Improved Search Function Work with Folders Settings Working with the Mail App Calendar People Tasks Excel Online Introduction Open and Edit an Excel Online Workbook Limitations of Excel Online Create a New Workbook with Excel Online Edit a Workbook Simultaneously with another Person Working with the Excel AppUse Excel effectively on mobile devices PowerPoint Online Introduction Open a PowerPoint Online Presentation Edit a Presentation Online Limitations of PowerPoint Online Create a Presentation with PowerPoint Online Working with the PowerPoint App Use Power Point effectively on mobile devices Word Online Introduction Open and Edit a Word Document Online Limitations of Word Online Create a New Document Edit a Document Simultaneously Working with the Word App

Duration 4 Days 24 CPD hours This course is intended for This course is the first in a series of two courses designed for programmers who are new to RPG IV. Basic programming experience is required. The student should have attended at least an introductory course to programming such as one of those available at technical colleges. The student is not taught the concepts of programming. Experienced programmers who are new to the Power System with IBM i should also attend this course. Examples of other programming languages are BASIC, COBOL, or RPG II. This course focuses entirely on the features of the RPG IV Version 7 compiler and the techniques that this compiler provides. Features of V7 are discussed. Previous techniques and the maintenance of programs that are written using legacy techniques, such as fixed format calculations, are not covered in the classroom. Some additional material and the bibliography will assist the new RPG IV programmer in the maintenance of legacy applications. Overview Write RPG IV version 7.1 programs to produce reportsWrite simple RPG IV version 7.1 inquiry programs that interact with displaysReview compilation listing, find and correct compilation errorsMaintain existing applications written in the RPG IV Version 7.1 languageUse many popular RPG IV built-in functions This course is a comprehensive exposure to the basic features and functions of RPG IV for Version 7. Course Outline RPG IV introduction Coding specifications for RPG IV Data representation and definition Manipulating data in calculations Using printer and display files in an RPG IV program Structured programming, error handling, subprocedures, and subroutines Using arrays, data structures, and data areas Accessing the DB2 database using RPG IV What's next? Additional course details: Nexus Humans AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Overview This comprehensive course on Document Control and EDMS Implementation Step will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Document Control and EDMS Implementation Step comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Document Control and EDMS Implementation Step. It is available to all students, of all academic backgrounds. Requirements Our Document Control and EDMS Implementation Step 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 • 7 lectures • 00:56:00 total length •Module 01: Introduction: 00:05:00 •Module 02: Role and Important of Document Controller: 00:13:00 •Module 03: Document and Record management: 00:06:00 •Module 04: Document Management Best Practices: 00:04:00 •Module 05: Record Management Best Practices: 00:04:00 •Module 06: Introduction to EDMS (Enterprise Document Management System): 00:24:00 •Assignment - Document Control and EDMS Implementation Step: 3 days

The comprehensive Advanced AutoLISP Programming has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Advanced AutoLISP Programming today, and learn from the very best the industry has to offer! This best selling Advanced AutoLISP Programming has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced AutoLISP Programming is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced AutoLISP Programming is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Advanced AutoLISP Programming is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Advanced AutoLISP Programming , you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced AutoLISP Programming will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Advanced AutoLISP Programming to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Microsoft Excel course might help you get there! Expand your expertise with high-quality training - study the Microsoft Excel course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Microsoft Excel online training course. The Microsoft Excel course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Microsoft Excel course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Microsoft Excel training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover in the Course: >> Microsoft Excel - Beginner, Intermediate & Advanced << Unit 01: Excel from A-Z Course Introduction Unit 02: Getting Started With Excel Unit 03: Values, Referencing and Formulas Unit 04: Intro to Excel Functions Unit 05: Adjusting Excel Worksheets Unit 06: Visually Pleasing Cell Formatting Unit 07: How to Insert Images and Shapes! Unit 08: Visualize Data with Charts Unit 09: Excel's Printing Options Unit 10: Benefits of Using Excel Templates Unit 11: Working with Excel Datasets Unit 12: Excel Database Functions Unit 13: Excel Data Validation Unit 14: Excel PivotTables Unit 15: Excel's PowerPivot Add-In Unit 16: Excel's Conditional Functions Unit 17: Excel's Lookup Function Unit 18: Text Based Functions in Excel Unit 19: Auditing Formulas and Views in Excel Unit 20: Excel's 'what If?' Tools Unit 21: Welcome to Excel VBA Unit 22: The VBA Language Unit 23: Writing VBA Code Unit 24: Important VBA Tools and Logic Unit 25: Excel VBA Lopps Unit 26: Triggering Macros Unit 27: Excel User Forms Unit 28: Starting a Career in Excel Tutor Support Once you enrol in our Microsoft Excel Course with the Academy for Health & Fitness, you are allocated your tutor. The tutor's guidance and assistance will be available throughout your studies with the college. He/ she will evaluate your work and will provide you with regular feedback on your progress. CPD 15 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 Microsoft Excel course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.