Expand your Power BI knowledge and take your reports to the next level. Course overview Duration: 1 day (6.5 hours) This course is aimed at existing users who want to expand their skills to use advanced reporting techniques and use DAX to create calculated columns and measures. Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data and create simple reports. Objectives By the end of the course you will be able to: Import and connect data tables Create and use date calendars Create calculated columns Create and use measures Use drill down and drill through Create Tooltip pages Add and customise slicers Add action buttons Streamline your report for use in the Power BI Service Content Review of importing and loading data Importing data Transforming data Adding custom columns Creating data models Building visuals Creating date calendars Building date tables Creating Financial Year information Including Month and Day information Creating calculated columns Power Query custom columns vs DAX columns Creating DAX calculated columns Creating measures Implicit vs Explicit Measures Building measures Using DAX Common DAX functions Drill Down vs Drill Through Review of drill down Creating drill through pages Using drill through Creating ToolTips Pages Adding pages to use for Tooltips Linking ToolTip pages to visuals Using action buttons Adding images Adding buttons Setting actions Working with slicers Adding slicers Changing slicer settings Syncing slicers between pages Showing what has been sliced Setting slicer interactions Techniques in the Power BI Service Hiding the navigation bar Stopping users manually filtering
Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available. Duration 1 day (6.5 hours) Overview This Adobe Acrobat course looks at the powerful features of the tool quite often overlooked. The course requires the use of either the Standard or Professional versions of Acrobat as the free Acrobat Reader only has limited functionality. Learn how to combine documents into a single file, edit and mark up PDFs, compare documents, redact data from documents and create fillable forms. Objectives By the end of the course you will be able to: Create PDFs from other tools Set security Collate and combine files into a single PDF Edit PDF files Complete and sign documents Create fillable forms Mark up PDF documents Compare files Redact data Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Setting PDF options for print, image quality and security Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Collating and Combining Files Combining multiple files into a single PDF Adding extra files Deleting pages and reorganising pages Editing Files Editing text and graphics Adding text and images Adding headers and footers, watermarks and backgrounds Adding Links Adding manual links Automatic links Completing and signing documents Using fill and sign to complete forms Adding signatures Creating Fillable and Signable Forms Prepare a form Autodetect fillable fields Add manual fillable fields Adding drop downs, check boxes, etc. Naming fields Setting field properties Previewing the form Marking Up Documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio Replying to comments Comparing Files Selecting settings Comparison report Reviewing differences Using the changes pane Redacting Data (Acrobat Professional only) Setting redaction options Redacting chosen text Searching and redacting words, phrases or patterns Redacting whole pages Applying redaction
Unlock the power of effective negotiation. Gain essential skills to navigate complex deals, build lasting partnerships, and achieve optimal outcomes. Course overview Duration: 1 day (6.5 hours) This course is designed for those who need to understand and be able to use essential negotiation skills to make them more effective in their role. Externally you maybe negotiating with suppliers, customers, regulatory authorities and other organisations. Internally you will be negotiating with stakeholders, colleagues, and team members which could be for resources, time, budget or facilities. Being able to negotiate agreements that are acceptable to all parties requires skill and is essential to maintain healthy, functional relationships. This will be a facilitated workshop designed to be flexible to achieve the desired outcome. We will achieve the objectives through a mixture of facilitated discussion, interactive exercises designed to give insight and facilitator input. During the day we will deal with the stages of a negotiation from preparation to closing. Individuals will get the opportunity to practice the skills needed to create win-win outcomes through a number of generic but realistic scenarios. Objectives By the end of the course you will be able to: State the principles of effective negotiation Prepare effectively for different types of negotiation Set negotiation objectives and identify what can be ‘traded’ Explain how assertiveness and influencing skills can affect outcomes Deploy appropriate strategies and tactics to achieve the best results Use different techniques to deal with difficult customers and difficult situations Content Influencing Seek first to understand, and then be understood The importance of understanding the other party’s position and how to do it The power of non-verbal communication Dealing with difficult customers and difficult situations whilst maintaining a positive relationship How to approach negotiations Identifying potential negotiations and preparing for potential outcomes Aiming for results which deliver win/win outcomes Developing a win/win mindset and behaviours Rights and responsibilities of negotiators Setting Negotiation Objectives Clarifying essential, desirable and ideal objectives Assessing the most favoured, realistic target and walk away positions The Negotiation Process The importance of preparation Creating an opening proposal Where to pitch the opening proposal Bargaining/Trading - Gaining Momentum Knowing your parameters – what can be traded? Choosing a strategy and tactics Dealing with questionable tactics and ploys Building rapport – the communication process Asking the right questions and active listening Being assertive, demanding your rights and ensuring you meet your responsibilities Closing Techniques Trial and actual closing techniques Signalling Summarising and documenting the agreement Follow up and implementation of the deal
The Positive Psychology course to explore core values, shape a profound vision and create an actionable plan for your best life.
Supporting teams with Neurodiveristy
This course is specifically for Sunbelt Rentals team members. This module covers the requirements for TExT and how to carry out the Thorough Examination and Test process for on-tool dust extraction machines. To complete the training you will need a working knowledge of machinery and have operated or completed Combined Inspections and Tests (PAT) on machines.
Firefighting or solving the same problems week after week? Create a problem-solving culture in your business with this proven methodology.
Qualification Number 601/4458/0 Minimum entry age 19 Guided Learning Hours 180 What does this qualification cover? This qualification aims to: • introduce the concepts of equality and diversity in a variety of environments including society, the community and the workplace • highlight how stereotyping and labelling affect individuals • outline the effects of prejudice and discrimination • allow the learner to examine rights and responsibilities • stress the importance of taking individual responsibility and action to help and support others • provide a basis for further study and/or career development. The objectives of these qualifications are to help learners to: • raise their awareness of the issues surrounding equality and diversity • apply this awareness through their actions in society, community and the workplace. Who is it suitable for? This qualification is suitable for learners aged 19 and above. What are the entry requirements? There are no specific recommended prior learning requirements for this qualification. How is this qualification structured? The qualification is made up of three mandatory units: • Unit 1 Equality and diversity in society • Unit 2 Equality and diversity in the community • Unit 3 Equality and diversity in the workplace How is it assessed? This qualification is assessed via an internally assessed and externally verified portfolio of evidence. Funding for our qualifications This qualification is available fully funded under the Adult Education Budget funding stream and is free to the candidate.
Handset and/or Voicemail Training 1600’s, 1400, 96/95 series handsets, J Series and Voicemail Workplace Attendant Console and One-X Attendant Console One-X Portal and Video Soft phone / One X Communicator One-X Mobile/ Preferred Mobile IX Workplaces and Mobile App Agent and CMS Supervisor ASA – Avaya Site Administrator Tool AACC Administrator, Supervisor and Agent
Become a Certified Digital Leader Designed for: IT managers and business managers Consultants Project managers Key take aways from this leadership course (non-technical): Be comfortable with digital trends and technologies Leverage digital for your business Organise digital and manage digital transformation successfully Module 1 - Digital concepts Digital building blocks Digital lifecycle Big Data strategy Module 2 - Digital strategy Strategy Golden triangle of digital transformation Opportunity analysis Module 3 - Digital marketing Advertising Funnels E-commerce Module 4 - Digital economy Competitive landscape Influencers Legislation Module 5 - Digital finance Digital investments Defining budgets for digital ROI of digital marketing Module 6 - Information risks Information security concepts AI risks Privacy and Intellectual Property Module 7 - Organising digital Organisational design Iterative approaches Module 8 - Leading the digital workforce Digital mindset Robots & human workforce Industry 4.0 Module 9 - Leading Digital Transformation programmes Product development & Innovation Programme management Organisational change Case studies 3 business cases