3353 Courses

Discover seamless financial management with Xero – a cloud-based accounting software empowering businesses to streamline invoicing, reconcile transactions, and gain real-time insights. Take control of your finances with Xero's user-friendly interface and robust features for efficient bookkeeping and financial success.

Register on the Fraud Awareness and Prevention Training 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 Fraud Awareness and Prevention Training 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 Fraud Awareness and Prevention Training 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 Fraud Awareness and Prevention Training, 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 Module 01: Becoming a Fraud Investigator Becoming a Fraud Investigator 00:11:00 Module 02: Managing Risk and Identifying Fraud Managing Risk and Identifying Fraud 00:16:00 Module 03: The Principles of Fraud Prevention The Principles of Fraud Prevention 00:11:00 Module 04: Detecting Fraud and Finding Evidence Detecting Fraud and Finding Evidence 00:14:00 Module 05: Fraud Investigation and Response Fraud Investigation and Response 00:11:00 Module 06: UK Laws and Legislation Regarding Fraud UK Laws and Legislation Regarding Fraud 00:13: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.

Intuit QuickBooks 2008 Foundation Training Course is one of our best selling and most popular course. The Intuit QuickBooks 2008 Foundation Training is organised into 19 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 14 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? This Payroll Management course is ideal for professionals who work in a business or corporate setting, especially people who are assigned to manage accounts and payroll, as well as people who are interested in learning more about bookkeeping and payroll management. Course Content Intuit QuickBooks 2008 Foundation Training Opening QuickBooks Pro 2008 01:00:00 Accounting Basics, Part One 01:00:00 Accounting Basics, Part Two 01:00:00 Getting Started with QuickBooks 01:00:00 Getting Help in QuickBooks 00:30:00 Lists, Forms, and Registers 00:30:00 Using the Chart of Accounts 00:30:00 Using the Journal 00:30:00 Adding Items and Services 01:00:00 Adding Vendors 00:30:00 Adding Customers 00:30:00 Adding Employees 00:30:00 Sales Receipts 00:30:00 Customer Payments 00:30:00 Finance Charges 01:00:00 Setting up Invoices 00:30:00 Finishing Invoices 00:30:00 Tracking Invoices 00:30:00 Issuing Credit Memos 01:00:00 Mock Exam Mock Exam- Intuit QuickBooks 2008 Foundation Training 00:20:00 Final Exam Final Exam- Intuit QuickBooks 2008 Foundation Training 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00: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.

Register on the Quickbooks Desktop Training 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 Quickbooks Desktop Training 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 Quickbooks Desktop Training course Receive a 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 All students who successfully complete the Quickbooks Desktop Training course can instantly download their digital certificate. You can also purchase a hard copy of the Quickbooks Desktop Training course certificate, which will be delivered by post for £9.99. Who is This Course for? The Quickbooks Desktop Training is ideal for those who already work in this sector or are an aspiring professional. This Quickbooks Desktop Training 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 Quickbooks Desktop Training is open to all students and has no formal entry requirements. To study the Quickbooks Desktop Training course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path The Quickbooks Desktop Training is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Quickbooks Desktop Training and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Quickbooks Desktop Training Setting up your Chart of Accounts 00:18:00 Setting up customers and vendors and items 00:10:00 The AR Accounts Receivable Cycle 00:11:00 AP The Accounts Payable Cycle 00:08:00 Memorized Transactions 00:02:00 Creating and Customizing Reports 00:09: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.

