3275 Accounting & Finance courses

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Access 365 Beginner Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Access 365 Beginner Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Access 365 Beginner Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Access 365 Beginner Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Access 365 Beginner ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Access 365 Beginner there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Access 365 Beginner course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Access 365 Beginner does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Access 365 Beginner was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Access 365 Beginner is a great way for you to gain multiple skills from the comfort of your home.

In today's business environment, where regulatory compliance, effective customer relationship management, and adherence to employment laws are critical, our comprehensive training bundle is designed to empower professionals to excel in these crucial areas. This suite of courses includes a Diploma in Anti-Money Laundering (AML), training in Know Your Customer (KYC) protocols, UK-specific compliance, Customer Relationship Management (CRM), and Employment Law, providing a robust foundation for those looking to enhance their organisational integrity and operational efficiency. Stand out in the job market by completing the AML Training course. Get an accredited certificate and add it to your resume to impress your employers. 05 CPD Accredited Courses are: Course 01: Diploma in Anti-Money Laundering (AML) Course 02: KYC Course 03: Compliance UK Course 04: CRM - Customer Relationship Management Course 05: Employment Law Our AML, KYC, UK Compliance, CRM, and Employment Law Training course starts with the basics of AML Training and gradually progresses towards advanced topics. Therefore, each lesson of this AML Training is intuitive and easy to understand. Key Highlights of the AML Course: Lifetime Access to all AML Learning Resources An Interactive, Online AML Course Created By Experts in the AML Field Self-Paced and 24/7 Learning Support Free Certificate After AML Course Completion Diploma in Anti-Money Laundering (AML): The Diploma in Anti-Money Laundering (AML) equips professionals with essential skills to detect and prevent financial crimes, ensure compliance with regulations, and safeguard organizational integrity. KYC (Know Your Customer): The KYC (Know Your Customer) course enhances customer verification processes, mitigating fraud risks and building trust with clients, which are vital for regulatory compliance and protecting businesses from penalties. Compliance UK: Compliance UK provides an overview of regulatory standards, ensuring businesses operate within legal boundaries to avoid penalties and maintain regulatory compliance. CRM - Customer Relationship Management: CRM focuses on enhancing customer interactions and loyalty, driving business growth through personalised experiences and effective relationship management strategies. Employment Law: The Employment Law course covers essential legal aspects of managing a workforce, ensuring businesses create a fair and compliant work environment, and mitigating legal risks. ***AML - Anti Money Laundering Course Curriculum***: Module 01: Introduction to AML Module 02: Proceeds of Crime Act 2002 Module 03: Development of AML Regulation Module 04: Responsibility of the AML Reporting Officer Module 05: AML Risk-based Approach Module 06: Customer Due Diligence Module 07: AML Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: AML Awareness and Training Quality Licence Scheme Endorsed Certificate of Achievement: Upon completing the AML course, you can order an original hardcopy certificate of achievement. This prestigious certificate, endorsed by the Quality Licence Scheme, will be titled 'Diploma in Anti Money Laundering (AML) at QLS Level 5'. Your certificate will be delivered directly to your home. The pricing scheme for the certificate is as follows: £109 GBP for addresses within the UK. Please note that delivery within the UK is free of charge. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The AML course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in AML. It is also great for professionals who are already working in AML and want to get promoted at work. Money Laundering Reporting Officer AML Analysts AML Officer Risk & Compliance Analyst Compliance Manager Requirements To enrol in this AML course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this AML training course, you may explore trendy and in-demand jobs related to this course. Such as: Compliance Officer - £30,000-£50,000/year. Risk Manager - £35,000-£60,000/year. Financial Investigator - £35,000-£60,000/year. Fraud Investigator - £30,000-£50,000/year. Corporate Finance Analyst - £40,000-£70,000/year. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - £9.99 Each hardcopy Certificate is available for £9.99. P.S. For each hardcopy certificate the delivery charge inside the UK is £3.99 and for international students it is £9.99.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Sage 50 Payroll Basics course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Sage 50 Payroll Basics course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Sage 50 Payroll Basics and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Sage 50 Payroll Basics course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Sage 50 Payroll Basics course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Sage 50 Payroll Basics will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Sage 50 Payroll Basics Module 1: Payroll Basics 00:10:00 Module 2: Company Settings 00:08:00 Module 3: Legislation Settings 00:07:00 Module 4: Pension Scheme Basics 00:06:00 Module 5: Pay Elements 00:14:00 Module 6: The Processing Date 00:07:00 Module 7: Adding Existing Employees 00:08:00 Module 8: Adding New Employees 00:12:00 Module 9: Payroll Processing Basics 00:11:00 Module 10: Entering Payments 00:12:00 Module 11: Pre-Update Reports 00:09:00 Module 12: Updating Records 00:09:00 Module 13: e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) 00:16:00 Module 15: Employee Records and Reports 00:13:00 Module 16: Editing Employee Records 00:07:00 Module 17: Process Payroll (December) 00:12:00 Module 18: Resetting Payments 00:05:00 Module 19: Quick SSP 00:10:00 Module 20: An Employee Leaves 00:13:00 Module 21: Final Payroll Run 00:07:00 Module 22: Reports and Historical Data 00:08:00 Module 23: Year-End Procedures 00:09:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Get ready for an exceptional online learning experience with the Money, Banking, Monetary Policy, TAX, Accounting, Economics, Finance, Investment & AML bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Money, Banking, Monetary Policy, TAX, Accounting, Economics, Finance, Investment & AML is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Money & Banking package has something for everyone. As part of the Money, Banking, Monetary Policy, TAX, Accounting, Economics, Finance, Investment & AML package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Money & Banking bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: Central Banking Monetary Policy Digital Banking Bank Teller Raise Money and Valuation for Business Banking and Finance Accounting Statements Financial Analysis UK Tax Accounting Introduction to VAT Applied Economics Anti Money Laundering & Countering of Terrorist Financing Introduction to Accounting Capital Budgeting & Investment Decision Rules Debt Management - Online Course Hacked Credit and Debit Card Recovery Course Finance Principles Financial Reporting Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Money & Banking Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with Money & Banking Bundle. Build a strong knowledge base in your chosen course via Money & Banking Bundle. Benefit from the flexibility and convenience of online learning. With the Money & Banking package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Money, Banking, Monetary Policy, TAX, Accounting, Economics, Finance, Investment & AML, a rich anthology of 15 diverse courses. Each course in the Money & Banking bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisMoney, Banking, Monetary Policy, TAX, Accounting, Economics, Finance, Investment & AML bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Money, Banking, Monetary Policy, TAX, Accounting, Economics, Finance, Investment & AML bundle offers you the flexibility and convenience to learn at your own pace. Make the Money & Banking package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Money, Banking, Monetary Policy, TAX, Accounting, Economics, Finance, Investment & AML bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Money, Banking, Monetary Policy, TAX, Accounting, Economics, Finance, Investment & AML bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Money & Banking bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Unveil the intricate world of financial operations with our comprehensive programme. Discover the nuances of managing vendor relationships, processing invoices, and utilising cutting-edge technologies. Navigate through the intricacies of purchase ledger management and master financial budgeting, auditing, and reporting. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this dynamic course, you'll gain expertise in vendor management, understanding the pulse of invoice and payment processing. Immerse yourself in the latest technologies revolutionising the accounts payable landscape. Unleash your potential in purchase ledger management, and become adept at financial budgeting, auditing, and reporting. As you embark on this journey, grasp the core concepts that will empower your career in the heart of financial processes. Course Curriculum Module 01: Introduction to Accounts Payable Processing Module 02: Vendor Management Module 03: Invoice & Payment Processing Module 04: Technologies in Accounts Payable Processing Module 05: Purchase Ledger Management Module 06: Financial Budgeting, Auditing, and Reporting Learning Outcomes: Efficiently manage vendor relationships for seamless financial transactions. Master the art of processing invoices and payments with precision. Navigate and utilise the latest technologies in accounts payable processing. Gain insights into the intricacies of purchase ledger management. Develop proficiency in financial budgeting, ensuring optimal resource allocation. Acquire the skills for meticulous financial auditing and reporting. CPD 10 CPD hours / points Accredited by CPD Quality Standards Mastering Accounts Payable Procedures 1:31:15 1: Module 01: Introduction to Accounts Payable Processing 15:48 2: Module 02: Vendor Management 15:30 3: Module 03: Invoice & Payment Processing 12:19 4: Module 04: Technologies in Accounts Payable Processing 17:45 5: Module 05: Purchase Ledger Management 11:13 6: Module 06: Financial Budgeting, Auditing, and Reporting 17:40 7: CPD Certificate - Free 01:00 Who is this course for? Finance professionals seeking advanced skills in accounts payable processing. Business administrators aiming to enhance financial management capabilities. Aspiring financial analysts looking to delve into purchase ledger management. Accountants keen on mastering the intricacies of financial budgeting and auditing. Individuals aspiring to excel in financial reporting and analysis roles. Career path Accounts Payable Specialist Financial Analyst Purchase Ledger Clerk Audit Assistant Finance Manager Reporting Analyst Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Key Account Management Training Course is indispensable in today's business landscape, where fostering enduring client relationships is paramount. Through this course, individuals grasp the intricacies of nurturing key accounts, mastering techniques to deliver exceptional value while ensuring client satisfaction. Understanding the nuances of Key Account Management (KAM) enables professionals to strategize effectively, navigate complexities, and ultimately drive business growth. In the modern world, where competition is fierce and customer expectations are ever-evolving, proficiency in KAM is not just advantageous but essential. Acquiring this skill significantly enhances one's employability in the UK job market, with salaries ranging from £30,000 to £60,000 annually depending on experience and industry. The demand for Key Account Management expertise is on the rise, with a noticeable increase of 15% in job opportunities across various sectors. Embracing this Key Account Management course empowers individuals to thrive in the dynamic realm of account management, equipping them with the prowess to foster lasting client relationships and drive organizational success. Key Features: CPD Certified Key Account Management Course Free Certificate from Reed CIQ Approved Key Account Management Course Developed by Specialist Lifetime Access Course Curriculum: Module 01: Introduction to Key Account Management Module 02: Purpose of Key Account Management Module 03: Understanding Key Accounts Module 04: Elements of Key Account Management Module 05: What Makes a Good Key Account Manager Module 06: Building and Delivering Value to Key Accounts Module 07: Key Account Planning Module 08: Business Customer Marketing and Development Module 09: Developing Key Relationships Module 10: The Importance of Record Keeping for Key Account Management Module 11: Internal KAM Aspects Module 12: The Value Proposition Learning Outcomes: Analyze key account objectives and strategies for effective implementation. Identify factors contributing to successful key account management relationships. Develop comprehensive key account plans to maximize business opportunities. Apply business customer marketing techniques to enhance key account development. Cultivate strong internal relationships to support key account management initiatives. Utilize effective record-keeping practices to monitor and evaluate key account performance. CPD 10 CPD hours / points Accredited by CPD Quality Standards Key Account Management Training 3:21:16 1: Module 01: Introduction to Key Account Management Preview 17:02 2: Module 02: Purpose of Key Account Management 16:38 3: Module 03: Understanding Key Accounts 14:48 4: Module 04: Elements of Key Account Management 20:26 5: Module 05: What Makes a Good Key Account Manager 21:23 6: Module 06: Building and Delivering Value to Key Accounts 13:06 7: Module 07: Key Account Planning 14:11 8: Module 08: Business Customer Marketing and Development 17:50 9: Module 09: Developing Key Relationships 23:40 10: Module 10: The Importance of Record Keeping for Key Account Management 10:08 11: Module 11: Internal KAM Aspects 15:52 12: Module 12: The Value Proposition 15:12 13: CPD Certificate - Free 01:00 Who is this course for? This Key Account Management Training course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Key Account Management Training. Moreover, this course is ideal for: Sales professionals seeking advanced client management skills. Marketing managers aiming to strengthen customer relationships. Business development executives focusing on key account growth strategies. Account managers transitioning to key account management roles. Entrepreneurs looking to enhance their business customer management expertise. Requirements There are no requirements needed to enrol into this Key Account Management Training course. We welcome individuals from all backgrounds and levels of experience to enrol into this Key Account Management Training course. Career path After finishing this Key Account Management Training course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Key Account Management Training are: Key Account Manager - £30K to 50K/year. Business Development Executive - £25K to 35K/year. Sales Manager - £35K to 60K/year. Account Director - £40K to 70K/year. Marketing Manager - £30K to 50K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Unveil the intricate world of financial operations with our comprehensive programme. Discover the nuances of managing vendor relationships, processing invoices, and utilising cutting-edge technologies. Navigate through the intricacies of purchase ledger management and master financial budgeting, auditing, and reporting. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this dynamic course, you'll gain expertise in vendor management, understanding the pulse of invoice and payment processing. Immerse yourself in the latest technologies revolutionising the accounts payable landscape. Unleash your potential in purchase ledger management, and become adept at financial budgeting, auditing, and reporting. As you embark on this journey, grasp the core concepts that will empower your career in the heart of financial processes. Course Curriculum Module 01: Introduction to Accounts Payable Processing Module 02: Vendor Management Module 03: Invoice & Payment Processing Module 04: Technologies in Accounts Payable Processing Module 05: Purchase Ledger Management Module 06: Financial Budgeting, Auditing, and Reporting Learning Outcomes: Efficiently manage vendor relationships for seamless financial transactions. Master the art of processing invoices and payments with precision. Navigate and utilise the latest technologies in accounts payable processing. Gain insights into the intricacies of purchase ledger management. Develop proficiency in financial budgeting, ensuring optimal resource allocation. Acquire the skills for meticulous financial auditing and reporting. CPD 10 CPD hours / points Accredited by CPD Quality Standards Mastering Accounts Payable Procedures 1:31:15 1: Module 01: Introduction to Accounts Payable Processing 15:48 2: Module 02: Vendor Management 15:30 3: Module 03: Invoice & Payment Processing 12:19 4: Module 04: Technologies in Accounts Payable Processing 17:45 5: Module 05: Purchase Ledger Management 11:13 6: Module 06: Financial Budgeting, Auditing, and Reporting 17:40 7: CPD Certificate - Free 01:00 Who is this course for? Finance professionals seeking advanced skills in accounts payable processing. Business administrators aiming to enhance financial management capabilities. Aspiring financial analysts looking to delve into purchase ledger management. Accountants keen on mastering the intricacies of financial budgeting and auditing. Individuals aspiring to excel in financial reporting and analysis roles. Career path Accounts Payable Specialist Financial Analyst Purchase Ledger Clerk Audit Assistant Finance Manager Reporting Analyst Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Overview This comprehensive course on Advanced Excel Course (Formula, VLOOKUP & Power Query) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Advanced Excel Course (Formula, VLOOKUP & Power Query) comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Advanced Excel Course (Formula, VLOOKUP & Power Query). It is available to all students, of all academic backgrounds. Requirements Our Advanced Excel Course (Formula, VLOOKUP & Power Query) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 5 sections • 41 lectures • 02:56:00 total length •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00 •Assignment - Advanced Excel Course (Formula, VLOOKUP & Power Query): 00:00:00

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00

Overview This comprehensive course on New Functions in Microsoft Excel 2021 will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This New Functions in Microsoft Excel 2021 comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this New Functions in Microsoft Excel 2021. It is available to all students, of all academic backgrounds. Requirements Our New Functions in Microsoft Excel 2021 is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 10 lectures • 01:11:00 total length •Introduction and Agenda: 00:07:00 •RANDARRAY: 00:04:00 •UNIQUE: 00:05:00 •SEQUENCE: 00:04:00 •SORT and SORTBY: 00:09:00 •SORT A Practical Example: 00:04:00 •FILTER: 00:07:00 •FILTER A Practical Example: 00:08:00 •Other Useful New Functions: 00:15:00 •Using the New Functions in Reports: 00:08:00