3468 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

Microsoft Excel® in Depth: 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

Microsoft Excel® in Depth (Virtual) 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

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? 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.

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.

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.

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.

The comprehensive Swing Trading Analysis for Beginners has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Swing Trading Analysis for Beginners today, and learn from the very best the industry has to offer! This best selling Swing Trading Analysis for Beginners has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Swing Trading Analysis for Beginners is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Swing Trading Analysis for Beginners is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The Swing Trading Analysis for Beginners 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 Swing Trading Analysis for Beginners, 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 Swing Trading Analysis for Beginners 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 Swing Trading Analysis for Beginners 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.