497 Courses in Birmingham

Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

Psychodynamic Couples Therapy examines unconscious processes and unresolved conflicts from the past that affect the current relationship. This approach helps couples gain insight into their behaviours and emotions, fostering deeper understanding and connection.   Key areas: unconscious processes, unresolved conflicts, behaviour insight, emotional understanding, deeper connection 3 x 1 hour sessions

Overview 2 day course on key interest rate derivative products, covering both theory (product mechanics, market conventions and valuation) and practice (wide range of applications for wide range of market participants showcased) Who the course is for Interest rate traders, salespeople and quants Asset-liability management staff with banks and insurance companies Fixed income and credit asset managers / hedge funds / pension funds / insurance companies Corporate treasurers Risk management Anyone using interest rate derivatives Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview A review of the most enduringly popular structured equity-linked products. This 1 day hands-on programme will help you gain familiarity with 1st generation & 2nd generation structured products convexity – and their applications. Discover techniques for maximising the participation rate to enhance returns for investors. Explore the trade-offs between coupon payments and gearing, and how they affect the risk-return profile of the notes. Explore ladder structures, their relationship to lookbacks, and the benefits they offer to investors. Learn about accumulators, their structuring, and the reasons behind their controversy in the market. Who the course is for Structured Products Desks, Financial Engineers, Product Controllers Traders, Dealing Room Staff and Sales People Risk Managers, Quantitative Analysts and Middle Office Managers Fund Managers, Investors, Senior Managers Researchers and Systems Developers Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview Learn about contract triggers, including European vs. American style, and variations like one-touch, no-touch, and double no-touch options. Who the course is for Risk managers IT System developers Traders and derivatives teams Consultants and brokers Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Level 2 NVQ Diploma in Groundworks Operations

This course is designed to help the individual understand their responsibilities within the...

Expert consultant to conduct Fire Risk Assessment of site/ workplace/ relevant building

This workshop will provide an opportunity to understand and apply a range of commercial analysis tools in a problem-solving environment.

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