Instructor Led Excel Training in United Kingdom

Executive PA Seminar A massively popular seminar so book early! This programme will equip you with all the soft skills you'll need to develop to enjoy a successful career as a PA, including organisation, assertiveness, time management and many others. You'll gain a detailed understanding of the demands, motives and problems of the company executive. Expand and improve directly on your contribution to the  more...

Lotus Course Fundamentals Of Domino 8 Application Development The course provides the information that you need to know to successfully create and modify database applications in IBM Lotus Domino Designer 8. It provides an overview of the Lotus Domino 8 and Lotus Domino Designer 8 environments, introduces the elements and skills that are used in creating single-database Domino applications, describes how the formula language can be used to enhance the  more...

Database Design & Development DATABASE DEVELOPMENT Mullan Training specialise in design & development of databases - we use the technology best suited to the Client (including Access, VB/ VBA, FoxPro, FileMaker, SQL Server, etc). We sit down with the client and identify their needs, develop a prototype based on the initial specification, then refine the system as necessary. Please contact us if you would like to  more...

Advanced Powerpoint ...our workspace and interrelate your presentation with both Excel and Word files. Create custom shows, hyperlinks to internal slides/ websites/ external files, etc Delegates that have their on presentations they want to work on are encouraged to bring then to the course to work on as part of the tutorial. LOCATIONS Courses can be delivered at our offices in Belfast city centre (opposite the  more...

Advanced MS Excel (1 & 2 Days) ...Excel Intermediate / Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features. PREREQUISITES A working knowledge of Excel or our Introduction to MS Excel course. BENEFITS At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to: -  more...

Introduction to MS Excel - 1 Day ...Excel Introduction course is suitable for complete beginners to Microsoft Excel. Prerequisites A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Excel is required. Benefits At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create a spreadsheet from  more...

Adobe Acrobat ...ing styles Source files will include Word, PowerPoint & Excel Tools Use of tools within Adobe (Link, Movie, Sound, Page Action, etc) Use bookmarks as navigation tools Use bookmarks to present magnified views or take readers instantly to related topics. Create Form Fields Create a new form from a Word document and create one from scratch within Acrobat Create form fields in the  more...

Introduction To Sage Line 50 ...Quick Ratio Exporting Export Data to MS Word, MS Excel, MS Outlook Month/Year End Run Month End Procedures Run year End Procedures Line 50 Stock Control/Movements Invoice/Quotes/Pro-forma/Credit Note Production Discount Structures Bill of Materials Sales Order Processing Purchase Order Processing LOCATIONS Courses can be delivered at our offices  more...

VB Excel ... 2 day course is suitable for Advanced users of Microsoft Excel responsible for very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data. PREREQUISITES A high proficiency of Microsoft Excel is essential, or completion of our 2 day Adavnced MS Excel course. BENEFITS At the end of the  more...

Microsoft Excel Advanced Training Microsoft Excel is the world's most popularl spreadsheet application and makes calculating, displaying and sharing data easy. This advanced excel training course introduces delegates to Excel's more powerful functions, including Absolute Cell Addressing, Conditional Functions, Data Validation, Pivot Tables and much more besides  more...

Microsoft Excel Training Microsoft Excel is the world's most popularl spreadsheet application and makes calculating, displaying and sharing data easy. This beginners Excel training course provides a solid introduction to Excel's core functionality, including Rows and Columns, Formatting Data, Creating Charts & Graphs, Using Formulas, Print Layouts and much more.  more...

VBA For Excel Training This VBA for Excel training course will provide delegates with knowledge of Visual Basic for Applications within the contect of Excel. This 2 day VBA for Excel training course will teach participants how to create and edit macros, and gain understanding of the VBA code.  more...

Microsoft Excel 2003 Level 1 Aims This course is aimed at people who want to learn how to use Microsoft Excel to carry out basic spreadsheet tasks including the creation of simple formulas and functions. The course is suitable for either beginners or people with limited experience of the product. Prerequisites Students who wish to attend this course need to be familiar with the use of a PC keyboard and mouse.  more...

Microsoft Excel 2003 Level 2 Aims This course is aimed at people who want to expand their basic knowledge of Microsoft Excel to work with larger spreadsheets and workbooks, create charts and manage tables of data. Prerequisites Students who wish to attend this course must have a basic knowledge of Excel and feel comfortable with creating, saving, editing and formatting spreadsheets and creating basic formulas and  more...

Microsoft Excel 2003 Level 3 Aims This course is aimed at people who want to expand their knowledge into some of the more advanced calculation and analytical capability of Microsoft Excel. Prerequisites Students who wish to attend this course must have a good knowledge of Excel and be competent at working with basic formulas and functions, multiple sheets and multiple files.  more...

Microsoft Excel 2003 Level 4 Aims This course is aimed at people who want to expand their knowledge into the more specialised analytical functionality and built-in automation offered by Microsoft Excel. Prerequisites Students who wish to attend this course must have a very good knowledge of Excel and be competent at working with advanced functions (e. g. Logical & LookUp) and have some basic knowledge of Excela ™s  more...

Microsoft Excel 2007 Level 1 Aims This course is aimed at people who want to learn how to use Microsoft Excel to carry out basic spreadsheet tasks including the creation of simple formulas and functions. The course is suitable for either beginners or people with limited experience of the product. Prerequisites Students who wish to attend this course need to be familiar with the use of a PC keyboard and mouse.  more...

Microsoft Excel 2007 Level 2 Aims This course is aimed at people who want expand their basic knowledge of Microsoft Excel to work with larger spreadsheets and workbooks, create charts and manage tables of data. Prerequisites Students who wish to attend this course must have a basic knowledge of Excel and feel comfortable with creating, saving, editing and formatting spreadsheets and creating simple formulas and  more...

Microsoft Excel 2007 Level 3 Aims This course is aimed at people who want expand their knowledge into some of the more advanced calculation and analytical capability of Microsoft Excel. Prerequisites Students who wish to attend this course must have a good knowledge of Excel and be competent at working with basic formulas and functions, multiple sheets and multiple files.  more...

Microsoft Excel 2007 Level 4 Aims This course is aimed at people who want to expand their knowledge into the more specialised analytical functionality and built-in automation offered by Microsoft Excel. Prerequisites Students who wish to attend this course must have a very good knowledge of Excel and be competent at working with advanced functions (e. g. Logical & LookUp) and have some basic knowledge of Excela ™s  more...

Microsoft Excel Level 5 Introduction to VBA Programming Aims This course is aimed at people who want to begin expanding their knowledge into enhancing, customising and automating the built-in functionality of Microsoft Excel. Prerequisites Students who wish to attend this course must have a very good working knowledge of Excel.  more...

Microsoft Excel Level 6 Intermediate VBA Programming Aims This course is aimed at people who want to explore further the VBA language and write VBA code so that future maintenance tasks can be carried out with the minimum of effort. Prerequisites Students who wish to attend this course must have a good knowledge of Excel and have attended the Microsoft Excel Level 5 Introduction to VBA course or have good personal experience at writing basic  more...

Microsoft Office 2007 Introduction Aims This course is aimed at users who require only a basic understanding of Microsoft Word, Excel and Outlook. Users who need a more in depth introduction to Office 2007 applications should attend the full introductory (Level 1) courses instead. Prerequisites Students who wish to attend this course need to be familiar with the use of a PC keyboard and mouse.  more...

Microsoft Visio 2007 Level 2 Aims This course is designed for individuals who have an understanding of the basic workflow and the concept of end-to-end flowcharting. Prerequisites Students should be familiar with personal computers, mouse, and keyboard (basic typing skills are recommended). They should be comfortable in the Windows environment and be able to use Windows to manage information on their computers.  more...

Financial Modelling with Microsoft Excel Build professional models to improve financial performance The widespread availability of computer spreadsheets has revolutionised budgeting, forecasting and planning. In the past, financial modelling was something done exclusively by accountants and as a result they had almost total control of financial information. Nowadays many managers are expected to have a much closer control and  more...

Valuation Techniques for Hedge Funds This two-day course teaches the skills and tools required to value companies, including quantitative methods of investment analysis, sources of risk and return, specials situations and strategic analysis. Financial modelling techniques using Excel will be explained, with ample exercises and opportunities to apply these skills in practice.  more...

Lotus Course Fundamentals of Domino 8 Application Development The course provides the information that you need to know to successfully create and modify database applications in IBM Lotus Domino Designer 8. It provides an overview of the Lotus Domino 8 and Lotus Domino Designer 8 environments, introduces the elements and skills that are used in creating single-database Domino applications, describes how the formula language can be used to enhance the  more...

Human Resource and Personnel Management If you are looking for a quality course that provides a complete insight into the fundamentals of HR and Personnel Management best practice as well as guidance on key employment issues then this is the event for you! With its comprehensive coverage of HR and Personnel Management best practice, easy to follow format, superbly written supporting materials, role plays and group exercises, feedback  more...

ISO 14001 - Environmental Management Systems Auditor - IEMA Accredited Course ...un in partnership with IEMA Accredited training provider, Excel Partnership. Contents: Key session topics include: - The EMS Standards (ISO 14001, Eco-Management and Audit Regulation - EMAR, etc.) EMS auditing standards Audit planning. Use of checklists Audit interviewing and evaluation of information Environmental legislation and codes of practice Environmental aspects and  more...

Index Linked Bonds and Inflation Derivatives The market for index-linked bonds and inflation derivatives is growing rapidly. The program covers the mechanics of the instruments, their valuation and how they can be used to take or hedge inflation exposure alone or embedded in other structures. Traders, risk managers, fund managers, project finance and structured finance practitioners, accountants, auditors, consultants and anyone interested  more...

Strategic ALM, Treasury and Capital Asset and Liability Management (ALM) is a key function of growing importance in financial markets. ALM involves a number of techniques that maximise the use of an organisation's assets and liabilities to improve performance. The course provides a deep understanding of the subject, offering an overview of traditional ALM and detailing the more recently applied risk measures, their modelling and use  more...

Statistics for Researchers The course aims to give researchers to understand principles of statistical design and analysis and their relevance to research in a range of scientific disciplines. It covers some probability and statistical methods, mainly through examples. Training contain around 30% of lectures, 70% of guided quizzes and labs. In case of closed course we can tailor the examples and materials to a  more...

Hedge Funds Risk Management Trade Performance Analysis Review the key fundamentals of the hedge fund industry and develop a deep understanding of the quantitative principles of hedge fund modelling and analysis through applied problem solving and implementation using key techniques and methods. Computer-based workshops (Excel and VBA) are very hands-on building on the basics through to some advanced hedge fund modelling and risk management  more...

Numerical Techniques 1 Monte Carlo Simulation Course Outline Over the past two decades increased changes in the complexity of financial products and increasing computational capacity has meant that Monte Carlo methods have become the mainstay of any financial engineer's toolkit. This course illustrates how Monte Carlo can be used in modern finance for both pricing and risk management purposes. The course uses a combination of theoretical  more...

Convertible Bonds and Securities ...egies. Exercises and pricing models are implemented using Excel functions and macros and participants will be able to take away all worked examples. Who The Course is For * Traders * Credit and equity risk managers * IT * Middle office * Quantitative researchers * Hedge funds * Portfolio managers * Structured products desk Prior Knowledge * Numerate background (basic)  more...

Interest Rate Derivatives 2 Second Generation Techniques ...de fully worked scenario spreadsheets containing relevant Excel functions and macros for participants to take away. Who The Course is For This course is designed for anyone who wishes to be able to price, use and manage second-generation interest rate derivatives: * Quantitative Analysts * Risk Managers * Financial Engineers * Traders and Structurers * Researchers and others who  more...

Equity Derivatives Valuation and Management Course Outline Equity derivatives have been growing in importance over a number of years and are now well established in the financial marketplace. This seminar is for anyone who wishes to be able to price, use, manage or evaluate equity derivatives and exotic equity options. More than half of the seminar is devoted to practical small group sessions. Who The Course is For Anyone who wishes  more...

Risk Management and Modelling Course Outline This course develops a set of tools essential for the accurate management of the wide range of risks encountered in capital markets. Techniques are applied cumulatively in a sequence of workshops that include Value at Risk and its limitations, practical uses of Monte Carlo simulations and the Merton and Gaussian approaches for estimation of probabilities. Who The Course is For  more...

Asset Backed Securities Assessment and Management of Risk Course Outline This intensive and participative 2-day programme covers the key elements of asset-backed securities and in particular mortgage backed securities. Terminology, procedures, models and applications of ABS concepts will be included along with the latest products used for hedging the risks and for developing new markets. The first day will cover the risk factors, prepayment models  more...

Using Inflation Derivatives in Today s Market ...e intensive exercises include simulations using Microsoft Excel or other industry standard software. Participants will be able to take away worked examples including a number of Excel functions and macros. Who the Course is for Traders, risk managers, fund managers, project finance and structured finance practitioners, accountants, auditors, consultants and anyone interested in the use  more...

Maths Refresher Course Outline Mathematics is at the heart of financial techniques, but many finance texts and courses assume a lot of prior knowledge. This programme aims to bridge the gap between mathematical theory and financial practice by providing a practical and visual approach to the most useful theories and methods. Calculations will be fully explained, and Excel spreadsheets will be used as a  more...

Volatility Trading and Managing Risk Course Outline The course starts by providing an understanding of how to estimate volatility and the consequences of the various ways of describing volatile asset prices. This leads into sessions on the application of a range of standard volatility derivatives such as VIX futures and options and volatility swaps. The final part of the programme covers the treatment of volatility in the more  more...

Property Derivatives Course Outline Terminology, procedures, models and applications related to the latest real-estate derivatives will be covered in this course. The first day is dedicated to forwards and futures and to the introduction of a new type of modelling based on mean-reverting models with nonlinear trend. Day two covers total return swaps and options pricing and risk calculations based on value-at-risk  more...

Managing Exotic Risk Course Outline New market conditions have changed forever the way in which managers need to think about complex risk. In this course we look at lessons from the recent financial crisis and how to avoid explosions of risk from illiquid and complex products during times of financial stress. Lessons learned call for a re-assessment of tools available for the management of exotic risk. More than  more...

Counterparty Risk, Credit Exposure and CVA ...les and additional exercises and models implemented using Excel functions and macros. All delegates will receive a copy of Jon Gregory's recent published book "Counterparty Credit Risk: The New Challenge for Global Financial Markets" (Wiley). Who The Course is For * Credit traders and credit officers * Risk managers and credit risk practitioners * Structurers and salespeople *  more...

Correlation Trading and Risk Management ...g the weaknesses and pitfalls where needed. During the Excel based workshops students will have access to proprietary status-of-the-art professional software for exotic and multi-underlying pricing, thus gaining an understanding of multifactor pricing models and higher order exotic effects on risk exposures. Who The Course is For Senior managers that need to understand risk Junior  more...

Market Forecasting Training Course Audience This course has been created for analysts, forecasters wanting to introduce or improve forecasting which can be related to sale forecasting, economic forecasting, technology forecasting, supply chain management and demand or supply forecasting. Description This course guides delegates through series of methodologies, frameworks and algorithms which are useful when choosing how  more...

Analysing Financial Data in Excel Training Course Financial or market analysts, managers, accountants Course Objectives Facilitate and automate all kind of fincial analysis with Microsoft Excel  more...

Excel For Statistical Data Analysis Training Course ...rning how to facilitate statistical analysis in Microsoft Excel. Course Objectives This course will help improving your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research. This course describes how to use the Analysis ToolPak in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It  more...

Excel VBA Advanced Training Course This course has been created for VBA developers who want to learn advanced topics and use VBA macros in the most efficient way. The course deals with object oriented programming, advanced VBA functionality and integration with external libraries and data sources.  more...

Excel VBA Introduction Training Course This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms.  more...

Statistics Level 2 Training Course This statistics course covers advanced statistics. It explains most of the tools commonly used in research, analysis, forecasting. It provides very short explanation of theory behind the formulas. This course does not related to any specific field of knowledge, but can be tailored if all the delegates have the same background and goals. Some basic computers tools are used during this course  more...