727 Courses delivered Online

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Accountancy will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Accountancy will help you keep ahead of the pack. The Accountancy incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this Accountancy will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Accountancy, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Accountancy course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Accountancy? Course 01: Accounting and Tax Course 02: Diploma in Quickbooks Bookkeeping Course 03:Team Management Course 04: Payroll Management - Diploma Course 05: Xero Course 06: Sage 50 Training Course 07: Microsoft Excel Training: Depreciation Accounting Course 08: Applied Business Analysis Diploma Course 09: GDPR Data Protection Level 5 Course 10: Microsoft Excel Level 3 As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Accountancy to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Accountancy: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum of Accountancy Bundle Course 01: Accountancy Module 01: Introduction to Accounting Module 02: The Role of an Accountant Module 03: Accounting Concepts and Standards Module 04: Double-Entry Bookkeeping Module 05: Balance Sheet Module 06: Income statement Module 07: Financial statements Module 08: Cash Flow Statements Module 09: Understanding Profit and Loss Statement Module 10: Financial Budgeting and Planning Module 11: Auditing Course 02: Accounting and Tax Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Payee, Payroll and Wages Module 07: Value Added Tax Module 08: Corporation Tax Module 09: Double Entry Accounting Module 10: Management Accounting and Financial Analysis Module 11: Career as a Tax Accountant in the UK Course 03: Diploma in Quickbooks Bookkeeping 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 Course 05: Payroll Management - Diploma Sage 50 Payroll for Beginners Payroll Basics Company Settings Legislation Settings Pension Scheme Basics Pay Elements The Processing Date Adding Existing Employees Adding New Employees Payroll Processing Basics And Many More... Sage 50 Payroll Intermediate Level The Outline View and Criteria Global Changes Timesheets Departments and Analysis Holiday Schemes Recording Holidays Absence Reasons Statutory Sick Pay And Many More... Course 06: Xero Introduction Getting Started Invoices and Sales Bills and Purchases Bank Accounts Products and Services Fixed Assets Payroll VAT Returns Course 07: Sage 50 Training Module 1: Payroll Basics Module 2: Company Settings Module 3: Legislation Settings Module 4: Pension Scheme Basics Module 5: Pay Elements Module 6: The Processing Date Module 7: Adding Existing Employees Module 8: Adding New Employees Module 9: Payroll Processing Basics Module 10: Entering Payments Module 11: Pre-Update Reports Module 12: Updating Records Module 13: e-Submissions Basics Module 14: Process Payroll (November) Module 15: Employee Records and Reports Module 16: Editing Employee Records Module 17: Process Payroll (December) Module 18: Resetting Payments Module 19: Quick SSP Module 20: An Employee Leaves Module 21: Final Payroll Run Module 22: Reports and Historical Data Module 23: Year-End Procedures Sage 50 Payroll Advanced Diploma Module 1: The Outline View and Criteria Module 2: Global Changes Module 3: Timesheets Module 4: Departments and Analysis Module 5: Holiday Schemes Module 6: Recording Holidays Module 7: Absence Reasons Module 8: Statutory Sick Pay Module 9: Statutory Maternity Pay Module 10: Student Loans Module 11: Company Cars Module 12: Workplace Pensions Module 13: Holiday Funds Module 14: Roll Back Module 15: Passwords and Access Rights Module 16: Options and Links Module 17: Linking Payroll to Accounts Course 08: Microsoft Excel Training: Depreciation Accounting Introduction Depreciation Amortization and Related Terms Various Methods of Depreciation and Depreciation Accounting Depreciation and Taxation Master Depreciation Model Conclusion Course 09: Applied Business Analysis Diploma Module 01: Introduction to Business Analysis Module 02: Business Processes Module 03: Business Analysis Planning and Monitoring Module 04: Strategic Analysis and Product Scope Module 05: Solution Evaluation Module 06: Investigation Techniques Module 07: Ratio Analysis Module 08: Documenting and Managing Requirements Module 09: Career Prospect as a Business Analyst in the UK Course 10: GDPR Data Protection Level 5 Module 01: GDPR Basics Module 02: GDPR Explained Module 03: Lawful Basis for Preparation Module 04: Rights and Breaches Module 05: Responsibilities and Obligations Course 11: Microsoft Excel Level 3 Microsoft Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Excel Templates CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Accountancy bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Accountancy 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 Having these various expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Understanding financial management is crucial for the success of any business. In fact, studies have shown that poor financial management is one of the leading causes of business failure. That's why our Payroll, Tax, Accounting & Business Administration bundle is so important. Whether you're looking to enhance your CV or boost your business acumen, our bundle has something for everyone. Dive into the world of payroll management and gain an in-depth understanding of the intricacies of employee compensation. Develop your accounting skills with our introduction to accounting and accounting and tax courses, and learn to use Xero Projects & Job Costing software like a pro. Our Employment Law Level 3 and Certificate in Anti Money Laundering (AML) courses will give you the knowledge you need to stay on top of regulatory requirements, while our Financial Analysis and Data Analysis in Microsoft Excel Complete Training courses will equip you with the tools you need to make informed business decisions. And it's not just technical skills - our Business Administration Level 3, Decision Making, and Effective Communication Skills Diploma courses will teach you essential soft skills that are vital in any workplace. With hardcopy and PDF certificates included, you'll have tangible proof of your newfound expertise. Invest in yourself and take the first step towards a brighter future. Enrol in our Payroll, Tax, Accounting & Business Administration bundle today. Learning Outcomes of Payroll, Tax, Accounting & Business Administration Upon completion of this course bundle, you will be able to: Gain a comprehensive understanding of payroll management and tax regulations. Develop skills in accounting and financial analysis to make informed business decisions. Learn how to use Xero Projects and Job Costing to manage project finances effectively. Understand employment law and the role of Anti-Money Laundering (AML) regulations in business. Develop proficiency in data analysis using Microsoft Excel. Learn effective communication skills to enhance interpersonal relationships in the workplace. Develop the ability to make strategic business decisions based on critical thinking and problem-solving. Acquire knowledge and skills in business administration to manage and lead a team. This Payroll, Tax, Accounting & Business Administration Bundle Consists of the following Premium courses: Course 01: Payroll Management Course Course 02: Introduction to Accounting Course 03: Accounting and Tax Course 04: Xero Projects & Job Costing Course 05: Employment Law Level 3 Course 06: Certificate in Anti Money Laundering (AML) Course 07: Financial Analysis Course 08: Data Analysis in Microsoft Excel Complete Training Course 09: Business Administration Level 3 Course 10: Decision Making Course 11: Effective Communication Skills Diploma So, enrol now in this Payroll, Tax, Accounting & Business Administration to advance your career! Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses of our Payroll, Tax, Accounting & Business Administration Bundle Certificate, student ID for the title course are included with this Payroll, Tax, Accounting & Business Administration Bundle Full tutor support available from Monday to Friday with this Payroll, Tax, Accounting & Business Administration Free up your time - don't waste time and money travelling for classes Accessible, informative modules of Payroll, Tax, Accounting & Business Administration designed by expert instructors Get 24/7 help or advice from our email and live chat teams Learn at your ease - anytime, from anywhere Study the Payroll, Tax, Accounting & Business Administration course from your computer, tablet or mobile device CPD accredited Payroll, Tax, Accounting & Business Administration bundle - improve the chance of gaining professional skills Payroll, Tax, Accounting & Business Administration Curriculum of Payroll, Tax, Accounting & Business Administration Bundle Course 01: Payroll Management Course Payroll System in the UK Basics Company Settings Legislation Settings Pension Scheme Basics Pay Elements The Processing Date Adding Existing Employees Adding New Employees Processing Basics Entering Payments Pre-Update Reports Updating Records e-Submissions Basics Process Payroll (November) Employee Records and Reports Editing Employee Records Process Payroll (December) Resetting Payments Quick SSP An Employee Leaves Final Payroll Run Reports and Historical Data Year-End Procedures Course 2: Introduction to Accounting Section 01: Accounting Fundamental Section 02: Accounting Policies Course 3: Accounting and Tax Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Payee, Payroll and Wages Module 07: VAT Module 08: Corporation Tax Module 09: Double Entry Accounting Module 10: Management Accounting and Financial Analysis Module 11: Career as a Tax Accountant in the UK Course 4: Xero Projects & Job Costing Module 01: Introduction Module 02: Getting Started Module 03: Setting up Staff Module 04: Small Project Example Module 05: Quotes Module 06: Products & Services Module 07: Invoicing Module 08: Reporting Module 09: Bigger Project Example Module 10: Projects and Profit & Loss Module 11: Thank You Course 5: Employment Law Level 3 Module 01: Basic of Employment Law Module 02: Legal Recruitment Process Module 03: Employment Contracts Module 04: Employee Handbook Module 05: Disciplinary Procedure Module 06: National Minimum Wage & National Living Wage Module 07: Parental Right, Sick Pay & Pension Scheme Module 08: Discrimination in the Workplace Module 09: Health & Safety at Work Module 10: Dismissal, Grievances and Employment Tribunals Module 11: Workplace Monitoring & Data Protection Course 6: Certificate in Anti Money Laundering (AML) Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Course 7: Financial Analysis Module 01: Introduction Module 02: Profitability Module 03: Return Ratio Module 04: Liquidity Ratio Module 05: Operational Analysis Module 06: Detecting Manipulation Course 8: Data Analysis in Microsoft Excel Complete Training Module 01: Modifying a Worksheet Module 02: Working with Lists Module 03: Analyzing Data Module 04: Visualizing Data with Charts Module 05: Using PivotTables and PivotCharts Module 06: Working with Multiple Worksheets and Workbooks Module 07: Using Lookup Functions and Formula Auditing Module 08:Automating Workbook Functionality Module 09:Creating Sparklines and Mapping Data Module 10:Forecasting Data Course 9: Business Administration Level 3 Module 01: Representing Your Boss and Company Module 02: Skills of an Effective Administrator Module 03: Business Writing Skills Module 04: Communication Skills Module 05: Business Telephone Skills Module 06: Mail Services and Shipping Module 07: Travel Arrangements Module 08: Organising Meeting and Conferences Module 09: Time Management Module 10: Record Keeping and Filing Systems Module 11: Effective Planning and Scheduling Course 10: Decision Making Module 01: What is Decision Making? Module 02: Stress and Its Impact Module 03: Time Stress and Decision Making Module 04: Personal Level Decision making Under Stress Module 05: Organisational Level Decision making Under Stress Module 06: Decision Making for Conflict Management Course 11: Effective Communication Skills Diploma Module 01: Business Communication Module 02: Verbal and Non-verbal Communication Module 03: Written Communication Module 04: Electronic Communication Module 05: Communicating with Graphics Module 06: Effectively Working for Your Boss CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Payroll, Tax, Accounting & Business Administration This Payroll, Tax, Accounting & Business Administration bundle is perfect for: Individuals looking to start a career in accounting and business administration. Accounting and finance professionals looking to upskill and stay up-to-date with industry standards. Business owners or managers looking to gain a deeper understanding of financial management and business administration. Anyone interested in a career in payroll management, financial analysis, or business administration. Those looking to progress into senior roles within accounting and business administration. Requirements Payroll, Tax, Accounting & Business Administration This Payroll, Tax, Accounting & Business Administration course has been designed to be fully compatible with tablets and smartphones. Career path This Payroll, Tax, Accounting & Business Administration bundle will be beneficial for anyone looking to pursue a career as: Payroll Manager: £23,000 - £45,000 per annum. Financial Analyst: £25,000 - £50,000 per annum. Business Administration Manager: £22,000 - £55,000 per annum. Tax Manager: £30,000 - £65,000 per annum. Finance Director: £70,000 - £120,000 per annum. Certificates Certificate of completion Digital certificate - Included

Register on the Business Data Analysis today and build the experience, skills and knowledge you need to enhance your expert 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 an e-certificate as proof of your course completion. The Business Data Analysis 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 Business Data Analysis Receive a e-certificate upon successful completion of the course Get taught by experienced, expert 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 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 of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. 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 In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring expert. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain an expert lesson to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Business Data Analysis, 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 Business Data Analysis Module 01: Introduction to Business Analysis 00:14:00 Module 2: Business Environment 00:16:00 Module 3: Business Processes 00:44:00 Module 4: Business Analysis Planning and Monitoring 00:27:00 Module 5: Strategic Analysis and Product Scope 00:28:00 Module 6: Solution Evaluation 00:24:00 Module 7: Investigation Techniques 00:45:00 Module 8: Ratio Analysis 00:26:00 Module 9: Stakeholder Analysis and Management 00:22:00 Module 10: Process Improvement with Gap Analysis 00:25:00 Module 11: Documenting and Managing Requirements 00:26:00 Module 12: Business Development and Succession Planning 00:24:00 Module 13: Planning & Forecasting Operations 00:21:00 Module 14: Business Writing Skills 00:39:00 Order Your Certificate Order your Certificate QLS 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.

Schedule & Cost Control Skills is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Project Management and looks at skills needed to improve in relevant industry or Management. By taking this course you will gain the necessary skills to perform effectively in this field. The Schedule & Cost Control Skills 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 4 Hours, 45 Minutes! 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 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 of Achievement 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. Course Content Quick PM Review PM Review 00:13:00 PMI-SP 00:11:00 Time Management Time Management 00:20:00 Schedules 00:21:00 Estimating 00:17:00 Critical Path Method Critical Path Method 00:05:00 Critical Path Model 00:10:00 Resource Leveling 00:13:00 Basic Cost Management Basic Cost Management 00:11:00 Estimating 00:09:00 Introduction to Earned Value Introduction to Earned Val ue 00:13:00 Forecasting 00:12:00 Cumulative Cost Curve 00:05:00 Critical Chain Management Possible Paths 00:17:00 The Results 00:18:00 Possible Paths 00:17:00 Other Cost Calculations Other Cost Calculations 00:14:00 Payback Period 00:07:00 Common Depreciation Conventions 00:12:00 Mock Exam Mock Exam- Schedule & Cost Control Skills 00:20:00 Final Exam Final Exam- Schedule & Cost Control Skills 00:20:00 Assignment Assignment - Schedule & Cost Control Skills 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 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.

