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

4054 Courses in Cardiff delivered Online

The World of Actuaries

By Online Training Academy

Uncover the secrets behind financial foresight in our captivating Actuarial Science course. Navigate through the intricate world of financial risk assessment and valuation with a curriculum meticulously designed to empower you with the skills demanded in today's dynamic financial landscape. Delve into the realm of cash flow valuation and deterministic models, gaining insights into the backbone of financial decision-making. Explore life tables, annuities, and insurance, mastering the stochastic approach to contingencies. Confront challenges posed by taxation and inflation, unravel probabilistic models, and refine individual risk assessment. Embrace the principles of premium calculation and delve into the intricacies of multiple decrement theory. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this riveting exploration, discover the art of individual risk models and the principles of premium calculation. Craft a profound understanding of multiple decrement theory, equipping yourself with indispensable knowledge for navigating the complexities of financial landscapes. Elevate your financial acumen with this comprehensive exploration of actuarial science, where each module unravels a layer of strategic financial insight. Course Curriculum Module 1: Introduction to Actuary Module 2: Actuaries and Their Environment Module 3: The Valuation of Cash Flows Module 4: The Basic Deterministic Model Module 5: The Life Table Module 6: Life Annuities Module 7: Life Insurance Module 8: The Stochastic Life Contingencies Model Module 9: The Stochastic Approach to Insurance and Annuities Module 10: Taxation and Inflation Module 11: Probabilistic Models, Uncertain Payment and Profit Testing Module 12: Individual Risk Models Module 13: Principles of Premium Calculation Module 14: Multiple Decrement Theory Learning Outcomes: Analyze and value cash flows with precision for strategic decision-making. Master the stochastic life contingencies model for advanced risk assessment. Apply principles of premium calculation to craft financially sound strategies. Develop a deep understanding of taxation and inflation in financial scenarios. Navigate uncertainties with individual risk models for robust financial planning. Acquire expertise in multiple decrement theory for comprehensive risk management. CPD 10 CPD hours / points Accredited by CPD Quality Standards The World of Actuaries 2:31:13 1: Module 1: Introduction to Actuary 12:29 2: Module 2: Actuaries and Their Environment 14:21 3: Module 3: The Valuation of Cash Flows 11:39 4: Module 4: The Basic Deterministic Model 10:50 5: Module 5: The Life Table 10:37 6: Module 6: Life Annuities 13:35 7: Module 7: Life Insurance 12:16 8: Module 8: The Stochastic Life Contingencies Model 10:46 9: Module 9: The Stochastic Approach to Insurance and Annuities 10:47 10: Module 10: Taxation and Inflation 07:58 11: Module 11: Probabilistic Models, Uncertain Payment and Profit Testing 07:58 12: Module 12: Individual Risk Models 07:11 13: Module 13: Principles of Premium Calculation 10:22 14: Module 14: Multiple Decrement Theory 09:24 15: CPD Certificate - Free 01:00 Who is this course for? Financial Analysts seeking advanced risk assessment skills. Actuarial Enthusiasts eager to delve into stochastic life contingencies models. Strategic Planners aiming to apply premium calculation principles effectively. Financial Managers wanting to master taxation and inflation dynamics. Risk Management Professionals looking to enhance individual risk modeling skills. Career path Financial Analyst Risk Manager Actuarial Consultant Investment Strategist Insurance Analyst Pension Fund Manager Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

The World of Actuaries
Delivered Online On Demand2 hours 30 minutes
£12

The World of Actuaries

By Online Training Academy

