5333 Courses in Cardiff delivered Online

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 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. 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

Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | FREE 5 CPD Courses | Lifetime Access

Step confidently into the world of freelance translation with a course designed to sharpen your skills and boost your business savvy—all from the comfort of your chosen workspace. Mastering Freelance Translation: From Basics to Business is your no-nonsense guide to building a solid foundation in professional translation, while also learning how to navigate the freelance landscape with clarity and purpose. Whether you’re new to the scene or brushing up on your strategy, this course strikes the perfect balance between linguistic finesse and smart business thinking. You'll gain a deeper understanding of what it truly means to work independently as a translator in today's fast-moving digital market. From honing your workflow to managing projects with ease, this course delivers insights you can actually use—without the fluff. It’s designed for those who are serious about freelancing and want to approach it with professionalism, confidence, and a touch of wit. After all, translating is a serious business… but no one said we couldn't enjoy the process. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: An Overview of Translation Module 02: Introduction to Freelancing Module 03: Introduction to Freelance Translator Module 04: Activities Before Getting Started Module 05: Finding Clients Module 06: Managing the Work Module 07: Marketing Module 08: CAT Tools in Translation Module 09: Getting Paid for The Work Module 10: Setting Up Home Office Module 11: Professional Ethics of Freelance Translators Module 12: Ensuring Quality Module 13: Other Tips and Tricks to Keep in Mind Learning Outcomes: Master the core principles of translation. Build a successful freelance translation business. Locate and engage with clients effectively. Utilise CAT tools for enhanced productivity. Navigate the world of professional ethics and quality assurance. Implement best practices for marketing and home office setup. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring freelance translators Language enthusiasts looking to turn their skills into a profession Professionals seeking a side career or an additional source of income Anyone interested in the world of freelance translation Career path Freelance Translator Localization Specialist Content Writer Language Consultant Project Manager in Translation International Business Liaison Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

Course Overview Discover how to find a healthy work-life balance and cope successfully with stressful situations by using Mindfulness at Work. Stress management is now critical to good productivity in the workplace, with the quality of operations and the well-being of staff dependent on it. This course will help you utilise the principles of mindfulness in everyday activities, contributing to a safe and positive environment at all times. This very practical Mindfulness tutorial will guide you through all positive habits, values, and behaviours that are conducive to both outcomes and personal health. A comprehensive learning curve is provided, from waking up tips to relaxation exercises. This coaching provides the perfect education for those serious about maintaining quality and mental positivity. Enrol now and learn to work smarter but not harder. This best selling Mindfulness at Work has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Mindfulness at Work is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Mindfulness at Work 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 Mindfulness at Work 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 Mindfulness at Work, 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 Mindfulness at Work 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 Mindfulness at Work 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.

Description: Safety procedures are the most important part of any organization's Safety Management System. This Workplace Safety Manual Developing Course provide consistency and when followed create a safety working environment and greater productivity due to less injury down time. Safety procedure writing is more difficult and time consuming than it at first appears. By this course you will get the foundation to start writing effective safety procedures. You will learn to develop a safety procedure template, write and revise step-by-step safety procedures, and much more related to this sector. So, if you want to develop your skills don't wait to join this course. Learning Outcomes: Devise a Safety Procedure Framework Improvise a flowchart to perform process activities with an accurate depiction Exploit the brainstorming so that you can gather the crucial information for a safety procedure creation Realise a range of procedure types including (Step-by-step, Playscript, The Decision Tree and Decision Tables) Learn how to write and review Step-by-Step safety procedures Impart communication contents for the safety procedures Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Workplace Safety Manual Developing Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Workplace Safety Manual Developing Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Course Overview 00:05:00 Setting the Stage 00:15:00 Safety Procedures Basics 00:15:00 Flowcharting 00:30:00 Gathering Information 00:30:00 Procedure Writing 00:15:00 Honing the Draft Procedure 00:30:00 Some Other Methods 00:15:00 Mock Exam Mock Exam- Workplace Safety Manual Developing Course 00:20:00 Final Exam Final Exam- Workplace Safety Manual Developing Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Supervisors are an integral part of the economy. You have the ability to galvanize the people to increase their productivity. To gain the technical skills and knowledge to perform supervision, Supervisor Skills Training Course is perfect for you. In this course, you will learn about the ways of prioritizing, planning and managing their time. You will also learn about their primary leadership style, developing flexibility, finding ways to meet the needs of employees through communication, disrupt conflicts and make it a positive thing, etc. This skills of communication and coaching will help you to become successful. Learning Outcomes: Routes to give a priority, strategy, and learn how to manage their time Get knowledge of recognizing their basic leadership methods Know how to improvise some adaptability so as to implement other leadership features Means to encounter the requirements of employees as well as your colleagues by dint of communication and coaching. Paths to transform conflict an effective mean for creative, well-cycled solutions to the problems you are dealing with. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Supervisor Skills Training Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Supervisor Skills Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Course Overview 00:15:00 What's Your Type? How About Mine? 00:45:00 Understanding Leadership 00:45:00 Manage Your Time and Your Energy 00:45:00 Employee Development Models 00:30:00 Dealing with Conflict and Difficult Issues 00:15:00 What Successful Leaders Do 00:15:00 Mock Exam Mock Exam- Supervisor Skills Training Course 00:20:00 Final Exam Final Exam- Supervisor Skills Training Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: A staff retreat is important to maintain harmony in an office environment. It usually takes longer than two hours of staff meetings to get the work done. This Staff Retreating Certificate Course will help you change your approach towards your colleagues and help bolster your communication with them. In this course, you will learn about importance of discussing experiences in staff retreats, know the reasons, develop and present staff retreats relevant activities, evaluation questionnaire, checklist, etc. You will be able to garner knowledge which will help you increase productivity, efficiency and sales. Learning Outcomes: Analyse experience with staff retreats Get information for what staff retreats are operated Realise the chief staff retreat undertakings categories Improve as well as present retreat activities Figure out the critical components for success of a staff retreat Formulate a planning Learn how to apply the keys to running checklist for a staff retreat Enhance an assessment questionnaire Identify post-retreat activities that would assert the consistent success of your staff retreats Turn your top three take home ideas into reality for producing successful staff retreats Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Staff Retreating Certificate Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Staff Retreating Certificate Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Course Overview 00:15:00 Staff Retreats 00:15:00 Types of Undertakings at a Staff Retreat 00:15:00 Designing a Staff Retreat 00:45:00 Running the Retreat 00:30:00 Post-Retreat 00:15:00 Mock Exam Mock Exam- Staff Retreating Certificate Course 00:20:00 Final Exam Final Exam- Staff Retreating Certificate Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Discover a holistic approach to understanding the world of coding with the enriching bundle: "C# Coding, Java and Python Programming." This remarkable course package promises an engaging blend of two prestigious QLS-endorsed programmes and five CPD QS-accredited offerings. As a testament to your efforts, every successful participant will be rewarded with hardcopy certificates, providing a tangible representation of their coding prowess. Diving into this treasure trove of knowledge, participants will uncover the intricacies of C#, Java, and Python through our QLS-endorsed courses. Each class has been meticulously structured to enhance comprehension and ensure a rewarding learning journey. Furthermore, five CPD QS-accredited courses extend the learning experience beyond, covering JavaScript, ASP.Net, Data Visualization, and Scratch. Key Features of the C# Coding, Java and Python Programming Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our C# Coding, Java and Python Programming bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Basic C# Coding QLS Course 02: Introduction to Java QLS Course 03: Diploma in Python Programming 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: Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML Course 02: Master JavaScript with Data Visualization Course 03: Python from Scratch Course 04: Coding with Scratch Course 05: Mastering Java for Beginners & Experts In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our C# Coding, Java and Python Programming courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcome: Develop a comprehensive understanding of C#, Java, and Python programming languages. Gain insights into JavaScript and ASP.Net through CPD QS-accredited courses. Uncover the techniques of Data Visualization using JavaScript. Understand the fundamentals of coding with Scratch. Master the art of Java for both beginners and experts. Learn how to build projects from scratch using Python. Become proficient in the use of coding essentials, including HTML. Embark on an enriching journey into the realm of coding with the "C# Coding, Java and Python Programming" bundle. This carefully curated package equips learners with the fundamentals and advanced aspects of three critical programming languages. The offering also extends to five other relevant courses, all of which are CPD QS-accredited, presenting a comprehensive coding landscape. These add-on subjects dive deeper into JavaScript, ASP.Net, Data Visualization, and Scratch, making this bundle a powerhouse of coding knowledge. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring coders who aim to grasp the fundamentals and advanced techniques of key programming languages. Professionals seeking to diversify their skill set with a comprehensive understanding of coding. Students of computer science desire to deepen their understanding of critical programming languages. Existing coders looking to bolster their resumes with QLS-endorsed and CPD QS-accredited courses. Career path C# Developer: £30,000 - £45,000 Java Developer: £35,000 - £55,000 Python Programmer: £45,000 - £65,000 JavaScript Developer: £30,000 - £50,000 ASP.Net Developer: £35,000 - £55,000 Data Analyst (specialising in data visualisation): £30,000 - £60,000 (Note: Salary estimates are based on the average UK salaries as of 2023.) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.