24-Hour Flash Sale! Prices Reduced Like Never Before!! Ever wonder how successful UK businesses stay on top of their finances? In the UK businesses using accounting software like Xero grow 32% faster than those using manual methods. If you're looking to boost your career in accounting or want to gain the skills to manage your own business finances effectively, this comprehensive Xero Accounting & Bookkeeping bundle is for you! This Xero Accounting & Bookkeeping, Payroll bundle equips you with the knowledge and practical skills needed to thrive in the UK financial landscape. Learn how to use Xero, the leading accounting software, to manage Invoices, Expenses, Payroll, and Taxes with ease. Gain a deep understanding of VAT (Value Added Tax) and Depreciation Accounting, and master financial analysis techniques to generate insightful reports for informed decision-making. This Xero Accounting & Bookkeeping, Payroll, VAT & Tax Accounting Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Xero Accounting - Complete Training Course 02: Payroll Administrator Training Course 03: Introduction to VAT Online Training Course 04: Microsoft Excel Training: Depreciation Accounting Learning Outcomes of Xero Accounting & Bookkeeping Master Xero accounting software for efficient financial management. Accurately process payroll and comply with UK tax regulations. Gain in-depth understanding of VAT calculations and reporting. Utilise Excel for depreciation accounting and financial analysis. Analyse financial reports to generate valuable business insights. Develop a comprehensive understanding of UK tax accounting principles. Investing in this Xero Accounting bundle is an investment in your future. Enrol today in Xero Accounting & Bookkeeping and unlock a brighter financial future for your UK business! Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Xero Accounting - Complete Training Module 01: Xero Accounting Coursebook Module 02: Getting Started Module 03: Setting Up Of The System Module 04: Customers And Suppliers Module 05: Fixed Assets Module 06: Bank Payments And Receipts Module 07: Petty Cash Module 08: Bank Reconciliation Module 09: Business Credit Card Account Module 10: Aged Reports Module 11: Payroll And Journals Module 12: Vat Return Module 13: Correction Of Error Course 02: Payroll Administrator Training Module 01: Payroll System In The UK Module 02: Payroll Basics Module 03: Company Settings Module 04: Legislation Settings Module 05: Pension Scheme Basics Module 06: Pay Elements Module 07: The Processing Date Module 08: Adding Existing Employees Module 09: Adding New Employees Module 10: Payroll Processing Basics Course 03: Introduction to VAT Online Training Module 01: Understanding VAT Module 02: VAT Terminology and Calculation Module 03: VAT Taxable Persons Module 04: VAT Registration Module 05: VAT Rates Module 06: Invoicing and Records Module 07: VAT Application in Goods, Services and Vehicles Module 08: Supply Module 09: The VAT Return Module 10: Tips on VAT Compliance Course 04: Microsoft Excel Training: Depreciation Accounting Module 01: Introduction Module 02: Depreciation Amortisation And Related Terms Module 03: Various Methods Of Depreciation And Depreciation Accounting Module 04: Depreciation And Taxation Module 05: Master Depreciation Model Module 06: Conclusion Assessment Process Once you have completed all the modules on 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 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? nyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Accountants Finance managers Bookkeepers Business owners Finance students Career upskillers This Xero accounting software training program has been created to develop your Xero accounting skills and the overall understanding of the software. It has no association with Xero Limited and operates independently. Please note, that the certificate you receive upon completion is CPD accredited and not an official Xero certification. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Xero Certified Accountant - £25,000 to £50,000 Payroll Manager - £30,000 to £45,000 Sage 50 Accountant - £22,000 to £40,000 Financial Analyst - £30,000 to £60,000 Bookkeeper - £20,000 to £35,000 Data Analyst - £25,000 to £55,000 Certificates CPD Accredited Digital Certificate Digital certificate - £12.99 Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

***24 Hour Limited Time Flash Sale*** Xero Accounting and Bookkeeping Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Xero Accounting and Bookkeeping Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Xero Accounting and Bookkeeping bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Xero Accounting and Bookkeeping Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Xero Accounting and Bookkeeping Career Bundle: Course 01: Xero Accounting & Bookkeeping Course Course 02: Xero Advisor Course 03: Quickbooks Bookkeeping Course 04: Excel for Bookkeeping Course 05: Bookkeeping Tool: Google Sheets Course 06: Sage 50 Accounts Course 07: Payroll: Payroll Management Course 08: Accountancy at QLS Level 5 Diploma Course 09: Managerial Accounting Training Course 10: Applied Accounting Course: Mastering Financial Management Course 11: Accounts Payable Clerk Training Course 12: Making Budget & Forecast Course 13: Cost Control Process and Management Course 14: Anti-Money Laundering (AML) Course 15: Tax Accounting Diploma Course 16: Introduction to VAT Online Training Course 17: Corporate Finance: Working Capital Management Course 18: Level 4 Diploma Accounting and Business Finance Course 19: Financial Modelling for Decision Making and Business Plan Course 20: Financial Accounting Course 21: Commercial Law Course 22: Microsoft Excel Training: Depreciation Accounting Course 23: Concept of Charity Accounting Course 24: Understanding Financial Statements and Analysis Course 25: Finance Assistant Training: Level 1 & 2 Certification Course 26: Negotiation Skills Certificate Course 27: Document Control Course 28: Advanced Diploma in Microsoft Excel Course 29: Online Time Management Training Course 30: Risk Assessment & Management With Xero Accounting and Bookkeeping, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Xero Accounting and Bookkeeping today and take the first step towards achieving your goals and dreams. Why buy this Xero Accounting and Bookkeeping? Free CPD Accredited Certificate upon completion of Xero Accounting and Bookkeeping Get a free student ID card with Xero Accounting and Bookkeeping Lifetime access to the Xero Accounting and Bookkeeping course materials Get instant access to this Xero Accounting and Bookkeeping course Learn Xero Accounting and Bookkeeping from anywhere in the world 24/7 tutor support with the Xero Accounting and Bookkeeping course. Start your learning journey straightaway with our Xero Accounting and Bookkeeping Training! Xero Accounting and Bookkeeping premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Xero Accounting and Bookkeeping is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Xero Accounting and Bookkeeping course. After passing the Xero Accounting and Bookkeeping exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Xero Accounting and Bookkeeping course is ideal for: Students seeking mastery in Xero Accounting and Bookkeeping Professionals seeking to enhance Xero Accounting and Bookkeeping skills Individuals looking for a Xero Accounting and Bookkeeping-related career. Anyone passionate about Xero Accounting and Bookkeeping Requirements This Xero Accounting and Bookkeeping doesn't require prior experience and is suitable for diverse learners. Career path This Xero Accounting and Bookkeeping bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Get FREE 1 QLS Endorsed Certificate Course with 10 Additional CPD Accredited Bundle Courses in A Single Payment. With the increased regulatory scrutiny on financial transactions, the significance of KYC has soared, not just as a regulatory requirement but as a vital business practice. In the UK alone, financial crimes have been on a rise, with KYC non-compliance fines reaching over £360 million in recent years. This KYC Bundle provides foresight into the evolution of KYC and AML methodologies, preparing learners for emerging trends and technologies. Client Due Diligence will teach the process of continual evaluation of customer documents and information, as well as account monitoring to guarantee compliance. In addition, you will get knowledge about how to evaluate client risk, comply with anti-money laundering (AML) rules, and accurately pinpoint a customer's identity, financial activity, and level of risk through this course. Furthermore, you will master KYC, AML, and DPR for business operations in the UK to advance in the field. Understanding the regulatory requirements pertinent to your target sector in great detail is essential to become a KYC analyst. With a single payment, you will gain access to KYC course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This KYC Bundle Package includes: Main Course: Diploma in Know Your Customer at QLS Level 3 10 Additional CPD Accredited Premium Courses - Course 01: Customer Service Training Course 02: Effective Methods of Public Speaking and Presentation Skill Course 03: Compliance Management Course Course 04: Financial Analysis Course Course 05: Anti-Money Laundering (AML) Course 06: Functional Skills English Course 07: Customer Relationship Management Course 08: Sales and Marketing Coordinator Course 09: Workplace Productivity Course Course 10: Online Time Management Training Learning Outcomes of this Bundle: Understand the foundational principles of KYC and its importance in today's financial sector. Gain expertise in Customer Due Diligence and its critical role in KYC compliance. Comprehend the intricacies of AML regulations and how they intertwine with KYC practices. Learn the specific KYC and AML regulatory requirements for UK business operations. Identify industry-specific regulations and the obligation to adhere to KYC standards. Anticipate future trends in KYC compliance and prepare for advancements in the field. Why Choose Our Bundle? You will receive a free certificate from the Quality Licence Scheme Get a free student ID card with KYC Training Get instant access to this KYC course. Learn from anywhere in the world This is an affordable and simple to understand The KYC is an entirely online, interactive lesson with voiceover audio Lifetime access to the KYC course materials The KYC comes with 24/7 tutor support So enrol now in this KYC: Know Your Customer Today to advance your career! Take a step toward a brighter future! Here is the curriculum breakdown of main QLS Course of this KYC bundle: Diploma in Know Your Customer at QLS Level 3 Introduction to KYC Customer Due Diligence AML (Anti-Money Laundering) KYC, AML, and Data Privacy Regulations for Businesses Operations in the United Kingdom Regulations to be Complied by Industries Methods for carrying out KYC and AML and the Future of KYC Compliance Assessment Process After completing an online module from KYC bundle, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, & the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Know Your Customer at QLS Level 3 exams. CPD 285 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This KYC bundle is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Perfect for Financial compliance officers Risk management professionals Business operation managers Data privacy specialists Banking sector employees Fintech entrepreneurs Requirements No prior background or expertise is required for this KYC bundle. Career path After completing the bundle, you can develop experience and knowledge of a range of healthcare settings or job sectors such as: KYC Specialist Compliance Analyst Risk Manager Data Privacy Officer AML Investigator Financial Advisor Certificates Diploma in Know Your Customer - KYC at QLS Level 3 Hard copy certificate - Included For Additional The Quality Licence Scheme Courses, You have to pay the price based on the Level of these Courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International delivery) CPD Accredited Certificate Digital certificate - £10 Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD .

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored training courses: In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills