856 Courses delivered Online

This course condenses Microsoft Word, PowerPoint, and Outlook into a powerful 90-minute learning experience. Learn the core functionalities to create professional documents, captivating presentations, and manage your email efficiently. Ideal for busy professionals or anyone new to Microsoft Office. Boost your productivity and become a Microsoft whiz in just 90 minutes! Enroll now and conquer your workday!

Accountancy refers to the profession or studies of an accountant who keeps a record of financial work and taxes. Without proper accounting, business is meaningless. The Level 2 Diploma in Accountancy course provides extensive lessons about accounting to make you prepare for the business world. Upon completion, you will be efficient enough to manage the accounting department. Therefore, the course is suitable for managers and people who want to obtain a career in accounting. Along with this Level 2 Diploma in Accounting: Accountancy (Accountant Training), you will get 10 additional Career development courses, an original hardcopy certificate, a transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included in this Level 2 Diploma in Accounting? Course 01: Accountancy Course 02: Accounting and Tax Course 03: Microsoft Excel Level 3 Course 04: Team Management Course 05: Diploma in Quickbooks Bookkeeping Course 06: Level 3 Xero Training Course 07: Effective Communication Skills Diploma Course 08: Decision Making Course 09: Applied Business Analysis Diploma Course 10: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 11: Financial Investigator Accounting: Accountancy (Accountant Training) Course Curriculum of Accounting: Accountancy (Accountant Training) Course 1: Accountancy Introduction to Accountancy The Role of an Accountant Accounting Concepts and Standards Double-Entry Bookkeeping Balance Sheet Income statement Financial statements Cash Flow Statements Understanding Profit and Loss Statement Financial Budgeting and Planning Auditing How will I get my Certificate? After successfully completing the Accounting: Accountancy (Accountant Training) course, you can 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) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Accounting: Accountancy (Accountant Training) Anyone from any background can enrol in this Accounting: Accountancy (Accountant Training) bundle. Requirements Our Accounting: Accountancy (Accountant Training) course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path The Accounting: Accountancy (Accountant Training) course will be very beneficial and helpful, especially to the following professionals: Payroll Administrator Accounting Clerk Bookkeeper Bookkeeping Assistant Account Assistant Office Administrator Office Manager Accounts Payable Clerk. Accounts Receivable Clerk. Payroll Clerk Staff Accountant. Certificates Certificate of completion Digital certificate - Included

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Business Operations Manager bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 25 course mega bundle that will exceed your expectations within your budget. The Business Operations Manager related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Business Operations Manager bundle will help you build a solid foundation to become a proficient worker in the sector. This Business Operations Manager Bundle consists of the following 20 CPD Accredited Premium courses - Course 01 :Office Administration Course 02 :Admin Support Assistant Course 03 :Document Control Course 04 :UK Employment Law Course 05 :Strategies & Skills for Recruitment - Online Course Course 06 :Office Receptionist Course Course 07 :Email Etiquette Course 08 :Performance Management Course 09 :Key Performance Indicators Professional Course 10 :Objectives and Key Results (OKR) Course 11 :Performance and Appraisal Management Course 12 :Supporting a Grieving Employee: A Manager's Guide Course 13 :Workplace First Aid Level 3 Course 14 :Supervisor Training Course 15 :Risk Assessment & Management Course 16 :Microsoft Office 2016 Advanced Course 17 :New Functions in Microsoft Excel 2021 Course 18 :Delegation Skills Course 19 :Goal Setting Masterclass Course 20 :Leadership: Practical Leadership 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Learning Outcome This tailor-made Business Operations Manager bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Business Operations Manager Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Business Operations Manager bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Business Operations Manager Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Level 5 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 150 CPD Points | Lifetime Access

Acquire in-depth knowledge of heat exchanger design and cost-saving management with EnergyEdge's TEM & HTRI course. Join our virtual instructor-led training to stay ahead in the industry.

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Fall into Savings. Enjoy the biggest price fall this Holiday! Give a compliment to your career and take it to the next level. This Payroll, Employment Law & Business Administration bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Payroll, Employment Law & Business Administration bundle will help you stay ahead of the pack. Throughout the Payroll, Employment Law & Business Administration programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Payroll, Employment Law & Business Administration course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Payroll, Employment Law & 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 Enrol now in Payroll, Employment Law & Business Administration to advance your career, and use the premium study materials from Apex Learning. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum of Bundle Course 01: Payroll Management Course Payroll System in the UK Payroll Basics Company Settings Legislation Settings Pension Scheme Basics Pay Elements The Processing Date Adding Existing Employees Adding New Employees Payroll 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 02: Introduction to Accounting Section 01: Accounting Fundamental Lecture-1. What is Financial Accounting Lecture-2. Accounting Double Entry System and Fundamental Accounting Rules Lecture-3. Financial Accounting Process and Financial Statements Generates Lecture-4. Basic Accounting Equation and Four Financial Statements Lecture-5. Define Chart of Accounts and Classify the accounts Lecture-6. External and Internal Transactions with companies Lecture-7. Short Exercise to Confirm what we learned in this section Section 02: Accounting Policies Lecture-8. What are Major Accounting Policies need to be decided by companies Lecture-9. Depreciation Policies Lecture-10. Operational Fixed Asset Controls Lecture-11. Inventory Accounting and Controls Lecture-12. Revenue Accounting and Controls Course 03: 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 04: 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 05: 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 06: 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 07: 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 08: 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 09: 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? Anyone from any background can enrol in this Payroll, Employment Law & Business Administration bundle. Requirements This Payroll, Employment Law & Business Administration course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Payroll Management Course) 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.

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

Level 2 Microsoft Office Essentials