826 Courses in Cardiff delivered Online

***Level 5: Accounting and Finance*** Accounting and finance assist businesses in measuring, monitoring, and planning their operations. This course has been designed to provide a thorough introduction to business Accounting and Finance as both an idea and a profession. This course will equip you with in-demand accounting and finance skills as well as the ability to complete practicable processes while working in an organisation. This could be tricky, especially if this is your first consignment in the accounting and finance sector. Our Level 5: Accounting and Finance course provides a solid understanding of accounting and financial methods, concepts, and duties to properly prepare you for a career in the accounting and finance sector. Learning Outcomes After completing this Level 5: Accounting and Finance course, learner will be able to: Understand the essentials of accounting and finance Understand the types of cost data and cost analysis Gain a thorough understanding of contribution analysis Understand break-even and cost-volume-profit analysis Understand relevant cost and know to make short-term decisions Know how to manage financial assets Understand forecasting cash needs and budgeting Cost control and variance analysis Know how to manage accounts receivable and credit Know how to manage inventory Understand the time value of money Know how to improve managerial performance Understand capital budgeting decisions Understand improve managerial performance Understand sources of short-term financing Know how to consider term loans and leasing Understand long-term debt and equity financing Understand accounting conventions and recording financial data Why Choose Level 5 Accounting and Finance Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] ***Level 5: Accounting and Finance*** Detailed Course Curriculum Module 1: Essentials of Accounting and Finance Identify the Non-Financial Manager's Concern with Finance The Importance of Finance Financial and Operating Environment Module 2: Types of Cost Data and Cost Analysis The Importance of Cost Data Types of Costs How Do Your Costs Behave? Segregating Fixed Cost and Variable Cost Cost Allocation Cost Analysis What You Can Learn from the Japanese? Module 3: Contribution Analysis Should You Accept a Special Order? How Do You Determine a Bid Price? Determining Profit from Year to Year Are You Utilising Capacity? Module 4: Break-Even and Cost-Volume-Profit Analysis What is Cost-Volume-Profit Analysis? What and Why of Break-Even Sales? What is the Margin of Safety? Cash Break-Even Point What is Operating Leverage? Sales Mix Analysis Module 5: Relevant Cost and Making Short-Term Decisions What Costs Are Relevant to You? Accepting or Rejecting a Special Order Pricing Standard Products Determining Whether to Sell or Process Further Adding or Dropping a Product Line Utilising Scarce Resources Don't Forget the Qualitative Factors Module 6: Forecasting Cash Needs and Budgeting Forecasts Using Forecasts Preparing Financial Forecasts Budgets The Sales Budget The Production Budget The Direct Material Budget The Direct Labour Budget The Factory Overhead Budget The Ending Inventory The Selling and Administrative Expense Budget The Cash Budget The Budgeted Income Statement The Budgeted Balance Sheet A Shortcut Approach to Formulating the Budget Module 7: Cost Control and Variance Analysis Defining a Standard The Usefulness of Variance Analysis Setting Standards Determining and Evaluating Sales Variances Cost Variances Labour Variances Overhead Variances The Use of Flexible Budgets in Performance Reports Standards and Variances in Marketing Sales Standards Variances in Warehousing Costs Module 8: Managing Financial Assets Working Capital Financing Assets Managing Cash Properly Getting Money Faster Delaying Cash Payments Opportunity Cost of Foregoing a Cash Discount Volume Discounts Module 9: Managing Accounts Receivable and Credit Credit References Credit Policy Analysing Accounts Receivable Module 10: Managing Inventory Inventory Management Considerations Inventory Analysis Determining the Carrying and Ordering Costs The Economic Order Quantity (EOQ) Avoiding Stock Outs Determining the Reorder Point or Economic Order Point (EOP) The ABC Inventory Control Method Supply Chain Management Module 11: The Time Value of Money Future Values - How Money Grows Future Value of an Annuity Present Value - How Much Money is Worth Now? Present Value of Mixed Streams of Cash Flows Present Value of an Annuity Perpetuities Applications of Future Values and Present Values Module 12: Capital Budgeting Decisions Types of Investment Projects What Are the Features of Investment Projects? Selecting the Best Mix of Projects With a Limited Budget Income Taxes and Investment Decisions Types of Depreciation Methods How Does MACRS Affect Investment Decisions? The Cost of Capital Module 13: Improving Managerial Performance What is Return on Investment (ROI)? What Does ROI Consist of? - Du Pont Formula ROI and Profit Objective ROI and Profit Planning ROI and Return on Equity (ROE) Module 14: Sources of Short-Term Financing Trade Credit Cash Discount When are Bank Loans Advisable? Working with a Bank Issuing Commercial Paper Using Receivables for Financing Using Inventories for Financing Module 15: Considering Term Loans and Leasing Intermediate-Term Bank Loans Using Revolving Credit Insurance Company Term Loans Financing with Equipment Leasing Module 16: Long-Term Debt and Equity Financing Types of Long-Term Debt Equity Securities How Should You Finance? Module 17: Accounting Conventions and Recording Financial Data Double Entry and the Accounting Equation Assessment Method After completing each module of the Level 5: Accounting and Finance course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Level 5: Accounting and Finance course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Level 5: Accounting and Finance This course is ideal for: Candidates interested to start a career in accountancy Business owners seeking to look after their own accounts Existing accountancy workers in seeking higher positions or promotion Accountancy workers with no formal qualifications Anyone wishing to boost their career prospects. Requirements Level 5: Accounting and Finance There are no specific requirements for Level 5: Accounting and Finance course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Level 5: Accounting and Finance This course may lead you to a variety of career opportunities. Accounts Assistant Accounts Payable & Expenses Supervisor Accounts Payable Clerk Audit Trainee Payroll Administrator / Supervisor Tax Assistant / Accountant. Accounting Clerk Auditing Clerk Accounts Receivable Clerk Certificates Certificate of completion Digital certificate - Included

This certificate is intended for students who want to improve their knowledge of medication safety. They might be learners who want to obtain this training in order to advance to higher education or learners who wish to study this course in order to complement other studies. The purpose of this Safe Handling of Medication in Health & Social Care course is to provide everyone who is involved in the care sector with the essential knowledge required to provide the best professional approach to the managing and safe handling of medicines. There are no specific recommended prior learning requirements for this qualification. However, students who have already completed a Level 1 certificate may find this Safe Handling of Medication in Health & Social Care a helpful course and easy to understand. Experts say that more than half of all medication is prescribed, delivered, or sold incorrectly annually. In addition, half of all patients in the UK do not know the proper way of taking their medicine appropriately. These facts may frequently have devastating effects, especially when medicine falls into the hands of the wrong people. By finishing this, Safe Handling of Medication in Health & Social Care course, you will not only obtain a recognized certificate, but you will also build and improve your knowledge and abilities in medication handling in health and social care. Safe Handling of Medication in Health & Social Care course helps students understand the difference between medication and prescriptions A prescription comprises all of the facts, personal information, and instructions that a pharmacist needs to know about what drug to give. This course gives students a detailed understanding of medicines. Prescription medicine is one that may only be provided to a patient with the written permission of a licensed health practitioner. Prescription medications include blood pressure drugs, cancer medications, and severe pain relievers. Medication is the term used to describe the drugs and or medical devices used to treat or prevent medical disorders and is effective for use without a doctor's prescription. Safe Handling of Medication in Health & Social Care bundle course gives students a general understanding of different types of medication and their usage. You must be familiar with the names of your medicines as well as the crucial facts about how they operate. Some medications, for example, may have negative interactions with certain foods, other medications, or even nutritional supplements, making you very sick. Take the time to educate yourself with the help of this bundle Safe Handling of Medication in Health & Social Care course to enhance your knowledge. Learning Outcomes After completing this course, the learner will be able to: Gain a general understanding of different types of medication and their use. Gain in-depth knowledge of the procedures for obtaining, storing, administering and disposing of medication. Understand the legislation and the audit process related to medication and issues of responsibility and accountability. Understand the record-keeping process for medication. Why Choose Level 2 Certificate in Understanding the Safe Handling of Medication in Health & Social Care Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this Safe Handling of Medication in Health & Social Care Bundle Course Course 01: Level 2 - Safe Handling of Medication in Health & Social Care Course 02: Level 6 Diploma in Health and Social Care Management Course 03: Level 3 Award in Health and Social Care Course Course 04: Level 3 Diploma in Healthcare Support Course 05: Level 2 Health & Care Course 06: Level 2 Certificate in Preparing to Work in Adult Social Care Course 07: Level 2 Award in Support Work in Schools and Colleges Course 08: Healthcare Management Training Course 09: Safeguarding Vulnerable Adults Training Course 10: Social Worker: Social Work Diploma Course 11: Adults Support Worker Course Course 12: Mental Health Support Worker ***Other Benefits of Safe Handling of Medication in Health & Social Care Bundle Course Free 12 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course] Through this course, you will learn everything you need to know to progress. Higher education always empowers you with the appropriate equipment to move ahead. Safe Handling of Medication in Health & Social Care course will help students to have a better knowledge of the procedures for obtaining, storing, administering, and disposing of medication. From the Safe Handling of Medication in Health & Social Care course students will gain a detailed understanding of medicine. Understand that heat, air, light, and moisture can all harm medicines. If you do not know about the correct way of storing medicines, your knowledge would be incomplete. Medicines should always be kept in a cold, dry area. One needs to store it in a dresser drawer or a cabinet, for example, away from the stove, sink, and any hot appliances. Medicine can also be kept in a storage container, on a shelf, or in a cold closet. Moreover, the course also covers the topic of the correct way of disposing of medicines. However, a better knowledge of disposing of medicines reduces the risk of accidental poisoning. The course teaches students how to deliver medications safely, and how to guarantee that record keeping, and audits are performed appropriately. Safe Handling of Medication in Health & Social Care bundle course contains all of the teachings that you can simply understand and use to your abilities easily. For individuals attempting to make a profession in this field, it will help them to understand the basics and to educate them fully. The Safe Handling of Medication in Health & Social Care qualification covers the different medications and their applications. You will also learn how to administer medicines safely, and how to ensure that record-keeping and audits are completed properly. So, enroll now without any further delay to complete our exclusive bundle Safe Handling of Medication in Health & Social Care course. Course Curriculum of- *** Safe Handling of Medication in Health & Social Care *** Module 1: Understand Medication and Prescriptions Understand the use of different types of medication Understand how medicines are classified Understand legislation and guidelines related to medication Understand the roles of self and others in the medication process Know how to access information about medication Module 2: Supply, Storage and Disposal of Medication Understand how medicines are supplied and obtained Know the requirements for storing medication Understand the requirements for the safe disposal of medication Module 3: Understand the Requirements for the Safe Administration of Medication Understand the legislation and guidance in relation to administration of medicine Understand the preparation to be taken prior to administering medication Understand how medication is administered safely and in a way that meets individual needs Understand how to support individuals to administer their own medication Understand the procedures to follow when there are problems with the administration of medication Understand how the effects of medication are monitored Module 4: Record Keeping and Audit Processes for Medication Understand the audit process in relation to medication transactions and stock levels Understand how information is recorded and confidentiality maintained Understand own role in relation to accountability and responsibility Understand the importance of safeguarding individuals in relation to medication use ***GIFT Courses Curriculum: Course 01: Level 6 Diploma in Health and Social Care Management Module 01: A Quick Overview of Health and Social Care Module 02: Understanding Healthcare Module 03: Understanding Social Care Module 04: The UK Health System Module 05: Care and Support Planning Module 06: Person-Centred Care Module 07: Communication in Health and Social Care Module 08: Developing Effective Communication Skills Module 09: Developing Listening Skills Module 10: Understanding the Promotion of Equality, Diversity and Rights in Health and Social Care Setting Module 11: Responsibilities for Health and Safety Module 12: Safeguarding in Social Care Module 13: Identifying Social Risk and Needs in Health Care ----------------------- Course 02: Level 3 Award in Health and Social Care Course Module 01: Equality, Diversity and Rights in Health and Social care Module 02: Human Growth and Development Module 03: Safeguarding in Health and Social Care ----------------------- Course 03: Level 3 Diploma in Healthcare Support Module 01: Promote Personal Development in Care Settings Module 02: Promote Safeguarding and Protection in Care Settings Module 03: Promote Health, Safety and Wellbeing in Care Settings Module 04: Understand Mental Well-Being and Mental Health Promotion Module 05: Causes and Spread of Infection Module 06: Promote Communication in Care Settings Module 07: Responsibilities of a Care Worker Module 08: Promote Effective Handling of Information in Care Settings Module 09: Understand Mental Health Problems Module 10: The Principles of Infection Prevention and Control Module 11: Cleaning, Decontamination and Waste Management Module 12: Duty of Care in Care Settings Module 13: Promote Equality and Inclusion in Care Settings Module 14: Promote Person-Centred Approaches in Care Settings Module 15: Study Skills for Senior Healthcare Support Workers Module 16: Undertake Personal Hygiene Activities with Individuals Module 17: Implement Therapeutic Group Activities Module 18: Obtain a Client History Module 19: Care for the Elderly Module 20: Understand Mental Health Interventions Module 21: Understanding Suicide Interventions ----------------------- Course 04: Level 2 Health & Care Module 01: An Overview of the Safety in the Workplace Module 02: What is a Hazard Module 03: Rectifying Hazards Module 04: Implementing Proactive Measures Module 05: How to Prepare and Undertake a Safety Plan ----------------------- Course 05: Level 2 Certificate in Preparing to Work in Adult Social Care ----------------------- Course 06: Level 2 Award in Support Work in Schools and Colleges ----------------------- Course 07: Healthcare Management Training ----------------------- Course 08: Safeguarding Vulnerable Adults Training ----------------------- Course 09: Social Worker: Social Work Diploma ----------------------- Course 10: Adults Support Worker Course ----------------------- Course 11: Mental Health Support Worker Assessment Method After completing each module of the Level 2 Certificate in Understanding the Safe Handling of Medication in Health & Social Care, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This qualification is ideal for students who want to improve their knowledge of the safe handling of medicines. They might be learners who want to access this training in order to advance to higher-level qualifications or learners who want to study this programme to complement other studies. Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Safe Handling of Medication in Health & Social Care course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This Safe Handling of Medication in Health & Social Care course is designed for anyone who wants to start a career in care and wishes to handle medication. It can lead to roles such as Care Worker or Pharmacy Assistant. Certificates Certificate of completion Digital certificate - Included

Duration 3 Days 18 CPD hours There are good reasons Adobe Premiere Pro is such a popular post-production video editing software application. It excels for a wide variety of uses; tapeless and DSLR footage; cross-platforms, open workflows for easy collaboration, powerful metadata features for greater editing and production efficiency, plus real-time 3D editing and Virtual Reality. This four-day course is ideal for beginners, as well as Final Cut Pro and Avid editors - or for anyone who is involved in a content creation environment. Adobe Premiere Interface Performing Nonlinear Editing in Premiere Pro Looking at the Standard Digital Video Workflow Enhancing the Workflow with Premiere Pro Expanding the Workflow Incorporating other Components into the Editing Workflow Adobe Creative Cloud Video Workflow Touring the Premiere Pro Workspace Looking at the Workspace Layout Customizing the Workspace Introducing Preferences Keyboard Shortcuts Moving, Backing up, and Syncing User Settings Setting up a Project Setting up a Sequence Setting up the Timeline Importing Media Importing Assets Working with ingest Options and Proxy Media Working with the Media Browser Importing Images Using Adobe Stock Customizing the Media Cache Recording a Voice-over Organizing Media Project Panel Working with Bins Monitoring Footage Modifying Clips Mastering the Essentials of Video Editing Using the Source Monitor Navigating the Timeline Essential Editing Commands Working with Clips and Markers Using Program Monitor Controls Setting the Playback Resolution Playing back VR Video Using Markers Using Sync Lock and Track Lock Finding Gaps in the Timeline Selecting Clips Moving Clips Extracting and Deleting Segments Adding Transitions Understanding Transitions Edit points and Handles Adding Video Transitions Using A/B mode to Fine-tune a Transition Adding Audio Transitions Performing Advanced Editing Techniques Performing Three or Four-point Editing Changing Playback Speed Replacing Clips and Footage Nesting Sequences Performing Regular Trimming Performing Advanced Trimming Trimming in the Program Monitor Putting Clips in Motion Adjusting the Motion Effect Changing Clip Position, Size, and Rotation Working with Keyframe Interpolation Using other Motion-related Effects Multi-camera Editing Following the Multi-camera Process Creating a Multi-camera Sequence Switching Multiple Cameras Finalizing Multi-camera Editing Editing and Mixing Audio Setting up the Interface to Work with Audio Examining Audio Characteristics Creating a Voice-over Scratch Track Adjusting Audio Volume Normalizing Audio Creating a Split Edit Adjusting Audio Levels for a Clip Sweetening Sound Sweetening Sound with Audio Effects Adjusting EQ Cleaning up Noisy Audio Fading Audio with Essential Sounds Adding Video Effects Working with Effects Master Clip Effects Masking and Tracking Visual Effects Keyframing Effects Effect Presets Frequently Used Effects Improving Clips with Color Correction and Grading Following a Color-oriented Workflow An overview of Color-oriented Effects Fixing Exposure Problems Fixing Color Balance Using Special Color Effects Creating a Look Exploring Compositing Techniques Understanding an Alpha Channel Making Compositing Part of Your Projects Working with the Opacity Effect Working with Alpha-channel Transparencies Color Keying a Green Screen Shot Using Mattes Creating Titles An Overview of Shapes & Type Loading in Graphics Using the Essentials Graphic Panel Browsing Templates Saving Templates Mastering Video Typography Essentials Creating Titles Stylizing Text Making Text Roll and Crawl Introducing Captions Managing Your Projects Using the File menu Using the Project Manager Performing the Final Project Management Steps Importing Projects or Sequences Managing Collaboration Using the Libraries Panel Managing Your Hard Drives Exporting Frames, Clips, and Sequences Overview of Export Options Exporting Single Frames Exporting a Master Copy Working with Adobe Media Encoder Uploading to Social Media Exchanging with Other Editing Applications Additional course details: Nexus Humans Adobe Premiere Pro training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Adobe Premiere Pro course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Join this course to take your 3D modeling skills up a notch! Graduate to the next level of game design by learning all about the Blender to Unreal Engine 5 (UE5) professional workflow for medieval dungeon props. You will learn how to build assets in Blender and then how to import them into Unreal Engine 5 for your project.

