3590 Courses in Cardiff delivered On Demand

Description: Microsoft Excel 2007 is created for it to help everyone become more efficient with their work and has been widely used by almost everyone. This course was created to help anyone who wants to learn about Microsoft Excel 2007, from being a beginner to the advanced level user. Through this course, you will learn the importance of planning and organise when creating a worksheet. This will help you maximise the capability of this program. You will learn all the important functions and formula that are used in Microsoft Excel. This course will help you practice what you've learned and learn how to apply what you've learned in your career.This course will provide you with the necessary skills, knowledge and information of Microsoft Excel.  Who is the course for? Professionals who want to learn about Microsoft Excel 2007 features People who have an interest in knowing all the functions in Microsoft Excel 2007 Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel 2007 Complete Course - Beginners, Intermediate, Advanced is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accountant Account Assistant Administrative Assistant Administrator Bookkeeper Office Manager Personal Assistant Secretary. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Final Exam Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: As the most-used spreadsheet program in the world, learning how to use the Microsoft Excel will give you an edge in your professional career. This Microsoft Excel 2010 complete course is created to help you in learning all the functions and features of this program. Whether you are a beginner, intermediate and advanced level user, this course will help you in learning all the necessary skills, knowledge, and information about the Microsoft Excel. You will learn how to plan and organise your data using the tools in this program. You will know how to use the functions of Microsoft Excel that will help you in finishing your tasks effectively.This course will provide you with the necessary skills, knowledge and information of Microsoft Excel.  Who is the course for? Professionals who want to learn all about Microsoft Excel 2010 program. People who have an interest in knowing all the functions and features of Microsoft Excel. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel 2010 - Beginners, Intermediate, Advanced course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accountant Account Assistant Administrative Assistant Administrator Bookkeeper Office Manager Personal Assistant Secretary. Microsoft Excel 2010 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 for Beginners 00:00:00 Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Complete Course - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Excel 2010 Complete Course - Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Forex trading basics, including a market overview, types of Forex traders, the advantages and risks of trading Forex, are covered in this course.

Excel Crash Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel Crash Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Analysis of Twitter Dataset and Designing Heatmaps Introduction to the Excel crash course 00:06:00 Understanding the Twitter Dataset 00:05:00 Extracting Other Details for Analysis 00:09:00 Creating Pivot Tables 00:08:00 Applying Conditional Formatting using Color Scales 00:03:00 Adding Slicers to Dashboard 00:02:00 Applying Custom Number Formats 00:03:00 Adding Custom Images to Charts 00:11:00 Interlude - Data Manipulation Challenge 00:02:00 Adding Heatmap Legend 00:02:00 Wrapping Up - Introduction to Open Analytics 00:02:00 Advanced Currency Converter using Dynamic Arrays Introduction to Modern Excel Tables and Dynamic Arrays 00:11:00 Using Power Query for Data Manipulation 00:08:00 Applying Power Query Data Transformations 00:06:00 Structured Table Referencing 00:12:00 XLOOKUP Function and Pivot Table Calculations 00:05:00 Laundry Service Model and Invoicing Dashboard Introduction to the Project 00:01:00 Overview of the Laundry Model Project 00:04:00 Understanding the Inputs 00:03:00 Formatting the Input Tables 00:04:00 Duplicate and Combine Tables with Power Query 00:09:00 Rounding Digits in Power Query 00:02:00 Load Specific Tables from Power Query 00:02:00 Feature Extraction and Named Ranges 00:10:00 Combining Elements - Data Validation with Named Ranges 00:08:00 Combining Elements - Understanding the INDIRECT Function 00:02:00 Combining Elements - Dynamic Drop-down Menu with Data Validation 00:04:00 Combining Elements - INDEX and MATCH with Multiple Criteria 00:12:00 Understanding the MATCH Formula with Multiple Criteria 00:06:00 Business Invoice Dashboard Design 00:06:00

Excel Spreadsheet Training Course Overview Tired of staring at endless rows and columns in frustration? Would you like to transform your data into insights that impress your boss and streamline your work? Then welcome to Excel Spreadsheet Training: Your Journey from Spreadsheet Novice to Spreadsheet Ninja! At the beginning of the Excel Spreadsheet Training course, you will acquire a thorough understanding of the Excel interface, confidently navigating and leveraging its features for efficient spreadsheet management. Besides, you will learn to enter and manipulate various data types, including text, numbers, time, logical values, and graphics, ensuring accurate and diverse information representation. This course will help you increase your productivity as you master Autofill and Speedfil functionalities, streamlining your workflow and saving valuable time during data entry. Additionally, this Excel Spreadsheet Training course will assist you in developing the skills to save files effectively, ensuring data security and accessibility while maintaining a well-organized digital workspace. Expertise in formulas increases Excel efficiency. In this Excel Spreadsheet Training course, you will gain a solid foundation in Formula Basics, understand the mathematical order behind formulas, and confidently create and manipulate them to suit your analytical needs. Furthermore, you will learn the art of copying relative and absolute formulas, facilitating efficient replication of calculations across your spreadsheet. As you move deeper into the Excel Spreadsheet Training course, you will learn the tricks and techniques to manage the sheets efficiently. When you finish the course, you will be introduced to the functions enabling you to harness Excel's full potential for complex data analysis and decision-making. Without any further delay, enrol in the Excel Spreadsheet Training course to make a fast progression in your career.  Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Anti-Money Laundering (AML) Training Course Online Are you interested in learning more about anti-money laundering, or AML? With the help of this fantastic Anti-Money Laundering (AML) Training, you can progress in your career and become well-versed in AML (Anti Money Laundering). This Anti-Money Laundering (AML) Training is divided into many sections. Throughout the Anti-Money Laundering (AML) Training, you will learn a brief introduction to money laundering to comprehensive training and awareness. Also, the Anti-Money Laundering (AML) Training covers the Proceeds of Crime Act of 2002 and the development of AML (Anti Money Laundering) legislation. Moreover, the Anti-Money Laundering (AML) Training describes the responsibilities of the officer, risk management, and client handling. After finishing this Anti-Money Laundering (AML) Training, you will examine the record-keeping process and agent management system. With the help of our expert Anti-Money Laundering (AML) Training, increase your knowledge immediately! So, enrol as soon as possible. Learning Outcomes of Anti-Money Laundering (AML) Training After completing the Anti-Money Laundering (AML) Training, learners can : Discover what activities indicate the presence of money laundering through our AML: Anti-Money Laundering (AML) Training. This AML: Anti-Money Laundering (AML) Training teaches how to perform risk management and keep savings protected. Learn the roles and responsibilities of an AML(Anti Money Laundering) professional throughout the Anti-Money Laundering (AML) Training. Explore ways to keep accurate financial records and install online alerts in this Anti-Money Laundering (AML) Training. This Anti-Money Laundering (AML) Training helps to gain the ability to teach AML(Anti Money Laundering) awareness and safeguarding methods to others. Main Course: Anti-Money Laundering (AML) Training Course Free Courses are including with this Anti-Money Laundering (AML) Training Course Along with The Anti-Money Laundering (AML) Training Course, We Offer a free Risk Management Course Along with The Anti-Money Laundering (AML) Training Course, We Offer a free Financial Advisor Course Special Offers of this Anti-Money Laundering (AML) Training Course This AML: Anti-Money Laundering (AML) Training Course includes a FREE PDF Certificate. Lifetime access to this AML: Anti-Money Laundering (AML) Training Course Instant access to this AML: Anti-Money Laundering (AML) Training Course Get FREE Tutor Support to this AML: Anti-Money Laundering (AML) Training Course Anti-Money Laundering (AML) Training Course Online This AML: Certificate in Anti Money Laundering (AML) course is divided into multiple sections, ranging from A Brief Introduction of Money Laundering to all training and awareness. AML: The Proceeds of Crime Act of 2002 and the Development of Certificate in Anti Money Laundering (AML) Legislation are also covered in the course material for the Certificate in Anti Money Laundering (AML). Additionally covered in this AML: Certificate in Anti Money Laundering (AML) training are client handling, risk management, and officer responsibilities. After completing this AML: Certificate in Anti Money Laundering (AML) course, you will study the record-keeping process and agent management system. Who is this course for? Anti-Money Laundering (AML) Training Course Onlin This AML: Anti-Money Laundering (AML) Training is recommended for anybody who wants to protect their organisation and clients by learning about AML (Anti Money Laundering) legislation and how terrorist funding works. Requirements Anti-Money Laundering (AML) Training Course Online To enrol in this Anti-Money Laundering (AML) Training Course, students must fulfil the following requirements. To join in our Anti-Money Laundering (AML) Training Course, you must have a strong command of the English language. To successfully complete our Anti-Money Laundering (AML) Training Course, you must be vivacious and self driven. To complete our Anti-Money Laundering (AML) Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Anti-Money Laundering (AML) Training Course. Career path Anti-Money Laundering (AML) Training Course Online Our AML: Anti-Money Laundering (AML) Training will open up doors for various jobs including AML Officer, Compliance Officer, Risk Manager, Manager and Director.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Understanding Marginal Costing Course is designed to help individuals grasp the vital concept of marginal costing, an essential tool in financial decision-making. In today’s competitive business landscape, understanding how to calculate and apply marginal costs allows businesses to optimise operations and increase profitability. This course simplifies complex financial theories and makes them accessible for anyone looking to gain a solid foundation in cost management, whether for career progression or enhancing business performance. By the end of the course, you’ll gain a clear understanding of how marginal costing contributes to pricing decisions, cost control, and profitability analysis. It offers a clear distinction between fixed and variable costs, enabling students to make more informed decisions when analysing profit margins. With flexible online access, this course allows you to learn at your own pace, diving deep into the techniques and formulas used by financial professionals to improve business strategies. Whether you’re aiming to advance in your career or strengthen your financial acumen, Understanding Marginal Costing provides the knowledge to confidently analyse and apply costing methods effectively. 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: Introduction to Costing Methods Module 02: Understanding Marginal Costing Module 03: Cost Classification Module 4: Cost-Volume-Profit (CVP) Analysis Module 05: Decision-Making Using Marginal Costing Module 06: Contribution Margin Ratio and Profit Planning Module 07: Limitations and Criticisms of Marginal Costing Learning Outcomes Analyze costs effectively for informed decision-making. Utilize Marginal Costing strategically for financial planning. Classify costs adeptly to enhance decision-making capabilities. Implement Contribution Margin Ratio for profitable strategies. Grasp the limitations and criticisms of Marginal Costing. Enhance financial acumen for various professional pursuits. 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? Entrepreneurs seeking financial mastery. Finance enthusiasts eager to deepen their knowledge. Professionals aiming to enhance decision-making skills. Students pursuing a career in finance. Business managers seeking strategic financial insights. Aspiring analysts and consultants. Individuals preparing for financial roles. Anyone interested in mastering Marginal Costing principles. Career path Financial Analyst Management Accountant Business Consultant Cost Accountant Budget Analyst Entrepreneurial Ventures in Finance 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.

Embark on a journey through the fascinating realm of 'Digital Banking,' a course designed to revolutionize your understanding of modern finance. Picture a world where traditional banking evolves into a dynamic, technology-driven sphere. This course delves deep into the transformation from conventional banking practices to the cutting-edge landscape of 'rbs digital banking.' You'll explore the dramatic shift to Internet and Mobile Banking, unravelling the complexities of 'direct banking' concepts. Immerse yourself in the synergy of social media and banking, understanding how fintech firms are reshaping financial interactions. The course isn't just about concepts; it's a deep dive into the technological marvels like IoT, AI, ML, Blockchain, and Big Data, transforming the finance sector. Additionally, get exclusive insights into a 'CIO Wishlist' that outlines the essential elements for a comprehensive digital banking ecosystem. Learning Outcomes Comprehend the evolution from traditional to digital banking, emphasizing the role of Internet and Mobile Banking. Understand the integration of social media in banking and the impact of fintech firms on the finance sector. Gain knowledge about cutting-edge technologies like IoT, AI, ML, Blockchain, and Big Data in banking. Analyse the 'CIO Wishlist' for creating a comprehensive digital banking framework. Develop insights into the future trends and challenges in the digital banking landscape. Why buy this Digital Banking? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Digital Banking there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? Individuals interested in the transition from traditional to digital banking practices. Professionals seeking to understand the impact of fintech and social media in finance. Technology enthusiasts eager to explore IoT, AI, ML, Blockchain, and Big Data in banking. Aspiring CIOs or IT professionals aiming to understand digital banking infrastructure. Finance students or early-career bankers keen on future trends and digital banking challenges. Prerequisites This Digital Banking does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Digital Banking was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Digital Banking Manager: £45,000 - £70,000 Per Annum Fintech Analyst: £40,000 - £65,000 Per Annum Blockchain Developer: £50,000 - £80,000 Per Annum Data Scientist in Banking: £55,000 - £85,000 Per Annum AI/ML Specialist in Finance: £60,000 - £90,000 Per Annum Cybersecurity Analyst in Banking: £50,000 - £75,000 Per Annum Course Curriculum Story of Digital Banking -- An overview section Introduction 00:02:00 Moving from Traditional Banking to New-gen Banking Moving from Traditional Banking to New-gen Banking 00:08:00 Proliferation of Internet Banking, Mobile Banking and 'direct Banking' concept Proliferation of Internet Banking, Mobile Banking and 'direct Banking' concept 00:07:00 Use of Social media in Banking and arrival of Fintech Firms Use of Social media in Banking and arrival of Fintech Firms 00:09:00 Innovative technologies IOT, AI, ML, Block-chain,, Big data etc Innovative technologies IOT, AI, ML, Blockchain,, Big data etc 00:10:00 Illustrative 'CIO Wishlist' to complement or enable comprehensive digital Bank Illustrative 'CIO Wishlist' to complement or enable comprehensive digital Bank 00:10:00