3297 Courses delivered Online

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

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Unlock the power of financial knowledge with our Accounting & Bookkeeping bundle! Dive into the world of finance with this comprehensive collection of 11 courses designed to equip you with the tools and expertise necessary to thrive in the financial industry. The bundle includes the QLS-endorsed Accounting & Bookkeeping Course, which comes with a QLS hardcopy certificate - a valuable addition to any financial professional's portfolio. But that's not all! You'll also get access to 10 other relevant courses, all CPD-QS accredited, covering everything from introductory accounting principles to advanced financial analysis techniques. With our bundle, you'll gain an in-depth understanding of accounting and bookkeeping, as well as the ability to manage payroll, use Xero Accounting software, and work with Sage 50. You'll also learn about tax accounting, financial investigation, and anti-money laundering and fraud management - all crucial skills for any financial professional. This bundle is perfect for anyone looking to start a career in finance or for professionals looking to expand their knowledge and take their career to the next level. With our expertly crafted courses and accessible learning materials, you'll be on your way to mastering the world of finance in no time! So why wait? Enrol in the bundle right now! This Accounting & Bookkeeping Course Bundle Package includes: Course 01: Advanced Diploma in Xero Accounting And Bookkeeping at QLS Level 7 10 Premium Additional CPD QS Accredited Courses - Course 01: Introduction to Accounting Course 02: Accountancy Course 03: Xero Accounting - Complete Training Course 04: Payroll: Payroll Management Course 05: Sage 50 Diploma Course 06: Managerial Accounting Course 07: Tax Accounting Diploma Course 08: Financial Analysis Course Course 09: Financial Investigator Course 10: Anti Money Laundering and Fraud Management Why Prefer This Accounting & Bookkeeping Course Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this Accounting & Bookkeeping Course bundle courses, you will be able to learn: Gain an understanding of accounting and bookkeeping principles and practices. Learn how to use Xero Accounting software and Sage 50. Master payroll management techniques. Develop an understanding of tax accounting and financial analysis. Learn how to conduct financial investigations and manage fraud. Understand anti-money laundering regulations. Earn a QLS-endorsed Accounting & Bookkeeping Course certificate. ***Curriculum breakdown of Accounting & Bookkeeping*** Introduction Getting Started Invoices and Sales Bills and Purchases Bank Accounts Products and Services Fixed Assets Payroll VAT Returns How is the Accounting & Bookkeeping Course Bundle Assessment Process? You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams. CPD 280 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone looking to start a career in finance. Professionals looking to expand their knowledge of finance. Individuals interested in payroll management and tax accounting. Anyone seeking a QLS-endorsed certificate in Accounting & Bookkeeping. Career path Our course bundle will prepare you for a range of careers, including: Junior Accountant (£18,000-£25,000) Payroll Administrator (£18,000-£25,000) Financial Analyst (£25,000-£50,000) Tax Accountant (£25,000-£60,000) Fraud Investigator (£25,000-£50,000) Anti-Money Laundering Analyst (£25,000-£40,000) Certificates Advanced Diploma in Xero Accounting And Bookkeeping at QLS Level 7 Hard copy certificate - Included CPD QS Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Offering insights into various types of credit facilities, including syndicated loans, corporate bonds, and revolving credit facilities. This overview encompasses both secured and unsecured lending, as well as specialized financing solutions like asset-based lending and mezzanine financing.  What is Inside the manual? Introduction and Overview of Loans This section introduces the concept of loans, including syndicated loans, and differentiates between commitment and actual loans. It explains the basic instruments of term loans and revolving credits, highlighting their purposes, benefits, and how they serve as fundamental tools for financing in the corporate world. Syndication Process and Terms Details the process and rationale behind syndicated loans, contrasting them with bilateral loans. Exploring the key terms of loan agreements, including clauses, conditions precedent, interest periods, and repayment terms. It elucidates the complexity and intricacy of syndicated loans,. Borrower and Bank Perspectives Explores why borrowers opt for syndicated loans from their viewpoint and analyses the benefits these loans offer to banks. This insight underlines the mutual advantages, including risk distribution for banks and the ability to secure larger amounts of capital for borrowers, showcasing the synergy in syndicated loan transactions. Debt Structuring Fundamentals Investigates the hierarchy of claims, secured versus unsecured creditors, and the nuances of subordination. This section offers a deep dive into the mechanisms that protect creditors and structure debt in ways that manage risk and prioritize repayments, highlighting the legal and strategic considerations in debt structuring. Introduction to Bonds and Bond Issuance Covers the basics of bonds, including their types, valuation, and the role of rating agencies. Further exploring the process of bond issuance, the actors involved, and the strategic considerations from both the issuer and investor perspectives. This segment broadens the understanding of corporate financing through the lens of the bond market. Credit Products Beginning with a foundational exploration of loans, detailing syndicated, term, and revolving credits, and elaborates on the strategic implications of these instruments for corporate finance. The book covers the syndication process, offering insights from both borrowers' and banks' perspectives, and navigates through the intricacies of loan agreements and debt structuring, emphasizing the importance of managing risk and prioritizing repayments.