Uncover the secrets behind financial foresight in our captivating Actuarial Science course. Navigate through the intricate world of financial risk assessment and valuation with a curriculum meticulously designed to empower you with the skills demanded in today's dynamic financial landscape. Delve into the realm of cash flow valuation and deterministic models, gaining insights into the backbone of financial decision-making. Explore life tables, annuities, and insurance, mastering the stochastic approach to contingencies. Confront challenges posed by taxation and inflation, unravel probabilistic models, and refine individual risk assessment. Embrace the principles of premium calculation and delve into the intricacies of multiple decrement theory. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this riveting exploration, discover the art of individual risk models and the principles of premium calculation. Craft a profound understanding of multiple decrement theory, equipping yourself with indispensable knowledge for navigating the complexities of financial landscapes. Elevate your financial acumen with this comprehensive exploration of actuarial science, where each module unravels a layer of strategic financial insight. Course Curriculum Module 1: Introduction to Actuary Module 2: Actuaries and Their Environment Module 3: The Valuation of Cash Flows Module 4: The Basic Deterministic Model Module 5: The Life Table Module 6: Life Annuities Module 7: Life Insurance Module 8: The Stochastic Life Contingencies Model Module 9: The Stochastic Approach to Insurance and Annuities Module 10: Taxation and Inflation Module 11: Probabilistic Models, Uncertain Payment and Profit Testing Module 12: Individual Risk Models Module 13: Principles of Premium Calculation Module 14: Multiple Decrement Theory Learning Outcomes: Analyze and value cash flows with precision for strategic decision-making. Master the stochastic life contingencies model for advanced risk assessment. Apply principles of premium calculation to craft financially sound strategies. Develop a deep understanding of taxation and inflation in financial scenarios. Navigate uncertainties with individual risk models for robust financial planning. Acquire expertise in multiple decrement theory for comprehensive risk management. CPD 10 CPD hours / points Accredited by CPD Quality Standards The World of Actuaries 2:31:13 1: Module 1: Introduction to Actuary 12:29 2: Module 2: Actuaries and Their Environment 14:21 3: Module 3: The Valuation of Cash Flows 11:39 4: Module 4: The Basic Deterministic Model 10:50 5: Module 5: The Life Table 10:37 6: Module 6: Life Annuities 13:35 7: Module 7: Life Insurance 12:16 8: Module 8: The Stochastic Life Contingencies Model 10:46 9: Module 9: The Stochastic Approach to Insurance and Annuities 10:47 10: Module 10: Taxation and Inflation 07:58 11: Module 11: Probabilistic Models, Uncertain Payment and Profit Testing 07:58 12: Module 12: Individual Risk Models 07:11 13: Module 13: Principles of Premium Calculation 10:22 14: Module 14: Multiple Decrement Theory 09:24 15: CPD Certificate - Free 01:00 Who is this course for? Financial Analysts seeking advanced risk assessment skills. Actuarial Enthusiasts eager to delve into stochastic life contingencies models. Strategic Planners aiming to apply premium calculation principles effectively. Financial Managers wanting to master taxation and inflation dynamics. Risk Management Professionals looking to enhance individual risk modeling skills. Career path Financial Analyst Risk Manager Actuarial Consultant Investment Strategist Insurance Analyst Pension Fund Manager Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

The World of Actuaries
Delivered Online On Demand2 hours 30 minutes
£12

Investment Strategies

5.0(1)

By LearnDrive UK

Unlock the secrets of the wealthy by mastering diverse investment strategies designed to balance risk and reward. From value investing to real estate, cryptocurrencies to tax strategies, this course offers a holistic guide to building and sustaining wealth like never before.

Investment Strategies
Delivered Online On Demand1 hour
£5

Investment: How to Invest in All Season

5.0(1)

By LearnDrive UK

Elevate your investment skills by building a resilient all-season portfolio. This course equips you with the advanced strategies and psychological insights to make informed investment choices, regardless of market conditions. Navigate through volatility and stay committed to your long-term goals with our comprehensive guide to all-season investing.

Investment: How to Invest in All Season
Delivered Online On Demand1 hour
£5

Essentials of UK VAT

4.7(47)

By Academy for Health and Fitness

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Essentials of UK VAT course might help you get there! Expand your expertise with high-quality training - study the Essentials of UK VAT course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Essentials of UK VAT online training course. The Essentials of UK VAT course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Essentials of UK VAT course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Essentials of UK VAT training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** ***Essentials of UK VAT*** Module 1: Understanding VAT Module 2: VAT Terminology and Calculation Module 3: VAT Taxable Persons Module 4: VAT Registration Module 5: VAT Rates Module 6: Invoicing and Records Module 7: VAT Application in Goods, Services and Vehicles Module 8: Supply Module 9: The VAT Return Module 10: Tips on VAT Compliance Module 11: VAT Exemptions and Zero-Rated VAT Module 12: Miscellaneous Issues and Penalties Module 13: Making Tax Digital Assessment Process Once you have completed all the modules in the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Essentials of UK VAT
Delivered Online On Demand7 hours
£12