14 in 1 "Retail Assistant Training" Bundle only at £79 Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Retail Assistant Training course you are looking for? Can't find the complete Training package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Retail and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one bundle has been designed by industry experts. We prioritised what learners were looking for in a complete Retail Assistant Training package and developed this in-demand course that will enhance your skills and prepare you for the competitive job market. Furthermore, to help you showcase your expertise in Retail, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Retail Assistant Training Bundle Consists of the following Premium courses: Course 01: Retail Management - Level 5 Course 02: Logistic Management Course 03: Retail Strategy Course 04: Basic Product Management Course 05: Purchasing & Procurement Course - Level 3 Course 06: Level 3 Tax Accounting Course 07: Introduction to VAT Course 08: Commercial Law 2021 Course 09: Operations Management Course 10: Strategic Planning and Analysis for Marketing Course 11: Sales Negotiation Training Course 12: Basic Business Finance Course 13: Diploma in Quickbooks Bookkeeping Course 14: Customer Relationship Management Enrol now to advance your career, and use the premium study materials from Apex Learning. Benefits you'll get from choosing Apex Learning for this Retail Assistant Training: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID included in a one-time fee Free up your time - don't waste time and money travelling for classes Learn anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum Course 01: Retail Management - Level 5 Module 01: Introduction to Retail Management Module 02: Retail Strategy Module 03: Retail Buying and Merchandising Module 04: Retail Pricing Module 05: Supply Chain Management in Retailing Module 06: The Sales Process and Dealing with Customers at the Checkout Module 07:Importance of Consumer Behaviour Module 08: Taking Trends and Targeting Customers Effectively Module 09: The Importance of Communicating with Customers Module 10: Choosing a Retail Location Module 11: Retail Psychology Module 12: Negotiate the Right Deal with Suppliers Module 13: Develop Store Security Procedures Module 14: Management Skills for Leading Your Team Module 15: Selling in Multiple Channels Module 16: Retail Brand Management Module 17: Health & Safety for Retail Stores Module 18: Consumer Rights Act Course 02: Logistic Management Module 01: Introduction to Logistic Management Module 02: Planning Framework for Logistics Module 03: Supply Chain Management Module 04: Logistics Management and Organisation Module 05: Sourcing, Purchasing, and Procurement Module 06: Channels of Distribution Module 07: Supplier Relationship Management Module 08: Inventory Planning and Management Module 09: Principles of Warehousing Module 10: Transport Management Module 11: Negotiation Techniques Module 12: Customer Service and Logistics Course 03: Retail Strategy Module 01: Introduction to Retail Management Module 02: Retail Strategy Module 03: Retail Buying and Merchandising Module 04: Retail Pricing Module 05: Supply Chain Management in Retailing Module 06: The Sales Process and Dealing with Customers at the Checkout Module 07:Importance of Consumer Behaviour Module 08: Taking Trends and Targeting Customers Effectively Module 09: The Importance of Communicating with Customers Module 10: Choosing a Retail Location Module 11: Retail Psychology Module 12: Negotiate the Right Deal with Suppliers Module 13: Develop Store Security Procedures Module 14: Management Skills for Leading Your Team Module 15: Selling in Multiple Channels Module 16: Retail Brand Management Module 17: Health & Safety for Retail Stores Module 18: Consumer Rights Act Course 04: Basic Product Management Module 01: Course Introduction - Product Module 02: Definition of Product Module 03: Classification of Product Module 04: Consumer Goods Module 05: Business Goods Module 06: Levels of a Product Module 07: Product Quality Module 08: Product Mix Module 09: Product Life Cycle Module 10: Branding Module 11: Branding Strategies Module 12: Brand Equity Course 05: Purchasing & Procurement Course - Level 3 Module 01: Supply Chain Basics Module 02: Role of Procurement in an Organisation Module 03: The Purchasing Cycle Module 04: Purchasing Toolkits Module 05: Managing Competitive Bids Module 06: Quality Management Module 07: Supplier Relationship Management Module 08: Analysing and Reducing Risk in the Supply Chain Module 09: Improving Efficiency and Accuracy Module 10: Category Management Module 11: Inventory Management Module 12: E-Procurement Course 06: Level 3 Tax Accounting Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Advanced Income Tax Module 07: Payee, Payroll and Wages Module 08: Capital Gain Tax Module 09: Value Added Tax Module 10: Import and Export Module 11: Corporation Tax Module 12: Inheritance Tax Module 13: Double Entry Accounting Module 15: Career as a Tax Accountant in the UK Course 07: Introduction to VAT 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 Module 11: VAT Exemptions and Zero-Rated VAT Module 12: Miscellaneous VAT Issues and Penalties Module 13: Making Tax Digital Course 08: Commercial Law 2021 Module 01: Introduction of Commercial law Module 02: Business Organisations Module 03: International Trade: the Theory, the Institutions, and the Law Module 04: Sales of Goods Law Module 05: Consumer Law and Protection Module 06: E-Commerce Law Module 07: Competition Law Course 09: Operations Management Module 01: Introduction Module 02: Project Module 03: Business Development and Succession Planning Module 04: Process Module 05: Supply Chain Module 06: Planning & Forecasting Operations Module 07: Procurement & Purchasing Module 08: Manufacturing & Delivery Operations Module 09: Quality Module 10: Managing Risk and Recovery Module 13: Communication Skills Module 14: Negotiation Techniques Module 18: Business Environment Module 19: Business Writing Skills Course 10: Strategic Planning and Analysis for Marketing Module 01: An Introduction to Strategic Planning Module 02: Development of a Strategic Plan Module 03: Strategic Planning for Marketing Module 04: Strategic and Marketing Analysis Module 05: Internal Analysis Module 06: External Analysis Module 07: Market Segmentation, Targeting and Positioning Module 08: Approaches to Customer Analysis Module 09: Approaches to Competitor Analysis Course 11: Sales Negotiation Training Sales Negotiation Training Negotiation Station - How To Negotiate Successfully Course 12: Basic Business Finance Module 01: What is Business Finance? Module 02: Why Businesses Fail Module 03: The Principles of Business Finance Part 1 Module 04: The Principles of Business Finance Part 2 Module 05: The Balance Sheet Module 06: The Income Statement Module 07: The Cashflow Statement Module 08: A Business Finance Exercise Module 09: Financial Performance Indicators Module 10: Investment Analysis Module 11: Investment Analysis Exercise Module 12: Key Learning Points in Business Finance Course 13: Diploma in Quickbooks Bookkeeping 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 Course 14: Customer Relationship Management Module 01: Introduction Module 02: CRM Fundamentals Module 03: CRM Strategies CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Retail Assistant Training bundle including- Students Graduates Job Seekers Job Holders Requirements Our Retail Assistant Training is fully compatible with PCs, Macs, laptops, tablets 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. Career path Having this Retail Assistant Training expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Retail Management - Level 5) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Retail Management - Level 5) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

HR Assistant - Video Training Course Course is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in the field of HR Management and looks at skills needed to improve workplace management. By taking this course you will gain the necessary skills to perform effectively in this field. The HR Assistant - Video Training Course Course is organized into 36 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 8 Hours, 20 Minutes! 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? HR Assistant - Video Training Course is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more about this subject. Course Content Human Resources Assistant Introduction Human Resources Assistant 00:10:00 Potential Careers 00:05:00 Attracting and Retaining Employees HRM Overview 00:13:00 Forecasting Demand 00:10:00 Cultural Diversity 00:11:00 Diversity Survey 00:09:00 Recruiting, Selection, and Orientation Job Analysis 00:10:00 Application 00:20:00 Bad Resume 00:05:00 Good Resume 00:12:00 Cover Letter 00:10:00 Selection 00:11:00 Form I-9 00:17:00 Form W-9 00:07:00 Form W-4 00:10:00 Form 1095-B 00:07:00 Compensation and Benefits 00:17:00 Training and Development Personal and Professional Development 00:14:00 Training Evaluation Form 00:12:00 Performance Appraisal Performance Appraisal 00:19:00 Appraisal 00:14:00 Legal Environment of HRM National Labor Relations Act 00:12:00 Labor-Management Relations Act 00:14:00 Occupational Safety and Health Act 00:13:00 Motivating Employees Motivation 00:17:00 Physiological Needs 00:16:00 Motivation-Hygiene Theory 00:12:00 Firm Characteristics 00:22:00 Contemporary Motivation Theory Weakness of Maslow and Herzberg's Theories 00:18:00 Expectancy Theory 00:13:00 Motivation Techniques Management by Objectives 00:17:00 Behavior Modification 00:19:00 Telecommuting 00:20:00 Teams and Teamwork What is a Team? 00:09:00 Stages of Development 00:06:00 Team Cohesiveness 00:09:00 Mock Exam Mock Exam- HR Assistant - Video Training Course 00:20:00 Final Exam Final Exam- HR Assistant - Video Training Course 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.

An insightful, enjoyable and experiential programme to help you analyse data and information and make a balanced decision based upon sound commercial reasoning. It will enable you to identify options, make decisions and take actions based on a thorough analysis combined with instinct and intuition to make a positive effect on profitability. This programme will help you: Identify ways to analyse data and sort relevant from irrelevant information Develop analytical and numerate thinking, and consider the financial implications of a decision Make decisions based on sound commercial reasoning - a mix of intuition and analysis Select from a range of tools to analyse a situation and apply these effectively Understand how costs and profits are calculated Use tried-and-tested techniques to manage and control your budgets Appreciate the fundamentals of financial analysis Focus on the bottom line Identify the basics of capital investment appraisal for your business Evaluate results and seek opportunities for improvement to your business 1 The commercial environment What do shareholders and investors want? What do managers want? Profit v non-profit organisations Investor expectations 2 Financial and non-financial information Risk and reward considerations Drivers of commercial decisions 3 Running a business A practical exercise to bring financial statements to life Different stakeholder interests in a business The impact and consequences of decisions on financial statements 4 Where do I make a difference to the organisation? How can I contribute to an improved business performance? Key performance indicators - measuring the right things A 'balanced scorecard' approach - it's not all about money! 5 A 'balanced scorecard' approach Analysing and reviewing my contribution to the business direction What is the current focus of my commercial decisions? Developing the business in the right way - getting the balance right! Where should/could it be in the future? Do my decisions support the overall vision and strategy? 6 Making commercial decisions Left-brain and right-brain thinking Convergent and divergent thinking Analysis and instinct Interactive case study exercise - emotional and rational decisions Reflection - what is my style of making decisions 7 Let's consider the customer! Identifying target markets Differentiating propositions and products Customer service considerations Marketing considerations and initiatives Pricing strategies and considerations 8 Strategic analysis The external environment The internal environment LEPEST analysis SWOT analysis Forecasting Group activity - analysing markets and the competition How do these improve your decisions? 9 Comparing performance Analysing key financial ratios Ways to compare performance and results Break-even analysis 10 Profit and loss accounts and budgeting Managing income and expenditure The budgeting process How does this link to the profit and loss account? Managing and controlling a cost centre/budget The role of the finance department Different ways of budgeting Incremental budgeting Zero-based budgeting 11 Understanding the balance sheet Purpose of balance sheets Understanding and navigating the content What does a balance sheet tell you? How do you affect your balance sheet? Links to the profit and loss account A practical team exercise that brings financial statements to life 12 Business decisions exercise How does this improve your decisions? A practical exercise to apply new knowledge and bring commercial thinking to to life The impact and consequences of decisions on financial statements 13 Working capital Why is this important? The importance of keeping cash flowing Business decisions that affect cash Calculating profit 14 Capital investment appraisal Capex v Opex Payback Return on investment The future value of money The concept of hurdle rate 15 Lessons learned and action planning So what? Recap and consolidation of learning The decisions that I need to consider Actions to achieve my plan

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Business Administration is the study of different management departments and roles of the components in business. In business administration, you need to learn about the principles, Organizations, Decision making and Leadership. Through this course, you will also learn all the knowledge and information management, its characteristics, its nature, levels and principles. Payroll is a very big part of any company, as it helps manage the company's finances when it comes to employee salaries. There is a huge demand for people who can use their skills in this department as there are a lot of numbers that need to be taken care of. You will also learn the basics of payroll and managing it efficiently through the course. Find out how to manage business and its clients and employee payroll system in this course. Course Highlights Business Administration and Management is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Business Administration and Management into 49 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 11 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Business Administration and Management Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Business Administration and Management is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Business Administration and Management is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Business Administration and Management - Updated Version Introduction to Business Management 00:25:00 Operations Management 00:24:00 Introduction to Business Analysis 00:14:00 Strategic Analysis and Product Scope 00:28:00 Project Management 00:19:00 Business Development and Succession Planning 00:24:00 Planning & Forecasting Operations 00:21:00 Performance Management 00:18:00 Management of Cash and Credit 00:19:00 Quality Management 00:21:00 Managing Risk and Recovery 00:26:00 Communication Skills 00:25:00 Business Environment 00:16:00 Organisational Skills 01:16:00 Negotiation Techniques 00:16:00 Human Resource Management 00:19:00 Motivation and Counselling 00:19:00 Customer Service 00:16:00 Time Management 00:40:00 Conflict Management 00:14:00 Business Administration and Management - Old Version Business Administration What is Business Administration? FREE 01:00:00 Business and Organisations FREE 00:30:00 Management of Business 01:00:00 Business Organization Perspectives 01:00:00 Decision Making 01:00:00 Approaches to Leadership 01:00:00 Management Management 01:00:00 Definition of Management 01:00:00 Characteristics of Management 01:00:00 Management Functions/Process of Management 01:00:00 Nature of Management 01:00:00 Levels of Management 01:00:00 Characteristics of Professional Managers 00:30:00 Principles of Management 01:00:00 Managing Payroll What Is Payroll? FREE 01:00:00 Principles Of Payroll Systems FREE 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 01:00:00 When Workers Leave Employment 01:00:00 Hiring Employees 01:00:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 01:00:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Mock Exam Mock Exam- Business Administration and Management 00:30:00 Final Exam Final Exam- Business Administration and Management 00:30: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