A comprehensive understanding of equity as a means of corporate funding, offering insights into both the private equity and public equity landscapes, venture capital, and the strategic considerations involved in raising and managing equity investments. What is Inside the manual? Discounted Cash Flow Techniques This section provides a comprehensive guide to understanding and applying discounted cash flow (DCF) valuation, including the basics of discounting, the structure of DCF valuations, estimating free cash flow, and calculating terminal value. It covers key value drivers like sales growth rates and EBITDA margins, and compares free cash flow to the firm (FCFF) and free cash flow to equity (FCFE). Cost of Capital An essential element in financial modelling and valuation, this part delves into risk types, the Capital Asset Pricing Model (CAPM), calculating the cost of debt, and determining the weighted average cost of capital (WACC). It explores firm-specific vs. market risk, beta calculations, equity risk premiums, and the optimal leverage ratio. Comparable Company Analysis (Comps) Focusing on how to conduct comps analysis, this section discusses selecting a comparable universe, moving from equity value to enterprise value, choosing the appropriate multiples, and adjusting for special situations like currency impacts and exceptional items. It provides practical insights into valuing companies using comps. Precedent Transactions Analysis Offering an overview of using precedent transactions for valuation, including sourcing relevant transaction information, understanding the mechanics of analysis, and considerations for equity value vs. enterprise value. This section is vital for assessing past transactions to inform current valuations. Valuation Integrations and Considerations Combining elements of DCF, cost of capital, comps, and precedent transactions, this part synthesises the methods into a cohesive valuation approach. It addresses practical aspects like calculating unfunded pension liabilities, adjusting for leases, and understanding the impact of capital structure on valuations. Valuation A concise guide covers key financial valuation techniques, including discounted cash flow (DCF) analysis, cost of capital estimation, comparable company analysis, and precedent transaction analysis. It addresses how to estimate future cash flows, calculate a company's cost of capital using CAPM and WACC, apply valuation multiples, and assess the strategic considerations behind M&A premiums.

Equip yourself with the knowledge and skills to develop, utilise, and review financial models effectively, ensuring they can be used to support strategic decision-making and financial analysis with confidence. What is Inside the manual? M&A Strategies This section introduces the core concepts of M&A, explaining the goals of acquisitions, including the pursuit of synergies through scale, scope, and diversification. It also covers acquisition and disposal strategies, providing a foundation for understanding the strategic rationale behind M&As. Acquiring Private Companies Offering a process overview from the early stages through to post-completion, this section is crucial for understanding the nuances involved in private company acquisitions. It includes detailed steps such as target analysis, due diligence, and the finalization of sale and purchase agreements. Selling Private Companies This part parallels the acquisition process but from the perspective of selling private companies. It details disposal strategies, preparation for sale, and different approaches to achieving a sale, such as demergers, auctions, and the 'rifleshot' approach.  Public Company Takeovers Focusing on the regulatory environment, the takeover process (both friendly and hostile), and defence tactics, this section is key for anyone involved in or studying public company takeovers.  Successful M&A Concluding with what determines success and failure in acquisitions, this section emphasizes the importance of planning, implementation, and integration.  Financial Modelling The guide covers everything from basic model structure, naming conventions, and sheet consistency, to more advanced topics like data consolidation, the use of arrays, and handling date series. It also delves into the nuances of Excel, such as relative vs. absolute references, using logical functions, and managing volatile functions.

The Accounting and Analysis Manual is an indispensable resource for finance professionals, auditors, and business managers navigating the complexities of financial reporting and analysis. What is inside the manual? Presentation of Financial Statements This section is foundational, providing readers with a comprehensive understanding of how financial statements are structured and presented, which is crucial for both reporting and analysis. Balance Sheet Issues: Assets and Liabilities A deep dive into the intricacies of assets and liabilities, including current and non-current classifications, debt, leases, and more. This part is essential for understanding a company's financial health and operational sustainability. Income Statement Issues Focusing on revenue recognition and the implications of employee share options, this section is key for understanding how a company's operations translate into financial performance. Understanding Cash Flow Statements With emphasis on free cash flow, this section highlights the importance of cash management and its impact on a company's valuation and investment attractiveness. Accounting and Analysis for M&A This comprehensive segment covers the end-to-end process and considerations for M&A activities, including the consolidation process, acquisition accounting, and the treatment of goodwill.  Accounting and Analysis Cover the fundamentals of accounting frameworks, reporting elements, and the mechanics of preparing financial statements, including detailed discussions on assets, liabilities, income statements, and cash flow statements.

The Introduction to M&A manual is an indispensable resource for finance professionals, auditors, and business managers looking at beginning their M&A journey. What is Inside the manual? Model Setup and Structure This foundational section covers everything from initial design principles to file naming conventions and sheet consistency. It also discusses the importance of freezing panes for ease of use, establishing a coherent model structure. Inputs, Assumptions, and Outputs Essential for the integrity and flexibility of financial models, this part delves into how to organise inputs and assumptions effectively, the creation of a control panel for easy scenario adjustments, and the clear presentation of outputs for decision-making. Advanced Excel Techniques Focusing on critical Excel functionalities such as relative vs. absolute referencing, naming cells and ranges, and the use of functions like IF, LOOKUP, and INDIRECT. It also covers the management of volatile functions and data consolidation techniques. Data Analysis and Presentation This section emphasises tools and methods for analysing model outputs, including pivot tables, array formulas, and sensitivity analysis using Goal Seek and data tables. It also covers the validation of data inputs and outputs, conditional formatting, and the creation of charts for visual representation of data. Model Auditing and Error Detection A critical component for ensuring the accuracy and reliability of financial models, this part provides strategies for auditing models, tracking changes, detecting errors, and utilising Excel's built-in auditing tools. It offers a systematic approach to reviewing models and ensuring they are free of errors and ready for use. Introduction to Mergers and Aquisitions This book offers a concise yet comprehensive guide to the intricacies of mergers and acquisitions (M&A), covering both theoretical strategies and practical steps involved in buying and selling companies. It explores the initial planning and strategy, dives into the specifics of dealing with both private and public companies, and discusses the critical aspects of deal structuring and post-acquisition integration.

A comprehensive understanding of equity as a means of corporate funding, offering insights into both the private equity and public equity landscapes, venture capital, and the strategic considerations involved in raising and managing equity investments. What is Inside the manual? Introduction to Equity This section lays the groundwork by explaining the features of equity, its additional characteristics, and the different types of equity available. It also provides an overview of corporate funding options, setting the stage for a deeper dive into more specific equity-related topics. Private Equity Covering everything from the basics of private equity, the goals of private equity investments, and the structure of private equity firms to the process of attracting private equity, including preparing a business plan and approaching investors. Venture Capital Offering an overview of venture capital, including the types of investors involved, such as venture capital funds and business angels, and the lifecycle of a venture capital investment. This section is crucial for understanding the role of venture capital. Raising Public Equity Detailed exploration of public equity markets, the process and terminology of equity capital markets, the advantages and disadvantages of raising public equity, and the criteria for listing on various markets. It includes a comprehensive guide to the Initial Public Offering (IPO) process,. Private Equity Exits and the IPO Process Highlighting the end goals of private equity investment through exit strategies, including a detailed look at the IPO process as a key exit route. This includes due diligence, drafting the prospectus, launching the IPO, and the obligations following a public listing. Raising Equity Capital Raising Equity Capital is a guide which explores the essentials of equity financing, breaking down private equity, venture capital, and public equity markets. It covers the characteristics of equity, different funding options, and the detailed process of securing private equity, including deal structures and exits.

This Fibonacci Trading : Fibonacci Retracement is the ultimate introduction to Fibonacci trading. You will learn all the trading secrets needed to navigate the market with expertise, with real world examples. Taught by an experienced instructor, the course is broken down into 5 key modules, covering essential topics to take your trading to the next level.  You will learn how to trade Fibonacci retracements, introducing strategies that will help you make smart financial decisions and beat the market. You will also gain essential technical analysis skills, as well as in-depth knowledge of the history of Fibonacci, and why it is so popular. This course is perfect for day traders, swing traders, Forex traders, stocks traders and investors who want to gain deeper knowledge of this powerful marketing tool, to become a master trader. This best selling Fibonacci Trading : Fibonacci Retracement has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Fibonacci Trading : Fibonacci Retracement is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Fibonacci Trading : Fibonacci Retracement is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Fibonacci Trading : Fibonacci Retracement is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Fibonacci Trading : Fibonacci Retracement, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Fibonacci Trading : Fibonacci Retracement will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Fibonacci Trading : Fibonacci Retracement to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.