2036 Design courses in Cardiff delivered Online

Are you looking to enhance your Data Analysis with Excel skills? If yes, then you have come to the right place. Our comprehensive course on Data Analysis with Excel will assist you in producing the best possible outcome by mastering the Data Analysis with Excel skills. The Data Analysis with Excel is for those who want to be successful. In the Data Analysis with Excel, you will learn the essential knowledge needed to become well versed in Data Analysis with Excel. Our Data Analysis with Excel starts with the basics of Data Analysis with Excel and gradually progresses towards advanced topics. Therefore, each lesson of this Data Analysis with Excel is intuitive and easy to understand. Why would you choose the Data Analysis with Excel from Compliance Central: Lifetime access to Data Analysis with Excel materials Full tutor support is available from Monday to Friday with the Data Analysis with Excel Learn Data Analysis with Excel skills at your own pace from the comfort of your home Gain a complete understanding of Data Analysis with Excel Accessible, informative Data Analysis with Excel learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Data Analysis with Excel bundle Study Data Analysis with Excel in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Data Analysis with Excel Improve your chance of gaining in demand skills and better earning potential by completing the Data Analysis with Excel Data Analysis with Excel Curriculum Breakdown of the Data Analysis with Excel Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Data Analysis with Excel helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Data Analysis with Excel. It is also great for professionals who are already working in Data Analysis with Excel and want to get promoted at work. Requirements To enrol in this Data Analysis with Excel, all you need is a basic understanding of the English Language and an internet connection. Career path The Data Analysis with Excel will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Data Analysis with Excel. 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

Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace. You Will Learn Following Things: Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365. Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas. Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics. Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges. Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making. This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite. On the other hand, anyone who wants to establish their career as: like MS Office User Microsoft Office 2019 User Touch Typing Worker Audio Typist Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Administrative Assistant - £20K to £30K/year Data Analyst - £25K to £45K/year Office Manager - £25K to £40K/year Project Coordinator - £25K to £35K/year Marketing Assistant - £20K to £30K/year Course Curriculum Section 01: Getting Started Introduction 00:03:00 Getting started on Windows, macOS, and Linux 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: Excel 2021: Basics Excel Overview 00:05:00 Start Excel Spreadsheet 00:04:00 Enter Text and Numbers 00:07:00 Relative References 00:04:00 Working with ranges 00:07:00 Save and Save as Actions 00:08:00 File Extensions, Share, Export, and Publish files 00:06:00 Section 03: Excel 2021: Rows, Columns, and Cells Adding Rows and Columns 00:03:00 Modifying Rows and Column lengths 00:05:00 Section 04: Excel 2021: Data Handling Copy, Cut, and Paste 00:07:00 Copying Formulas 00:03:00 Section 05: Excel 2021: Page Setting Up and Print Page setup options 00:06:00 Fit to print on One Page 00:03:00 Print Workbooks 00:03:00 Section 06: Excel 2021: Sorting and Filtering Sorting Data Ascending Order 00:04:00 Sorting Data Descending Order 00:02:00 Filter Data 00:04:00 Section 07: Excel 2021: Writing Formulas Creating Basic Formulas 00:06:00 Datetime Formulas 00:06:00 Mathematical formulas phase1 00:20:00 Mathematical formulas phase2 00:12:00 Section 08: Excel 2021: Advanced Formulas VLOOKUP formula 00:12:00 HLOOKUP formula 00:04:00 Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 00:08:00 Handling #NA and Approximates match in XLOOKUP 00:11:00 Section 10: Excel 2021: Data and Tools Split Text into columns 00:07:00 Flash Fill 00:07:00 Data Validation 00:07:00 Remove Duplicates 00:08:00 Import Data from Text files 00:06:00 Import Data from .CSV files 00:03:00 Section 11: Excel 2021: Formatting data and tables Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Numbers 00:05:00 Formatting Date 00:03:00 Formatting Tables 00:05:00 Section 12: Excel 2021: Pivot Tables Pivot Tables 00:07:00 Pivot Charts 00:02:00 Section 13: Excel 2021: Charts Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Creating Charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line Charts 00:02:00 Pie and Doughnut charts 00:04:00 Section 14: PowerPoint 2021: Course Introduction Overview 00:04:00 Start PowerPoint Presentation 00:05:00 Screen setting and Views 00:05:00 Section 15: PowerPoint 2021: Basics Presentation Tips and Guidelines 00:06:00 Creating a New Presentation 00:04:00 Working with Slides 00:04:00 Save a Presentation 00:04:00 Print Slides 00:03:00 Section 16: PowerPoint 2021: Text and Bullet Options Formatting Text 00:05:00 Slide Text Alignments 00:03:00 Multi-Column Text Alignments 00:02:00 Adding Bullets and Numbered List Items 00:03:00 Section 17: PowerPoint 2021: Adding Graphic Assets Insert Shapes 00:03:00 Insert Icons 00:03:00 Insert Graphics 00:04:00 Add 3D Models 00:03:00 Insert Pictures 00:03:00 Section 18: PowerPoint 2021: Picture Formatting Picture Options 00:04:00 Picture Cropping 00:03:00 Applying Built-in Picture Styles 00:04:00 Section 19: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 00:03:00 Modifying SmartArt 00:03:00 Creating a Target Chart using SmartArt 00:03:00 Section 20: PowerPoint 2021: Working with Tables Create a Table on Slide 00:04:00 Formatting Tables 00:02:00 Inserting Tables 00:02:00 Table Layouts 00:01:00 Section 21: PowerPoint 2021: Working with Charts Add a Chart 00:02:00 Formatting Charts 00:02:00 Insert Chart from Microsoft Excel 00:03:00 Section 22: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 00:03:00 Adding Audio to a Presentation 00:02:00 Screen Recording and Adding 00:02:00 Section 23: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 00:04:00 Section 24: PowerPoint 2021: Animation Object Animation 00:03:00 Effect Options 00:02:00 Advanced Animation 00:02:00 Triggers to control animation 00:02:00 Section 25: PowerPoint 2021: Slideshow Effects Onscreen Presentation 00:02:00 Hiding Slides 00:02:00 Changing Order of Slides 00:02:00 Copying Slides 00:02:00 Section 26: Word 2021: Introduction Overview of MS Word 00:04:00 Start MS Word 2021 00:05:00 Section 27: Word 2021: Basics Create a new blank document 00:04:00 Creating a paragraph text 00:05:00 Non-printing characters 00:03:00 Save a document 00:03:00 Open a document 00:01:00 Find and replace 00:04:00 Section 28: Word 2021: Word Formatting AutoCorrect options 00:03:00 Formatting text 00:04:00 Copy cut and paste 00:04:00 Character formatting 00:02:00 Format painter 00:04:00 Work with numbers 00:02:00 Add bullets 00:03:00 Outline creation 00:04:00 Section 29: Word 2021: Tables Creating a table 00:03:00 Adding rows and columns to a table 00:02:00 Formatting table data 00:02:00 Borders and shading 00:02:00 Sorting in a table 00:04:00 Draw a table 00:04:00 Convert text to table 00:03:00 Convert table to text 00:02:00 Insert a spreadsheet 00:02:00 Quick tables - readily available formats 00:02:00 Section 30: Word 2021: Styles Working with styles 00:02:00 Creating styles 00:02:00 Clear formatting 00:01:00 Section 31: Word 2021: Page Layout Margins 00:02:00 Orientation 00:01:00 Page size setting 00:01:00 Adding columns 00:03:00 Page break - section break 00:02:00 Adding watermark 00:03:00 Headers and footers 00:03:00 Section 32: Word 2021: Envelops and Lables Create envelops 00:02:00 Creating labels 00:02:00 Section 33: Word 2021: Mail Merges Creating a mail merge document 00:03:00 Section 34: Word 2021: Review and Printing Thesaurus and spell check 00:01:00 Word count 00:01:00 Speech - read aloud 00:01:00 Language - translate 00:01:00 Tracking 00:01:00

Revenue Operations course is designed to provide a comprehensive overview of revenue operations within an organization, as well as its benefits, importance, and the roles that they play in the above mentioned organization

Certificate in Risk Management If you want to learn about Risk management and become an expert in the field, you have arrived at the right place. Our Certificate in Risk Management course is a great way to brush up on your knowledge and skills. With this Training Tale course, you will get a solid introduction on the topic of risk management and learn how to conduct a risk assessment. Our Certificate in Risk Management course will also teach you about the various types of risks that your company may face. With this Certificate in Risk Management course, you will learn about the benefits of risk management and the steps of the risk assessment process. Learners are led through the key roles and obligations of those employed in professional Risk Management throughout 17 motivating modules. Industry experts designed this Certificate in Risk Management course to enable you to learn quickly and efficiently and at your own pace and convenience. Enrol today and take the next step towards your personal and professional goals. Courses are included in this Certificate in Risk Management Course Course 01: Diploma in Risk Management Course 02: Level 2 Diploma in Business Administration Course 03: Level 7 Diploma in Facilities Management Course [ Note: Free PDF certificate as soon as completing the Certificate in Risk Management course] Certificate in Risk Management Course Curriculum of Certificate in Risk Management Course Industry Experts Designed this Certificate in Risk Management course into 17 detailed modules. Assessment Method of Certificate in Risk Management After you have finished the Certificate in Risk Management Course, you will need to take an electronic multiple-choice exam or Assignment to see if you have grasped everything. To pass the exam and be eligible for the pending certificates, you must achieve at least 60%. As soon as you pass the examination, you will be qualified to request your certification. Certification of Certificate in Risk Management After completing the MCQ/Assignment assessment for Certificate in Risk Management Course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Certificate in Risk Management Certificate in Risk Management course is ideal for- Fresh Graduates Students Job Seekers Anyone interested in risk management Quality Managers Quality Assurance professionals People who are already employed in related fields and want to improve their expertise and skills. Requirements Certificate in Risk Management There are no specific requirements for Certificate in Risk Management course because it does not require any advanced knowledge or skills. Career path Certificate in Risk Management Candidates who successfully complete our Certificate in Risk Management Course can advance a huge variety of careers, including: Quality Manager Quality Assurance Manager Risk Management Manager Risk Manager Risk-Management Consultant Risk-Management Analyst Certificates Certificate of completion Digital certificate - Included

Follow your dreams by enrolling on the Accountancy course today and develop the experience, skills and knowledge you need to enhance your professional development. Accountancy will help you arm yourself with the qualities you need to work towards your dream job. Study the Accountancy training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Accountancy course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Accountancy course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Accountancy course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Accountancy course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Accountancy course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Accountancy course. The Accountancy course is designed by industry experts and is tailored to help you learn new skills with ease.  The Accountancy is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Accountancy when it suits you. Access the Accountancy course modules from any internet-enabled device, including computers, tablets, and smartphones. The Accountancy course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Accountancy now and start learning instantly! What You Get Out Of Studying Accountancy With Janets: Receive a digital Certificate upon successful completion of the Accountancy 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) Description The Accountancy training course is delivered through Janets' online learning platform. Access the Accountancy content from any internet-enabled device whenever or wherever you want to. The Accountancy course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Accountancy course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Accountancy course. After successfully passing the Accountancy course exam, you will be able to apply for a CPD-accredited certificate as proof of your Accountancy qualification. 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 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 Accountancy is ideal for those who already work in this sector or are an aspiring professional. This Accountancy 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 Accountancy is open to all students and has no formal entry requirements. To study the Accountancy course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Accountancy is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Accountancy and gain an industry-recognised qualification that will help you excel in finding your ideal job.

Demystify the world of finance with our comprehensive Finance course. From understanding banking systems to mastering personal financial planning, this course is designed to equip you with the skills to make informed financial decisions in personal and corporate settings.

Demystify the world of finance with our comprehensive Basics of Finance course. From understanding banking systems to mastering personal financial planning, this course is designed to equip you with the skills to make informed financial decisions in personal and corporate settings.

Cost Control Process and Management Level 3 Course Overview Cost Control Process and Management Level 3 provides a thorough, step-by-step understanding of how to monitor, manage, and reduce costs in the food and hospitality industry. Whether you're managing a restaurant, running a kitchen, or simply want to optimise your business processes, this course breaks down everything you need to know — from inventory terms and purchasing controls to recipe costing and menu engineering. This instructor-guided, self-paced course is packed with practical examples and real-world insights that will help you reduce waste, increase profitability, and maintain operational efficiency. With lifetime access to the course materials, you can learn at your own speed and revisit content anytime you need a refresher. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand key cost control terms and inventory principles Set up effective PAR levels and re-order points Manage purchasing, receiving, and storing processes efficiently Apply recipe cards, buffet costing, and menu pricing strategies Perform butcher tests, bar checks, and spot recipe testing Monitor slow/non-moving stock and control production Use reports and checklists for daily/monthly food cost tracking Implement menu engineering reports to boost profitability Why Choose This Cost Control Process and Management Level 3 Course? This course has been designed to provide you with job-ready skills that are directly applicable in real-world cost control environments. You’ll gain both the theoretical understanding and the hands-on techniques needed to streamline operations and cut unnecessary costs. All content is accessible online and supported by expert guidance. Whether you're aiming to enhance your current role or preparing for a new career path, this course will help you stand out in the food & beverage industry. Who is this Cost Control Process and Management Level 3 Course for? This course is ideal for individuals looking to strengthen their expertise in the subject area, whether you're a complete beginner aiming to build foundational knowledge, a professional seeking to enhance your current role, or a business owner wanting to manage specific operations in-house. It's also beneficial for career changers exploring new opportunities, or anyone eager to gain practical, industry-relevant skills to boost their employability. Entry Requirements There are no formal requirements to enrol in this course. A basic understanding of food service or hospitality operations will be helpful but not essential. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

Launch your journey in stock trading with this comprehensive course, designed to demystify market mechanics, financial analysis, and advanced trading strategies. Tailored for both beginners and seasoned traders, it offers insights into stock and bond valuation, emerging market trends, and essential risk management techniques.

Sage 50 Payroll for Beginners Course Overview Mastering payroll is essential for any business operation, and Sage 50 Payroll is one of the UK’s most widely used systems for managing employee payments, tax, pensions, and more. This beginner-level course is designed to introduce you to the complete payroll process using Sage 50, from setting up company details to running year-end reports. Whether you’re looking to work in payroll, start a role in HR or finance, or simply want to enhance your accounting knowledge, this course provides step-by-step training to help you build a solid foundation. You’ll start by exploring payroll basics and navigating company and legislation settings. Then, you’ll dive into practical tasks such as adding employees, entering payments, generating reports, and handling submissions. You’ll also gain insights into essential year-end procedures and how to process final payments correctly, giving you confidence in real-world scenarios. No prior payroll experience is required, making this course ideal for aspiring payroll administrators or small business owners looking to manage staff payments in-house. With flexible online learning and practical modules, this course ensures that you can develop your Sage 50 skills at your own pace — ready to take on payroll duties with efficiency and accuracy. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the fundamentals of Sage 50 Payroll software Learn how to set up company and legislation settings correctly Gain the skills to add new and existing employees to the payroll system Process payrolls and update employee records efficiently Handle statutory payments and employee departures with confidence Master e-submissions and produce accurate reports and year-end summaries Who is this Sage 50 Payroll for Beginners Course for? This Sage 50 Payroll for Beginners course is ideal for aspiring payroll administrators and HR assistants who want to develop practical skills in managing payroll processes. It’s also perfectly suited for small business owners looking to handle their company’s payroll operations in-house. In addition, accountancy or finance students aiming to enhance their career prospects will benefit greatly from this course. Whether you're starting from scratch or looking to refresh your knowledge, this course provides the foundation you need to confidently use Sage 50 Payroll. Entry Requirements There are no formal prerequisites for this course. It is open to anyone interested in learning payroll using Sage 50, regardless of previous experience. A basic understanding of computer use is helpful, but not essential. All you need is a stable internet connection and a desire to learn! Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.