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

9456 Office courses in Cardiff delivered Online

Microsoft Excel 2016: Data Analysis with PivotTables Course

By Study Plex

Highlights of the Course Course Type: Online Learning Duration: 1 Hour 17 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Office Excel Understand the core competencies and principles of Microsoft Office Excel Explore the various areas of Microsoft Office Excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel 2016: Data Analysis with PivotTables Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel data analysis course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel data analysis course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel data analysis course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive excel data analysis course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This excel data analysis course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This excel data analysis course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This excel data analysis course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Introduction Introduction 00:01:00 Preparing Data and Creating Pivot Tables Prepare Data - Introduction 00:01:00 Prepare Data 00:06:00 Create a PivotTable - Introduction 00:07:00 Create a PivotTable from a Local Data Source 00:06:00 Create a PivotTable from Multiple Local Data Sources 00:07:00 Create a PivotTable from an External Data Sources 00:07:00 Analyzing Data by Using PivotTables Summarize PivotTable Data - Introduction 00:01:00 Summarize Pivottable Data 00:07:00 Organize PivotTable Data - Introduction 00:01:00 Organize PivotTable Data 00:04:00 Filter Pivottable Data 00:07:00 Format a PivotTable - Introduction 00:01:00 Format a PivotTable 00:03:00 Refresh and Change PivotTable Data - Introduction 00:01:00 Refresh and Change PivotTable Data 00:06:00 Working with PivotCharts Create a PivotChart - Introduction 00:01:00 Create a PivotChart 00:04:00 Manipulate PivotChart Data 00:04:00 Format a PivotChart 00:05:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Microsoft Excel 2016: Data Analysis with PivotTables Course
Delivered Online On Demand
£19

Microsoft Project Introduction (live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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

Microsoft Project Introduction (live online classes)
Delivered OnlineFlexible Dates
£275

Admin, Secretarial & PA - Level 7

4.3(43)

By John Academy

Course Overview Every office needs someone who can carry out the administrative duties effectively and also represent the company in the best possible way. For this reason, proficient office admins and receptionists are always in high demand. If you are looking for a promising job, then this could be your call. The Admin, Secretarial & PA - Level 7 course will help you pursue a career in this field.  In the Admin, Secretarial & PA - Level 7 course, you will learn the core skills required to become an office admin. Through this course, you will get introduced to business etiquette. The easy-to-follow modules will teach you business writing, communication and organisation skills. You will become skilled in providing quality customer services. In addition, the course will provide you with effective tips for planning and scheduling.  After completing the course, you will receive a certificate of achievement. This certificate will elevate your resume and boost your employability in this promising sector. Enrol now! Learning Outcomes of Admin, Secretarial & PA - Level 7 Familiarise with the key skills required for office administration Learn different business etiquette Develop the skills to organise meetings and conferences Improve your business writing, communication and organisation skills Build the expertise to provide quality customer service Pick up the effective planning and scheduling strategies Who is this Course for? The Admin, Secretarial & PA - Level 7 course is perfect for those who want to pursue a career in the relevant fields. This course will also be beneficial for those already working in this area.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can, however, also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet, or desktop from anywhere, anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Admin, Secretarial & PA - Level 7 course will be beneficial for any related profession or industry, such as: Office Admin Secretarial Personal Assistant Receptionist Module 01 - Introduction to Personal Assistant & Admin Support Assistant Introduction to Office Administration 00:17:00 Module 02 - Introduction to Office Administration Introduction to Office Administration 00:17:00 Module 03 - Skills of an Effective Administrator Skills of an Effective Administrator 00:18:00 Module 04 - Introduction to Reception and Receptionist Introduction to Reception and Receptionist 00:29:00 Module 05 - Business Telephone Skills Business Telephone Skills 00:21:00 Module 06 - Representing Your Boss and Company Representing Your Boss and Company 00:25:00 Module 07 - Business Etiquette Business Etiquette 00:19:00 Module 08 - Mail Services and Shipping Mail Services and Shipping 00:26:00 Module 09 - Travel Arrangements Travel Arrangements 00:22:00 Module 10 - Organising Meeting and Conferences Organising Meeting and Conferences 00:19:00 Module 11 - Diary Management and Note taking Diary Management and Note taking 00:21:00 Module 12 - Time Management Time Management 00:25:00 Module 13 - Record Keeping and Filing Systems Record Keeping and Filing Systems 00:24:00 Module 14 - Business Writing Skills Business Writing Skills 00:25:00 Module 15 - Organisational Skills Organisational Skills 00:19:00 Module 16 - Communication Skills Communication Skills 00:19:00 Module 17- Customer Service Customer Service 00:22:00 Module 18- Effective Planning and Scheduling Effective Planning and Scheduling 00:39:00 Module 19 - Invoicing/Petty Cash Invoicing/Petty Cash 00:20:00 Assignment Assignment - Admin, Secretarial & PA - Level 7 03:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Admin, Secretarial & PA - Level 7
Delivered Online On Demand10 hours 7 minutes
£18

Diploma on Legal Secretary and Office Skills

By Online Training Academy

Are you ready to take your career to the next level? Our Diploma on Legal Secretary and Office Skills is designed to equip you with the comprehensive knowledge and practical skills needed to excel in the dynamic legal field. This program is perfect for those seeking a rewarding career as a legal secretary or paralegal, providing you with the expertise to support legal professionals effectively. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access The Diploma on Legal Secretary and Office Skills provides learners with comprehensive training to excel in a legal office environment. Students will learn about the various roles and responsibilities within a legal workplace, focusing on ethical conduct and professional behavior. The course covers essential skills such as customer service, telephone handling, and managing meetings, ensuring students can efficiently support legal professionals. Learners will also gain proficiency in data management, record-keeping, proofreading, and editing legal documents. Additionally, the course includes training in professional writing, understanding English law and legal systems, and specific areas of law such as family law, contract law, property law, and wills and probate. By the end of the course, students will be well-equipped with the necessary knowledge and practical skills to perform effectively as legal secretaries. Course Curriculum Module 01: Introduction to Legal Secretary Module 02: The Legal Workplace and Professionals Module 03: Professional Conduct and Ethics of Paralegals Module 04: Customer Service and Telephone Handling Skills Module 05: Meeting Management & Minute Taking Module 06: Data Management and Record-Keeping Module 07: Document Proofreading and Editing Module 08: Professional Writing and Documents Module 09: English Law & Legal Systems Module 10: Family Law and Insurance Practice Module 11: Law of Contract & Law of Tort Module 12: Property Law & Conveyancing Practice Module 13: Wills, Probate, Estate Law Module 14: Other Essential Skills for Secretarial Role Learning Outcomes: Understand the role and duties of a legal secretary. Navigate the legal workplace and engage with professionals. Adhere to paralegal professional conduct and ethics standards. Deliver excellent customer service and manage telephone communications. Efficiently organise meetings and accurately take minutes. Manage data and maintain precise records. CPD 10 CPD hours / points Accredited by CPD Quality Standards Diploma on Legal Secretary and Office Skills 3:48:56 1: Module 01: Introduction to Legal Secretary 12:29 2: Module 02: The Legal Workplace and Professionals 28:03 3: Module 03: Professional Conduct and Ethics of Paralegals 15:01 4: Module 04: Customer Service and Telephone Handling Skills 13:22 5: Module 05: Meeting Management & Minute Taking 37:43 6: Module 06: Data Management and Record-Keeping 08:37 7: Module 07: Document Proofreading and Editing 12:55 8: Module 08: Professional Writing and Documents 16:41 9: Module 09: English Law & Legal Systems 22:55 10: Module 10: Family Law and Insurance Practice 12:29 11: Module 11: Law of Contract & Law of Tort 15:52 12: Module 12: Property Law & Conveyancing Practice 11:51 13: Module 13: Wills, Probate, Estate Law 07:57 14: Module 14: Other Essential Skills for Secretarial Role 12:01 15: CPD Certificate - Free 01:00 Who is this course for? Aspiring legal secretaries and administrative staff. Individuals seeking a career in law. Office staff needing legal office skills. Professionals transitioning to legal environments. Students interested in legal administrative roles. Career path Legal Secretary Paralegal Assistant Office Administrator in a legal setting Legal Receptionist Document Management Clerk Conveyancing Assistant Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Diploma on Legal Secretary and Office Skills
Delivered Online On Demand4 minutes
£12

Legal Secretary - Legal Office Administration and Support

By Compliance Central

***Transform Yourself: From Beginner to Legal Secretary in One Course*** Did you know according to a recent report, the demand for Legal Secretaries is expected to grow by 5% in the next few years? This essential role provides the foundation for a successful legal career. If you're looking to step into the exciting world of law, this legal course comprehensive course equips you with the knowledge and skills to thrive as a Legal Secretary. This Legal Secretary - Legal Office Administration and Support course is designed to provide a theoretical grounding in all the key areas a Legal Secretary needs to excel. Through a series of engaging modules, you'll gain a thorough understanding of English Law, legal terminology, and essential secretarial practices. Learning Outcomes By the end of this Legal Secretary - Legal Office Administration and Support course, you will be able to: Gain a thorough understanding of the legal secretary's role and responsibilities within a legal practice. Develop a strong foundation in English Law and the legal systems that govern the UK. Master the fundamentals of contract law, tort law, wills & probate, property law, criminal law, and family law. Hone your skills in professional writing, document creation, proofreading, and editing. Learn effective meeting management, minute-taking techniques, and data management practices. Develop a comprehensive understanding of human rights and their application in legal contexts. Key Highlights for Legal Secretary - Legal Office Administration and Support Course: CPD QS Accredited Proficiency with this Legal Secretary course. After successfully completing the Legal Secretary course, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Legal Secretary course. The online test with immediate results You can study and complete the Legal Secretary course at your own pace. Study for the Legal Secretary course using any internet-connected device, such as a computer, tablet, or mobile device. This Legal Secretary - Legal Office Administration and Support course is your gateway to a fulfilling career as a Legal Secretary. Throughout the course, you'll delve into various legal areas, including contract law, tort law, wills & probate, property law, criminal law, family law, and business law. You'll gain insights into the legal systems within the UK and explore the intricacies of legal documents. The Legal Secretary course also emphasizes the importance of communication, interpersonal skills, and organization, all essential for success as a Legal Secretary. Furthermore, you'll develop proficiency in document proofreading, editing, and minute-taking, ensuring accuracy and efficiency in your daily tasks. The Legal secretary course also covers essential secretarial skills like data management, record-keeping, and meeting management, equipping you to provide exceptional support to lawyers and legal teams. Curriculum Breakdown of the Legal Secretary - Legal Office Administration and Support Course Module 01: Introduction to Legal Secretary Module 02: English Law & Legal Systems Module 03: Law of Contract & Law of Tort Module 04: Wills, Probate, Estate Law Module 05: Property Law & Conveyancing Practice Module 06: Criminal Law Module 07: Understanding Criminal Psychology Module 08: Contract & Business Law Module 09: Family Law and Insurance Practice Module 10: Conflict and Conflict Resolution Module 11: Professional Writings and Documents Module 12: Document Proofreading and Editing Module 13: Meeting Management & Minute Taking Module 14: Data Management and Record-Keeping Module 15: Other Essential Skills for Secretarial Role Module 16: Human Rights CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Legal Secretary - Legal Office Administration and Support course is suitable for: Individuals with an interest in a career in law. Those seeking to become a Legal Secretary. Professionals looking to enhance their legal knowledge and secretarial skills. Graduates seeking entry-level positions in the legal sector. Career changers interested in transitioning into the legal field. Anyone who wants to gain a foundational understanding of the legal system. Requirements There are no specific prerequisites for this Legal Secretary - Legal Office Administration and Support However, a basic understanding of legal terminology and strong written communication skills will be beneficial. Career path This Legal Secretary - Legal Office Administration and Support course provides a strong foundation for a fulfilling career as : Paralegal Legal Assistant Solicitor (with further qualifications) Legal Compliance Officer Legal Consultant Legal Case Manager ***Enroll today and take the first step towards becoming a successful Legal Secretary!*** Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Legal Secretary - Legal Office Administration and Support
Delivered Online On Demand7 hours
£12

Executive Secretarial & Personal Assistant Skills Training Course

By iStudy UK

Course Overview Secretaries and Personal Assistants are integral to the smooth running of a business, making sure that office procedures are maintained effectively and everyday administrative duties are completed to a high standard. They are responsible for managing meetings, greeting clients, maintaining records, and other key office support duties.  In this Personal Assistant Training Course, you will develop all the essential skills needed to fast track your career in this field, equipping you with practical knowledge that will help boost your earning potential. It will guide you through a range of office procedures, from organising your binder and workspace to Microsoft Office training and putting together an office procedure guide. Not only that, but you will learn how to build a positive relationship with your manager and learn strategies for building your professional image. Stand out to prospective employers with this accredited Personal Assistant Training Course! What You Will Learn In this Executive Personal Assistant Course, you'll learn a range of administrative and transferable skills needed to provide quality office support. It provides essential information on key office procedures, as well as strategies for improving your efficiency in the workplace. Fundamental Office Administrative Procedures Putting Together The office Procedure Guide What You Should Include in Your Binder Verbal & Nonverbal Communication Skills Steps to Effective Meeting Management Microsoft Word, Excel & PowerPoint Training Effective Time Management Strategies Building a Strong Working Relationship With Your Manager Building Your Self-Esteem and Professional Image Influencing and Negotiating Techniques 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.

Executive Secretarial & Personal Assistant Skills Training Course
Delivered Online On Demand3 days
£25

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced 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 Macros & VBA - Online  classroom
Delivered OnlineFlexible Dates
£550

Work Area Organisation for Increased Office Productivity

4.7(160)

By Janets

Register on the Work Area Organisation for Increased Office Productivity 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 Work Area Organisation for Increased Office Productivity 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 Work Area Organisation for Increased Office Productivity 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 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 Work Area Organisation for Increased Office Productivity, 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 Work Area Organisation for Increased Office Productivity Module 01: Introduction 00:01:00 Module 02: Purge 00:02:00 Module 03: Redistributing 00:04:00 Module 04: Fences Software 00:04:00 Module 05: Create Work Spaces 00:06:00 Module 06: Proximity 00:04:00 Module 07: Lable What You Can 00:03:00 Module 08: Move to Digital 00:03:00 Module 09: Clean Your Desk Off 00:03:00 Module 10: Multiple Inboxes 00:03:00 Module 11: Mailings 00:03:00 Module 12: Discard Dates 00:03:00 Module 13: Magazines 00:02:00 Module 14: File Weekly 00:03: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.

Work Area Organisation for Increased Office Productivity
Delivered Online On Demand44 minutes
£25

Dynamic Arrays in Microsoft Excel Training

By Lead Academy

Dynamic Arrays in Microsoft Excel Training Course Overview Are you looking to begin your Microsoft Office Excel career or want to develop more advanced skills in Microsoft Office Excel? Then this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Excel. This dynamic arrays in Microsoft Excel training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as an office admin. The dynamic arrays in Microsoft Excel training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as an office admin. This comprehensive dynamic arrays in Microsoft Excel training course is the perfect way to kickstart your career in the field of Microsoft Office Excel. This dynamic arrays in Microsoft Excel training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as an office admin or want to learn more skills on Microsoft Office Excel but unsure of where to start, then this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This dynamic arrays in Microsoft Excel training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive dynamic arrays in Microsoft Excel training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Office Excel. Entry Requirement There are no academic entry requirements for this dynamic arrays in Microsoft Excel training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately.. Career path This dynamic arrays in Microsoft Excel training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Dynamic Arrays in Microsoft Excel Training
Delivered Online On Demand
£25

Conflict Management at Office

4.7(160)

By Janets

Register on the Conflict Management at Office today and build the experience, skills and knowledge you need to enhance your expert 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 Conflict Management at Office 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 Conflict Management at Office Receive a e-certificate upon successful completion of the course Get taught by experienced, expert 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 Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £69. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring expert. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a Certificate of Achievement to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the Conflict Management at Office, 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 Unit 01: Introduction Welcome to the Course 00:03:00 What are Conflict and Conflict Management? 00:03:00 Unit 02: Understand the Keys to Conflict The Rational and Irrational Sources of Conflict 00:03:00 The Effects of Respect on Conflict 00:04:00 How to Use Respect to Help Resolve Conflict 00:05:00 Unit 03: How Misunderstandings Arise and the Solution How Communication Works 00:05:00 How we listen: The Four Listening Levels 00:05:00 How to Listen Well 00:04:00 Unit 04: Personality Types in Conflict How Personality Types Conflict 00:02:00 How Specific Personalities Clash at Work 00:04:00 How to Avoid Personality Clash 00:02:00 Unit 05: Escalation of Conflict Resistance: It's Not Conflict yet. 00:02:00 The Onion Model of Resistance e 00:07:00 The Signs of Conflict Escalation 00:03:00 Unit 06: De-escalating Conflict The Strategies for Handling Conflict 00:06:00 Conflict De-escalation Process 00:03:00 Conflict Handling Modes - The Thomas-Kilmann Model 00:02:00 The Five Thomas-Kilmann Modes 00:06:00 Getting Help from a Third Party 00:05:00 How to Recover from a Broken (Professional) Relationship 00:05:00 Unit 07: Closing Section Good Conflict and Bad Conflict 00:04:00 The Secret to Avoiding Conflict 00:03:00 Assignment Assignment - Conflict Managemnet at Office 4 days, 23 hours Order Your Certificate Order your Certificate QLS 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.

Conflict Management at Office
Delivered Online On Demand5 days
£25