414 Link courses in London

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients 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 public, one to one, tailored and bespoke courses. Tailored training courses: In, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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 Certificates Certificates Certificate of completion Digital certificate - Included

Facilitated by Registered Clinicians with extensive experience

A virtual sales training programme aimed at enhancing the skills of the salesperson to have engaging customer conversations which open opportunities and close more business.

A sales manager's role has more to do with the ability to lead, mentor, and motivate a sales team to achieve or exceed an organisation's sales goals. This programme concentrates on these skills and behaviours enhancing their existing skills to new levels through the sales management process.

PHOTOSHOP ONE DAY COURSE ONE TO ONE LIFETIME EMAIL SUPPORT.

Autocad face to face training customised and bespoke. In-person

Microsoft Power BI training courses at Introduction and Intermediate levels. Click on the link below to view full details: Power BI courses

The Trisat 3 day Physical Intervention Training Crossover for Close Protection training can now crossover your old PI Model

Standard or Custom Excel courses at Introduction, Intermediate, Advanced and Super User level. Click on the link below for full details: Excel 365 courses

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. For Level I, the curriculum takes a bottom-up approach to the alternative investments industry. The readings offer detailed insights into the variety of institutional-quality strategies spanning the alternatives universe. Upon completing Level I, Candidates should have working knowledge of the relevant strategies available for investment, along with the basic tools to evaluate them. The CAIA Charter is granted upon completion of two levels of qualifying exams, combined with relevant professional experience. 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: Professional Standards and Ethics • Professionalism • Integrity of Capital Markets • Duties to Clients • Duties to Employers • Investment Analysis, Recommendations, and Actions • Conflicts of Interest Topic 2: Introduction to Alternative Investments • What is an Alternative Investment? • The Environment of Alternative Investment • Quantitative Foundations • Statistical Foundations • Foundations of Financial Economics • Derivatives and Risk-Neutral Valuation • Measures of Risk and Performance • Alpha, Beta, and Hypothesis Testing Topic 3: Real Assets • Natural Resources and Land • Commodities • Other Real Assets • Real Estate and Debt • Real Estate Equity Topic 4: Private Securities • Private Equity Assets • Private Equity Funds • Private Equity Funds of Funds • Evolution of Investing in Private Equity • Private Credit and Distressed Debt Topic 5: Hedge Funds • Structure of Hedge Funds • Macro and Managed Future Funds • Event-Driven and Relative Value Hedge Funds • Equity Hedge Funds • Funds of Hedge Funds Topic 6: Structured Products • Introduction to Structuring • Credit Risk and Credit Derivatives • CDO Structuring of Credit Risk • Equity-Linked Structured Products DURATION 200 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate