8916 Organisation courses

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

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

Electrical safety in organisations is often the responsibility of non-electrically qualified staff, such as facilities managers, risk managers or health & safety officers who have not had systematic training in how to prevent electrical hazards in the workplace. This situation results in a number of deaths in the workplace being caused by electrical incidents. This course provides a comprehensive overview of the fundamentals of electrical safety and a systematic set of principles for assessing and managing electrical safety in any business and across all sectors of industry and the public sector: the subject is universally applicable, across industries and countries. The course is applicable to the buildings, facilities, equipment and environments associated with a wide range of organisations, irrespective of size, which includes the industrial, commercial and the public sectors. The course provides practical guidance to enable individuals and their organisations to have a level of knowledge and understanding to manage the risks associated with an electrical system. It will focus on providing a specific procedure for managing electrical safety. The course follows the structure of the IET’s Code of Practice for Electrical Safety Management. The aim of the Code of Practice for Electrical Safety Management is to provide good practice guidance to enable individuals and their organisations to have a level of knowledge and understanding to manage the risks associated with an electrical system. There are many technical publications that provide guidance on certain aspects of electrical safety but not in a way that provides a process for managing electrical safety.

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 from our growing 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. 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. 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 Certificates Certificates Certificate of completion Digital certificate - Included

In this day and age, it’s crucial to know everything there is to know about international economic sanctions. With AGRC’s Certificate in Sanctions Compliance, you will acquire the theoretical and practical knowledge and skills to comply with any sanction imposed and protect your business from penalties and reputational damage. Over the past several decades, international economic sanctions have become a central instrument in global governance, being employed by both sovereign states and international organisations. More recently, there has been a shift towards ‘smart’ or targeted sanctions that aim at the political and economic elites of targeted countries (e.g., through asset freezes and travel bans) rather than a more comprehensive sanctions approach (e.g., large-scale trade or oil embargoes) that has a detrimental effect on civilian populations. In the era of financial globalisation, such ‘smart’ sanctions entail increased compliance obligations for state institutions and private organisations which, if not met, carry significant fines, penalties, and other adverse consequences. Study method Online, self-paced Duration 25 hours Access to content 365 days Certification Certificate in Compliance Additional info Exam(s) / assessment(s) is included in price Description This certificate provides a thorough understanding of sanctions and an opportunity to explore the recent global trends in economic sanctioning, while tracing the roles of the relevant actors within this complex framework. You will examine the motives and rationale behind such decisions, the effects and consequences experienced not only by the targeted parties but also those doing business with them, either directly or indirectly. The certificate is structured to offer the relevant knowledge with reference to practical examples that will enable for a sanctions compliance strategy to be conducted in an effective manner, essential to mitigating the sanctions risk. Topics Covered • Definition of sanctions • Framework and legal basis • The international framework • Multilateral sanctions • Unilateral sanctions and key sovereign states • The legal and institutional framework • Categories of restrictive measures • Administration of sanctions • Managing and mitigating sanctions risk • Sanctions compliance programmes • Processes and systems • Sanctions screening and evasion Expected Learning Outcomes Upon completing this certification, you will be able to: • Understand sanctions and the importance of compliance • Understand why it’s important to comply • Review and understand the global sanctions framework • Define a sanctions compliance programme and governance framework • Define sanctions lists and screening • Manage alert investigations • Understand sanctions risk • Determine how much your institution is vulnerable to sanctions risks • Apply modern methodologies that will increase the efficiency and effectiveness of your programme • Protect your institution from dealing with embargoed individuals or entities • Understand the best practices for sanctions compliance controls Who is this course for? Financial crime and regulatory compliance professionals Professionals working within the sanctions environment who wish to certify their knowledge Operational staff who need to understand the importance of sanctions compliance Regulators Consultants AML, compliance, and risk professionals Anyone working in financial services interested in attaining a better understanding of how sanctions work Requirements No previous knowledge or experience is required, although it is assumed that participants have good knowledge of English and sound educational background.

Outspoken Cycles Park Tool School courses are aimed at home mechanics who wish to have an in-depth knowledge of their bikes as well as those individuals required to maintain bikes for friends, schools, clubs, businesses and other organisations. The 4 Day Advanced course teaches you advanced mechanical skills following the Park Tool Big Blue Book of Bicycle Repair syllabus in order to help you gain the confidence to take on bicycle repairs involving various manufacturers and systems. Completion of assessment leads to the award of a certificate. You are encouraged to work on your own bike. Please be aware for some elements of the course certain bikes may not be suitable, however, there are also a number of classroom bikes to work on where necessary. We can provide a classroom bike if you’re unable to bring your own.  Course Detail Over four days you will cover: Workshop Practices (Health and Safety, Safe use of tools, PPE, etc.) Tyres & Tubes (Inspection, sizing, systems, puncture repair) Cassettes & Freewheels (types, compatibility, wear, removal and installation) Hub Service (full strip down and rebuild, different systems) Gears and Cabling (identify issues, re-cable, set up and adjustment) Headsets (a-Head and Quill types, strip down and reassemble) Wheel Truing (spoke replacement, introduction to truing, demo wheel construction and lacing) Frame Assessment & Preparation (damage, tools, frame preparation etc.) Bike Setup (choosing the right size bike, saddle height, basic bike fit) Cranksets & Bottom Brackets (different types discussed, removal and replacement) Rim & Disc Brakes (mechanical disc and rim brake set up and adjustment, demo of hydraulic brake bleed) Price The course costs £500 inc VAT. This includes Park Tool Big Blue Book of Bicycle Repair and the use of all tools and equipment while on course.  If you’re a Cambridge Cycling Campaign member, we offer a 15% discount to support the good work that they do. Please email us for access to your coupon code. Refunds for courses are only given under exceptional circumstances and never within 7 days of the advertised course. In the unlikely event we have to make the difficult decision to cancel a course, participants will be offered a refund or the option to reschedule. Please read our terms and conditions for full details. Pre-requisites Course participants must be 18 years old or above. We may be able to accommodate younger participants 16+, we accept these on a case by case basis based on prior experience. Please contact us to discuss. Participants should have a good knowledge of the key content outlined in the Basic: Ride With Confidence and Intermediate courses before booking the Advanced course as this level of knowledge is assumed by the instructor on the day. There will be a brief refresher, but if you are unsure do get in touch to discuss. Course Timings, Assessment, Location & Travel Courses run 9am-4pm over four days, or 9:30am – 4:30pm for weekend courses. Courses take place in our dedicated training workshop at our offices in Cambridge. We have an abundance of bike racks, and we are close to Cambridge North Station. There is limited parking on site on a first-come-first-served basis and we are close to parking at Cambridge North Station. There is some limited on-road parking (at owners risk). You may also park for free at the Milton Park & Ride, which is only a short 15 minute cycle to our workshop.  Further details If you have any further questions, please do please get in touch to discuss. For more information, please read our Terms & Conditions. I would like to say a big thank you to all the teachers for the knowledge they have given me, I’ve loved learning it – Simon Spry, PTS Advanced Participant July 2022

Target Audience Mentors of business professionals, leaders & executives who are undertaking personal and professional development. Duration 3hrs Course Overview This course is designed to equip mentors to effectively guide their mentees through their development program. It provides mentors with insights into the mentoring program structure, expectations of mentors and mentees, and techniques for fostering a constructive and development-focused relationship. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes Follow the structure and meet the objectives of the organisation’s mentoring program. Apply effective strategies for building a productive mentoring relationship. Confidently facilitate development-focused conversations and activities. Support mentees in creating and implementing action plans.

Course Overview Effective use of technology in adaptive organisations is critical for innovation, collaboration and efficiency. By reflectively examining the patterns and pitfalls of technology usage, individuals can identify how they can best harness the latest tools and platforms to increase the quality and effectiveness of their effort. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Examine the current technology landscape -Identify bottlenecks and issues with current tools & processes -Collectively explore new tools and platforms -Prioritise & plan adoption of new technology Format F2F or Virtual Delivery Mode Closed Cohort Duration 4 Hrs Target Audience Business professionals, leaders & executives looking to drive innovation through creative use of technology in complex or ambiguous contexts.

Course Overview Organisational adaptability is most likely to be achieved and ingrained into culture when it is effected at an individual level. This course provides a neuroscience-informed framework for individuals to develop mindset, skills, and habits that prefigure adaptability in response to changing business requirements and environment. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes -Explain the current organizational challenges that require adaptability -Identify strategies to personally manage adversity -Use outward thinking approaches to explore opportunities -Apply proactive and collaborative methods to embrace and manage change Format F2F or Virtual Delivery Mode Closed Cohort or Occasional Limited Public Schedule Duration 4 Hrs Target Audience Business professionals, leaders & executives aiming to enhance their own adaptability to complex or ambiguous contexts.

Target Audience Business professionals, leaders & executives aiming to develop their awareness of, and connection to self and others in complex or ambiguous contexts. Duration 1 Day Course Overview Adaptive social and emotional skills enable individuals to build social connections and regulate their emotions effectively in order to work well with others in an evolving organisational context. This involves strengthening emotional intelligence and shifting their mindset to become open, collaborative and focussed on forming value-driving partnerships. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes Exploring your own Emotional Intelligence Identifying common ground Gaining trust, respect and commitment Applying assertive techniques to manage and resolve conflicts