Enhancing Your Credit Rating Course

5.0(2)

By Training Express

Are you ready to take control of your financial future? The Enhancing Your Credit Rating Course offers you the opportunity to gain valuable insights into how credit scores are calculated, how to improve your rating, and how to maintain it effectively. Whether you're looking to secure a loan, mortgage, or simply gain better financial security, this course provides the essential knowledge you need to understand your credit report and take the necessary steps to enhance your creditworthiness. No need for face-to-face meetings or physical attendance – the course is designed for your convenience, accessible online at your own pace. Throughout the course, you will discover proven strategies to raise your credit score, the importance of managing credit responsibly, and how to navigate through any obstacles that may be holding you back. You’ll learn how to assess your credit report for inaccuracies, manage outstanding debts, and improve your financial habits in a straightforward, engaging way. This course isn’t just about numbers – it’s about making smarter financial decisions that will set you up for success, both now and in the future. Start taking control of your credit rating today, and enjoy the benefits of a better financial standing! 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: Understanding Credit Scores Module 02: Basics of Credit Reports Module 03: Factors Influencing Credit Scores Module 04: Identifying and Disputing Errors on Credit Report Module 05: Strategies for Building and Sustaining a Positive Credit Profile Module 06: Additional Tools and Resources for Credit Improvement Module 07: Best Practices for Responsible Credit Card Management Learning Outcomes Analyse credit scores' impact on financial well-being for informed decision-making. Demonstrate proficiency in interpreting and navigating credit reports effectively. Implement strategies to identify and rectify errors within credit reports. Develop a comprehensive understanding of factors influencing credit scores. Formulate and execute effective strategies for building and maintaining a positive credit profile. Utilise additional tools and resources to enhance and sustain credit improvement. 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? Individuals aiming to enhance their financial literacy. Those seeking to understand and improve their creditworthiness. Young professionals navigating the complexities of personal finance. Anyone looking to secure their financial future through smart credit management. Individuals aspiring to make informed decisions about credit-related matters. Those committed to building a positive credit history for long-term financial stability. Individuals seeking practical insights into responsible credit card management. Anyone wanting to master the art of credit improvement for financial success. Career path Financial Advisor Credit Analyst Loan Officer Banking Customer Service Representative Financial Education Consultant Debt Counsellor 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.

Enhancing Your Credit Rating Course
Delivered Online On Demand1 hour
£12

Level 5 Hospitality Management - CPD Certified

5.0(3)

By School Of Health Care

