3800 Office Skills courses

This course is perfect for the beginner but also delves into building a SAS Model and intermediate topics. Learn SAS Data Step, SQL Step, Macros, SAS Model Building, Predictive Analytics, SAS and ML. If you are using SAS Enterprise Guide and want to learn how to code/program instead of using the point-and-click interface, this course is ideal!

A medical secretary is responsible for ensuring that a doctor's office runs smoothly so that patients receive the best possible care. A medical secretary must understand office organisation and standard procedures to provide this secretarial support. They should also be able to use medical terminologies fluently. This Office Admin and Reception Skills will teach you about the medical secretarial profession and the skills needed to do the job successfully. This coursewill teach you about the roles and responsibilities of a medical secretary. You will also learn various medical secretary skills, including an effective filing system, medical transcription, medical writing, maintaining medical records, an appointment system, and more. Furthermore, this comprehensive Office Admin and Reception Skills will teach you the critical concepts of patient confidentiality and other legal aspects of the healthcare industry. Learning Outcomes After completing this course, learner will be able to: Understand the fundamentals of the National Health Service. Understand the roles and responsibilities of a medical secretary. Know how to organise schedules and manage appointment systems. Gain a clear understanding of the Law, Ethics and Medicine. Gain a thorough understanding of the effective filing system in medical offices. Familiarise yourself with the concept of patient confidentiality and its dos and don'ts. Become skilled at controlling and ordering stocks and supplies. Gain in-depth knowledge of Medical Terminology and Clinical Aspects. Know the importance of health and safety in the healthcare sector. Have a solid understanding of Complementary Medicine Why Choose Diploma in Medical Receptionist and Secretary from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Receptionist : Office Admin and Reception Skills 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 Receptionist : Office Admin and Reception Skills Course. **Courses are included in this Receptionist : Office Admin and Reception Skills Bundle Course Course 01: Receptionist : Office Admin and Reception Skills Course 02: Communication Skills Course Course 03: Level 4 Time Management Course Course 04: Level 5 Negotiation Skills Course Course 05: Level 5 Report Writing Course Course 06: Level 4 Copy Writing Course Course 07: Level 2 Customer Service Course 08: Level 1 Certificate in Well-being Course 09: Mental Health Support Worker Course 10: Level 3 Diploma in Healthcare Support ***Others Included of Receptionist : Office Admin and Reception Skills Bundle Course Free 10 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Detailed course curriculum of the Office Admin and Reception Skills: Module 1: The National Health Service History Structure of the NHS The NHS Plan Resource Allocation Delivering Care Mental Health Services Public Health The NHS, the Regions and Devolution Module 2: Patient (Customer) Care The Medical Receptionist Putting Patient First Complaints Within the Health Service The Complaints Procedure Patient and Public Involvement Patient's Rights Access to Health Care Total Quality in Medical Practice Customer Care: Involving Patients and the Public Module 3: Communication Report Writing Electronic Mail & Mobile Phones: Text Messages Telephone Skills People Skills - Face to Face Meeting Performance Review & Counselling The Practice Leaflet & Hospital Information Leaflets Networking Module 4: Law, Ethics and Medicine Medical Ethics and Etiquette Doctor's Duties Patient's Right The Regulatory Bodies and Their Role Legal Aspects Certification Health and Safety at Work Module 5: Health & Safety in a Clinical Environment First Aid at Work Hazardous Substances The NHS National Patient Safety Agency (NPSA) Hepatitis & AIDS Fire Precautions Clinical Risk Management Coping With Aggression & Violence Module 6: Practical Reception Skills in General Practice Record Keeping and General Administration Information Technology Module 7: The Hospital Service The Patient's Route Through the Hospital Outpatient Appointments Admissions from the Waiting List Accident and Emergency Admissions Home From Hospital Support Day Cases and Ward Attendees Hospital Team Clinical Audit Star Ratings What is a Medical Record? Cases Notes Master Index Filing Room or Records Library Medical Records Procedure for Departments Retention of Records Destruction of Medical Records The Role of the Secretary in the Hospital Module 8: Private Medicine Private Clinic or Hospital The Secretary In Private Practice Module 9: Forms, Fees and Finances in General Practises Contracting Finance Practice Income Scotland Wales Northern Ireland Module 10: Using Information Technology Computers in General Practice Electronic Medicine Computers in Hospitals Maintaining Security Module 11: Medical Terminology and Clinical Aspects Pathology and X-ray Examinations Prescribing and Drugs Nurse Prescribing New Developments in Pharmacy Module 12: Audit, Health Economics and Ensuring Quality for the Medical Receptionist and Secretary Audit Health Economics and Cost-effective Medicine Private Finance Initiative Clinical Governance National Institute for Clinical Excellence (NICE) National Clinical Assessment Service (NCAS) National Service Framework (NSF) Patient Surveys Module 13: Complementary Medicine Acupuncture Alexander Technique Aromatherapy Chiropractic Homoeopathy Hydrotherapy Hypnotherapy Osteopathy Reflexology ------------------- ***Communication Skills Course*** Module 01: Introduction to Communication Module 02: The Communication Skills Module 03: Different Types of Communication Module 04: Different Methods of Communication Module 05: Styles of Communication Module 06: Barriers to Communication Module 07: Assessing Communication Competence: Relevant Criteria Module 08: Seven Actions for Effective Communication Module 09: Do's and Don'ts of Effective Communication ------------------- ***Level 4 Time Management Course*** Module 1: Basics of Time Management Module 2: Prioritise Your Time Module 3: Organise Your Time Module 4: Using Your Time Efficiently Module 5: Time Management in the Workplace Module 6: Time Management For Students Module 7: Time Management Software Module 8: Create a Value-Based Time Management Plan ------------------- ***Level 5 Proofreading & Copy Editing*** Module 01: An Overview of Proofreading Module 02: Use of the Style Guide Module 03: Spelling and Grammar Module 04: Paper-based Proofreading Module 05: On the Screen Proofreading Module 06: Basics of Copy Editing Module 07: Copy Editing - the Use of Language Module 08: Copy Editing - Checking Accuracy and Facts Module 09: Copy Editing - Legal Checks Module 10: Career Development ------------------- ***Level 5 Negotiation Skills Course*** Module 01: An Overview of Negotiation Module 02: How to Prepare For Negotiations Module 03: The Process of Negotiation Module 04: Ways of Developing Persuasion & Influencing Skills Module 05: Ways of Developing Communication Skills Module 06: How to Develop Active Listening Skills Module 07: Comprehending Body Language Module 08: Assertiveness and Self Confidence Module 09: Managing Anger Module 10: Managing Stress Module 11: Negotiation Tactics to Closing a Better Deal Module 12: Ways of Overcoming Sales Objections ------------------- ***Level 5 Report Writing Course*** Module 01: Introduction to Report Writing Module 02: The Basics of Business Report Writing Module 03: The Practical Side of Report Writing (Part-1): Preparation & Planning Module 04: The Practical Side of Report Writing (Part-2): Collecting and Handling Information Module 05: The Practical Side of Report Writing (Part-3): Writing and Revising Report Module 06: The Creative Side of Report Writing (Part -1): A Style Guide to Good Report Writing Module 07: The Creative Side of Report Writing (Part -2): Improving the Presentation of Your Report Module 08: Developing Research Skills Module 09: Developing Creativity & Innovation Module 10: Develop Critical Thinking Skills Module 11: Interpersonal Skill Development ------------------- ***Level 2 Customer Service*** Module 1: Introduction to Customer Service Module 2: Understanding the Organisation Module 3: Prepare to Deliver Excellent Customer Service Module 4: Communication in the Customer Service Role Module 5: Understand Customers ------------------- ***Level 1 Certificate in Well-being*** ------------------- ***Mental Health Support Worker*** ------------------- ***Level 3 Diploma in Healthcare Support*** ------------------- Assessment Method After completing each module of the Receptionist : Office Admin and Reception Skills, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Receptionist : Office Admin and Reception Skills, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. 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? Office Admin and Reception Skills is ideal for Health Care Professionals who work and will be working in healthcare settings such as hospitals, clinics, and healthcare facilities. Requirements There are no specific requirements for this Receptionist : Office Admin and Reception Skills because it does not require any advanced knowledge or skills. Students who intend to enrol in this Receptionist : Office Admin and Reception Skills must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing this Receptionist : Office Admin and Reception Skills, you will have developed a set of skills necessary for career advancement and will be able to pursue a variety of job opportunities, including - Medical Receptionist Medical Secretary Healthcare Administrator GP Receptionist Patient Coordinator Certificates Certificate of completion Digital certificate - Included

Transform your human resource and payroll management skills with our comprehensive "Payroll, HR & HR Systems" course bundle! Gain a solid theoretical grounding with three QLS-endorsed courses: Payroll Management, HR (Human Resource), and Complete Guide to HR Systems. On successful completion, enjoy the prestige of owning a hardcopy certificate for each, showcasing your dedication and knowledge. But the learning doesn't stop there. Our bundle includes five additional CPD QS accredited courses, handpicked for their relevance to modern HR operations. Sage 50 Payroll for Beginners provides a thorough introduction to the popular payroll software, while Organisational Behaviour, HR and Leadership unpacks the intricacies of organisational dynamics. With Certificate in HR Audit, you can dive deep into internal HR procedures, and with Virtual Interviewing for HR and Safer Recruitment Training, you'll master the art of virtual recruitment and talent acquisition, a skill crucial in today's digital age. Key Features of the Payroll, HR & HR Systems Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Payroll, HR & HR Systems bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Payroll: Payroll Management QLS Course 02: HR (Human Resource) QLS Course 03: Complete Guide to HR systems 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Sage 50 Payroll for BeginnersCourse 02: Organizational Behaviour, HR and LeadershipCourse 03: Certificate in HR AuditCourse 04: Virtual Interviewing for HRCourse 05: Safer Recruitment Training In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV WritingCourse 02: Job Search SkillsCourse 03: Self Esteem & Confidence BuildingCourse 04: Professional Diploma in Stress ManagementCourse 05: Complete Communication Skills Master Class Convenient Online Learning: Our courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. This incredible, comprehensive 8-course bundle guarantees a holistic understanding of Payroll, HR Systems, equipping you with the theoretical knowledge to make a mark in your professional journey. Learning Outcomes: Gain a strong theoretical foundation in payroll management. Understand the principles and practices of Human Resource Management. Learn the use and application of HR systems. Comprehend the basics of Sage 50 Payroll. Develop insights into Organisational Behaviour and Leadership in HR context. Master the techniques of HR Audit. Equip yourself with virtual interviewing skills and safer recruitment practices. Our Payroll, HR & HR Systems course bundle delivers an in-depth, theoretical understanding of key HR topics. It brings together knowledge from various fields like payroll management, HR audit, and HR systems, providing a holistic perspective on the overall management of human resources. The bundle further highlights the importance of organisational behaviour, leadership, and safer recruitment practices - pivotal aspects in maintaining a harmonious and productive work environment. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Career path HR Manager (Salary range: £35,000 - £60,000) Payroll Specialist (Salary range: £25,000 - £40,000) HR Systems Analyst (Salary range: £30,000 - £50,000) Recruitment Specialist (Salary range: £22,000 - £35,000) Organisational Development Manager (Salary range: £45,000 - £70,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

This course will teach you all you need to know about working as a Help Desk agent. This course has been meticulously planned to fulfill all of the candidates' demands, and the agenda has been customized to the most recent technological developments.

The job market in the UK has been through a significant amount of turbulence over the last year, mainly due to the pandemic and recent war. As a result, finding a suitable niche in this highly competitive job market has become more challenging. So to cover up all your limitations and uproot all the hurdles to a stable and dignified career, we are here with a package you can't refuse! This time Apex Learning will show you the pathway to a successful career through the most well-researched and expertly made Microsoft Office bundle. Our Microsoft Office package, with the latest digital study materials and innovative learning method, will give you in-depth knowledge of this domain. You will dive deep into the core basics with our step-by-step lessons and proficient tutor guidance. You will be able to hone your knowledge from beginner to advanced level as there will be frequent tests, fun quizzes and practical analysis of the topics. Moreover, you will keep yourself up to date with the current situation in the area of your interest. As Microsoft Office, there are endless opportunities for you if you have the right knowledge and skill. Therefore, to make your career journey a successful one, we designed this bundle as a one-stop solution for you. This 20-in 1 Ultimate Microsoft Office bundle consists of the following Courses: Course 01: MS Word Diploma Course 02: Proofreading & Copyediting Course 03: PowerPoint Diploma Course 04: Microsoft Excel Level 3 Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Microsoft Excel: Master Power Query in 120 Minutes! Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis in Microsoft Excel Complete Training Course 12: Excel Must know Formulas and Functions Course 13: Excel spreadsheet for Beginner Course 14: Excel Data Analysis Course 15: Excel Vlookup, Xlookup, Match and Index Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17: PowerBI Formulas Course 18: Outlook Tips and tricks Course 19: Excel PowerQuery and PowerPivot Course 20: Complete Microsoft Power BI 2021 Additionally, you will get 5 other career-guided courses in this Microsoft Office bundle: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Microsoft Office bundle. Learning Outcomes of Microsoft Office bundle This career-oriented bundle will help you to Gain the ability to excel in the role of Microsoft Office Know your responsibilities as Microsoft Office and convey your experience to others Gain excellent interpersonal and communication skills Know the pros and cons of working as Microsoft Office Adhere to the regulations around this area Gain time and risk management skills to ensure efficiency Manipulate technological advancement to become more effective Maintain moral standards and set an example for your peers CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Microsoft Office bundle. Requirements This Microsoft Office course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (MS Word Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Tired of browsing and searching for a Service Helpdesk & Technical Support course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Service Helpdesk & Technical Support bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Service Helpdesk & Technical Support course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Service Helpdesk & Technical Support and help you along your learning journey. Advanced audio-visual learning modules of these Service Helpdesk & Technical Support courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Service Helpdesk & Technical Support, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Service Helpdesk & Technical Support Bundle Consists of the following Premium courses: Course 01: Service Helpdesk & Technical Support Course Course 02: Level 4- Office Management Course 03: Paralegal Course 04: Online Meeting Management Course 05: Interpersonal Skills in Management Course 06: Customer Relationship Management Course 07: Document Control Course 08: Information Management Course 09: Email Writing Training Course 10: Level 2 Effective Minute Taking Course Course 11: Touch Typing Essential Skills Level 3 Course 12: Business Law Course 13: Workplace Confidentiality Course 14: Public Speaking and Presentation Skill Course Enrol now in Service Helpdesk & Technical Support to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course ) Hard Copy Certificate: Free (For The Title Course ) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Service Helpdesk & Technical Support expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Service Helpdesk & Technical Support Course Managing Interoffice Calls and Voicemail Aspects of Phone Etiquette Business Telephone Skills Building Rapport Over the Phone Inbound and Outbound Calls Active Listening and Managing Tough Callers Mail Services and Shipping Intra Organisation Dealings Problem Solving over the Phone Record Keeping and Filing Systems Business Writing Skills Organisational Skills Communication Skills Customer Relationship Management Effective Planning and Scheduling Invoicing/Petty Cash Course 02: Level 4- Office Management Introduction to Office Administration Skills of an Effective Administrator Mail Services and Shipping Effective Planning and Scheduling Organising Meeting and Conferences Business Writing Skills Time Management Stress Management Business Telephone Skills Communication Skills Conflict Management Business Etiquette Microsoft Office Skills Course 03: Paralegal Understanding the Concept of Paralegal Key Legal Terminology Effective Communication Skills for Paralegals The Legal Workplace & Professionals Law & Legal Systems Contract & Business Law Property Law Wills, Probate, Estate Law Criminal Law Common Paralegal Legal Matters Human Rights Conflict and Conflict Resolution Professional Conduct and Ethics of Paralegals Mandatory Knowledge Fields and Survival Tips for Paralegals Course 04: Online Meeting Management Planning and Preparation Online Meeting Platforms Meeting Etiquette and Tips Course 05: Interpersonal Skills in Management What are Soft Skills? Communication Teamwork Problem-Solving Time Management Attitude and Work Ethic Adaptability/Flexibility Self-Confidence (Owning It) Ability to Learn From Networking Employee Relations Motivation and Counselling Course 06: Customer Relationship Management Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Course 07: Document Control Introduction to Document Control Principles of Document Control and Elements of Document Control Environment Document Control Lifecycle Document Control Strategies and Instruments Document Management Quality Assurance and Controlling Quality of Documents Project Document Control Electronic Document Management Systems and Soft Copy Documentation Course 08: Information Management Introduction to Information Management Information Management Strategy Databases and Information Management Management Information Systems (MIS) Auditing Information Systems Ethical and Social Issues and Data Protection Course 09: Email Writing Training E-Mail Communications Fundamentals of Writing Effective E-mails Manage Your E-mail Writing Styles and Tone Additional Tips for Writing Effective E-Mail Exercise Caution Course 10: Level 2 Effective Minute Taking Course Introduction to Minute Writing Preparation for Minute Taking The Meeting Structure Minute Meeting, Decision and Action Roles and Responsibility of Minute Taker Tips for Minute Taking Technology in Minute Taking Building Confidence Course 11: Touch Typing Essential Skills Level 3 Getting Started DRILL 1 The home keys DRILL 2 e and i, g and h DRILL 3 o and n, shift keys and t DRILL 4 extra practice . and y DRILL 5 , and w DRILL 6 m and u DRILL 7 v and x DRILL 8 sentence drills DRILL 9 figures DRILL 10 alphabetical paragraphs Recap Course 12: Business Law Understanding Business Law European Community Law The Court System Civil and Alternative Dispute Resolution Contract & Business Law Employment Law Agency Law Consumer Law and Protection Law of Tort Business Organisations Company Law Business Property Competition Law Course 13: Workplace Confidentiality Introduction to workplace confidentiality Business Etiquettes and Types of Confidentiality The Importance of Confidentiality Confidentiality with Co-workers Preventing Confidentiality Breach How Employers Can Protect Confidential Information Course 14: Public Speaking and Presentation Skill Course Introduction QUICK UNLEARNING Before Starting this "SKILL" IS THIS HAPPENED WITH YOU???? Impressive Methods of Hooking Audience, even before your Speech or Presentation 6 Highly Impressive Methods of Starting any Speech or Presentation!! Body Language: 6 Methods for Impressive Body Language for Speech or Presentation Vocal Variety: 3 Methods (VST) for POWERFUL Vocal Variety Effective Methods of Ending Any Speech or Presentation Bonus CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Service Helpdesk & Technical Support bundle. Requirements Our Service Helpdesk & Technical Support course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Service Helpdesk & Technical Support expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

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

Course Overview An office administrator's role includes organising meetings, managing databases, receiving and directing visitors, and more. It requires a great deal of expertise to carry out this long list of responsibilities. But don't worry, the Complete Office Administration Online Course is here to equip you with all the essential skills to prosper as an office admin.  In this extensive Complete Office Administration Online Course, you will be able to improve your communication skills. You will acquire excellent organisational skills. This curriculum includes lessons on bookkeeping and payroll management. It will enrich your skills in financial planning and budgeting. Step-by-step, you will be able to conquer all the skills to provide adequate admin support.  Whether you are already a professional or wishing to pursue a career in the admin sector, this course is the perfect package to learn how to balance your responsibilities. Join the course to gear up with all the admin skills and prepare for a cherishable career. What You Will Learn You'll learn about: Admin Support Managing Time Verbal and Non-verbal Communication Skills Business Writing Writing Business Reports, E-mails, Letters and Meeting Agendas Bookkeeping & Payroll Management Financial Planning, Budgeting and Control Auditing Customer Service and Telephone Handling MS Office and many more Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

Course Description This Office Administration and Stress Management: Part 4 course will help you explore how to prepare for major stressful events and what to do when those events happen. It will also teach you how to use a stress log system to identify and manage stressors. In addition, you will learn the best strategies that you can implement to prevent conflict from occurring. This Office Administration and Stress Management: Part 4 course will also help you better manage stress. If all these sound good to you, join the course right away!  Learning outcome  Learn how to prepare for stressful events Gain an understanding of how to use stress log system Get to know conflict management strategies Learn how to better manage your stress How Much Do Office Assistants Earn? Senior - £22,000(Appx.) Average - £21,000(Appx.) Starting - £19,000(Appx.) Requirement Our Office Administration and Stress Management: Part 4 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. Office Administration and Stress Management: Part 4 Module 01: Coping with Major Events 00:07:00 Module 02: Our Challenge to You 00:09:00 Module 03: Conflict Management 00:14:00 Module 04: Stress Management 00:16:00 Assignment Assignment - Office Administration and Stress Management: Part 4 00:00:00