3204 Accounting & Finance courses in Pontypridd delivered Online

Microsoft Excel 2019 for Beginner course teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease. Key Features of the Microsoft Excel 2019 for Beginner Course : Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life coaching Course *** (Offer Ends Soon) *** Course Curriculum The detailed curriculum outline of our Microsoft Excel 2019 for Beginner course is as follows: ***Microsoft Excel 2019*** Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Who is this course for? Anyone with a knack for learning new skills can take this Microsoft Excel 2019 for Beginner course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions. Accreditation All of our courses, including this course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. Requirements The Microsoft Excel 2019 is open to all students and has no formal entry requirements. To study the Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career path This course will give you a comprehensive understanding of the Microsoft Excel platform and assist you in pursuing several exciting employment opportunities, such as - Administrative Assistant Accountants Business Analyst Cost Estimator Data Entry Specialist Project Manager And many more! These job prospects pay an average of £15k to £55k a year in the UK. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Enhance your Excel skills with our comprehensive course covering 50 essential tips and techniques. Perfect for beginners and professionals alike, this course offers CPD accreditation and practical insights to boost your career prospects.

Master advanced Excel skills and boost your career with our Microsoft Excel Advanced Diploma Course. Gain proficiency in data analysis, understand advanced features, and develop practical expertise.

CPD Accredited | Free PDF Certificate | 20 CPD Points | Lifetime Access | Tutor Support

Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.

Master data retrieval in Excel with our XLOOKUP and VLOOKUP course. Learn to efficiently find and analyze data, enhancing your spreadsheet skills for better decision-making.

Are you looking to enhance your Quickbooks skills? If yes, then you have come to the right place. Our comprehensive course on Quickbooks will assist you in producing the best possible outcome by mastering the Quickbooks skills. The Quickbooks course is for those who want to be successful. In the Quickbooks course, you will learn the essential knowledge needed to become well versed in Quickbooks. Our Quickbooks course starts with the basics of Quickbooks and gradually progresses towards advanced topics. Therefore, each lesson of this Quickbooks course is intuitive and easy to understand. Why would you choose the Quickbooks course from Compliance Central: Lifetime access to Quickbooks course materials Full tutor support is available from Monday to Friday with the Quickbooks course Learn Quickbooks skills at your own pace from the comfort of your home Gain a complete understanding of Quickbooks course Accessible, informative Quickbooks learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Quickbooks Study Quickbooks in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Quickbooks Course Quickbooks Curriculum Breakdown of the Quickbooks Course Getting prepared - access the software and course materials Getting started Setting up the system Nominal ledger Customers Suppliers Sales ledger Purchases ledger Sundry payments Sundry receipts Petty cash VAT - Value Added Tax Bank reconciliation Payroll / Wages Reports Tasks CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Quickbooks course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Quickbooks. It is also great for professionals who are already working in Quickbooks and want to get promoted at work. Requirements To enrol in this Quickbooks course, all you need is a basic understanding of the English Language and an internet connection. Career path The Quickbooks course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Quickbooks. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

UK Self Assessment Tax Return course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in UK Self Assessment Tax Return. Our course starts with the basics of UK Self Assessment Tax Return and gradually progresses towards advanced topics. Therefore, each lesson of this UK Self Assessment Tax Return is intuitive and easy to understand. So, stand out in the job market by completing the UK Self Assessment Tax Return course. Get an accredited certificate and add it to your resume to impress your employers. Along with the UK Self Assessment Tax Return course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Breakdown of the UK Self Assessment Tax Return Course Introduction to Self Assessment Logging into the HMRC System Fill in the Self Assessment Return CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this UK Self Assessment Tax Return course. Requirements To enrol in this UK Self Assessment Tax Return course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to UK Self Assessment Tax Return. Tax Accountant: £30,000 to £50,000 per year Tax Consultant: £35,000 to £60,000 per year Tax Analyst: £25,000 to £45,000 per year Financial Advisor (specializing in tax): £35,000 to £60,000 per year Tax Compliance Officer: £25,000 to £40,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Are you ready to embark on an enlightening journey of wisdom with the ERP Project Manager bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - ERP Project Manager - CPD Certified. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Operations Management: Enterprise Resource Planning Course 02: Project Management Training Course 03: Project Management: How to Build a Project Charter Course 04: Business Analysis Course Level 5 Course 05: Leadership and Management Course Course 06: SAP Controlling (CO) - Product Costing S4HANA Course 07: Finance and Budgeting Course Course 08: Personal and Networking Skills Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the ERP Project Manager - CPD Certified bundle illuminate your path to wisdom. The ERP Project Manager - CPD Certified bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the ERP Project Manager - CPD Certified package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the ERP Project Manager bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the ERP Project Manager - CPD Certified community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the ERP Project Manager bundle. Establish robust bases across each course nestled within the ERP Project Manager bundle. Decipher intricate concepts through the articulate content of the ERP Project Manager bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the ERP Project Manager bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The ERP Project Manager bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the ERP Project Manager bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The ERP Project Manager bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the ERP Project Manager bundle allows learners to make meaningful contributions to their chosen fields. Embark on the ERP Project Manager journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the ERP Project Manager bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the ERP Project Manager bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99