Hospitality Management: Hospitality Management Course Online This Hospitality Management: Hospitality Management Course aims to provide practical guidance and specialist knowledge on topics such as housekeeping, catering, front office operations, quality of service, and staff training requirements. This Hospitality Management: Hospitality Management Course is an in-depth training program for new managers and aspiring professionals in the hospitality and tourism industries. This Hospitality Management: Hospitality Management Course will give you a solid understanding of the hospitality industry and its key areas, with a focus on different types of hotels and hospitality roles. This Hospitality Management: Hospitality Management Course will teach you how to manage all hotel operations as well as develop an effective service management program that incorporates safety, security, quality, and cutting-edge technology. By the end of this Hospitality Management: Hospitality Management Course, you will gain all of the necessary skills and knowledge to become a successful Hotel Manager and advance your career in the Hospitality sector. Main Course: Level 5 Hospitality Management Course Free courses included with Hospitality Management: Hospitality Management Course Course 01: Level 4 Time Management Course 02: Level 2 Food Hygiene and Safety for Catering Course 03: Food Allergen Awareness Training Course 04: Level 7 Diploma in Event Management Course 05: Level 3 HACCP Training Course Special Offers of this Hospitality Management: Hospitality Management Course: This Hospitality Management: Hospitality Management Course includes a FREE PDF Certificate. Lifetime access to this Hospitality Management: Hospitality Management Course Instant access to this Hospitality Management: Hospitality Management Course 24/7 Support Available to this Hospitality Management: Hospitality Management Course [ Note: Free PDF certificate will provide as soon as completing the Hospitality Management: Hospitality Management Course] Hospitality Management: Hospitality Management Course Online Course Curriculum of Hospitality Management: Hospitality Management Course Module 01: An Overview of the Hospitality Industry Module 02: Travel and Tourism Module 03: Forces Affecting Growth and Change in the Hospitality Industry Module 05: Understanding the Management of Food and Beverage Operations Module 06: Understanding Accounting in Hospitality Module 07: Restaurant Operations Module 08: Balance Sheet and the P&L Statement Module 09: Budgets Assessment Method of Hospitality Management: Hospitality Management Course After completing Hospitality Management: Hospitality Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Hospitality Management: Hospitality Management Course After completing the Hospitality Management: Hospitality Management Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Hospitality Management: Hospitality Management Course Online This Hospitality Management: Hospitality Management Course is ideal for anyone who works in or aspires to work in the hospitality industry, which includes the following professions: - Hospitality Manager, Hotel Manager, Housekeeping Manager, Catering Manager. Requirements Hospitality Management: Hospitality Management Course Online To enrol in this Hospitality Management: Hospitality Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Hospitality Management: Hospitality Management Course. Be energetic and self-motivated to complete our Hospitality Management: Hospitality Management Course. Basic computer Skill is required to complete our Hospitality Management: Hospitality Management Course. If you want to enrol in our Hospitality Management: Hospitality Management Course, you must be at least 15 years old. Career path Hospitality Management: Hospitality Management Course Online Candidates who successfully complete our Hospitality Management: Hospitality Management Course may pursue a wide range of careers, including: Manager of Maintenance Manager of Marketing Manager of Operations Manager of Sales Event Planner

Level 5 Hospitality Management - CPD Certified
Delivered Online On Demand18 hours
£12

Advanced Excel Course (Formula, VLOOKUP & Power Query)

By SkillWise

Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced Excel Course (Formula, VLOOKUP & Power Query) Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced Excel Course (Formula, VLOOKUP & Power Query) Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Excel Course (Formula, VLOOKUP & Power Query) Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced Excel Course (Formula, VLOOKUP & Power Query) Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced Excel Course (Formula, VLOOKUP & Power Query)? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Advanced Excel Course (Formula, VLOOKUP & Power Query) 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? This Advanced Excel Course (Formula, VLOOKUP & Power Query) course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced Excel Course (Formula, VLOOKUP & Power Query) does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Advanced Excel Course (Formula, VLOOKUP & Power Query) was made by professionals and it is compatible with all PCs, Macs, 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 As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Advanced Excel Course (Formula, VLOOKUP & Power Query) is a great way for you to gain multiple skills from the comfort of your home. Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:07:00 Microsoft Excel Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Assignment Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query) 04:41:00 Order Your Certificate Order Your Certificate QLS

Advanced Excel Course (Formula, VLOOKUP & Power Query)
Delivered Online On Demand
£29

Advanced MS Office Excel Course

By SkillWise

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced MS Office Excel Course Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced MS Office Excel Course Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced MS Office Excel Course Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced MS Office Excel Course Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced MS Office Excel Course ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Advanced MS Office Excel Course 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? This Advanced MS Office Excel Course course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced MS Office Excel Course does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Advanced MS Office Excel Course was made by professionals and it is compatible with all PCs, Macs, 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 As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Advanced MS Office Excel Course is a great way for you to gain multiple skills from the comfort of your home. Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Mock Exam Final Exam

Advanced MS Office Excel Course
Delivered Online On Demand
£29

Microsoft Excel 2007 Complete Course - Beginner to Advanced

4.3(43)

By John Academy

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

Microsoft Excel 2007 Complete Course - Beginner to Advanced
Delivered Online On Demand22 hours 30 minutes
£25