• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

443 Systems courses in London

3ds max One Day Bespoke training course 1-2-1

By Real Animation Works

Face to face training customised and bespoke. Online or Face to Face

3ds max One Day Bespoke training course 1-2-1
Delivered in London or OnlineFlexible Dates
£400

TRAINING FOR FILM & GAME DESIGNERS One to One Online or Face to Face

By Real Animation Works

Film and VFX face to face training customised and bespoke. One to One Online or Face to Face

TRAINING FOR FILM & GAME DESIGNERS One to One Online or Face to Face
Delivered in London or OnlineFlexible Dates
£1,600

Level 2 NVQ Diploma in Construction Plant or Machinery Maintenance

By Dynamic Training and Assessments Ltd

Level 2 NVQ Diploma in Construction Plant or Machinery Maintenance

Level 2 NVQ Diploma in Construction Plant or Machinery Maintenance
Delivered In-Person in Nottinghamshire or UK WideFlexible Dates
£695

Power BI® - Business Data Analytics

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course  This 3 full-day training course will introduce participants to the Microsoft Power BI® software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI® environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data. The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they've learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn't be able to do what they need to do. This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Microsoft® PowerBI® is a trademark of Microsoft Corporation in the United States and/or other countries. Training Objectives Upon completion of this training course, participants will be able to: Confidently use the Power BI® solution, including Power BI® Desktop, PowerBI®.com and the Power BI® Gateway Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis Combine data sources together and gain an introductory understanding of the M language Write formulas using the DAX language for generating custom columns, measures and tables Design reports and dashboards using a wide range of both built-in and custom visuals Publish reports and dashboards to PowerBI®.com Share reports and dashboards with others using PowerBI®.com Customize reports and dashboards so that different user groups automatically see their own personalized views Target Audience This training course is intended for: Financial Analysts Accountants Budgeting and planning specialists Treasury Risk Managers Strategic Planners This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Course Level Basic or Foundation Trainer Your expert course leader has a Masters (Applied Finance & Investment), B.Comm (Accounting & Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years' experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings. He has trained delegates from a wide variety of Oil & Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions. Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm. He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing. Highlights from his oil and gas experience include: Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil & gas assets. Auditing and further development of life of project models for Chevron's Strategic Planning Division analysing their North West Shelf assets. Development of business plan and budgeting models for multinational oil & gas assets. Development of cash flow and taxation models for a variety of oil gas companies. Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' 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. Request for further information post training support and fees applicable Accreditions And Affliations

Power BI® - Business Data Analytics
Delivered in Internationally or OnlineFlexible Dates
£2,493 to £2,899

Introduction to Adobe InDesign

By Platform Training

InDesign is the professional choice for creating brochures, posters, magazines, e-books and apps. Through this introductory course, based at our London studios, you will receive expert InDesign training in how to create documents and prepare them for print or export as a PDF. Professional colour management, typography and advanced graphics and effects are all explored. This course covers all you need to know to get started with the application.

Introduction to Adobe InDesign
Delivered In-PersonFlexible Dates
£215

Geothermal Project Finance Analysis and Modelling

By EnergyEdge - Training for a Sustainable Energy Future

About this Virtual Instructor Led Training (VILT)  This 4 half-day Virtual Instructor Led Training (VILT) course will address a variety of contract and loan structuring issues associated with geothermal energy projects as well as comparison with solar, wind and battery storage. The course is designed to investigate how various project finance techniques and contract structures can be used to achieve a competitive power prices while maintaining a satisfactory equity return. Distinctive project finance features of power facilities that depend on geothermal, wind, hydro or solar resources will be evaluated with financial models. The course will cover economic analysis of exploration and development of geothermal facilities and how to incorporate probability of failure and success into an IRR framework. Subsequent sessions will address the theory underlying liquidated damages for delay, and performance as well as design of other incentives that is inherent in different contract structures. Nuanced project finance issues associated with structuring debt for renewable projects will be discussed including under what conditions the DSCR drives debt capacity and when the debt to capital ratio is instrumental. The course will be taught with a combination of theoretical discussions, term sheet review and focused financial models. Training Objectives Evaluation of the economic risks that arise from uncertainty associated with drilling exploration wells and development wells for geothermal projects. Analyse the theoretical issues with computing LCOE for geothermal projects compared to other renewable and non-renewable resources and the importance of cost of capital for renewable projects; Understand differences in contract structures for renewable projects and dispatchable projects and how a single price structure can distort incentives for efficient construction and operation; Understand components of financing that influence the bid price required to meet a required rate of return on equity and can result in relatively low prices with reasonable returns. Understand the importance of debt sizing constraints and what strategies are relevant when the debt to capital constraint applies relative to when the debt service coverage ratio drives the debt size; Understand how to compute P50, P90 and P99 for different projects driven by resource risk; Understand the difference between mean reverting resource variation and estimation mistakes that do not correct as the basis for 1-year P90 and 10-year P90. Understand under what conditions debt sculpting can affect returns and how synthetic sculpting can be used to increase returns when the DSCR constraint applies. Understand the theory of credit spreads, variable rate debt and interest rates in different currencies and compute the implied probability of default that in inherent in credit spreads. Understand how to evaluate the costs to equity investors and the benefits to lenders for various credit enhancements including DSRA accounts, cash flow sweeps and covenants. Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day, including time for lectures, discussion, quizzes and short classroom exercises. Trainer Your expert course leader provides financial and economic consulting services to a variety of clients, he teaches professional development courses in an assortment of modelling topics (project finance, M&A, and energy). He is passionate about teaching in Africa, South America, Asia and Europe. Many of the unique analytical concepts and modelling techniques he has developed have arisen from discussion with participants in his courses. He has taught customized courses for MIT's Sloan Business School, Bank Paribas, Shell Oil, Society General, General Electric, HSBC, GDF Suez, Citibank, CIMB, Lind Lakers, Saudi Aramco and many other energy and industrial clients. His consulting activities include developing complex project finance, corporate and simulation models, providing expert testimony on financial and economic issues before energy regulatory agencies, and advisory services to support merger and acquisition projects. Our key course expert has written a textbook titled Corporate and Project Finance Modelling, Theory and Practice published by Wiley Finance. The book introduces unique modelling techniques that address many complex issues that are not typically used by even the most experienced financial analysts. For example, it describes how to build user-defined functions to solve circular logic without cumbersome copy and paste macros; how to write function that derives the ratio of EV/EBITDA accounting for asset life, historical growth, taxes, return on investment, and cost of capital; and how to efficiently solve many project finance issues related to debt structuring. He is in the process of writing a second book that describes a series of valuation and analytical mistakes made in finance. This book uses many case studies from Harvard Business School that were thought to represent effective business strategies and later turned into valuation nightmares. Over the course of his career our key course expert has been involved in formulating significant government policy related to electricity deregulation; he has prepared models and analyses for many clients around the world; he has evaluated energy purchasing decisions for many corporations; and, he has provided advice on corporate strategy. His projects include development of a biomass plant, analysis and advisory work for purchase of electricity generation, distribution and transmission assets by the City of Chicago, formulation of rate policy for major metro systems and street lighting networks, advocacy testimony on behalf of low income consumers, risk analysis for toll roads, and evaluation of solar and wind projects. He has constructed many advisory analyses for project finance and merger and acquisition transactions. Lastly, our key course expert was formerly Vice President at the First National Bank of Chicago where he directed analysis of energy loans and also created financial modelling techniques used in advisory projects. He received an MBA specializing in econometrics (with honours) from the University of Chicago and a BSc in Finance from the University of Illinois (with highest university honours). POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' 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. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Geothermal Project Finance Analysis and Modelling
Delivered in Internationally or OnlineFlexible Dates
£1,006 to £1,899

3ds Max and Photoshop Training

By London Design Training Courses

Why Choose 3ds Max and Photoshop Training Course? Click here for more info 3D modeling and rendering potential with our specialized 3ds Max and Photoshop Training Course! Learn from modeling to rendering in 3ds Max and enhance visuals with Photoshop. Personalized, live online sessions with an experienced instructor. Enroll now and bring your 3D visualizations to life. Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. The 3ds Max and Photoshop Training Course offers comprehensive learning for beginners, focusing on core skills to create 3D models, rendered images, animations, and games using 3ds Max and Photoshop. Led by Autodesk Certified Instructors with expertise in 3D design, CGI, and visualizations, the course provides hands-on and practical training. 20-hour 3ds Max and Photoshop Training Course Course Description: 20-hour 3ds Max and Photoshop Training Course to master 3D modeling, rendering, and post-production. Learn to create 3D models, apply textures, animate objects, and utilize lighting techniques in 3ds Max. Gain expertise in Photoshop for post-processing and creating photorealistic textures. Ideal for 3D artists of all levels. Course Outline: Part 1: Introduction to 3ds Max (6 hours) - Understanding the user interface and workspace of 3ds Max - Navigating the viewport and utilizing basic tools for modeling - Creating and manipulating primitive objects for design purposes - Modifying objects with modifiers to achieve specific effects - Working with materials and textures to add realistic detail to 3D models - Basic lighting and rendering techniques to present the 3D scenes Part 2: Intermediate 3ds Max Techniques (6 hours) - Modeling using splines and polygons for more complex shapes - Creating and animating cameras to simulate real-world perspectives - Rigging and animating characters with bones for animation projects - Utilizing particle systems for visual effects and dynamic simulations - Designing realistic environments using landscape tools for outdoor scenes - Exploring advanced lighting and rendering techniques for enhanced visuals Part 3: Introduction to Photoshop for 3D Artists (4 hours) - Understanding the Photoshop workspace and essential tools for editing - Importing and exporting 3D models and textures between 3ds Max and Photoshop - Creating and editing textures and materials in Photoshop for realistic surfaces - Utilizing Photoshop for post-production and compositing to enhance 3D renders Part 4: Advanced Photoshop Techniques for 3D Artists (4 hours) - Creating custom brushes and textures for unique artistic elements - Using layer masks and adjustment layers for non-destructive editing - Exploring advanced compositing techniques for seamless integration of 3D elements - Creating photorealistic textures and materials for stunning 3D visuals Part 5: Project-Based Learning (4 hours) - Applying 3ds Max and Photoshop techniques to a real-world project - Creating a 3D model, texturing it in Photoshop, and rendering the final image - Receiving instructor feedback for critiquing and refining the project - Final presentation of the completed project showcasing skills learned.

3ds Max and Photoshop Training
Delivered in London or OnlineFlexible Dates
£600

The CAIA Association is a global professional body dedicated to creating greater alignment, transparency, and knowledge for all investors, with a specific emphasis on alternative investments. Course Overview The CAIA Association is a global professional body dedicated to creating greater alignment, transparency, and knowledge for all investors, with a specific emphasis on alternative investments. A Member-driven organization representing professionals in more than 100 countries, CAIA Association advocates for the highest ethical standards. Whether you need a deep, practical understanding of the world of alternative investments, a solid introduction, or data science skills for the future in finance, the CAIA Association offers a program for you. Why CAIA? Distinguish yourself with knowledge, expertise, and a clear career advantage – become a CAIA Charterholder. CAIA® is the globally recognized credential for professionals allocating, managing, analyzing, distributing, or regulating alternative investments. The Level II curriculum takes a top-down approach and provides Candidates with the skills and tools to conduct due diligence, monitor investments, and appropriately construct an investment portfolio. In addition, the Level II curriculum contains Emerging Topic readings; articles written by academics and practitioners designed to further inform and provoke the Candidate’s investment management process. After passing the Level II exam you are eligible, with relevant professional experience, to join the CAIA Association as a Member and receive the CAIA Charter. You will be part of an elite group of more than 13,000 professionals worldwide. Only after joining the Association, you are eligible to add the CAIA designation to your professional profiles. Who will benefit from enrolling in the CAIA program? Professionals who want to develop a deep level of knowledge and demonstrated expertise in alternative investments and their contribution to the diversified portfolio should pursue the CAIA Charter including: • Asset Allocators • Risk managers • Analysts • Portfolio managers • Traders • Consultants • Business development/marketing • Operations • Advisors Curriculum Topics: Topic 1: Emerging Topics • Decentralized Finance: On Blockchain- and Smart Contract-Based Financial Markets • Technical Guide for Limited Partners: Responsible Investing in Private Equity • Channels for Exposure to Bitcoin • Assessing Long-Term Investor Performance: Principles, Policies and Metrics • Demystifying Illiquid Assets: Expected Returns for Private Equity • An Introduction to Portfolio Rebalancing Strategies • Longevity and Liabilities: Bridging the Gap • A Short Introduction to the World of Cryptocurrencies Topic 2: Ethics, Regulation and ESG • Asset Manager Code • Recommendations and Guidance • Global Regulation • ESG and Alternative Investments • ESG Analysis and Application Topic 3: Models • Modeling Overview and Interest Rate Models • Credit Risk Models • Multi-Factor Equity Pricing Models • Asset Allocation Processes and the Mean-Variance Model • Other Asset Allocation Approaches Topic 4: Institutional Asset Owners and Investment Policies • Types of Asset Owners and the Investment Policy Statement • Foundations and the Endowment Model • Pension Fund Portfolio Management • Sovereign Wealth Funds • Family Offices and the family office Model Topic 5: Risk and Risk Management • Cases in Tail Risk • Benchmarking and Performance Attribution • Liquidity and Funding Risks • Hedging, Rebalancing, and Monitoring • Risk Measurement, Risk Management, and Risk Systems Topic 6: Methods for Alternative Investing • Valuation and Hedging Using Binomial Trees • Directional Strategies and Methods • Multivariate Empirical Methods and Performance Persistence • Relative Value Methods • Valuation Methods for Private Assets: The Case of Real Estate Topic 7: Accessing Alternative Investments • Hedge Fund Replication • Diversified Access to Hedge Funds • Access to Real Estate and Commodities • Access through Private Structures • The Risk and Performance of Private and Listed Assets Topic 8: Due Diligence and Selecting Managers • Active Management and New Investments • Selection of a Fund Manager • Investment Process Due Diligence • Operational Due Diligence • Due Diligence of Terms and Business Activities Topic 9: Volatility and Complex Strategies • Volatility as a Factor Exposure • Volatility, Correlation, and Dispersion Products and Strategies • Complexity and Structured Products • Insurance-Linked and Hybrid Securities • Complexity and the Case of Cross-Border Real Estate Investing DURATION 200 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

CAIA Level 2 Course
Delivered In-PersonFlexible Dates
£1,500

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Macros & VBA - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750

Microsoft Excel Advanced (now with live online classes) One-to-One Training

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Microsoft Excel Advanced (now with live online classes) One-to-One Training
Delivered In-Person in LondonFlexible Dates
£650