193 Acro courses in Nottingham

This workshop is very practical in its nature and aims to give delegates an opportunity to not only learn about the key aspects of successful bid writing, but to also put them into practice. The workshop helps delegates understand what is most important to buyers and how to successfully convey they proposition to them. 1 Welcome and introductions 2 The mindset of successful bid writing The mindset needed for successful bid writing Thinking from the buyer's perspective and not your own 3 Decision making The way buyers make decisions - rational and emotional Understanding buying motives Looking at how to present ideas against those motives The idea of cognitive fluency How to pitch an idea in a way that leads to a positive decision 4 To bid or not to bid? Writing a bid is a big commitment; a clear understanding of the chances of winning is required Understanding of the implications of winning and the impact it will have on the organisation 5 Understanding your value proposition Framework to help identify unique proposition and how that fits in with the requirements of the bid 6 The tender process Understanding the process to enable a successful chance of winning the bid Different types of tender processes Evaluation of criteria and the impact on bid writing 7 Writing skills Different ways of writing and structuring bids to ensure their messages gets across well in a way that will be looked on favourably by the buyer 8 Summarise 9 Close

This one-day programme explores the role of intellectual property (IP) in relation to innovation and creativity. It examines the different forms as well as the key processes, together with some of the oddities and idiosyncrasies of the legal regime that protects IP. It delves into the various IP models you should be aware of as well as key IP facts and figures and current IP trends across the global economy. This session is designed to give you a deeper understanding of: The main forms of intellectual property The importance of IP - both to your organisation and to the wider economy The key processes in the creation, commercial exploitation, and legal protection of IP The different models for the use of IP Some more advanced concepts for reviewing, valuing and managing IP 1 Main forms of intellectual property (IP) Patents Trademarks Copyright Design Trade secrets 2 Global IP business context Global IP facts and figures Figures for key jurisdictions Analysis of a company using IP data IP trends Overview of the key entities in the IP sector 3 Key IP processes IP creation IP portfolio management IP enforcement IP exploitation IP risk management 4 IP models IP models explained IP licensing IP litigation 5 IP concepts The IP maturity ladder Relative IP value and risk Axis of control 6 IP as an asset class Costs Valuation Financial perspective

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online

Successful account management requires time and investment to achieve high levels of customer satisfaction and develop new business opportunities. Ensuring you are equipped with the right tools to approach every customer interaction in a structured way will help you have productive relationships with your clients. Whether you're new to account management or experienced in business development and looking to expand your skillset, understanding how you can maximise customer relationships will be key to your success. We have developed this programme to be practical, fun and interactive. Participants will have the opportunity to learn and practice a number of key skills that will see successful results, and are encouraged to bring real life examples to the course so that learning can be translated to real world scenarios. This course will help participants: Learn how to plan growth and increase revenue from existing accounts Develop skills to build and develop essential relationships to increase value and visibility Learn how best to create loyalty and customer satisfaction Identify how to set account targets and development plan for building contacts and cross-selling Develop persuasion and influencing skills to better define needs and develop opportunities Learn how to add value at all stages; plus gaining competitive advantage Develop an up-selling, cross-selling strategy 1 Performance metrics for account management Introduction to the PROFIT account management model Using practical tools to measure account performance and success Planning your account strategy - red flags and green lights 2 Relationships for account management How to build and manage key relationships Producing a 'relationship matrix' Developing a coach or advocate 3 Setting objectives for your account Developing an upselling cross-selling strategy Setting jointly agreed goals, objectives and business plans Planning session 4 Feedback and Retention - building loyal and satisfied customers How to monitor and track your customer's satisfaction Building a personalised satisfaction matrix Customer service review meetings 5 Influence Getting your message and strategy across to C-level contacts Being able to better develop a business partnership within an accountes 6 Teamwork and time management Working with others to achieve your account goals Managing and working with a virtual team Managing your time and accounts effectively 7 Gaining commitment and closing the sale Knowing when to close for commitment How to ask for commitment professionally and effectively Key negotiation skills around the closing process - getting to 'yes' Checklist of closing and negotiation skills Practice session

ChatGPT, along with other AI tools, aims not to replace the human touch in management, but to enhance it. By addressing repetitive, daily tasks, these tools free up managers to concentrate on core responsibilities like strategic decision-making, team development, and innovation. As we move further into the digital age, integrating tools such as ChatGPT isn't a luxury; it's the future of proactive leadership. In this guide, we'll delve into 10 practical ways through which AI can elevate your efficiency and refine the quality of your work. Gain familiarity with prominent AI tools in the market Efficiently compose and respond to emails Generate concise summaries of complex reports and data. Obtain quick insights, data, and research across varied topics Streamline the writing of articles, training notes, and posts Craft interview tests, form relevant questions, and design checklists for the hiring process 1 Streamlining emails An inbox can be a goldmine of information but also a significant time drain for managers. Here's how to optimise it: Drafting responses: Give the AI a brief, and watch it craft a well-structured response. Sorting and prioritising: By employing user-defined rules and keywords, ChatGPT can flag important emails, ensuring no vital communication slips through the cracks. 2 Efficient report writing Reports, especially routine ones, can be time-intensive. Here's a smarter approach: Automate content: Supply key data points to the AI, and let it weave them into an insightful report. Proofreading: Lean on ChatGPT for grammar checks and consistency, ensuring each report remains crisp and error-free. 3 Rapid research From competitor insights to market trends, research is a pivotal part of management. Data synthesis: Feed raw data to the AI and receive succinct summaries in return. Question-answering: Pose specific questions about a dataset to ChatGPT and extract swift insights without diving deep into the entire content. 4 Reinventing recruitment Hiring can be a lengthy process. Here's how to make it more efficient: Resume screening: Equip the AI to spot keywords and qualifications, ensuring that only the most fitting candidates are shortlisted. Preliminary interviews: Leverage ChatGPT for the initial rounds of interviews by framing critical questions and evaluating the responses. 5 Enhancing training Especially for extensive teams, training can be a monumental task. Here's how ChatGPT can assist: Customised content: Inform the AI of your training goals, and it will draft tailored content suitable for various roles. PowerPoint design: Create visually appealing slide presentations on any topic in minimal time.

Trade barriers are going up across the globe. And cybercrime is on the increase. The link between the two? The value of trade secrets. As countries become increasingly protectionist as regards international trade, so their IP law has been changing, with the result that companies that previously would have sought protection through patents are opting to go down the trade secret route instead. But is this a high-risk strategy? Technology is changing and this is having an impact on forms of commercial co-operation. Collaborative or open forms of innovation by their very nature involve the sharing of intellectual property (IP), and in many instances this IP is in the form of valuable confidential business information (ie, trade secrets). Little surprise, then, that trade secrets disputes have increased accordingly. At the same time, the changes in technology make trade secrets more vulnerable to attack, misappropriation, theft. So just how effective are the legal protections for trade secrets? How can organisations safeguard the value in their IP (increasingly, the single biggest line in their balance sheets)? This programme is designed to help you address these issues. Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. This session is designed to give you a deeper understanding of: Emerging trends in trade secrets protection and exploitation The current situation in key jurisdictions Recent case law How leading companies are responding The importance of trade secret metadata Different external stakeholders and their interests Key steps for effective protection of trade secrets Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. 1 What are trade secrets? Definitions Examples Comparison with other forms of IP (patents, confidential information, know-how, copyright) 2 Current trends The various changes taking place affecting trade secrets - legal changes, trade wars, cybercrime, technology, commercial practice The current position in the UK, Europe, USA, China, Japan, Russia Corporate best practice 3 Trade secret disputes - how to avoid them Trade secret policies, processes and systems Administrative, legal and technical protection mechanisms The role of employees The sharing of trade secrets with others 4 Trade secret disputes - how to manage them Causes Anatomy of a trade secret court case 'Reasonable particularity' 5 Related issues Insurance Tax authorities and investigations Investor relations 6 Trade secret asset management roadmap Maturity ladder First steps Pilot projects

This programme has a simple objective: to help a sales team create and implementa comprehensive account development plan. If you want to earn strategic partner or preferred supplier status with your clients and customers then you need to add value to their business, consistently, and you can only do this if you have a plan - a key account management plan. This programme will help participants: Discover opportunities - through a deeper understanding of the customer's business Develop partnership - through a better 'value proposition' for the customer Increase repeat business - based on higher customer satisfaction Improve synergy - by getting everyone to 'sing from the same hymn sheet' Develop a collaborative account plan - validated by the customer and their own management Secure resources - management will align resources to execute soundly based account plans Win an increased share of 'customer wallet' - through systematic account development 1 The six principles of strategic account development Introduction to the PROFIT account development model:- Performance- Relationships- Objectives and goals- Feedback- Integration- Teamwork Practical account development strategies: overview and case studies 2 Performance Use practical tools to help you manage and measure account performance and success Design and build a monthly account dashboard for all sizes of account Prioritise and manage accounts and customers pro-actively and successfully, using proven planning tools Develop a cross-selling strategy to integrate products or solutions into the customer's business as closely as possible 3 Relationships How to build and manage key relationships within an account Qualifying and managing key influencers accurately Producing a 'relationship matrix' for each account quickly and easily Approaching and developing new contacts strategically Tools and techniques for successful tracking of contacts and call-backs Developing a coach or advocate in every customer organisation pro-actively 4 Objectives and goals Where are you now? - how to establish your competitive position within an account Know how to set, monitor and track key objectives for accounts over the short, medium and long term Selling against the competition - developing both long- and short-term sales strategies 5 Feedback - building loyal and satisfied customers The correct way to manage customer expectations and create listening loops within an account How to monitor and track your customer's perception and satisfaction with your organisation Building a personalised satisfaction matrix for each account Customer review meetings - best practice in building loyalty by regular joint planning events Understanding the concept of long-term customer value and the importance of adapting a customer-focused attitude 6 Integration How to integrate your products or solutions with the customer's business needs and processes Spot and react to early warning signals that may cause an account's loyalty to fade, reduce revenue or switch to a competitor Developing a loyalty strategy for key accounts or groups of smaller accounts Getting your message and strategy across to C-level contacts 7 Teamwork Working with others to achieve your account goals Gaining internal commitment from your organisation Managing and working with a virtual team Creating cross-departmental communication loops 8 Putting it all together Personal account reviews Personal learning summary and action plans

The aim of this programme is to provide current / prospective senior project managers with an in-depth review of the role and importance of project management in the organisation. It focuses on the strategic role of the project manager and aims to draw out the full scope of the role and how it impacts on project performance. The five key objectives of this programme are to enable the participants to: Identify the characteristics and attributes needed by project managers in ensuring the organisation is recognised as an industry leader in delivering successful projects Understand the full scope and impact of the project manager / leader's role in managing projects or programmes to maximise benefit to the business Define the hallmarks and skills required to manage significant business projects or project portfolios Develop an understanding of the skills required and their impact on the project through case study work and syndicate exercises Benefit from an effective forum for exchanging experience and fostering a sense of team spirit and mutual support between senior project managers DAY ONE 1 Introduction (Course sponsor) A vision of future opportunities and challenges The impact of project managers / leaders on future success 2 The determinants of success The contractor's perspective The client's perspective Success and failure: factors that determine the project outcome The impact of the project manager 3 Case study: Project Giotto How successful was this project? What were the primary factors that influenced the outcome? How relevant are these factors to current projects? Feedback and review 4 Project team exercise A practical exercise demonstrating the role of the project manager in managing the interfaces between the client, the project team and suppliers Review - what skills are required to be a 'world class' project manager? 5 The role of the Project Manager The role and skills of the 'world class' project manager The three key dimensions of effective project leadershipManaging influential stakeholdersManaging project performanceManaging the project team Project leadership skills appraisal (individual review) DAY TWO 6 Managing influential stakeholders Project management and the art of leadership Who are the influential stakeholders and how do they affect the project? What we need to do / not do, to build successful working relationships 7 Case study: Understanding the customer What are the likely problems the project manager will encounter? What should the project manager do to ensure an effective partnership? 8 Managing project performance Issues affecting commercial performance Joining up the project life-cycle: getting performance from inception to closure The roles of project manager, line manager and project sponsor 9 Project team exercise: Making the promise / delivering the promise An exercise demonstrating the commercial and team leadership skills needed by the project manager Review - what must the project manager do to optimise project performance? 10 Managing multi-functional project teams The challenges of building effective, multi-functional project teams Co-ordinating work across functional and organisational boundaries Maintaining strategic focus and balancing priorities 11 Making it happen Individual action planning Syndicate discussion 12 Course review and transfer planning (Course sponsor present) What will we do differently? How will we make it happen? Conclusion

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a 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 utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups