219 Office courses in Leicester

Overview A 1-day course on inflation-linked bonds and derivatives, focusing on the UK market in particular. We examine how inflation is defined and quantified, the choice of index (RPI vs. CPI), and the most common cash flow structures for index-linked securities. We look in detail at Index-linked Gilts, distinguishing between the old-style and new-style quotation conventions, and how to calculate the implied breakeven rate. Corporate bond market in the UK, and in particular the role of LPI in driving pension fund activity. Inflation swaps and other derivatives, looking at the mechanics, applications and pricing of inflation swaps and caps/floors. The convexity adjustment for Y-o-Y swaps is derived intuitively. Who the course is for Front-office sales product control research Traders Risk managers Fund managers Project finance and structured finance practitioners Accountants, auditors, consultants 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

Edoxi's MEAN Stack Course in Dubai equips you with essential skills to become a proficient developer. Edoxi's MEAN Stack course helps you build, deploy, and maintain full-stack JavaScript applications using the MEAN Stack framework. Our MEAN Stack course features one-on-one mentorship from our experts. Discover practical learning and implement your MEAN Stack skills in real-world situations through our project-centric approach, which emphasizes the importance of hands-on experience. Enroll in Our MEAN Stack Course and Gain Hands-On Experience with Expert Mentorship! Call us: +971 4380 1666 Mail us, at  info@edoxi.com Learn more:https://www.edoxi.com/dubai/mean-stack-course Address: Office 504, Bank Street Building, Next to Burjuman Metro Station Exit 3, Khalid Bin Al Waleed Rd, Dubai, United Arab Emirates

Our telephone training takes place in your normal working situation, using the actual telephones and software, and the programming software clients that trainees will use when fully trained. Our trainers will travel anywhere in the world to train you face to face, or if you prefer, we can offer our whole training catalogue remotely using Teams or Zoom. On-site and live remote telecoms training sessions have a general reputation as most effective for trainees to continue to efficiently carry out their telecoms usage, programming and own in-house training of future new employees. On-site training involves employees training at their place of work while they are doing their actual job, or in pre-organised classroom training sessions, based around hands-on interaction, trainer Q&A and all carried out using your own site telephone system. Our telephone trainers also offer consultations on your new or current telephone systems: looking into how you currently use your system, making suggestions on how programming could be tweaked and changed to improve your current usage, how to improve on call handling methods, and informing you of additional products which may be available on your system that you may not be aware of. This could help improve the level of communication across your company and interactions with your customers. We believe telephone handset and voicemail training sessions are essential to the smooth and efficient running of your company, making sure your staff are aware of all the features and benefits that the telephone handsets can offer, and ensuring calls are dealt with quickly and effectively. System administration training is available to teach new administrators how to manage and control a variety of system features. This type of training is especially important when new administrators have little or no previous telecom knowledge or experience, but it is equally important at all levels to ensure the new system is utilised to its maximum capability. Administration days or Call Centre Software training days take one full day to complete. Full Day Example: 9:30 - 16:00 Day Structure  09:30 - 10:45 Handset & VM session for up to 8 people 10:45 - 12:00 Handset & VM session for up to 8 people 12:00 - 12:45 Lunch  12:45 - 14:00 Handset & VM session for up to 8 people 14:00 - 15:15 Handset & VM session for up to 8 people 15:15 - 16:30 Handset & VM session for up to 8 people Half Day Example: 9:30 - 13:00 Switchboard training takes half a day (3-4 hours for up to 3 people). If you want to train more than 3 people, you may need to extend the day to a full day, to ensure everyone gets to have hands-on training on the switchboard. Super Users and Train the Trainer Sessions Super User sessions can also be organised to show advanced system features in order to provide an ongoing training service to their colleagues, once the trainers have left the site.

A half day workshop exploring practical ways we can invest in our workplace happiness.

This is an essential programme for any member of staff whose role requires a high level of attention to detail. The focus is specifically on the handling of text and data, whether at the input stage or when collating information into reports and documents for use by others. The session looks at both prevention and cure. For 'prevention', it focuses on understanding how common errors occur and on developing an awareness of the factors which influence our level of attentiveness. It introduces key psychological theories around attentiveness including the 'capacity' and 'bottleneck filter' models. And it looks at how working styles can affect attention to detail. For 'cure', the programme looks at how to minimise the effect of stress on concentration as well as introducing a number of tools and techniques for promoting accuracy - at both the input and the checking stages. Particular attention is paid to proof-reading techniques. By the end of the session, participants will: Appreciate why errors occur Understand how stress and other factors can affect focus and accuracy Know how to improve accuracy and reduce errors when handling text and data Be able to proof-read text and number-based documents more accurately 1 The importance of accuracy The impact of mistakes Why accuracy is so important Main reasons why errors occur 2 Attentiveness theory The 'capacity' and 'bottleneck filter' models Selective attention Chunking - big picture / little picture 3 Preparing for accuracy Working styles - how they affect detail-orientation Identifying and minimising the impact of stress on concentration 4 Practical strategies How to improve accuracy and reduce errors when inputting text Managing interruptions and distractions Proofing text and numbers

The often-used phrase, 'just the receptionist', completely misrepresents the role. An excellent receptionist is a most valuable resource for any organisation. This programme has been designed specifically to deal with the essential skills necessary to represent the organisation to the best possible effect. It will also help you get the most out of your working day. There are six key reasons to take part in this workshop. It will help you: See your role in a new light Develop your communication skills Deal with different types of customer and situation Boost your confidence Cope in a pressurised environment Get more satisfaction from your working day 1 Introduction Workshop objectives and personal objectives The challenges of 21st century communication What makes an excellent point of Reception? And why is it so important? Who and where are our customers? As a customer, how do you like to be treated? What makes people feel valued? Objective and subjective aspects of customer service 'Micro moments' that shape the relationship 2 Communication on reception Definition of communication Barriers to good communication The 'recipe' of verbal, vocal and visual aspects of communication Differences between communicating face-to-face and on the telephone Communication 'leaks' The primitive human response The impact of visual communication - body language, gesture and facial expression Voice - tone, speed, volume, pitch, clarity, inflection, pacing Words - positive words and phrases compared with negative terminology Professional greetings face-to-face Steering the conversation with effective questioning 3 Telephone excellence How we use the telephone Qualities of the telephone Non-verbal communication on the telephone - what aspects can be 'seen' by the other person? Professional telephone etiquette Taking and leaving messages - key points that can help customers, colleagues and the organisation Clarifying information 4 Listening skills for accuracy and relationship building How accurate are your listening skills? What are the challenges for accurate listening? Active / empathetic listening 5 Creating a rapport by 'style flexing' Understanding how different people communicate Shaping our message to the other person so that they feel understood How changing situations can alter communication needs 6 Confidence and assertiveness Recognising different styles of behaviour - aggressive, passive and assertive Qualities of assertive communication - verbal, vocal and visual Assertive techniques - basic, persistence, negotiation / empathetic Demonstrating confidence 7 Coping in a pressurised environment Words - the most useful ones to use with stressed people and identifying the 'red rag' words Challenging situations - what do you find difficult and how do you respond? Dealing with outbursts of anger Bringing non-stop talkers back from their tangent Constructive ways to say 'no' 8 Pulling it all together Action plans Summary of key learning points

Our Team Building Programmes are 'simply excellent' (quote from Unilever). They always deliver much greater energy' motivation and efficiently accelerates to a galvanised, integrated team for their Manager/Team Leader. They're great fun and very commercially orientated - the best of both key elements to a successful and long-lasting high performance team. A successful company is always made up of successful teams. Teams that can work autonomously with a clearly defined set of goals, roles, vision, responsibility and culture will always reach for and achieve far greater success than a team that works just as a group of individuals. Our team building solutions are individually built and geared towards teams at any level within an organisation, providing an independent and objective perspective to promote a common purpose such as the creation of a 'high performance team'. Out With The Old Traditionally, team building events have been restricted to certain levels of management where they head off site for a bit of archery, quad biking and paintballing or something along those lines. Then over some coffee and cocktails, business plans and more efficient ways to work are casually discussed. Whilst being out having fun instead of being at work may improve an individual person's mood, the effect will only be short-term, and will not go far in creating permanent and cohesive teams who are able to overcome challenges together and drive the business forward when back in the workplace. In With The New Today's business thinking is more strategic and certainly has to look for returns on the investment. That is why Dickson Training Ltd's team building programmes are bespoke and built to your requirements through research, understanding your business and, most importantly, what results and achievements you are looking to get out of the programme. Once "what success looks like" has been established, we create tasks and activities that will test your leadership, problem solving, communication and team work skills. When the tasks have been completed, the learning - both practical and theory - is debriefed to the group as well as how it will translate back in your business. Not only are our events great fun, but they provide participants with learning points they can act upon to improve or enhance the working practices/environment. Team Building That Gets Results We have a highly innovative team who design team builds to suit all budgets and time or space restrictions. Large or small, we will develop the perfect event to meet your commercial objectives, keeping in line with your values and company culture. More recently we have combined team galvanising events with ways to engage the participants with and support their local communities. This solution has proved extremely popular with our clients and we are continuing to develop more and more programmes doing exactly this. " Phil did everything in a very professional and focused manner, without losing sight of the overall aims or having 'fun'. When I moved to Airbus UK and subsequently European Aeronautic Defense and Space Company (EADS), I had no hesitation in recommending Phil and the team to deliver the required training and team events.  Without doubt Phil and his team are excellent providers of training, to suit even bespoke requirements, and I would not hesitate in recommending the team to any business in the future. " Glenn Brown, Systems & Expertise Manager, Airbus Personnel Service Augmented Skills – an Essay by Phil Dickson All of you, who are reading this, and all the people you meet and work with will have – ‘Augmented Skills’. So – if you are an IT Engineer or a Pharmacist; perhaps you are, or know, a Departmental Leader and you work with a Logistics Project Manager; these roles will demand core skills, whether they be technical know-how or qualifications in the discipline. But to be that bit better; more reliable; more effective & productive and therefore more valuable and, frankly, marketable – capitalizing on ‘Augment Skills’ comes into play. The I T Engineer who was a Chess Champion at Uni, which would indicate that they possess some key ‘Augmented skills’ including how they plan 3 steps ahead and are always prepared for the unexpected. The Pharmacist, who is a keen sportsperson in their private life, will likely be tenacious, team-orientated and disciplined – again these are superb qualities to have in this – or any – role. Your colleagues, as well as yourself, will have ‘Augmented Skills’ that will be an asset if only they are explored and applied to their role and indeed, career. Everyone has their own 'Super-power' If they love gardening, they are probably strategic, patient and inclined to research; if they cook or bake, they are usually well organized and comfortable with multi-tasking. A big reader will tend to be considered and possess good critical thinking faculties, and an amateur mechanic or keen DIY person will often be practical, resourceful and very determined. I have observed that many new Parents discover they have ‘Augmented Skills’ they didn’t know they had... such as getting order out of chaos and displaying industrial amounts of patience and good grace when they really do not feel like it. They very often become far more compassionate and empathetic. Most people have their very own ‘Superpower’. Invite your team members to offer their ‘Augmented Skills’ to your work-place – and just watch as it elevates the motivation levels and improves results. It’ll be very rewarding for all concerned – and for meeting the Team’s objectives, to encourage the person who is a talented artist to be a sounding board on some of the marketing imagery and layouts; for the team member who is great at Maths or resolving crosswords to be asked for their input to solving a problem that is causing logistical or operational headaches. Never exploit a Team member’s unique special skills at their expense I would like to stress, however, that it must never be an area where a team member gets exploited by harvesting their unique special skills to coerce them into taking on greater responsibilities and tasks without providing them with the commensurate salary and status. To do so would be immoral and, ultimately, counter-productive as it would lead to resentment and disenfranchisement. This is about encouraging people’s capability and inviting their input to boost confidence and enhance the team’s capability. Often, we need to be more than what our Job Description says It is also important to highlight that whatever a person’s role or function is – they will definitely need to have additional capabilities to be effective. The best example of this is when we designed and delivered a range of ‘Advanced Customer Care skills’ training sessions for the Met Office a few years ago…we met so many remarkably super-bright Meteorologists, many of whom were having to make significant adjustments to answering questions from Customers that seemed to be illogical and often, obtuse. It wasn’t enough for these Meteorologists to be highly skilled at interpreting data and identifying patterns – they needed ‘Augmented skills’ to make that information accessible to members of the public (and Council workers and Air Traffic controllers and Shipping agents) and many other people, as to what that particular weather system was going to be like in their area and at what time. They have to know how to ‘de-jargonise’ the material and provide succinct, clear, and yet temperate, descriptions without ever appearing exasperated, impatient or judgmental in response to sometimes quite silly questions. For a highly trained scientist – that can be counter-intuitive. Being Philosophical... and a wee bit pretentious At the risk of being a little Philosophical (and probably a wee bit pretentious) – in my own role of Trainer – my core skills have to include – being a very good communicator, an active listener and have innovative and engaging ways to convert an idea, or a model, into practical application that my Delegates and Clients gain tangible benefits from. This is how it applies to me... I really enjoy composing short, light classical-style piano pieces. Now, to do this well, you need to be able to find a transition from one chord or melody to a different theme or key. It has to be worked out very carefully to have incremental transitions and pleasant-sounding developments as the piece unfolds. I think I have become better at this as I have honed my skills as a composer. But I have realized that these very same skills have ‘Augmented’ my ability to help a Manager, or a Team, move from a state of conflict; tension; disfunction; disenfranchisement; lack of confidence to a place that is more harmonious with far greater productivity. The very same process of careful listening, considering options, taking well-considered steps, having a creative, sometimes brave, move towards a resolution are at play in both Training and Piano Compositions! Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

The 3-hour Baby & Child First Aid class covers CPR, Choking, Bumps, Burns, Breaks, Bleeding, Febrile Seizures and Meningitis & Sepsis Awareness and will give everyone who attends the peace of mind they deserve.

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint