687 Money Management courses delivered Online

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

Learn how to use Xero, Sage, or Quickbooks Onlines, whilst understanding the bookkeeping prinicples behind it.

To protect employees and employers in the workplace, ensure fair pay for the employees and protect children from labour, employment laws are very crucial. The employment law course online will provide you with valuable lessons on employment laws that further enhance your knowledge to ensure your rights, obligations, and responsibilities within the employer-employee relationship. From the laws regarding wages and workplace safety to discrimination and wrongful termination, this employment law training course covers everything that you need to know. Learn about the central employment laws in the most effective and sensible approach. You will also get a clear understanding of the laws concerning employment for foreign citizens and the penalty for illegal workers in the UK. In addition to that, discover the legal rights of both the employee and employer by taking the UK employment law certificate program.  Learning Outcomes Learn about the basics of Employment Law Get familiar with the legal recruitment process and employment contracts Learn about money management Get a wealth of knowledge national minimum wage and living wage Be proficient in workplace monitoring and data protection You'll also learn about the process of dismissals, grievances and employment tribunals Get a clear understanding of parental rights, sick pay and pension scheme Learn about health and safety at work Course Design Training offered by The UK employment law training course could potentially benefit a range of roles, but would particularly enhance careers in- Online study materials Mock exams Multiple-choice assessment Why Choose this Course? This is one of the best employment law courses online and suitable for anyone who wants to gain extensive knowledge, potential experience, and skills in the related field. Industry experts designed this course, so you don't have to worry about the quality. Earn a digital 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 Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate from Janets 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. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Why study this course* You will learn everything that is needed regarding The UK Employment Law. This is an excellent opportunity for anyone from any academic backgrounds to learn more and advance their learning, launch a new career or reinvigorate an existing one. Requirements The UK Employment Law Online Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career Path* Training offered by The UK Employment Law course could potentially benefit a range of roles, but would particularly enhance careers in- Employment Lawyer Legal Advising Human Resources Corporate coordinator and many more

***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.

Job costing can be a daunting task, especially when there are so many other project management responsibilities to take care of. One effective solution is Xero. Xero accounting and bookkeeping software simplifies project and job costing by providing a straightforward way to accurately record time and expenses for different jobs. In this course, you will gain all the skills you need to manage job costing in Xero efficiently and build full proficiency in this leading software. Through 11 in-depth modules, you will explore the fundamental aspects of Xero, starting with setting up staff, and finishing with project profit and loss. It includes step-by-step video training for beginners, for accurate recording, invoicing and reporting. Study as a part-time or full-time learner and gain the expertise to stay on track of your project costs. This best selling Xero Projects & Job Costing Level 2 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Xero Projects & Job Costing Level 2 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Xero Projects & Job Costing Level 2 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Xero Projects & Job Costing Level 2 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Xero Projects & Job Costing Level 2, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Xero Projects & Job Costing Level 2 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Xero Projects & Job Costing Level 2 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Learn how to master one of the most comprehensive accounting software packages on the market with these 25 Must-Know Tips for using QuickBooks Desktop. Anybody responsible for their own administration and finance will find QuickBooks to be an excellent way to manage personal or business accounting in their field. However, it can be a little challenging to organise accounts initially, and even veteran users may be missing some useful tricks. These 25 tips will put a stop to those concerns for all types of software users. This QuickBooks course guides you through a series of tips and techniques that will have you streamlining your finances in no time at all. You will be given expert tuition in every aspect of the software, from setting up security to making crucial payments and viewing double entries. The training will give you full confidence to use all the available functions of QuickBooks, and you'll soon be printing invoices and online chatting with colleagues simultaneously with its help. Find out about all the opportunities that QuickBooks holds for you by enrolling now. This best selling 25 Must-Know Tips for using QuickBooks Desktop has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth 25 Must-Know Tips for using QuickBooks Desktop is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The 25 Must-Know Tips for using QuickBooks Desktop is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The 25 Must-Know Tips for using QuickBooks Desktop is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the 25 Must-Know Tips for using QuickBooks Desktop, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the 25 Must-Know Tips for using QuickBooks Desktop will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the 25 Must-Know Tips for using QuickBooks Desktop to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Welcome To Quickbooks Online Bookkeeping Bookkeeping is a complex yet very crucial task for an organisation or a business. It requires skills and expertise to maintain accuracy in online bookkeeping. The Quickbooks Online Bookkeeping course is here to help you understand all the functions and tools of Quickbook. Within a few hours, you will know the ins and outs of Quickbook online bookkeeping. The Quickbooks Online Bookkeeping course will teach you the fundamentals of Quickbook. Step-by-step, you will learn how to write reports, paying suppliers, posting customer invoices and more. You will acquire the skills to manage payroll and calculate VAT. Every module will include new and advanced techniques of Bookkeeping and gradually increase your proficiency in this subject.  Good bookkeeping skills are always on demand. Join the Quickbooks Online Bookkeeping course to learn everything you need to become a competent bookkeeper. It will provide you with additional skills to stay ahead of the competition. Quickbooks Online Bookkeeping is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD, so you will get a career boost upon completing this course. Our Quickbooks Online Bookkeeping is packed with 42 modules and 3 hours, 53 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

  The innovative Quickbooks Desktop Level 3 has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.  This popular Quickbooks Desktop Level 3 has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Quickbooks Desktop Level 3 course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Quickbooks Desktop Level 3 is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Quickbooks Desktop Level 3 consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Quickbooks Desktop Level 3 has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Quickbooks Desktop Level 3 course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Quickbooks Desktop Level 3 has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

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