Name: Payroll Management Training
Price: 51 GBP
Availability: InStock

<p>As a Store Assistant, you'll be in charge of everything from inspecting deliveries to dealing with customer inquiries to making sure the shelves are filled with well-presented merchandise. Of course, a store assistant always gives exceptional customer service by responding to customer requests in a timely and polite manner.</p> <p><strong>Store Assistant Course Bundle:</strong></p> <ul> <li><strong> Course 01:</strong> Store Assistant Training</li><li><strong> Course 02:</strong> Inventory Management</li><li><strong> Course 03:</strong> Retail Management</li><li><strong> Course 04:</strong> Supply Chain Management</li><li><strong> Course 05: </strong>Purchase Ledger</li><li><strong> Course 06:</strong> Microsoft Excel</li><li><strong> Course 07:</strong> Communication Skills Training</li><li><strong> Course 08:</strong> Life Coaching</li><li><strong> Course 09:</strong> Warehouse Safety Training</li><li><strong> Course 10:</strong> Manual Handling Training</li></ul> <p>Enrol in our Store Assistant course and learn the essential knowledge of store assistant's duties and how to deal with customers. <strong>This Store Assistant course will enable you to work in a very fast-paced environment in the supermarket.</strong></p> <p>So, whether you are a fresher who wants to showcase Store Assistant skills to potential employers, or a professional who wants to flourish in their profession, then this course is for you.</p> <p>Learn everything on Store Assistant thoroughly from scratch.</p> <p><strong>Key Features</strong></p> <ul> <li>Instant e-certificate</li><li>Fully online, interactive course</li><li>Developed by qualified professionals</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Store Assistant</strong></p> <p><strong>Why Should you take this Store Assistant course?</strong></p> <p>Our course is a great place to start if you're looking to start a new career as Store Assistant and acquire relevant competencies. In addition, this program is for anyone interested in gaining in-demand Store Assistant proficiency to help launch a career as Store Assistant or improve their aptitude.</p> <p><strong>Certification</strong></p> <p>Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99).</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        31 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Learners do not require any prior knowledge or qualifications to enrol in this course.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.</p> </div>

                        </div>

Training Express

Retail Store Assistant Course

General Admission

<p><strong>**Don't Spend More; Spend Smarter**</strong></p> <p><strong>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</strong></p> <p>Give a compliment to your career and take it to the next level. This <strong>Personal Finance </strong>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 skills for your next promotion, this <strong>Personal Finance </strong>will help you keep ahead of the pack.</p> <p>The <strong>Personal Finance</strong> incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this <strong>Personal Finance</strong> will add extra value to your resume to stand out to potential employers.</p> <p>Throughout the programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the <strong>Personal Finance,</strong> you can equip yourself with the essentials to keep you afloat in the competition.</p> <p>Along with this Personal Finance course, you will get <strong>10 premium courses, an original </strong><strong>Hardcopy</strong>, <strong>8 PDF Certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p> <p><strong>This Personal Finance Bundle Consists of the following Premium courses: </strong></p> <ul> <li><strong>Course 01: </strong>Professional Personal Finance Course</li><li><strong>Course 02: </strong>Introduction to Accounting</li><li><strong>Course 03: </strong>Accounting and Bookkeeping Level 2</li><li><strong>Course 04: </strong>Level 3 Tax Accounting</li><li><strong>Course 05: </strong>Financial Analysis</li><li><strong>Course 06: </strong>Level 2 Financial Planning and Management Course</li><li><strong>Course 07: </strong>Investment</li><li><strong>Course 08: </strong>Stock Market Investing for Beginners</li><li><strong>Course 09: </strong>Microsoft Excel Training: Depreciation Accounting</li><li><strong>Course 10: </strong>Financial Modeling Using Excel</li><li><strong>Course 11: </strong>Advanced Diploma in MS Excel</li></ul> <p>So, enrol now to advance your career!</p> <p><strong>Benefits you'll get choosing Apex Learning:</strong></p> <ul> <li>Pay once and get lifetime access to 8 CPD courses</li><li>Free e-Learning App for engaging reading materials &amp; helpful assistance</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules designed by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong>PDF Certificate: Free (Previously it was £10 * 11 = £110)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul> <p>If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But with this special offer, Apex Learning is offering a<strong> Flat 50% discount </strong>on hard copy certificates, and you can get each for just <strong>£10</strong>!</p> <p>PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.</p><p><strong>Curriculum:</strong></p> <p><strong>Course 01: Professional Course</strong></p> <ul> <li>Section 01: Introduction</li><li>Section 02: Personal Finance</li><li>Section 03: Personal Expenses and Income</li><li>Section 04: Savings</li><li>Section 05: How to Manage Your Personal Finance Using Free Budgeting Software</li></ul> <p><strong>Course 02: Introduction to Accounting</strong></p> <p>Accounting Fundamental</p> <ul> <li>What is Financial Accounting</li><li>Accounting Double Entry System and Fundamental Accounting Rules</li><li>Financial Accounting Process and Financial Statements Generates</li><li>Basic Accounting Equation and Four Financial Statements</li><li>Define Chart of Accounts and Classify the accounts</li><li>External and Internal Transactions with companies</li><li>Short Exercise to Confirm what we learned in this section</li></ul> <p>Accounting Policies</p> <ul> <li>What are Major Accounting Policies need to be decided by companies</li><li>Depreciation Policies</li><li>Operational Fixed Asset Controls</li><li>Inventory Accounting and Controls</li><li>Revenue Accounting and Controls</li></ul> <p><strong>Course 03: Accounting and Bookkeeping Level 2</strong></p> <ul> <li>Introduction to the course</li><li>Introduction to Bookkeeping</li><li>Bookkeeping systems</li><li>Basics of Bookkeeping</li><li>The functionality of bookkeeping</li><li>On a personal note</li></ul> <p><strong>Course 04: Level 3 Tax Accounting</strong></p> <ul> <li>Tax System and Administration in the UK</li><li>Tax on Individuals</li><li>National Insurance</li><li>How to Submit a Self-Assessment Tax Return</li><li>Fundamentals of Income Tax</li><li>Advanced Income Tax</li><li>Payee, Payroll and Wages</li><li>Capital Gain Tax</li><li>Value Added Tax</li><li>Import and Export</li><li>Corporation Tax</li><li>Inheritance Tax</li><li>Double Entry Accounting</li><li>Management Accounting and Financial Analysis</li><li>Career as a Tax Accountant in the UK</li></ul> <p><strong>Course 05: Financial Analysis</strong></p> <ul> <li>Introduction</li><li>Profitability</li><li>Return Ratio</li><li>Liquidity Ratio</li><li>Operational Analysis</li><li>Detecting Manipulation</li></ul> <p><strong>Course 06: Level 2 Financial Planning and Management Course</strong></p> <ul> <li>Personal Finance Calculations</li><li>Saving for Retirement</li><li>Building Credit to Buy a Home</li><li>Personal Finance Guides for Beginners</li><li>Cashflow Management</li><li>Budgets and Money Management</li></ul> <p><strong>Course 07: Investment</strong></p> <ul> <li>Introduction to Investment</li><li>Types and Techniques of Investment</li><li>Key Concepts in Investment</li><li>Understanding the Finance</li><li>Investing in Bond Market</li><li>Investing in Stock Market</li><li>Risk and Portfolio Management</li></ul> <p><strong>Course 08: Stock Market Investing for Beginners</strong></p> <ul> <li>Module 01: Introduction to the Course</li><li>Module 02: Introduction to Stocks</li><li>Module 03: Money Required for Primary Investment</li><li>Module 04: Opening an Investment Account</li><li>Module 05: Brokerage Account Walkthrough</li><li>Module 06: Finding Winning Stocks</li><li>Module 07: Earning from Dividends</li><li>Module 08: Diversifying Portfolio</li><li>Module 09: Investment Plan</li><li>Module 10: Rebalancing Portfolio</li><li>Module 11: Understanding Order Types</li><li>Module 12: Investment Tax</li><li>Module 13: Investment Rules: Rule-1</li><li>Module 14: Investment Rules: Rule-2</li><li>Module 15: Investment Rules: Rule-3</li><li>Module 16: Investment Rules: Rule-4</li><li>Module 17: Investment Rules: Rule-5</li><li>Module 18: Stock Market Dictionary</li><li>Module 19: Setting Up the Trading Platform</li></ul> <p><strong>Course 09: Microsoft Excel Training: Depreciation Accounting</strong></p> <ul> <li>Introduction</li><li>Depreciation Amortization and Related Terms</li><li>Various Methods of Depreciation and Depreciation Accounting</li><li>Depreciation and Taxation</li><li>Master Depreciation Model</li><li>Conclusion</li></ul> <p><strong>Course 10: Financial Modeling Using Excel</strong></p> <ul> <li>Welcome to the Course! Get the Overview of What You'll Learn</li><li>Planning your Financial Model</li><li>Building a Model Template</li><li>Projecting the Income Statement</li><li>Projecting the Balance Sheet</li><li>Projecting Cash Flows</li><li>Advanced Financial Modeling</li><li>BONUS LESSON: Top 5 Excel Features for Financial Modellers</li></ul> <p><strong>Course 11: Advanced Diploma in MS Excel</strong></p> <ul> <li>Microsoft Excel 2019 New Features</li><li>Getting Started with Microsoft Office Excel</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li><li>Working with Functions</li><li>Working with Lists</li><li>Analyzing Data</li><li>Visualizing Data with Charts</li><li>Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Using Lookup Functions and Formula Auditing</li><li>Sharing and Protecting Workbooks</li><li>Automating Workbook Functionality</li><li>Creating Sparklines and Mapping Data</li><li>Forecasting Data</li><li>Excel VBA Data Management</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        110 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Anyone from any background can enrol in this bundle<strong>. </strong>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.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Ouris fully compatible with PC's, Mac's, 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.</p> <p>There is no time limit for completing this course; it can be studied in your own time at your own pace.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having this various expertise will increase the value of your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Apex Learning

Personal Finance Diploma - CPD Accredited

<p>Give a compliment to your career and take it to the next level. This <strong>Wages &amp; Benefits: Understanding Payroll Management </strong>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 <strong>Wages &amp; Benefits: Understanding Payroll Management </strong>will help you keep ahead of the pack.</p> <p>The <strong>Wages &amp; Benefits: Understanding Payroll Management </strong>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 <strong> Wages &amp; Benefits: Understanding Payroll Management </strong>will add extra value to your resume to stand out to potential employers.</p> <p>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 <strong> Wages &amp; Benefits: Understanding Payroll Management,</strong> you can equip yourself with the essentials to keep you afloat into the competition.</p> <p>Along with this <strong>Wages &amp; Benefits: Understanding Payroll Management </strong> course<strong>,</strong> 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.</p> <p><strong>This Wages &amp; Benefits: Understanding Payroll Management Bundle Consists of the following Premium courses: </strong></p> <ul> <li><strong>Course 01: </strong>Wages &amp; Benefits</li><li><strong>Course 02: </strong>Pension UK</li><li><strong>Course 03: </strong>Law and Contracts - Level 2</li><li><strong>Course 04: </strong>Level 3 Tax Accounting</li><li><strong>Course 05: </strong>Payroll Management - Diploma</li><li><strong>Course 06: </strong>Employment Laws &amp; Recruitment Process 2020 - Level 3</li><li><strong>Course 07: </strong>Sage 50 Training</li><li><strong>Course 08: </strong>Xero</li><li><strong>Course 09: </strong>Virtual Interviewing for HR</li><li><strong>Course 10: </strong>Microsoft Excel Level 3</li><li><strong>Course 11: </strong>Time Management</li></ul> <p>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 <strong>Wages &amp; Benefits: Understanding Payroll Management</strong> to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere.</p> <p>So, enrol now to advance your career!</p> <p><strong>Benefits you'll get choosing Apex Learning for this Wages &amp; Benefits: Understanding Payroll Management:</strong></p> <ul> <li>One payment, but lifetime access to 11 CPD courses</li><li>Certificate, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li></ul> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong>PDF Certificate: Free (Previously it was £10 * 11 = £110)</strong></li></ul> <ul> <li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul> <p>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<strong> Flat 50% discount </strong>on hard copy certificates, and you can get each for just <strong>£10</strong>!</p> <p><strong>P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. </strong></p><p>Curriculum of <strong>Wages &amp; Benefits: Understanding Payroll Management Bundle </strong></p> <p><strong>Course 01: Wages &amp; Benefits<br /></strong></p> <ul> <li>Basics of Employment Law</li><li>National Minimum Wage &amp; National Living Wage</li><li>Parental Rights, Sick Pay, &amp; Pension Scheme</li><li>Health &amp; Safety at Work</li></ul> <p><strong>Course 02: Pension UK<br /></strong></p> <ul> <li>Module 01: Overview of the UK Pension system</li><li>Module 02: Type of Pension Schemes</li><li>Module 03: Pension Regulation</li><li>Module 04: Pension Fund Governance</li><li>Module 05: Law and Regulation of Pensions in the UK</li><li>Module 06: Key Challenges in UK Pension System</li></ul> <p><strong>Course 03: Law and Contracts - Level 2<br /></strong></p> <ul> <li>Module 01: Introduction to UK Laws</li><li>Module 02: Ministry of Justice</li><li>Module 03: Agreements and Contractual Intention</li><li>Module 04: Considerations and Capacities of Contact Laws</li><li>Module 05: Terms within a Contract</li><li>Module 06: Misinterpretations and Mistakes</li><li>Module 07: Consumer Protection</li><li>Module 08: Privity of Contract</li><li>Module 09: Insurance Contract Laws</li><li>Module 10: Contracts for Employees</li><li>Module 11: Considerations in International Trade Contracts</li><li>Module 12: Laws and Regulations for International Trade</li><li>Module 13: Remedies for Any Contract Breach</li></ul> <p><strong>Course 04: Level 3 Tax Accounting<br /></strong></p> <ul> <li>Module 01: Tax System and Administration in the UK</li><li>Module 02: Tax on Individuals</li><li>Module 03: National Insurance</li><li>Module 04: How to Submit a Self-Assessment Tax Return</li><li>Module 05: Fundamentals of Income Tax</li><li>Module 06: Payee, Payroll and Wages</li><li>Module 07: Value Added Tax</li><li>Module 08: Corporation Tax</li><li>Module 09: Double Entry Accounting</li><li>Module 10: Management Accounting and Financial Analysis</li><li>Module 11: Career as a Tax Accountant in the UK</li></ul> <p><strong>Course 05: Payroll Management - Diploma</strong></p> <p>Sage 50 Payroll for Beginners</p> <ul> <li>Payroll Basics</li><li>Company Settings</li><li>Legislation Settings</li><li>Pension Scheme Basics</li><li>Pay Elements</li><li>The Processing Date</li><li>Adding Existing Employees</li><li>Adding New Employees</li><li>Payroll Processing Basics</li></ul> <p>And Many More...</p> <p>Sage 50 Payroll Intermediate Level</p> <ul> <li>The Outline View and Criteria</li><li>Global Changes</li><li>Timesheets</li><li>Departments and Analysis</li><li>Holiday Schemes</li><li>Recording Holidays</li><li>Absence Reasons</li><li>Statutory Sick Pay</li></ul> <p>And Many More...</p> <p><strong>Course 06: Employment Laws &amp; Recruitment Process 2020 - Level 3<br /></strong></p> <ul> <li>Module 01: Basic of Employment Law</li><li>Module 02: Legal Recruitment Process</li><li>Module 03: Employment Contracts</li><li>Module 04: Employee Handbook</li><li>Module 05: Disciplinary Procedure</li><li>Module 06: National Minimum Wage &amp; National Living Wage</li><li>Module 07: Parental Right, Sick Pay &amp; Pension Scheme</li><li>Module 08: Discrimination in the Workplace</li><li>Module 09: Health &amp; Safety at Work</li><li>Module 10: Dismissal, Grievances and Employment Tribunals</li><li>Module 11: Workplace Monitoring &amp; Data Protection</li></ul> <p><strong>Course 07: Sage 50 Training</strong></p> <ul> <li>Module 1: Payroll Basics</li><li>Module 2: Company Settings</li><li>Module 3: Legislation Settings</li><li>Module 4: Pension Scheme Basics</li><li>Module 5: Pay Elements</li><li>Module 6: The Processing Date</li><li>Module 7: Adding Existing Employees</li><li>Module 8: Adding New Employees</li><li>Module 9: Payroll Processing Basics</li><li>Module 10: Entering Payments</li><li>Module 11: Pre-Update Reports</li><li>Module 12: Updating Records</li><li>Module 13: e-Submissions Basics</li><li>Module 14: Process Payroll (November)</li><li>Module 15: Employee Records and Reports</li><li>Module 16: Editing Employee Records</li><li>Module 17: Process Payroll (December)</li><li>Module 18: Resetting Payments</li><li>Module 19: Quick SSP</li><li>Module 20: An Employee Leaves</li><li>Module 21: Final Payroll Run</li><li>Module 22: Reports and Historical Data</li><li>Module 23: Year-End Procedures</li></ul> <p>Sage 50 Payroll Advanced Diploma</p> <ul> <li>Module 1: The Outline View and Criteria</li><li>Module 2: Global Changes</li><li>Module 3: Timesheets</li><li>Module 4: Departments and Analysis</li><li>Module 5: Holiday Schemes</li><li>Module 6: Recording Holidays</li><li>Module 7: Absence Reasons</li><li>Module 8: Statutory Sick Pay</li><li>Module 9: Statutory Maternity Pay</li><li>Module 10: Student Loans</li><li>Module 11: Company Cars</li><li>Module 12: Workplace Pensions</li><li>Module 13: Holiday Funds</li><li>Module 14: Roll Back</li><li>Module 15: Passwords and Access Rights</li><li>Module 16: Options and Links</li><li>Module 17: Linking Payroll to Accounts</li></ul> <p><strong>Course 08: Xero</strong></p> <ul> <li>Introduction</li><li>Getting Started</li><li>Invoices and Sales</li><li>Bills and Purchases</li><li>Bank Accounts</li><li>Products and Services</li><li>Fixed Assets</li><li>Payroll</li><li>VAT Returns</li></ul> <p><strong>Course 09: Virtual Interviewing for HR<br /></strong></p> <ul> <li>Module 1: An Introduction to Virtual Interviewing</li><li>Module 2: Interviewer's Perspective</li><li>Module 3: Interview Preparation</li><li>Module 4: Picking a Tech to Use</li><li>Module 5: Attract and Hire the Best Talents</li><li>Module 6: Final Thoughts and Onboarding</li></ul> <p><strong>Course 10: Microsoft Excel Level 3<br /></strong></p> <ul> <li>Microsoft Excel 2019 New Features</li><li>Getting Started with Microsoft Office Excel</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li><li>Working with Functions</li><li>Working with Lists</li><li>Analyzing Data</li><li>Visualizing Data with Charts</li><li>Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Using Lookup Functions and Formula Auditing</li><li>Sharing and Protecting Workbooks</li><li>Automating Workbook Functionality</li><li>Creating Sparklines and Mapping Data</li><li>Forecasting Data</li><li>Excel Templates</li></ul> <p><strong>Course 11: Time Management</strong></p> <ul> <li>Identifying Goals</li><li>Effective Energy Distribution</li><li>Working with Your Personal Style</li><li>Building Your Toolbox</li><li>Establishing Your Action Plan</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        115 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Anyone from any background can enrol in this <strong>Wages &amp; Benefits: Understanding Payroll Management </strong>bundle<strong>. </strong>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.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Our <strong>Wages &amp; Benefits: Understanding Payroll Management </strong>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.</p> <p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having these various expertise will increase the value in your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Wages & Benefits: Understanding Payroll Management

<p><strong>Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now!</strong></p><p>Microsoft Office is <strong>the most widely used tool for sharing/presenting professional information by a considerable number of companies in the world</strong>. Microsoft Office's benefits to business productivity are so crucial that all professionals today are required to be experts in it.</p><p>Also, Microsoft Office skills can make your work life so much easier that you can complete your tasks in minutes that would take others hours. So enhance your skills and become that go-to guy that everyone envies with our comprehensive Microsoft Office Specialist (MOS) bundle.</p><p>After surveying thousands of learners just like you and considering their valuable feedback, this all-in<strong>-</strong>one Microsoft Office Specialist (MOS) bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand course that will enhance your skills and prepare you for the competitive Microsoft Office Specialist (MOS) job market.</p><p>Also, our experts are available for answering your queries on Microsoft Office Specialist (MOS) and help you along your learning journey. Advanced audio-visual learning modules of these Microsoft Office Specialist (MOS) courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.</p><p>Furthermore, to help you showcase your expertise in MOS, 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.</p><p><strong>This Microsoft Office Specialist (MOS) Bundle Consists of the following Premium courses: </strong></p><ul><li><strong>Course 01:</strong> Advanced Diploma in MS Excel</li><li><strong>Course 02:</strong> MS Word Diploma</li><li><strong>Course 03:</strong> PowerPoint Diploma</li><li><strong>Course 04:</strong> 50 Tips to Upgrade your Excel Skill</li><li><strong>Course 05:</strong> New Functions in Microsoft Excel 2021</li><li><strong>Course 06:</strong> Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li><strong>Course 07:</strong> Excel Sheet Comparison with VBA</li><li><strong>Course 08:</strong> Master Power Query in 120 Minutes!</li><li><strong>Course 09:</strong> Data Analysis in Excel Complete Training</li><li><strong>Course 10:</strong> The Complete Outlook Masterclass</li><li><strong>Course 11:</strong> Complete Power BI 2021</li><li><strong>Course 12:</strong> Microsoft Teams</li><li><strong>Course 13:</strong> Windows 10 Pro Complete Training</li><li><strong>Course 14:</strong> GDPR Data Protection Level 5</li></ul><p>Enrol now in Microsoft Office Specialist (MOS) to advance your career, and use the premium study materials from Apex Learning.</p><p><strong>Curriculum</strong></p><p><strong> Course 01: Advanced Diploma in MS Excel</strong></p><ul><li>Microsoft Excel 2019 New Features</li><li>Getting Started with Microsoft Office Excel</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li><li>Working with Functions</li><li>Working with Lists</li><li>Analyzing Data</li><li>Visualizing Data with Charts</li><li>Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Using Lookup Functions and Formula Auditing</li><li>Sharing and Protecting Workbooks</li><li>Automating Workbook Functionality</li><li>Creating Sparklines and Mapping Data</li><li>Forecasting Data</li><li>Excel VBA Data Management</li></ul><p><strong>How will I get my Certificate?</strong></p><p>After successfully completing the Microsoft Office Specialist (MOS) course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p><ul><li><strong></strong><strong>PDF Certificate: Free (For The Title Course )</strong></li><li><strong></strong><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        155 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This bundle is for all.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This bundle has no requirements.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.</p> </div>

                        </div>

Microsoft Office Specialist (MOS) - Excel, Word, PowerPoint, Outlook & Data Analysis

<p>Give a compliment to your career and take it to the next level. This<strong> Accountancy, AML, Financial Investigator </strong>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 &amp; Business Administration bundle will help you stay ahead of the pack.</p><p>Throughout the Accountancy, AML, Financial Investigator 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.</p><p>Along with this Accountancy, AML, Financial Investigator course, you will get <strong> 10 premium courses, an original</strong><strong>hardcopy</strong>, <strong>11 PDF certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p><p><strong>This Accountancy, AML, Financial Investigator Bundle Consists of the following Premium courses: </strong></p><ul><li><strong>Course 01: </strong>Accountancy</li><li><strong>Course 02: </strong>Accounting and Tax</li><li><strong>Course 03: </strong>Diploma in Quickbooks Bookkeeping</li><li><strong>Course 04: </strong>Microsoft Excel Level 3</li><li><strong>Course 05:</strong> Team Management</li><li><strong>Course 06: </strong>Level 3 Xero Training</li><li><strong>Course 07: </strong>Effective Communication Skills Diploma</li><li><strong>Course 08: </strong>Decision-Making</li><li><strong>Course 09: </strong>Applied Business Analysis Diploma</li><li><strong>Course 10: </strong>Fraud Management &amp; Anti Money Laundering Awareness Complete Diploma</li><li><strong>Course 11: </strong>Financial Investigator</li></ul><p>Enrol now in Accountancy, AML, Financial Investigator to advance your career, and use the premium study materials from Apex Learning.</p><p><strong>Certificate:</strong></p><ul><li><strong>PDF Certificate: Free (Previously it was £6*11 = £66)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</strong></li></ul><p>Curriculum of <strong>Accountancy, AML, Financial Investigator Bundle</strong></p><p><strong>Course 01: Accountancy</strong></p><ul><li>Module 01: Introduction to Accounting</li><li>Module 02: The Role of an Accountant</li><li>Module 03: Accounting Concepts and Standards</li><li>Module 04: Double-Entry Bookkeeping</li><li>Module 05: Balance Sheet</li><li>Module 06: Income statement</li><li>Module 07: Financial statements</li><li>Module 08: Cash Flow Statements</li><li>Module 09: Understanding Profit and Loss Statement</li><li>Module 10: Financial Budgeting and Planning</li><li>Module 11: Auditing</li></ul><p><strong>Course 02: Accounting and Tax</strong></p><ul><li>Module 01: Tax System and Administration in the UK</li><li>Module 02: Tax on Individuals</li><li>Module 03: National Insurance</li><li>Module 04: How to Submit a Self-Assessment Tax Return</li><li>Module 05: Fundamentals of Income Tax</li><li>Module 06: Payee, Payroll and Wages</li><li>Module 07: Value Added Tax</li><li>Module 08: Corporation Tax</li><li>Module 09: Double Entry Accounting</li><li>Module 10: Management Accounting and Financial Analysis</li><li>Module 11: Career as a Tax Accountant in the UK</li></ul><p><strong>Course 03: Diploma in Quickbooks Bookkeeping</strong></p><ul><li>Getting prepared - access the software and course materials</li><li>Getting started</li><li>Setting up the system</li><li>Nominal ledger</li><li>Customers</li><li>Suppliers</li><li>Sales ledger</li><li>Purchases ledger</li><li>Sundry payments</li><li>Sundry receipts</li><li>Petty cash</li><li>VAT - Value Added Tax</li><li>Bank reconciliation</li><li>Payroll / Wages</li><li>Reports</li><li>Tasks</li></ul><p><strong>Course 04: Microsoft Excel Level 3</strong></p><ul><li>Getting Started with Microsoft Office Excel</li><li>Performing Calculations</li><li>Modifying a Worksheet</li><li>Formatting a Worksheet</li><li>Printing Workbooks</li><li>Managing Workbooks</li><li>Working with Functions</li><li>Working with Lists</li><li>Analyzing Data</li><li>Visualizing Data with Charts</li><li>Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Using Lookup Functions and Formula Auditing</li><li>Sharing and Protecting Workbooks</li><li>Automating Workbook Functionality</li><li>Creating Sparklines and Mapping Data</li><li>Forecasting Data</li><li>Excel Templates</li></ul><p><strong>Course 06: Level 3 Xero Training</strong></p><ul><li>Introduction</li><li>Getting Started</li><li>Invoices and Sales</li><li>Bills and Purchases</li><li>Bank Accounts</li><li>Products and Services</li><li>Fixed Assets</li><li>Payroll</li><li>VAT Returns</li></ul><p><strong>Course 07: Effective Communication Skills Diploma</strong></p><ul><li>Module 01: Business Communication</li><li>Module 02: Verbal and Non-verbal Communication</li><li>Module 03: Written Communication</li><li>Module 04: Electronic Communication</li><li>Module 05: Communicating with Graphic</li><li>Module 06: Effectively Working for Your Boss</li></ul><p><strong>Course 08: Decision-Making</strong></p><ul><li>Module 01: What is Decision Making?</li><li>Module 02: Stress and Its Impact</li><li>Module 03: Time Stress and Decision Making</li><li>Module 04: Personal Level Decision making Under Stress</li><li>Module 05: Organisational Level Decision making Under Stress</li><li>Module 06: Decision Making for Conflict Management</li></ul><p><strong>Course 09: Applied Business Analysis Diploma</strong></p><ul><li>Module 01: Introduction to Business Analysis</li><li>Module 02: Business Processes</li><li>Module 03: Business Analysis Planning and Monitoring</li><li>Module 04: Strategic Analysis and Product Scope</li><li>Module 05: Solution Evaluation</li><li>Module 06: Investigation Techniques</li><li>Module 07: Ratio Analysis</li><li>Module 08: Documenting and Managing Requirements</li><li>Module 09: Career Prospect as a Business Analyst in the UK</li></ul><p><strong>Course 10: Fraud Management &amp; Anti Money Laundering Awareness Complete Diploma</strong></p><ul><li>Module 01: Introduction to Money Laundering</li><li>Module 02: Proceeds of Crime Act 2002</li><li>Module 03: Development of Anti-Money Laundering Regulation</li><li>Module 04: Responsibility of the Money Laundering Reporting Office</li><li>Module 05: Risk-based Approach</li><li>Module 06: Customer Due Diligence</li><li>Module 07: Record Keeping</li><li>Module 08: Suspicious Conduct and Transactions</li><li>Module 09: Awareness and Training</li></ul><p><strong>Course 11: Financial Investigator</strong></p><ul><li>Module 01: Introduction to Financial Investigator</li><li>Module 02: Introduction to Financial Investigation</li><li>Module 03: Characteristics of Financial Crimes</li><li>Module 04: Categories of Financial Crimes</li><li>Module 05: Financial Crime Response Plan</li><li>Module 06: Collecting, Preserving and Gathering Evidence</li><li>Module 07: Laws against Financial Fraud</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        115 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Anyone from any background can enrol in this Accountancy, AML, Financial Investigator bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Accountancy, AML, Financial Investigator course has been designed to be fully compatible with tablets and smartphones.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Accountancy, AML, Financial Investigator

<p><strong> Fall into Savings. Enjoy the biggest price fall this Holiday!  </strong></p><p>Give a compliment to your career and take it to the next level. This<strong> Payroll, Employment Law &amp; Business Administration </strong>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 &amp; Business Administration bundle will help you stay ahead of the pack.</p><p>Throughout the Payroll, Employment Law &amp; 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.</p><p>Along with this Payroll, Employment Law &amp; Business Administration course, you will get <strong>10 premium courses, an original</strong><strong>hardcopy</strong>, <strong> 11 PDF certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p><p><strong>This Payroll, Employment Law &amp; Business Administration Bundle Consists of the following Premium courses: </strong></p><ul><li><strong>Course 01:</strong> Payroll Management Course</li><li><strong>Course 02:</strong> Introduction to Accounting</li><li><strong>Course 03:</strong> Accounting and Tax</li><li><strong>Course 04:</strong> Xero Projects &amp; Job Costing</li><li><strong>Course 05:</strong> Employment Law Level 3</li><li><strong>Course 06:</strong> Certificate in Anti Money Laundering (AML)</li><li><strong>Course 07:</strong> Financial Analysis</li><li><strong>Course 08:</strong> Data Analysis in Microsoft Excel Complete Training</li><li><strong>Course 09:</strong> Business Administration Level 3</li><li><strong>Course 10:</strong> Decision Making</li><li><strong>Course 11:</strong> Effective Communication Skills Diploma</li></ul><p>Enrol now in Payroll, Employment Law &amp; Business Administration to advance your career, and use the premium study materials from Apex Learning.</p><p><strong>Certificate:</strong></p><ul><li><strong>PDF Certificate: Free (Previously it was £6*11 = £66)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</strong></li></ul><p>Curriculum of <strong>Bundle</strong></p><p><strong>Course 01: Payroll Management Course</strong></p><ul><li>Payroll System in the UK</li><li>Payroll Basics</li><li>Company Settings</li><li>Legislation Settings</li><li>Pension Scheme Basics</li><li>Pay Elements</li><li>The Processing Date</li><li>Adding Existing Employees</li><li>Adding New Employees</li><li>Payroll Processing Basics</li><li>Entering Payments</li><li>Pre-Update Reports</li><li>Updating Records</li><li>e-Submissions Basics</li><li>Process Payroll (November)</li><li>Employee Records and Reports</li><li>Editing Employee Records</li><li>Process Payroll (December)</li><li>Resetting Payments</li><li>Quick SSP</li><li>An Employee Leaves</li><li>Final Payroll Run</li><li>Reports and Historical Data</li><li>Year-End Procedures</li></ul><p><strong>Course 02: Introduction to Accounting<br /></strong></p><p><strong>Section 01: Accounting Fundamental</strong></p><ul><li>Lecture-1. What is Financial Accounting</li><li>Lecture-2. Accounting Double Entry System and Fundamental Accounting Rules</li><li>Lecture-3. Financial Accounting Process and Financial Statements Generates</li><li>Lecture-4. Basic Accounting Equation and Four Financial Statements</li><li>Lecture-5. Define Chart of Accounts and Classify the accounts</li><li>Lecture-6. External and Internal Transactions with companies</li><li>Lecture-7. Short Exercise to Confirm what we learned in this section</li></ul><p><strong>Section 02: Accounting Policies</strong></p><ul><li>Lecture-8. What are Major Accounting Policies need to be decided by companies</li><li>Lecture-9. Depreciation Policies</li><li>Lecture-10. Operational Fixed Asset Controls</li><li>Lecture-11. Inventory Accounting and Controls</li><li>Lecture-12. Revenue Accounting and Controls</li></ul><p><strong>Course 03: Accounting and Tax</strong></p><ul><li>Module 01: Tax System and Administration in the UK</li><li>Module 02: Tax on Individuals</li><li>Module 03: National Insurance</li><li>Module 04: How to Submit a Self-Assessment Tax Return</li><li>Module 05: Fundamentals of Income Tax</li><li>Module 06: Payee, Payroll and Wages</li><li>Module 07: Value Added Tax</li><li>Module 08: Corporation Tax</li><li>Module 09: Double Entry Accounting</li><li>Module 10: Management Accounting and Financial Analysis</li><li>Module 11: Career as a Tax Accountant in the UK</li></ul><p><strong>Course 04: Xero Projects &amp; Job Costing</strong></p><ul><li>Module 01: Introduction</li><li>Module 02: Getting Started</li><li>Module 03: Setting up Staff</li><li>Module 04: Small Project Example</li><li>Module 05: Quotes</li><li>Module 06: Products &amp; Services</li><li>Module 07: Invoicing</li><li>Module 08: Reporting</li><li>Module 09: Bigger Project Example</li><li>Module 10: Projects and Profit &amp; Loss</li><li>Module 11: Thank You</li></ul><p><strong>Course 05: Employment Law Level 3</strong></p><ul><li>Module 01: Basic of Employment Law</li><li>Module 02: Legal Recruitment Process</li><li>Module 03: Employment Contracts</li><li>Module 04: Employee Handbook</li><li>Module 05: Disciplinary Procedure</li><li>Module 06: National Minimum Wage &amp; National Living Wage</li><li>Module 07: Parental Right, Sick Pay &amp; Pension Scheme</li><li>Module 08: Discrimination in the Workplace</li><li>Module 09: Health &amp; Safety at Work</li><li>Module 10: Dismissal, Grievances and Employment Tribunals</li><li>Module 11: Workplace Monitoring &amp; Data Protection</li></ul><p><strong>Course 06: Certificate in Anti Money Laundering (AML)</strong></p><ul><li>Module 01: Introduction to Money Laundering</li><li>Module 02: Proceeds of Crime Act 2002</li><li>Module 03: Development of Anti-Money Laundering Regulation</li><li>Module 04: Responsibility of the Money Laundering Reporting Officer</li><li>Module 05: Risk-based Approach</li><li>Module 06: Customer Due Diligence</li><li>Module 07: Record Keeping</li><li>Module 08: Suspicious Conduct and Transactions</li><li>Module 09: Awareness and Training</li></ul><p><strong>Course 07: Financial Analysis</strong></p><ul><li>Module 01: Introduction</li><li>Module 02: Profitability</li><li>Module 03: Return Ratio</li><li>Module 04: Liquidity Ratio</li><li>Module 05: Operational Analysis</li><li>Module 06: Detecting Manipulation</li></ul><p><strong>Course 08: Data Analysis in Microsoft Excel Complete Training</strong></p><ul><li>Module 01: Modifying a Worksheet</li><li>Module 02: Working with Lists</li><li>Module 03: Analyzing Data</li><li>Module 04: Visualizing Data with Charts</li><li>Module 05: Using PivotTables and PivotCharts</li><li>Module 06: Working with Multiple Worksheets and Workbooks</li><li>Module 07: Using Lookup Functions and Formula Auditing</li><li>Module 08:Automating Workbook Functionality</li><li>Module 09:Creating Sparklines and Mapping Data</li><li>Module 10:Forecasting Data</li></ul><p><strong>Course 09: Business Administration Level 3</strong></p><ul><li>Module 01: Representing Your Boss and Company</li><li>Module 02: Skills of an Effective Administrator</li><li>Module 03: Business Writing Skills</li><li>Module 04: Communication Skills</li><li>Module 05: Business Telephone Skills</li><li>Module 06: Mail Services and Shipping</li><li>Module 07: Travel Arrangements</li><li>Module 08: Organising Meeting and Conferences</li><li>Module 09: Time Management</li><li>Module 10: Record Keeping and Filing Systems</li><li>Module 11: Effective Planning and Scheduling</li></ul><p><strong>Course 10: Decision Making</strong></p><ul><li>Module 01: What is Decision Making?</li><li>Module 02: Stress and Its Impact</li><li>Module 03: Time Stress and Decision Making</li><li>Module 04: Personal Level Decision making Under Stress</li><li>Module 05: Organisational Level Decision making Under Stress</li><li>Module 06: Decision Making for Conflict Management</li></ul><p><strong>Course 11: Effective Communication Skills Diploma</strong></p><ul><li>Module 01: Business Communication</li><li>Module 02: Verbal and Non-verbal Communication</li><li>Module 03: Written Communication</li><li>Module 04: Electronic Communication</li><li>Module 05: Communicating with Graphics</li><li>Module 06: Effectively Working for Your Boss</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        110 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Anyone from any background can enrol in this Payroll, Employment Law &amp; Business Administration bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Payroll, Employment Law &amp; Business Administration course has been designed to be fully compatible with tablets and smartphones.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>Payroll Management Course</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p><p><strong>Please Note:</strong> The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Payroll, Employment Law & Business Administration

<p><strong>Best Price Of The Market</strong></p> <p>Give a compliment to your career and take it to the next level. This<strong> Database Administrator </strong>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 Database Administrator bundle will help you stay ahead of the pack.</p> <p>Throughout the Database Administrator 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.</p> <p>Along with this Database Administrator course, you will get <strong>10 premium courses, an original</strong><strong>hardcopy</strong>, <strong>11 PDF certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p> <p><strong>This Database Administrator Bundle Consists of the following Premium courses: </strong></p> <ul> <li><strong> </strong><strong>Course 01: </strong>Introduction to Data Analysis</li><li><strong> </strong><strong>Course 02: </strong>Data Center Training Essentials: General Introduction</li><li><strong> </strong><strong>Course 03: </strong>Data Analytics with Tableau<strong><br /></strong></li><li><strong> </strong><strong>Course 04: </strong>Basic Google Data Studio</li><li><strong> </strong><strong>Course 05: </strong>Complete Google Analytics Course</li><li><strong> </strong><strong>Course 06: </strong>Python for Data Analysis</li><li><strong> </strong><strong>Course 07: </strong>Data Analysis in Excel Level 3 Course</li><li><strong> </strong><strong>Course 08: </strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li><strong> </strong><strong>Course 09: </strong>GDPR Data Protection Level 5</li><li><strong> </strong><strong>Course 10: </strong>Level 3 Cyber Security</li><li><strong> </strong><strong>Course 11: </strong>Encryption</li></ul> <p>Enrol now in Database Administrator to advance your career, and use the premium study materials from Apex Learning.</p> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the Database Administrator course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong></strong><strong> PDF Certificate: Free (Previously it was </strong> <strong>£</strong><strong>10 * 11 = </strong><strong>£</strong><strong>110)</strong></li><li><strong></strong><strong> Hard Copy Certificate: Free (For The Title Course)</strong></li></ul> <p>PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.</p><p>The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Database Administrator expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.</p> <p><strong>Curriculum of Bundle</strong></p> <p><strong> Course 01: Introduction to Data Analysis</strong></p> <ul> <li>Module 01: Introduction</li><li>Module 02: Agenda and Principles of Process Management</li><li>Module 03: The Voice of the Process</li><li>Module 04: Working as One Team for Improvement</li><li>Module 05: Exercise: The Voice of the Customer</li><li>Module 06: Tools for Data Analysis</li><li>Module 07: The Pareto Chart</li><li>Module 08: The Histogram</li><li>Module 09: The Run Chart</li><li>Module 10: Exercise: Presenting Performance Data</li><li>Module 11: Understanding Variation</li><li>Module 12: The Control Chart</li><li>Module 13: Control Chart Example</li><li>Module 14: Control Chart Special Cases</li><li>Module 15: Interpreting the Control Chart</li><li>Module 16: Control Chart Exercise</li><li>Module 17: Strategies to Deal with Variation</li><li>Module 18: Using Data to Drive Improvement</li><li>Module 19: A Structure for Performance Measurement</li><li>Module 20: Data Analysis Exercise</li><li>Module 21: Course Project</li><li>Module 22: Test your Understanding</li></ul> <p><strong> Course 02: Data Center Training Essentials: General Introduction</strong></p> <ul> <li>Module 01: Data Center Introduction</li><li>Module 02: Data Center Reliability</li><li>Module 03: Data Center Equipment</li><li>Module 04: Data Center White Space</li><li>Module 05: Data Center Support Spaces</li><li>Module 06: Data Center Security, Safety, Networks and IT</li></ul> <p><strong> Course 03: Data Analytics with Tableau</strong></p> <ul> <li>Module 01: Introduction to the Course</li><li>Module 02: Project 1: Discount Mart (Sales and Profit Analytics)</li><li>Module 03: Project 2: Green Destinations (HR Analytics)</li><li>Module 04: Project 3: Superstore (Sales Agent Tracker)</li><li>Module 05: Northwind Trade (Shipping Analytics)</li><li>Module 06: Project 5: Tesla (Stock Price Analytics)</li><li>Module 07: Bonus: Introduction to Database Concepts</li><li>Module 08: Tableau Stories</li></ul> <p><strong> Course 04: Basic Google Data Studio</strong></p> <ul> <li>Module 01: Introduction to GDS</li><li>Module 02: Data Visualization</li><li>Module 03: Geo-visualization</li><li>Module 04: A Socio-Economic Case Study</li></ul> <p><strong> Course 05: Complete Google Analytics Course</strong></p> <ul> <li>Module 01: Overview</li><li>Module 02: Navigation and Admin</li><li>Module 03: Creating a New Google Analytics Account</li><li>Module 04: Website Account Creation</li><li>Module 05: Connecting To WordPress Website</li><li>Module 06: Connecting To HTML Site</li><li>Module 07: Connect Custom Page and Site Builders</li><li>Module 08: Setting Up Annotations</li><li>Module 09: Setting Up Intelligence Events</li><li>Module 10: Set Up Custom Segments</li><li>Module 11: Export Data for Analysis</li><li>Module 12: Set Up Custom Reports</li><li>Module 13: Set Up Google Integrations</li><li>Module 14: Google Analytics Templates</li><li>Module 15: Real Time Reporting</li><li>Module 16: Setting Up Goals</li><li>Module 17: Third Party Integrations</li><li>Module 18: Audience Menu Overview</li><li>Module 19: Interests and Geography</li><li>Module 20: Conclusion</li></ul> <p><strong> Course 06: Python for Data Analysis</strong></p> <ul> <li>Welcome, Course Introduction &amp; overview, and Environment set-up</li><li>Python Essentials</li><li>Python for Data Analysis using NumPy</li><li>Python for Data Analysis using Pandas</li><li>Python for Data Visualization using matplotlib</li><li>Python for Data Visualization using Seaborn</li><li>Python for Data Visualization using pandas</li><li>Python for interactive &amp; geographical plotting using Plotly and Cufflinks</li><li>Capstone Project - Python for Data Analysis &amp; Visualization</li><li>Python for Machine Learning (ML) - scikit-learn - Linear Regression Model</li><li>Python for Machine Learning - scikit-learn - Logistic Regression Model</li><li>Python for Machine Learning - scikit-learn - K Nearest Neighbors</li><li>Python for Machine Learning - scikit-learn - Decision Tree and Random Forests</li><li>Python for Machine Learning - scikit-learn -Support Vector Machines (SVMs)</li><li>Python for Machine Learning - scikit-learn - K Means Clustering</li><li>Python for Machine Learning - scikit-learn - Principal Component Analysis (PCA)</li><li>Recommender Systems with Python - (Additional Topic)</li><li>Python for Natural Language Processing (NLP) - NLTK - (Additional Topic)</li></ul> <p><strong> Course 07: Data Analysis in Excel Level 3 Course</strong></p> <ul> <li>Modifying a Worksheet</li><li>Working with Lists</li><li>Analyzing Data</li><li>Visualizing Data with Charts</li><li>Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Using Lookup Functions and Formula Auditing</li><li>Automating Workbook Functionality</li><li>Creating Sparklines and Mapping Data</li><li>Forecasting Data</li></ul> <p><strong> Course 08: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</strong></p> <ul> <li>Introduction</li><li>Prepaid Expenses Models: Resources Download</li><li>Accounting for Prepaid Expenses</li><li>Excel Formulas Detailed: Introduction to three Excel Models</li><li>Formula Based Prepaid Expenses Model</li><li>Calculate Prepaid Expenses Amortisation from Exact Start Date</li><li>Prepaid Expenses Summary with Power Query and Pivot Table</li><li>Advanced VBA Prepaid Expenses Amortisation Model</li><li>BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way</li><li>Power Query &amp; Pivot Tables based Dashboard without any Formulas, Fully Dynamic</li><li>Thankyou</li></ul> <p><strong> Course 09: GDPR Data Protection Level 5</strong></p> <ul> <li>Module 01: GDPR Basics</li><li>Module 02: GDPR Explained</li><li>Module 03: Lawful Basis for Preparation</li><li>Module 04: Rights and Breaches</li><li>Module 05: Responsibilities and Obligations</li></ul> <p><strong> Course 10: Level 3 Cyber Security</strong></p> <ul> <li>FUNDAMENTALS OF NETWORKING</li><li>GETTING STARTED WITH CYBER SECURITY</li><li>LET'S BEGIN - THE FUNDAMENTALS OF CYBER SECURITY</li><li>DIVING DEEP INTO CYBER SECURITY</li><li>TYPES OF ACTORS, ATTACKS, MALWARE AND RESOURCES</li><li>FIREWALLS AND ANTIVIRUS</li><li>KEY SECURITY CONCEPTS</li></ul> <p><strong> Course 11: Encryption</strong></p> <ul> <li>Section 01: Introduction</li><li>Section 02: Basics of Common Encryption</li><li>Section 03: Technical Aspects of Encryption</li><li>Section 04: AES Basic Tech Demo</li><li>Section 05: File and System Encryption</li><li>Section 06: Conclusion</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        120 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>Anyone from any background can enrol in this Database Administrator bundle.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>This Database Administrator course has been designed to be fully compatible with tablets and smartphones.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having this expertise will increase the value of your CV and open you up to multiple job sectors.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div>    <p>P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.</p>    </div>

                        </div>

Database Administrator

<div fr-original-style="" style="box-sizing: border-box;">
<h2 style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);">Overview</h2><div style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In an era where digital transformation is at its peak, coding has become an essential skill, with over&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">26 million</strong>&nbsp;software developers worldwide and the number expected to grow to&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">28.7 million by 2024</strong>. Also, coding is the backbone of the modern digital world, powering everything from smartphones to the internet itself? These facts underscore the tremendous demand for skilled programmers and IT professionals across industries.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">With our exclusive coding&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">20-courses</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">bundle&nbsp;</strong>covering C++, Python, JavaScript, and IT fundamentals, you&#39;re on the path to becoming part of this in-demand workforce.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Coding (C++, Python, JavaScript &amp; IT) 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&#39;re looking to break into a new field or deepen your existing knowledge, the<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;Coding&nbsp;</strong>package has something for everyone.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">As part of the Coding (C++, Python, JavaScript &amp; IT) package, you will receive complimentary PDF certificates for all courses in&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Coding</strong>&nbsp;bundle at no extra cost. Equip yourself with the Coding bundle to confidently navigate your career path or personal development journey. Enroll in our Coding bundle today and start growing your career!</p></div><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This&nbsp;</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Coding&nbsp;</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Bundle Comprises the Following CPD Accredited Courses:</strong></p><ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 01:&nbsp;</strong>Introduction to Coding With HTML, CSS, &amp; Javascript</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 02:&nbsp;</strong>C++ Development: The Complete Coding Guide</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 03:&nbsp;</strong>C# Programming - Beginner to Advanced</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 04:&nbsp;</strong>Python Programming: Beginner To Expert</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 05:&nbsp;</strong>The Complete MySQL Server from Scratch: Bootcamp</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 06:&nbsp;</strong>Kotlin Programming: Android Coding Bible</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 07:&nbsp;</strong>Learn Web Development from Scratch</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 08:&nbsp;</strong>The Complete Front-End Web Development Course!</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 09:&nbsp;</strong>Secure Programming of Web Applications</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 10:&nbsp;</strong>JavaScript Project - Game Development with JS</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 11:&nbsp;</strong>Bash Scripting, Linux and Shell Programming</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 12:&nbsp;</strong>Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 13:&nbsp;</strong>Data Analysis</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 14:&nbsp;</strong>R Programming for Data Science</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 15:&nbsp;</strong>Learn Ethical Hacking From A-Z: Beginner To Expert</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 16:&nbsp;</strong>Cyber Security Awareness Training</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 17:&nbsp;</strong>Cloud Computing / CompTIA Cloud+ (CV0-002)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 18:&nbsp;</strong>CompTIA A+ (220-1001)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 19:&nbsp;</strong>Computer Networks Security from Scratch to Advanced</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 20:&nbsp;</strong>Microsoft Excel Complete Course</li></ul><div fr-original-style="" style="box-sizing: border-box;"><table fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td colspan="4" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"><br fr-original-style="" style="box-sizing: border-box;"></td></tr></tbody></table><br fr-original-style="" style="box-sizing: border-box;"></div><section style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What will make you stand out?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Here&#39;s how this comprehensive bundle sets you apart:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">High Demand Skills</strong>: Dive into programming languages and IT skills that are in high demand across various sectors.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">From Zero to Hero</strong>: Whether you&#39;re a beginner or looking to upgrade your skills, this coding bundle caters to all levels.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Expert-Led Training</strong>: Benefit from courses designed and taught by seasoned professionals with real industry experience.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Lifetime Access</strong>: Learn at your own pace with lifetime access to all course materials.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Tutor Support</strong>: Gain access to supportive tutor professionals for guidance.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Versatile Skill Set</strong>: Master the versatility of C++, the simplicity of Python, and the interactivity of JavaScript.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification of Completion</strong>: Enhance your resume with certifications that showcase your skills.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Future-Proof Your Career</strong>: Stay ahead in your career with up-to-date content on the latest technological advancements.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Risk-Free Learning</strong>: A 14-day money-back guarantee ensures that you can start learning risk-free.</li></ul></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 style="color: var(--bs-heading-color); box-sizing: border-box;" fr-original-style=" color: var(--bs-heading-color);">Certificates</h2><h4 style="color: var(--bs-heading-color); box-sizing: border-box;" fr-original-style=" color: var(--bs-heading-color);">Certificate Of Completion</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Digital certificate - Included</p><h4 style="color: var(--bs-heading-color); box-sizing: border-box;" fr-original-style=" color: var(--bs-heading-color);">Certificate Of Completion</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Hard copy certificate - Included</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will get a complimentary Hard Copy Certificate.</p></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 style="color: var(--bs-heading-color); box-sizing: border-box;" fr-original-style=" color: var(--bs-heading-color);"><br fr-original-style="" style="box-sizing: border-box;"></h2></section>

</div>

NextGen Learning

Coding (C++, Python, JavaScript & IT) 20 Courses Bundle

<p><strong>The IT Support Bundle: Your ticket to a career in IT Support</strong></p><p><strong>Do you love computers and technology? Are you always the one who is the IT support guy? The one who your friends and family turn to when they have a problem with their devices? If so, then a career in IT Support might be the perfect fit for you.</strong></p><p>IT Support professionals are in high demand, and they play a vital role in keeping businesses and organizations running smoothly. As an IT Support professional, you will be responsible for troubleshooting and fixing computer problems, installing and configuring software, and helping users with their IT support needs.</p><p>This IT support bundle can be the perfect place to start your career as an IT support professional.</p><p><strong>Key Features</strong></p><ul><li>CPD-Accredited IT support course</li><li>Instant e-certificate</li><li>Fully online, interactive IT Support course with audio voiceover</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Enrol now in this </strong><strong>IT Support </strong><strong>course to excel!</strong></p><p>IT Support is a rapidly growing field that is in high demand. Businesses of all sizes need IT support professionals to help them keep their systems running smoothly.</p><p>This bundle is the perfect way to get started in a career in IT Support. It includes 10 courses that will teach you the essential skills you need to succeed.</p><p><strong>This IT support bundle includes the following courses:</strong></p><ul><li><strong>Course 01:</strong>Functional Skills IT Level 2</li><li><strong>Course 02: </strong>Microsoft Word, PowerPoint &amp; Outlook</li><li><strong>Course 03: </strong>Microsoft Excel</li><li><strong>Course 04: </strong>Cyber Security Awareness Training</li><li><strong>Course 05: </strong>Display Screen Equipment (DSE) Training</li><li><strong>Course 06: </strong>CCTV Operator Course</li><li><strong>Course 07: </strong>CRM - Customer Relationship Management</li><li><strong>Course 08: </strong>Python Programming: Beginner To Expert</li><li><strong>Course 09: </strong>Basics of WordPress: Create Unlimited Websites</li><li><strong>Course 10: </strong>Machine Learning Basics</li></ul><p><strong>Learning Outcomes:</strong></p><ul><li>Understand the basics of IT</li><li>Use Microsoft Office Suite effectively</li><li>Protect systems from cyber attacks</li><li>Use DSE equipment safely</li><li>Operate CCTV systems</li><li>Manage customer relationships</li><li>Program in Python</li><li>Create websites with WordPress</li><li>Learn the basics of machine learning</li></ul><p><strong>Accreditation</strong></p><p>All of our courses included in this IT Support bundle are fully accredited.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your IT Support course, you will immediately be sent digital certificates for the bundle courses. Also, you can have your printed certificate delivered by post (shipping cost £3.99).</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        51 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Anyone who wants to learn about IT support</li><li>Anyone who wants to start a career in IT support</li><li>Anyone who wants to advance their career in IT support</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no formal requirements for this IT support bundle courses to be enrolled.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>T support technician: £20,000 - £30,000</li><li>IT support engineer: £30,000 - £40,000</li><li>IT support manager: £40,000 - £50,000</li><li>IT security analyst: £45,000 - £60,000</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion (Hard copy)</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.</p></div>
        <h4>Certificate of completion (PDF)</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

IT Support - Essential Skills Course

<p>In the dynamic landscape of the UK job market, staying abreast of industry demands is paramount. The recent surge in construction hazards in the UK has underscored the critical need for adept professionals in Payroll Management. Our comprehensive diploma courses not only address this pressing issue but also equip you with a multifaceted skill set crucial for diverse financial roles.</p><p><strong>Learning Outcomes</strong></p><p>Upon completion of this Payroll Management bundle, you should be able to:</p><ul><li>Master payroll administration for effective financial management.</li><li>Navigate accounting complexities with a diploma in accounting and bookkeeping.</li><li>Understand the intricacies of UK pension systems for sound financial planning.</li><li>Enhance legal acumen through Law and Contracts - Level 2.</li><li>Harness the power of Sage 50 Accounts for streamlined financial processes.</li><li>Develop essential office skills and advanced proficiency in Microsoft Excel.</li><li>Gain expertise in GDPR data protection and anti-money laundering practices.</li></ul><p>Our curriculum, ranging from Payroll Management to Bookkeeping and Payroll Administration, not only delves into the intricacies of financial management but also extends to areas like pension schemes, legalities, and data protection. Moreover, our courses integrate practical tools such as Sage 50 Accounts and Microsoft Excel Level 3, ensuring you are proficient in the latest technologies.</p><p><strong>This Payroll Management Bundle Consists of the following Premium courses:</strong></p><ul><li>Course 01: Payroll Management - Diploma</li><li>Course 02: Bookkeeping and Payroll Administration Diploma</li><li>Course 03: Payroll Management - Diploma</li><li>Course 04: Diploma in Accounting and Bookkeeping</li><li>Course 05: Pension UK</li><li>Course 06: Law and Contracts - Level 2</li><li>Course 07: Sage 50 Accounts</li><li>Course 08: Office Skills</li><li>Course 09: Microsoft Excel Level 3</li><li>Course 10: GDPR Data Protection</li><li>Course 11: Certificate in Anti-Money Laundering (AML)</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        110 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Individuals seeking a comprehensive understanding of financial management.</li><li>Professionals aiming to enhance their proficiency in payroll administration.</li><li>Aspirants looking to broaden their knowledge in accounting and bookkeeping.</li><li>Those interested in gaining insights into pension schemes and financial planning.</li><li>Individuals keen on advancing their legal acumen in contracts and legislation.</li><li>Anyone desiring expertise in data protection and anti-money laundering practices.</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>No requirements to enrol this Payroll Management Training course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li><strong>Payroll Administrator</strong>: £25,000 - £35,000 per annum</li><li><strong>Bookkeeper</strong>: £22,000 - £30,000 per annum</li><li><strong>Accounting Assistant</strong>: £23,000 - £32,000 per annum</li><li><strong>Legal Support Officer</strong>: £26,000 - £35,000 per annum</li><li><strong>Compliance Analyst</strong>: £30,000 - £40,000 per annum</li><li><strong>Data Protection Officer</strong>: £35,000 - £45,000 per annum</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPDQS Accredited e-Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>CPDQS Accredited Hard-Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>You will get the Hard Copy certificate for the title course (<strong>Payroll Management - Diploma</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each.</p><p><strong>Please Note:</strong> The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p></div>

                        </div>

Payroll Management Training

<span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Financial Modeling and Analysis are highly respected skills in the business world and are hugely sought after in the job marketplace.</span><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Financial Modelling is a powerful communication tool to clearly and effectively tell the story of a company to management and stakeholders. It is a critical decision-making tool used by management to make accurate and informed financial decisions about a company or project.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It is multidisciplinary, requiring expertise in Accounting, Finance, Financial Analysis, Valuation, and Microsoft Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has been developed to cover the entire body of knowledge issued by the Financial Modeling Institute for Level One; Advanced Financial Modeler Designation.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(35, 35, 51);">This course is certified by the CFA Society Nigeria with 40 PL Credits and CPD UK with 40 CPD Credits.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">In this course, you will learn 3 Statement Modeling from Scratch to Mastery using a real Company&#39;s Audited Financial Statement. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">The course includes</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&nbsp;&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions (with over 200+ step-by-step videos).&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;1 Technical Session to confirm your connectivity and solve any technical issues you may have).&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;10 intensive instructor-led live virtual sessions. Each session is 2 hours&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;9 compulsory intersession assignments you will need to complete and submit on www.OfficeTrainingHub.com&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;Intermittent tests and quizzes to gauge your assimilation.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">&bull; &nbsp; &nbsp;1 Capstone Project</span></p></span>

dbrownconsulting

Financial Modelling & Analysis

Financial Modelling

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

Advanced Financial Modeler Certificate Course

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.</p><p></p><p></p><p>This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course contains a 1-day Applied Workshop. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.</p><p></p></div><div id="course-pills-2"><h3>1 - Get started with Microsoft Power Platform for app makers</h3> <ul> <li>Identify components</li> <li>Create apps</li> <li>Get started with Microsoft Dataverse</li> <li>Work with Copilot in Microsoft Power Platform</li> </ul> <h3>2 - Create tables in Dataverse</h3> <ul> <li>Table characteristics</li> <li>Table relationships</li> <li>Dataverse logic and security</li> <li>Dataverse auditing</li> <li>Dual-write vs. virtual tables</li> </ul> <h3>3 - Create and manage columns within a table in Dataverse</h3> <ul> <li>Define columns in Microsoft Dataverse</li> <li>Column types in Microsoft Dataverse</li> <li>Add a column to a table</li> <li>Primary name column</li> <li>Restrictions that apply to columns in a table</li> <li>Create an auto numbering column</li> <li>Create an alternate key</li> </ul> <h3>4 - Load/export data and create data views in Dataverse</h3> <ul> <li>View data in a table</li> <li>Create or edit views of data in a table</li> <li>Dataverse data import options</li> <li>Load data into a table</li> <li>Dataverse data export options</li> <li>Export</li> <li>Add, update, or delete data in a table by using Excel</li> <li>Import data using Power Query</li> </ul> <h3>5 - Export data from Dataverse and use Microsoft Excel to edit records</h3> <ul> <li>Export data to Excel</li> <li>Edit and update data in Excel</li> </ul> <h3>6 - Get started with Microsoft Dataverse for Teams</h3> <ul> <li>Dataverse for Teams vs Dataverse</li> <li>Provision your first Dataverse environment</li> <li>Create your first table to store data</li> </ul> <h3>7 - Build your first app with Power Apps and Dataverse for Teams</h3> <ul> <li>Create your first app with the hero template</li> <li>Customize your app with Power Apps Studio</li> <li>Publish your app</li> <li>Install template apps</li> </ul> <h3>8 - Build your first workflow with Power Automate and Dataverse for Teams</h3> <ul> <li>Types of workflows that Power Automate can build in Dataverse</li> <li>Schedule a flow</li> </ul> <h3>9 - Create reports with Power BI and Dataverse for Teams</h3> <ul> <li>Connect to and transform Dataverse for Teams data from Power BI</li> <li>Create a Power BI report</li> <li>Publish the report</li> <li>Share the data</li> </ul> <h3>10 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>11 - Explore what Power BI can do for you</h3> <ul> <li>What can I do with the Power BI service as a consumer?</li> <li>View content in the Power BI service</li> <li>Collaborate and share in Power BI</li> <li>Find and view dashboards and reports</li> </ul> <h3>12 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>13 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>14 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>15 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Secure, publish, and share data in Power BI</h3> <ul> <li>Share and use reports in Power BI</li> <li>Row-level security</li> <li>Publish a report to a Power BI workspace</li> <li>Share reports and user experience</li> <li>Protect data in Power BI</li> <li>Data refresh and alerts</li> </ul> <h3>18 - Embed Power BI content</h3> <ul> <li>Embed Power BI reports</li> <li>Embed other Power BI content types</li> <li>Optimize the embedding experience</li> </ul> <h3>19 - How to build your first model-driven app with Dataverse</h3> <ul> <li>Model-driven apps, powered by Microsoft Dataverse</li> <li>Explore sample apps</li> </ul> <h3>20 - Get started with model-driven apps in Power Apps</h3> <ul> <li>Introducing model-driven apps</li> <li>Components of model-driven apps</li> <li>Design model-driven apps</li> <li>Incorporate business process flows</li> </ul> <h3>21 - Configure forms, charts, and dashboards in model-driven apps</h3> <ul> <li>Forms overview</li> <li>Form elements</li> <li>Configure multiple forms</li> <li>Use specialized form components</li> <li>Configure views overview</li> <li>Configure grids</li> <li>Create and edit views</li> <li>Configure charts overview</li> <li>Dashboards overview</li> <li>Use interactive streams and tiles</li> </ul> <h3>22 - Manage Dynamics 365 model-driven app settings and security</h3> <ul> <li>Configure role-based security</li> <li>Manage teams and business units</li> <li>Explore settings and customizations</li> </ul> <h3>23 - Use specialized components in a model-driven form</h3> <ul> <li>Create business process flows</li> <li>Embed a canvas app in a model-driven form</li> <li>Add a timeline in a model-driven form</li> <li>Create a report in a model-driven form</li> </ul> <h3>24 - Get started with Power Apps canvas apps</h3> <ul> <li>Start Power Apps</li> <li>Power Apps data sources</li> <li>Use Power Apps with Power Automate and Power BI</li> <li>Designing a Power Apps app</li> </ul> <h3>25 - Customize a canvas app in Power Apps</h3> <ul> <li>Improve your app by making basic customizations</li> <li>Explore controls and screens in canvas apps</li> </ul> <h3>26 - How to build the User Interface in a canvas app in Power Apps</h3> <ul> <li>Use themes to quickly change the appearance of your app</li> <li>Brand a control</li> <li>Icons</li> <li>Images</li> <li>Personalization</li> <li>Build for phones or tablets</li> </ul> <h3>27 - Navigation in a canvas app in Power Apps</h3> <ul> <li>Understanding navigation</li> <li>The Navigate and Back functions</li> <li>More ways to use the Navigate function</li> </ul> <h3>28 - Manage apps in Power Apps</h3> <ul> <li>Power Apps review</li> </ul> <h3>29 - Build a mobile-optimized app from Power Apps</h3> <ul> <li>Learn about mobile-optimized apps</li> <li>Identify components to make a canvas app mobile-optimized</li> <li>Create a mobile-optimized app that uses responsive designs</li> <li>Identify performance considerations for a mobile-optimized canvas app</li> </ul> <h3>30 - Use and understand Controls in a canvas app in Power Apps</h3> <ul> <li>Core properties of controls</li> <li>Entering and displaying data with text controls</li> <li>Additional controls for enhancing your app's usability</li> <li>Media</li> <li>Modern controls</li> <li>Work with component libraries</li> </ul> <h3>31 - Create formulas to change properties in a Power Apps canvas app</h3> <ul> <li>Formulas overview</li> <li>Use a formula to modify the format of controls</li> <li>Use formulas to perform calculations</li> <li>Use a control to modify the property of other controls</li> <li>Conditional formatting</li> <li>Functions for validating data</li> </ul> <h3>32 - Use imperative development techniques for canvas apps in Power Apps</h3> <ul> <li>Imperative versus declarative development</li> <li>The three types of variables in Power Apps</li> <li>Global variables</li> <li>Contextual variables</li> <li>Collections</li> <li>Additional variable concepts</li> </ul> <h3>33 - Manage apps in Power Apps</h3> <ul> <li>Power Apps review</li> </ul> <h3>34 - Create formulas to change properties in a Power Apps canvas app</h3> <ul> <li>Formulas overview</li> <li>Use a formula to modify the format of controls</li> <li>Use formulas to perform calculations</li> <li>Use a control to modify the property of other controls</li> <li>Conditional formatting</li> <li>Functions for validating data</li> </ul> <h3>35 - Create formulas to change behaviors in a Power Apps canvas app</h3> <ul> <li>Formulas and functionality</li> <li>Understanding true and false</li> <li>Understanding control behaviors and actions</li> <li>Performing multiple actions in a formula</li> <li>Control the display mode through a formula</li> <li>Use controls and functions to create a dynamic formula</li> </ul> <h3>36 - Author a basic formula that uses tables and records in a Power Apps canvas app</h3> <ul> <li>Records and tables</li> <li>Using the Table function</li> <li>Store a table</li> <li>Filter your table</li> <li>Use the lookup function to return a record</li> <li>Additional table functions</li> </ul> <h3>37 - Build a canvas app for a real estate solution with Copilot in Power Apps</h3><h3>38 - Get started with Power Automate</h3> <ul> <li>Introducing Power Automate</li> <li>Create your first flow</li> <li>Troubleshoot flows</li> </ul> <h3>39 - Build approval flows with Power Automate</h3> <ul> <li>Provide solutions to real-world scenarios.</li> </ul> <h3>40 - Build flows to manage user information</h3><h3>41 - Power Automate's deep integration across multiple data sources</h3><h3>42 - Use the Admin center to manage environments and data policies in Power Automate</h3> <ul> <li>Administer flows</li> <li>Export and import flows</li> <li>Learn how to distribute button flows</li> </ul> <h3>43 - Use AI Builder in Power Automate</h3> <ul> <li>AI Builder in Power Automate saves time</li> <li>Advanced usage of AI Builder in Power Automate</li> </ul> <h3>44 - Optimize your business process with process advisor</h3> <ul> <li>Get familiar with process advisor</li> <li>Create your first recording</li> <li>Edit recordings and group actions</li> <li>Analyze recordings and interpret results</li> <li>Automation recommendations</li> </ul> <h3>45 - Optimize your business process with process advisor</h3> <ul> <li>Get familiar with process advisor</li> <li>Create your first recording</li> <li>Edit recordings and group actions</li> <li>Analyze recordings and interpret results</li> <li>Automation recommendations</li> </ul> <h3>46 - Build flows for a real estate solution using Copilot in Power Automate</h3> <ul> <li>When to use Copilot in Power Automate</li> </ul> <h3>47 - Use Dataverse triggers and actions in Power Automate</h3> <ul> <li>Dataverse triggers</li> <li>Query data</li> <li>Create, update, delete, and relate actions</li> </ul> <h3>48 - Create tables in Dataverse</h3> <ul> <li>Table characteristics</li> <li>Table relationships</li> <li>Dataverse logic and security</li> <li>Dataverse auditing</li> <li>Dual-write vs. virtual tables</li> </ul> <h3>49 - Create and manage columns within a table in Dataverse</h3> <ul> <li>Define columns in Microsoft Dataverse</li> <li>Column types in Microsoft Dataverse</li> <li>Add a column to a table</li> <li>Primary name column</li> <li>Restrictions that apply to columns in a table</li> <li>Create an auto numbering column</li> <li>Create an alternate key</li> </ul> <h3>50 - Get started with Power Apps canvas apps</h3> <ul> <li>Start Power Apps</li> <li>Power Apps data sources</li> <li>Use Power Apps with Power Automate and Power BI</li> <li>Designing a Power Apps app</li> </ul> <h3>51 - How to build the User Interface in a canvas app in Power Apps</h3> <ul> <li>Use themes to quickly change the appearance of your app</li> <li>Brand a control</li> <li>Icons</li> <li>Images</li> <li>Personalization</li> <li>Build for phones or tablets</li> </ul> <h3>52 - Get started with Power Automate</h3> <ul> <li>Introducing Power Automate</li> <li>Create your first flow</li> <li>Troubleshoot flows</li> </ul> <h3>53 - Challenge Project - Build a booking requests app with Power Apps and Power Automate</h3> <ul> <li>Prepare</li> </ul></div>

Nexus Human

Microsoft Power Apps

Power Apps

Microsoft Power BI

Microsoft Power Platform

Power Automate

Microsoft Power Automate

PL-100T00 Microsoft Power Platform App Maker

<h2>Microsoft Excel® in Depth (Virtual)</h2>
 <p>This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.</p>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p><h3>What you will Learn</h3>
 <p>You'll learn how to:</p>
 <ul>
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li>
 <li>Create meaningful charts</li>
 <li>Use pivot tables</li>
 <li>Use Conditional Formatting, Data Validation</li>
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li>
 </ul>

IIL Europe Ltd

Microsoft Excel in Depth (Virtual)

<p><strong>***Offer Ends Today***</strong></p><p><strong>Earn up to 40K as a 'DATA ANALYST' or Your 100% Money Back</strong></p><p>Do you know that entry-level data analysts earn an average of <strong>£40,000 </strong>annually, with the potential to quickly earn six figures with experience and expertise? Are you looking to join the high-demand field of data analytics and earn a handsome salary? Our <strong>Data Analyst Job Ready Program</strong> is here to guide you all the way until you get the job you want.</p><p>Our Data Analyst Job Ready Program is your all-in-one solution to learn data analytics from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job in data analytics. By choosing our Data Analyst Job Ready Program, you're not just gaining skills; you're gaining a lifelong career partner.</p><p><strong>Our mission is simple - to be your trusted partner every step of the way, from Training to Employment.</strong></p><p>Enrol Now and Kickstart Your Data Analytics Career. Don't miss this opportunity to transform your career with the Data Analyst Job Ready Program. With our comprehensive training, career support, and money-back guarantee, you're not just enrolling in a program; you're investing in a brighter future. Join us now and become a part of the next generation of data analysts!</p><p>In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Data Analysts, so we can help you get the job you want.</p><p>If you are not happy with our service, we also offer a <strong>100% money-back guarantee</strong>. So what are you waiting for? Enrol in our Data Analyst Job Ready Program today and start your journey to becoming a successful Data Analyst!</p><p><strong>Why Choose Us?</strong></p><p>So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Data Analyst Job Ready Program:</p><ul><li><strong>Personalised Guidance: </strong>Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis.<br /><br /></li><li><strong>One-On-One Consultation Sessions with Experts: </strong>Gain invaluable insights and guidance from seasoned professionals who have thrived in the Data Analyst field.<br /><br /></li><li><strong>Extensive Job Opportunities:</strong> We have established partnerships with numerous companies actively seeking Data analysts. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere.<br /><br /></li><li><strong>Interview Preparation:</strong> We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress.<br /><br /></li><li><strong>100% Money-Back Guarantee: </strong>Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee.</li></ul><p><strong>Courses we will provide once you enrol in the program:</strong></p><ul><li><strong>Course 01: </strong>Introduction to Data Analysis</li><li><strong>Course 02: </strong>Business and Data Analytics for Beginners</li><li><strong>Course 03: </strong>Data Analytics with Tableau</li><li><strong>Course 04: </strong>Quick Data Science Approach from Scratch</li><li><strong>Course 05: </strong>Learn MySQL from Scratch for Data Science and Analytics</li><li><strong>Course 06: </strong>SQL for Data Science, Data Analytics and Data Visualization</li><li><strong>Course 07: </strong>Statistics &amp; Probability for Data Science &amp; Machine Learning</li><li><strong>Course 08: </strong>Basic Google Data Studio</li><li><strong>Course 09: </strong>R Programming for Data Science</li><li><strong>Course 10: </strong>Python Data Science with Numpy, Pandas and Matplotlib</li><li><strong>Course 11: </strong>Complete Python Machine Learning &amp; Data Science Fundamentals</li><li><strong>Course 12: </strong>2021 Data Science &amp; Machine Learning with R from A-Z</li><li><strong>Course 13: </strong>Microsoft Excel Complete Course</li><li><strong>Course 14: </strong>Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li><strong>Course 15: </strong>Data Center Training Essentials: General Introduction</li><li><strong>Course 16: </strong>Excel Data Analysis</li><li><strong>Course 17: </strong>Data Entry Administrator Training</li><li><strong>Course 18: </strong>SQL Masterclass: SQL For Data Analytics</li><li><strong>Course 19: </strong>Business Data Analysis</li><li><strong>Course 20: </strong>Master JavaScript with Data Visualization</li></ul><p><strong>How Can We Offer Job Guarantees?</strong></p><p>HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector.</p> <p><strong>The Data Analyst Job Ready Program with Career Support &amp; Money Back Guarantee is completed in 9 easy steps:</strong></p><p><strong>Step 1: Enrol in the Programme</strong></p><p>Begin your exciting journey with us by enrolling in the Data and Business Intelligence Analyst Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied.</p><p>After you enrol in the Program, you will get lifetime access to 6 premium courses related to Web Development. These courses will teach you the knowledge and skills required to become a successful Data and Business Intelligence Analyst. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing!</p><p><strong>Step 2: Initial One-On-One Counselling Session</strong></p><p>Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path.</p><p><strong>Step 3: Certification upon Course Completion</strong></p><p>After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject.</p><p><strong>Step 4: CV Revamping</strong></p><p>Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the finance industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently.</p><p><strong>Step 5: Building Network and Submitting CV</strong></p><p>We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile.</p><p><strong>Step 6: Interview Preparation</strong></p><p>With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills.</p><p><strong>Step 7: Securing Job Interviews</strong></p><p>Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want.</p><p><strong>Step 8: Post-Interview Support</strong></p><p>Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job.</p><p><strong>Step 9: Celebrate Your New Job!</strong></p><p>Once you've secured your dream job in web development, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role.</p><p>We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful Data and Business Intelligence Analyst career begins with us.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        1000 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p><strong>This Data Analyst Job Ready Program is perfect for:</strong></p><ul><li>Beginners eager to break into the field of data analytics and get a job.</li><li>Professionals looking to move their career towards data science.</li><li>Individuals seeking a comprehensive understanding of data analysis tools and techniques.</li><li>Those aiming for a career upgrade with advanced analytics skills.</li><li>Anyone interested in gaining practical, job-ready skills in data analytics and machine learning.</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This Data Analyst Job Ready Program will help you get a job in different roles, such as:</p><ul><li>Entry-Level Data Analyst: £25,000 - £35,000</li><li>Mid-Level Data Analyst: £35,000 - £60,000</li><li>Senior Data Analyst: £50,000 - £80,000</li><li>Data Scientist: £40,000 - £100,000</li><li>Data Analytics Manager: £60,000 - £100,000</li><li>Business Intelligence Analyst: £30,000 - £75,000</li><li>Machine Learning Engineer: £45,000 - £80,000</li></ul>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited e-Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>CPD Accredited Framed (Hardcopy) Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
        <h4>Enrolment Letter</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>QLS Endorsed Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
        <h4>Student ID Card</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

***Offer Ends Today***
Earn up to 40K as a 'DATA ANALYST' or Your 100% Money Back
Do you know that entry-level data analysts earn an average of £40,000 annually, with the potential to quickly earn six figures with experience and expertise? Are you looking to join the high-demand field of data analytics and earn a handsome salary? Our Data Analyst Job Ready Program is here to guide you all the way until you get the job you want.
Our Data Analyst Job Ready Program is your all-in-one solution to learn data analytics from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job in data analytics. By choosing our Data Analyst Job Ready Program, you're not just gaining skills; you're gaining a lifelong career partner.
Our mission is simple - to be your trusted partner every step of the way, from Training to Employment.
Enrol Now and Kickstart Your Data Analytics Career. Don't miss this opportunity to transform your career with the Data Analyst Job Ready Program. With our comprehensive training, career support, and money-back guarantee, you're not just enrolling in a program; you're investing in a brighter future. Join us now and become a part of the next generation of data analysts!
In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Data Analysts, so we can help you get the job you want.
If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Data Analyst Job Ready Program today and start your journey to becoming a successful Data Analyst!
Why Choose Us?
So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Data Analyst Job Ready Program:
Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis.
One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Data Analyst field.
Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Data analysts. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere.
Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress.
100% Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee.
Courses we will provide once you enrol in the program:
Course 01: Introduction to Data Analysis
Course 02: Business and Data Analytics for Beginners
Course 03: Data Analytics with Tableau
Course 04: Quick Data Science Approach from Scratch
Course 05: Learn MySQL from Scratch for Data Science and Analytics
Course 06: SQL for Data Science, Data Analytics and Data Visualization
Course 07: Statistics & Probability for Data Science & Machine Learning
Course 08: Basic Google Data Studio
Course 09: R Programming for Data Science
Course 10: Python Data Science with Numpy, Pandas and Matplotlib
Course 11: Complete Python Machine Learning & Data Science Fundamentals
Course 12: 2021 Data Science & Machine Learning with R from A-Z
Course 13: Microsoft Excel Complete Course
Course 14: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 15: Data Center Training Essentials: General Introduction
Course 16: Excel Data Analysis
Course 17: Data Entry Administrator Training
Course 18: SQL Masterclass: SQL For Data Analytics
Course 19: Business Data Analysis
Course 20: Master JavaScript with Data Visualization
How Can We Offer Job Guarantees?
HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector.
The Data Analyst Job Ready Program with Career Support & Money Back Guarantee is completed in 9 easy steps:
Step 1: Enrol in the Programme
Begin your exciting journey with us by enrolling in the Data and Business Intelligence Analyst Job Ready Program. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied.
After you enrol in the Program, you will get lifetime access to 6 premium courses related to Web Development. These courses will teach you the knowledge and skills required to become a successful Data and Business Intelligence Analyst. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about a thing!
Step 2: Initial One-On-One Counselling Session
Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path.
Step 3: Certification upon Course Completion
After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject.
Step 4: CV Revamping
Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the finance industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently.
Step 5: Building Network and Submitting CV
We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile.
Step 6: Interview Preparation
With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills.
Step 7: Securing Job Interviews
Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want.
Step 8: Post-Interview Support
Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job.
Step 9: Celebrate Your New Job!
Once you've secured your dream job in web development, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role.
We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful Data and Business Intelligence Analyst career begins with us.
 CPD 
1000 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
This Data Analyst Job Ready Program is perfect for:
Beginners eager to break into the field of data analytics and get a job.
Professionals looking to move their career towards data science.
Individuals seeking a comprehensive understanding of data analysis tools and techniques.
Those aiming for a career upgrade with advanced analytics skills.
Anyone interested in gaining practical, job-ready skills in data analytics and machine learning.
 Career path 
This Data Analyst Job Ready Program will help you get a job in different roles, such as:
Entry-Level Data Analyst: £25,000 - £35,000
Mid-Level Data Analyst: £35,000 - £60,000
Senior Data Analyst: £50,000 - £80,000
Data Scientist: £40,000 - £100,000
Data Analytics Manager: £60,000 - £100,000
Business Intelligence Analyst: £30,000 - £75,000
Machine Learning Engineer: £45,000 - £80,000
 Certificates 
CPD Accredited e-Certificate
 Digital certificate - Included 
CPD Accredited Framed (Hardcopy) Certificate
 Hard copy certificate - Included 
Enrolment Letter
 Digital certificate - Included 
QLS Endorsed Hard Copy Certificate
 Hard copy certificate - Included 
Student ID Card
 Digital certificate - Included 

Academy for Health and Fitness

Business Analytics & Intelligence

Data Engineering

Big Data Analytics

Data Science

HR Analytics

Data Analyst

Data Analyst Job Guarantee Program with Career Support & Money Back Guarantee

London

<h2>Microsoft Excel® in Depth: In-House Training</h2>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p>
 <p>This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.</p>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <ul> 
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li> 
 <li>Create meaningful charts</li> 
 <li>Use pivot tables</li> 
 <li>Use Conditional Formatting, Data Validation</li> 
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li> 
 </ul><section>
                    <h3>Getting Started</h3> 
 <ul> 
 <li>The building blocks of Excel, built-in functions, will be examined</li> 
 <li>The basics of formatting your data will be examined</li> 
 <li>Shortcuts and data manipulation will be explored</li> 
 <li>Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail</li> 
 </ul> 
 <p>Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more</p> 
 <h3>Using Named ranges, Data Validation, Sorting, and Filtering</h3> 
 <ul> 
 <li>Learn the Name manager;</li> 
 <li>Learn the difference between local and global names;</li> 
 <li>Ensure correct access to linked workbooks;</li> 
 <li>Ensure data accuracy;</li> 
 <li>Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);</li> 
 <li>Sorting by more than 3 fields;</li> 
 <li>Filtering by font, pattern, or value;</li> 
 <li>See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value</li> 
 </ul> 
 <h3>Conditional formatting and data formatting</h3> 
 <ul> 
 <li>Make relevant data stand out</li> 
 <li>Isolate highs and lows</li> 
 <li>Make error cells invisible</li> 
 <li>Learn about Data bars, Icon sets, and Color scales</li> 
 <li>Highlight differences between worksheets</li> 
 <li>Learn all the codes in the Format/Number list</li> 
 <li>Using cell Styles</li> 
 <li>Learn all about alignment, protection, borders, colors and more</li> 
 </ul> 
 <h3>Pivot Tables</h3> 
 <ul> 
 <li>Learn how to summarize large amounts of data with a few clicks</li> 
 <li>Learn various ways of presenting the data</li> 
 <li>Learn the various pivot table tools</li> 
 <li>Learn how to customize and format a pivot table to suit your needs</li> 
 <li>Learn how to group data</li> 
 <li>Learn how to use the various options to present your data</li> 
 </ul> 
 <h3>Charts</h3> 
 <ul> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn the 11 types of built-in charts</li> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn how to customize the charts to make the information tell the right story</li> 
 <li>Learn how to use the design, layout, and formatting available to charts in Excel 2007</li> 
 <li>Learn embedded charts versus chart sheets</li> 
 <li>Learn how to use modify all the pieces of a chart</li> 
 </ul> 
 <h3>Array formulas</h3> 
 <ul> 
 <li>Learn how to use the most powerful formulas in Excel</li> 
 <li>Learn how to combine many formulas into one compact array-formula</li> 
 <li>Learn the real power of these formulas and why regular formulas can't do the job</li> 
 <li>Learn how to use built-in array formulas, like TREND or TRANSPOSE</li> 
 </ul>


                </section>

Microsoft Excel in Depth: In-House Training

<h2>Microsoft Excel® in Depth: Virtual In-House Training</h2>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p>
 <p>This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions.</p>
 <p>The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects.</p><h3>What you Will Learn</h3>
 <p>You'll learn how to:</p>
 <ul>
 <li>Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more</li>
 <li>Create meaningful charts</li>
 <li>Use pivot tables</li>
 <li>Use Conditional Formatting, Data Validation</li>
 <li>Take advantage of using Named ranges, do sorting, filtering, tables</li>
 </ul><section>
                    <h3>Getting Started</h3> 
 <ul> 
 <li>The building blocks of Excel, built-in functions, will be examined</li> 
 <li>The basics of formatting your data will be examined</li> 
 <li>Shortcuts and data manipulation will be explored</li> 
 <li>Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail</li> 
 </ul> 
 <p>Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more</p> 
 <h3>Using Named ranges, Data Validation, Sorting, and Filtering</h3> 
 <ul> 
 <li>Learn the Name manager;</li> 
 <li>Learn the difference between local and global names;</li> 
 <li>Ensure correct access to linked workbooks;</li> 
 <li>Ensure data accuracy;</li> 
 <li>Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.);</li> 
 <li>Sorting by more than 3 fields;</li> 
 <li>Filtering by font, pattern, or value;</li> 
 <li>See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value</li> 
 </ul> 
 <h3>Conditional formatting and data formatting</h3> 
 <ul> 
 <li>Make relevant data stand out</li> 
 <li>Isolate highs and lows</li> 
 <li>Make error cells invisible</li> 
 <li>Learn about Data bars, Icon sets, and Color scales</li> 
 <li>Highlight differences between worksheets</li> 
 <li>Learn all the codes in the Format/Number list</li> 
 <li>Using cell Styles</li> 
 <li>Learn all about alignment, protection, borders, colors and more</li> 
 </ul> 
 <h3>Pivot Tables</h3> 
 <ul> 
 <li>Learn how to summarize large amounts of data with a few clicks</li> 
 <li>Learn various ways of presenting the data</li> 
 <li>Learn the various pivot table tools</li> 
 <li>Learn how to customize and format a pivot table to suit your needs</li> 
 <li>Learn how to group data</li> 
 <li>Learn how to use the various options to present your data</li> 
 </ul> 
 <h3>Charts</h3> 
 <ul> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn the 11 types of built-in charts</li> 
 <li>Learn how to create a chart with one keystroke!</li> 
 <li>Learn how to customize the charts to make the information tell the right story</li> 
 <li>Learn how to use the design, layout, and formatting available to charts in Excel 2007</li> 
 <li>Learn embedded charts versus chart sheets</li> 
 <li>Learn how to use modify all the pieces of a chart</li> 
 </ul> 
 <h3>Array formulas</h3> 
 <ul> 
 <li>Learn how to use the most powerful formulas in Excel</li> 
 <li>Learn how to combine many formulas into one compact array-formula</li> 
 <li>Learn the real power of these formulas and why regular formulas can't do the job</li> 
 <li>Learn how to use built-in array formulas, like TREND or TRANSPOSE</li> 
 </ul>


                </section>

Microsoft Excel in Depth: Virtual In-House Training

<p fr-original-style=" color: rgb(98, 98, 98);" id="isPasted" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The eight 1/2 day Support Manager course is uniquely created to provide training on the fundamentals of management relative to the support environment, and to enhance the inherent skills and knowledge of the support manager. This course focuses specifically on the most common management elements that occur in the technical support centre including, managing customer satisfaction, operations and team performance management and facilitating a team while managing a dynamic service product. This course offers support managers the opportunity to develop and refine their technology support leadership skills enabling them to effectively manage the challenges of the most complex support centres.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Attend</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The Support Manager course is for managers who have at least six months management experience and have received some basic management training.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Requirements</strong></p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">The course begins with a review and quiz on a set of pre-class reading materials. These materials are sent to each participant two weeks prior to the class start date. Participants are strongly encouraged to register at least two weeks in advance to allow time to complete these pre-class assignments.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">Each participant is required to bring the pre-class reading materials as well as a notebook computer with a USB port and with Microsoft Excel, Word and PowerPoint installed. These will be used as tools during the course. All other materials and tools will be provided.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;">Homework is assigned for most evenings of the course. Please plan for study time outside of class.</p><p fr-original-style=" color: rgb(98, 98, 98);" style="color: rgb(98, 98, 98); font-size: var(--font-size); box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Some of the training objectives&hellip;</b></p><ul fr-original-style=" color: rgb(115, 126, 134);" style="color: rgb(115, 126, 134); box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Manage dynamics of change within the support centre</li><li fr-original-style="" style="box-sizing: border-box;">Enhance leadership skills</li><li fr-original-style="" style="box-sizing: border-box;">Effective staff utilisation</li><li fr-original-style="" style="box-sizing: border-box;">Increase support centre morale and retention</li></ul>

SGSA Limited

Support Manager

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.</p>Overview<p>Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance.</p><p>VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.</p>Prerequisites<p>To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.</p></div><div id="course-pills-2"><h3>1. Using VBA to Solve Business Problems</h3><ul> <li>Use Macros to Automate Tasks in Excel</li> <li>Identify Components of Macro-Enabled Workbooks</li> <li>Configure the Excel VBA Environment</li></ul>  <h3>2. Recording a Macro</h3><ul> <li>Use the Macro Recorder to Create a VBA Macro</li> <li>Record a Macro with Relative Addressing</li> <li>Delete Macros and Modules</li> <li>Identify Strategies for Using the Macro Recorder</li></ul>  <h3>3. Writing VBA Code Directly</h3><ul> <li>Write VBA Code</li> <li>Discover Objects You Can Use</li> <li>Create a Custom Function</li></ul>  <h3>4. Solving Problems through Code</h3><ul> <li>Make Decisions in Code</li> <li>Work with Variables</li> <li>Perform Repetitive Tasks</li></ul>  <h3>5. Improving Your VBA Code</h3><ul> <li>Debug VBA Errors</li> <li>Deal with Errors</li> <li>Improve Macro Performance</li></ul>  <h3>6.  Controlling How and When Macros Run</h3><ul> <li>Prompt the User for Information</li> <li>Configure Macros to Run Automatically</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Visual Basic

Access VBA

Visual Basic Analysis

Microsoft Virtual Academy (MVA)

Microsoft Excel

Trainers Course

VBA with Microsoft Excel

<p>Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel courses. At <strong>UKHF Online</strong>, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel. Whether you're a student, recent graduate, or job seeker, our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition.</p><p><strong>Key Features of the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel Bundle:</strong></p><ul><li><strong>3 QLS-Endorsed Courses:</strong> We proudly offer 3 QLS-endorsed courses within our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle, providing you with industry-recognized qualifications. Plus, you'll receive a <strong>free hardcopy certificate</strong> for each of these courses.</li><ul><li><strong>QLS Course 01: </strong>Microsoft Teams - Master Microsoft Teams</li><li><strong> QLS Course 02:</strong> The Complete Microsoft Outlook Masterclass</li><li><strong> QLS Course 03: </strong>New Functions in Microsoft Excel 2021</li></ul></ul><ul><li><strong>5 CPD QS Accredited Courses</strong>: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices.</li><ul><li><strong>Course 01: </strong>Microsoft Excel Complete Course 2019</li><li><strong>Course 02: </strong>Microsoft Office 2016 Advanced</li><li><strong>Course 03:</strong> Microsoft Access Databases Forms and Reports</li><li><strong>Course 04: </strong>Microsoft Word Advanced</li><li><strong>Course 05: </strong>Outlook Tips and tricks</li></ul></ul><ul><li>In Addition, you'll get <strong>Five Career Boosting Courses</strong> absolutely FREE with this Bundle.</li><ul><li><strong>Course 01: </strong>Professional CV Writing</li><li><strong>Course 02: </strong>Job Search Skills</li><li><strong>Course 03:</strong> Self Esteem &amp; Confidence Building</li><li><strong>Course 04: </strong>Professional Diploma in Stress Management</li><li><strong>Course 05: </strong>Complete Communication Skills Master Class</li></ul></ul><ul><li>Convenient Online Learning: Our Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home.</li></ul><p><strong>Learning Outcomes of the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel Bundle:</strong></p><ul><li>Master the foundational principles and techniques of Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Develop advanced proficiency in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel methodologies and strategies.</li><li>Acquire in-depth knowledge of the latest trends and advancements in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Enhance your problem-solving and critical thinking abilities within the context of Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li><li>Cultivate strong communication and collaboration skills essential for success in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel.</li></ul> <p>The Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Microsoft Teams, Microsoft Outlook &amp; Microsoft Excel bundle, giving you the recognition you deserve.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        250 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Professionals who want to improve their skills in Microsoft Office applications</li><li>Individuals who want to enhance their problem-solving and analytical skills</li><li>Anyone looking to develop their career in a business or administrative role</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Administrative Assistant: £17,000 - £30,000 per year</li><li>Business Analyst: £25,000 - £60,000 per year</li><li>Data Analyst: £22,000 - £48,000 per year</li><li>Operations Manager: £24,000 - £70,000 per year</li><li>Project Manager: £25,000 - £70,000 per year</li></ul>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>

                        </div>

QLS Endorsed Diploma! Free 3 QLS Certificates + Free 10 CPD Course & Assessments> 250 CPD Points > Lifetime Access

Begin your journey towards a rewarding and successful career by enrolling in our all-inclusive bundle of 8 Microsoft Teams, Microsoft Outlook & Microsoft Excel courses. At UKHF Online, we have carefully selected and combined these courses to equip you with the vital skills and knowledge necessary to thrive in Microsoft Teams, Microsoft Outlook & Microsoft Excel. Whether you're a student, recent graduate, or job seeker, our Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle is designed to enhance your CV, impress potential employers, and set you apart from the competition.
Key Features of the Microsoft Teams, Microsoft Outlook & Microsoft Excel Bundle:
3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses.
QLS Course 01: Microsoft Teams - Master Microsoft Teams
QLS Course 02: The Complete Microsoft Outlook Masterclass
QLS Course 03: New Functions in Microsoft Excel 2021
5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices.
Course 01: Microsoft Excel Complete Course 2019
Course 02: Microsoft Office 2016 Advanced
Course 03: Microsoft Access Databases Forms and Reports
Course 04: Microsoft Word Advanced
Course 05: Outlook Tips and tricks
In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle.
Course 01: Professional CV Writing
Course 02: Job Search Skills
Course 03: Self Esteem & Confidence Building
Course 04: Professional Diploma in Stress Management
Course 05: Complete Communication Skills Master Class
Convenient Online Learning: Our Microsoft Teams, Microsoft Outlook & Microsoft Excel courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home.
Learning Outcomes of the Microsoft Teams, Microsoft Outlook & Microsoft Excel Bundle:
Master the foundational principles and techniques of Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Develop advanced proficiency in Microsoft Teams, Microsoft Outlook & Microsoft Excel methodologies and strategies.
Acquire in-depth knowledge of the latest trends and advancements in Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Enhance your problem-solving and critical thinking abilities within the context of Microsoft Teams, Microsoft Outlook & Microsoft Excel.
Cultivate strong communication and collaboration skills essential for success in Microsoft Teams, Microsoft Outlook & Microsoft Excel.
The Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Microsoft Teams, Microsoft Outlook & Microsoft Excel. With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Microsoft Teams, Microsoft Outlook & Microsoft Excel bundle, giving you the recognition you deserve.
 CPD 
250 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
Professionals who want to improve their skills in Microsoft Office applications
Individuals who want to enhance their problem-solving and analytical skills
Anyone looking to develop their career in a business or administrative role
 Career path 
Administrative Assistant: £17,000 - £30,000 per year
Business Analyst: £25,000 - £60,000 per year
Data Analyst: £22,000 - £48,000 per year
Operations Manager: £24,000 - £70,000 per year
Project Manager: £25,000 - £70,000 per year
 Certificates 
Digital certificate
 Digital certificate - Included 
Hard copy certificate
 Hard copy certificate - Included 

Microsoft Teams

Office Skills & Productivity

Microsoft Certification

Microsoft 365

Microsoft Office

Microsoft AZ-303

QLS Endorsed Diploma! Free 3 QLS Certificates + Free 10 CPD Course & Assessments> 250 CPD Points > Lifetime Access

Microsoft Teams, Microsoft Outlook & Microsoft Excel

<section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Virtual Instructor Led Training (VILT)</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">intermediate level 5 half-day Virtual Instructor Led Training (VILT) course</strong>&nbsp;is a comprehensive course that explains the technology of shell and tube heat exchangers as these robust types of heat exchangers are the most commonly used in the process and refinery industries where they provide flexibility and are easy to maintain.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The VILT course will provide details on the thermal and mechanical design, fabrication, inspection and maintenance in relation with international standards such as TEMA, API and ISO. For this heat exchanger type, the focus is on the mechanical and practical aspects.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Many case studies will be presented to demonstrate failures and mismatches. The thermal and mechanical design is conducted using sophisticated computer software and this VILT course is intended to complement thermal design training based on HTRI software. Participants will be offered problem case studies in order to reach solutions on their own.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To get a full picture of proven (advanced) heat transfer technologies, a basic training module for other types of heat exchangers is included. Besides Air Cooled, there will be a discussion on compact heat exchangers in more detail with all their pros and cons.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Participants are advised to bring a scientific calculator and laptop with Microsoft Excel installed.</p></section><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINING OBJECTIVES</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of this VILT course, participants will be equipped on the following:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">For engineers, this VILT course will provide a broad understanding of the technology and an excellent base for further learning.</li><li fr-original-style="" style="box-sizing: border-box;">For those responsible for thermal design, TEMA type selection, the training is intended to illustrate the interaction between the thermal and mechanical design, the understanding of which will lead to more reliable design outcomes.</li><li fr-original-style="" style="box-sizing: border-box;">For those coming from an operating environment, the VILT course will lead to a greater knowledge of the maintenance, inspection and repair needs of shell and tube heat exchangers, including information on common causes of failure. Solutions will be offered using the latest &ldquo;state of art&rdquo; technologies used to prevent fouling, tube vibration and throughput limitations.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TARGET AUDIENCE</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This VILT course is intended for professionals who want to improve the performance of heat exchanger in their company for shell and tube and compact types and include:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Mechanical Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Design Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Maintenance Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Instrument Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Project Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Process Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Heat Transfer Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Plant Engineers</li><li fr-original-style="" style="box-sizing: border-box;">Operation Engineers</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">COURSE LEVEL</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseThree" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINING METHODS</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This VILT course will be delivered online in&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5 half-day sessions comprising 4 hours per day</strong>, with 2 breaks of 10 minutes per day.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total).</p></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINER</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert course leader has almost 40 years of experience in Heat Exchanger Technologies. He is an international expert in heat exchanger type selection, special thermal/hydraulic design and latest enhanced heat transfer technologies. He conducts many training courses in this area and more than 1,000 employees, representing more than 250 companies, have attended his courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional Positions &amp; Credentials</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Former Chairman and Founder of HTRI&rsquo;s first Communication Committee: CC-Holland</li><li fr-original-style="" style="box-sizing: border-box;">CC-Holland (Chairman 1994 &ndash; 1997; Member 2004 &ndash; Present)</li><li fr-original-style="" style="box-sizing: border-box;">Chairman of NLAHX SenterNovem Working Party (1999 &ndash; 2010)</li><li fr-original-style="" style="box-sizing: border-box;">Member of ESDU Crude Oil Fouling Working Party (1999 &ndash; 2003)</li><li fr-original-style="" style="box-sizing: border-box;">Guest Lecturer Technical University Twente &amp; Eindhoven, The Netherlands</li><li fr-original-style="" style="box-sizing: border-box;">Guest Lecturer HTRI European Seminar October (2004 &amp; 2005)</li><li fr-original-style="" style="box-sizing: border-box;">Member of the Tasc-Force Committee ISO 16812</li><li fr-original-style="" style="box-sizing: border-box;">HTRI&rsquo;s Representative for The Netherlands (2008 &ndash; 2013)</li><li fr-original-style="" style="box-sizing: border-box;">Senior Fellow Heat Exchangers at BECHT</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Publications</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Reduced Total Life Cycle Costs Using Helixchanger Heat Exchangers and Enhancement Technology for the Process Industries (Co-Author, Davos, Switzerland July, 2001)</li><li fr-original-style="" style="box-sizing: border-box;">Reduced Total Life Cycle Costs Using Helixchanger Heat Exchangers (Co-Author, Hamilton, Canada, October, 2003)</li><li fr-original-style="" style="box-sizing: border-box;">Most frequently used Heat Exchangers from pioneering research to application worldwide (Co-Author, Prague, Czech Republic, October, 2004)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Previous Clients Include:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">BP</li><li fr-original-style="" style="box-sizing: border-box;">TOTAL</li><li fr-original-style="" style="box-sizing: border-box;">ExxonMobil</li><li fr-original-style="" style="box-sizing: border-box;">Shell Global Solutions</li><li fr-original-style="" style="box-sizing: border-box;">BASF</li><li fr-original-style="" style="box-sizing: border-box;">Technip</li><li fr-original-style="" style="box-sizing: border-box;">Aker Kvaerner</li><li fr-original-style="" style="box-sizing: border-box;">AKZO</li><li fr-original-style="" style="box-sizing: border-box;">Stamicarbon</li><li fr-original-style="" style="box-sizing: border-box;">FLUOR</li><li fr-original-style="" style="box-sizing: border-box;">Worley</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/tema-htri-heat-exchanger-design-cost-saving-management-virtual-instructor-led-training-vilt/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br fr-original-style="" style="box-sizing: border-box;"><a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" rel="noopener" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information about post training coaching support</a>&nbsp;and fees applicable for this.</p></div></section>

EnergyEdge - Training for a Sustainable Energy Future

Maintenance

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.

844 Courses

Retail Store Assistant Course

By Training Express

Personal Finance Diploma - CPD Accredited

By Apex Learning

Wages & Benefits: Understanding Payroll Management

By Apex Learning

Microsoft Office Specialist (MOS) - Excel, Word, PowerPoint, Outlook & Data Analysis

By Apex Learning

Accountancy, AML, Financial Investigator

By Apex Learning

Payroll, Employment Law & Business Administration

By Apex Learning

Database Administrator

By Apex Learning

Coding (C++, Python, JavaScript & IT) 20 Courses Bundle

By NextGen Learning

IT Support - Essential Skills Course

By Training Express

Payroll Management Training

By Apex Learning

Search By Location