Start your data science journey with this carefully constructed comprehensive course and get hands-on experience with Python for data science. Gain in-depth knowledge about core Python and essential mathematical concepts in linear algebra, probability, and statistics. Complete data science training with 13+ hours of content.

At Smack the Markets we offer a different way for serious traders who want a bespoke and personal approach to learning to trade. We work with a small number of new traders on a one-to-one basis at a time. This enables us to develop a program completely around you, whether you’re brand new to this business and need to start from scratch, or you have some experience but need to unlearn what’s not working and relearn new skills that do work.   Because your requirements may be unique, our bespoke programs are flexible too. We aim to work with new traders over the long term (typically as long as a year) to ensure you’ve mastered the skills and techniques we’ve taught, and also to ensure you can apply them effectively in different market conditions.   Our typical one-to-one programs will consist of weekly live online workshops covering the trading skills and techniques you need, moving gradually to monthly coaching and mentoring sessions as you become more proficient in trading on your own.   Our style of trading incorporates a combination of fundamental and technical analysis to read the markets, using one of four technical trading strategies to execute trade positions. Our strategies are suitable for all liquid markets including Indices, Forex, Commodities and Stocks.   All our bespoke programs include some access to our online trading room, so you can observe how we are using the same techniques to trade the markets ourselves. Once you have gained suitable experience in our trading methods and have a good understanding of risk management, you will be offered full membership, which will give you permanent access to the trading room and other membership services should you wish.   As a guild our bespoke one-to-one programs can range from 5 to 15+ individual sessions with prices ranging in the region of £1,500.00 to £3,000.00 depending on your requirements and current trading experience.   If you would like to discuss our bespoke one-to-one programs further, please get in touch to arrange a no obligation consultation with our head trader.

When it comes to purchasing and procurement, guesswork isn’t a strategy. This 8-in-1 Premium Courses Bundle walks you through the essentials of buying smarter, managing finance, handling supply chains, and mastering Excel. If you've ever been baffled by purchase ledgers, stock issues, or invoice trails, you're in good company—and the right bundle. The curriculum includes Purchasing and Procurement, Finance, Purchase Ledger, Financial Analysis, MS Excel, Logistics & Transportation, Supply Chain Management and Project Management. In short, it's a guided tour through the core tasks that keep businesses running like clockwork—minus the confusion and without a clipboard in sight. Learning Outcomes: Understand key principles of procurement and supplier negotiations. Learn to manage purchasing documents and payment records accurately. Use Excel for purchasing calculations, records and analysis. Grasp the flow and strategy of supply chain operations. Interpret financial data and identify trends in purchasing. Apply project management skills in procurement processes. Who is this Course For: Purchasing assistants wanting structured and focused training. Procurement professionals looking to refresh foundational knowledge. Admins involved in inventory and purchase tracking. Finance officers dealing with supplier invoicing and ledgers. Warehouse or logistics staff aiming for broader insight. Team members supporting supply chain decision-making. Career switchers exploring roles in procurement departments. Managers juggling buying decisions and project oversight. Career Path: Purchasing Assistant – £23,500 average salary Procurement Officer – £31,000 average salary Supply Chain Administrator – £26,500 average salary Logistics Coordinator – £28,000 average salary Procurement Analyst – £34,000 average salary Project Support Officer – £29,500 average salary

Helping customers buy products or services from retail organisations such as department stores, garden centres, high street chains, supermarkets and online and mail order businesses.

Register on the Microsoft Excel 2021 Course for Everyone - Complete Excel Course 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 Microsoft Excel 2021 Course for Everyone - Complete Excel Course 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 Microsoft Excel 2021 Course for Everyone - Complete Excel Course Receive an 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 Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. 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 Microsoft Excel 2021 Course for Everyone - Complete Excel 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. Course Content Section 01: Getting Started Introduction 00:03:00 Course Curriculum 00:04:00 Getting started on Windows, macOS, Android, and IOS 00:01:00 How to ask great questions 00:02:00 FAQ's 00:01:00 Starting Excel 00:04:00 Section 02: Excel Basics Introduction 00:02:00 Worksheet basics 00:22:00 Entering values and formulas 00:12:00 Data formats 00:10:00 Data handling basics - cut copy and paste 00:07:00 Save and print in excel 00:10:00 Excel Ranges 00:05:00 Section 03: Excel essential functions Introduction 00:01:00 Basic formula operations 00:06:00 Mathematical functions level 1 00:20:00 Mathematical functions level 2 00:12:00 Text functions level 1 00:09:00 Text functions level 2 00:13:00 Logical functions 00:11:00 Date time functions 00:06:00 V Lookup formula 00:12:00 HLookup formula 00:04:00 HLookup + Match formula 00:09:00 Match + Index formula 00:05:00 Section 04: XLookup only for Excel 2021 and Office 365 Introduction 00:02:00 XLookup 00:08:00 Handling #NA and Approximates match in XLookup 00:11:00 Wildcard matching in XLookup 00:06:00 Section 05: Get Data and tools Introduction 00:02:00 Split text into columns 00:07:00 Flash Fill 00:07:00 Remove Duplicates 00:08:00 Data Validation 00:07:00 Get- import Data from Text 00:06:00 Get - import Data from CSV 00:03:00 Section 06: Formatting data and tables Introduction 00:01:00 Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Number 00:05:00 Formatting Date 00:03:00 Formatting tables 00:05:00 Section 07: Pivot Tables Introduction 00:01:00 Creating Pivot Table 00:07:00 Value field settings 00:04:00 Number format 00:02:00 Pivot Table Design 00:03:00 Excel Exercise 00:01:00 Solution for Excel Exercise 00:02:00 Section 08: Excel Charts Introduction 00:01:00 Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Easy way to create charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line charts 00:02:00 Area charts 00:02:00 Pie and Doughnut charts 00:04:00 Format AreaPlot or XY chart 00:08:00 Scatter or bubble charts 00:02:00 Section 09: Advanced Excel charts Introduction 00:01:00 Frequency Distribution and Histograms 00:04:00 Waterfall charts 00:02:00 Hierarchy charts: sunburst and tree map 00:03:00 Combination charts 00:02:00 Sparklines 00:05:00 Section 10: Pivot Charts Pivot charts 00:02:00 Section 11: Maps Chart above 2019 Maps chart 00:04:00 3D Maps chart 00:03:00 Section 12: Business-Geo charts Introduction 00:01:00 Stock charts 00:02:00 Radar charts 00:02:00 Surface charts 00:02:00 Heat maps 00:04:00 Section 13: Named Ranges Indirect Name range Function 00:06:00 Named ranges 00:05:00 Section 14: Import Data into Excel Import Data from Website - Excel 2019 above 00:09:00 Import Data table from PDF file - Excel 2021 00:04:00 Section 15: Advanced Excel Product Sale Tax invoice: Tax Calculations 00:05:00 Project: Sales forecast tracker 00:07: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.

12 in 1 Career Guided Programme | Python, Data Science, ML, Tableau, SQL Programming, Data Mining, Business Analysis | 130 CPD Points | Tutor Support | Lifetime Access