8103 Courses delivered Online

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

Learn how to be fully effective in your role without burning yourself out. Course overview Duration: 1 day (6.5 hours) There are only 24 hours in a day, and only so many of those that you want to spend in the office! While many people seem to see working long hours and being highly stressed as a badge of honour you can in fact be more productive and fully effective in your role without burning yourself out. Quite simply in this whirlwind world we need to be great at managing the time and that’s what this interactive one day workshop will teach you. Objectives  By the end of the course you will be able to: Use a selection of tools to set goals, plan and prioritise your time Stop self-sabotaging and create more productive time every day Take control of your day, the time you have available and other people who try to steal your time Hold more effective meetings Manage stress so that you can be at your peak more often Content Getting Started Understanding the need to manage your time effectively Identifying your time stealers Setting goals Getting clarity about what needs to be done Understanding what is urgent and what is important in order to prioritise your tasks Planning your time Using to do lists and other time management tools Stop Self Sabotaging Understanding your time personality and the impact it can have on how you use your time and how others perceive your time management Recognising procrastination and taking action The myth of multitasking Creating focus and clarity in your day Using the time you have to be most productive Taking Control How to assert yourself with others who might be impacting your time management Managing interruptions Saying no and feeling OK about it Negotiating workloads Delegating How to hold productive meetings Managing your meeting attendance effectively Avoiding Burnout Exploring stress and how we respond to it Shifting mindsets Thinking differently Managing overwhelm and panic Tools to manage stress at work

Get to grips with all the features of Teams, including calls and chats, Teams and Channels and Meetings Course overview Duration: 2 hours This session is aimed at those new or self-taught users of Teams to show them the features and how to setup and use it effectively. Objectives  By the end of the course you will be able to: Use the core functions of Microsoft Teams Set up Microsoft Teams Make Calls Send Chats to colleagues via teams Set up channels Run Teams meetings Content What is Teams Teams elements Setting up your Teams Setting up audio and video Using voicemail Setting voicemail language Calls and Chats Sending individual and group chats Making and receiving calls Missed call notification Searching Teams and Channels Creating channels Channel settings Setting channel notifications Emailing channels Creating private channels Posting to channels Alerting specific people in a channel Adding files to channels Sending links to channels Teams Meetings Setting up meetings Running meetings from channels Setting backgrounds Screen sharing in meetings Handing over control Creating meeting notes Adding files to teams or meetings Using the meeting chat

Look at some of the more advanced planning features available in Project. Course overview Duration: 1 day (6.5 hours) Our Project – Advanced Planning and Control course looks at advanced planning and resourcing techniques in Microsoft Project and how to customise your schedule to give better visibility and flexibility. The course is designed for experienced users of Project who have attended our Project Planning and Control introduction course or have equivalent knowledge. You must be confident using Project to build and resource schedules and create task dependencies. Objectives  By the end of the course you will be able to: Work with different types of task Amend resource load on a task Work with multiple resource rates Create custom tables Add custom fields Create calculated fields Add drop down lists in fields Filter and extract information Create new views Export information Content Advanced planning techniques Splitting tasks Task types Spreading work across activities Advanced resourcing techniques Resource types Assignment views Effective dates Work contours Overtime work Using multiple resource rates Creating custom tables Customising tables Adding fields Creating custom fields Adding text, number, date and time fields Using flag fields Defining pick lists Renaming custom fields Creating calculated fields Creating formulas Using graphical indicators Uploading and tracking progress Completing work Completing work per resource Updating tasks Updating the project Working with the status date Rescheduling work Viewing baseline against schedule Project overview statistics Working with filters Building standard filters Building interactive filters Task and resource filters Using highlight filters Creating custom views Creating customised views Customising text styles Using grouping techniques Exporting information Exporting to Excel

Develop the commercial awareness, financial knowledge and strategic thinking capabilities, to influence the direction of the business Course overview Duration: 2 days (13 hours) This course is aimed at managers who want to develop their commercial awareness, financial knowledge and strategic thinking capabilities, so that they can influence the direction of their business and deliver to their full potential. Day one of the course provides the skills and insights to make sense of your company’s financial position and performance. Day two helps delegates to consider the strategic thinking tools required to plot the forward course needed to maximise the potential of the business. As well as looking at how to make effective business decisions, this course gives a good grounding in finance and profitability. As a two day programme, day one provides the skills and insights to make sense of the company’s financial position and performance. Day two then considers the strategic thinking tools needed to plot the forward course needed to maximise the potential of the business. Objectives By the end of the course you will be able to: An understanding of the balance sheet, profit and loss account, cash flow and statutory and management accounts Learnt to correctly employment key financial ratios to analyse your business A practical definition of strategy analysis tools to examine the current environment and capabilities Steps to devise a mission and vision statement Recognition of the skills and resources needed to achieve the vision Generation of appropriate strategic and tactical commercial objectives Content What is Strategy Defining Strategy Strategic thinking Strategic models Commercial thinking – what is money? Where are we now STEEPLE analysis SWOT Analysis P&E forces at work Political distortions in capitalist markets Where are we trying to get to Setting the mission and vision Creating a BHAG Strategies for deflation and inflation The role of banks Commercial and investment banking Fractional reserving Securitisation How to get there Skill gap analysis Business Process Re engineering The role of creativity How to get there Getting the team on board Individual and team motivation The power of the brand Overcoming challenges Debt and deleveraging Change management Creating value Discounted Cash Flows Building the business case Asset Valuation techniques Making it happen Turning Strategic Thinking into Strategic Plans Scenario planning for an uncertain future Creating commitments and lock in Discussion and review Time will be set aside during the course for review sessions with time for questions, answers and action learning.

Gain practical skills in influencing and decision-making, perfect for anyone working in team-based or project-focused environments, with interactive, hands-on learning. Course overview Duration: 1 day (6.5 hours) This is a highly interactive and practical course which will help you to use influencing and decision making techniques. This workshop has been specifically designed to give you an opportunity to learn and test a range of influencing and decision making models and techniques. The course is aimed at anyone who interacts with others on a regular basis, especially those in project management disciplines, multi disciplinary, matrix type organisations where healthy debate and challenge are key to achieving optimum resolutions. Objectives By the end of the course you will be able to: Utilise a variety of new techniques to enhance your influencing skills Recognise the impact of non-verbal communication and use it to enhance influencing behaviours Use language skills necessary to get your message across in an influential way Apply different techniques for dealing with aggression Understand VUCA – Volatility, Uncertainty, Complexity & Ambiguous Use Perception, Bias, Decision Making and Judgement Understand personal preferences and approaches to Decision Making Speed read others approach to decision making Apply Mindsets, Skillsets and Toolsets for decision making Content What is influencing? Sources of power Influencing skills Choosing the right approach Developing Skills Communication skills – the language of influence Different influencing techniques and when to use them Having the confidence to challenge Dealing with confrontation and challenges in a confident manner The Decision Lifecycle – Personal Preferences Understand the human facts that influence decision making Understanding personal preferences and approaches to Decision Making Understand the impact of Perception, Bias and judgement in decision making Speed reading others approach to decision making Frameworks to provide context for decision making Understand the business factors that influence decision making - VUCA The Cynefin Framework – decision making in complex situations Understanding which business context, you operate in – simple, complicated, complex or chaotic Understanding how to decide in complexity Practical Practical exercises Case studies Personal action planning

Learn how to use this innovative tool to analyse and validate your schedule, to add and model uncertainty and risk and to work with updated plans to compare project progress. Course overview Duration: 1 day (6.5 hours) This course looks at the powerful features of Nodes and Links. It looks at analysing and validating your schedule, adding uncertainty and risk and working with updated plans to compare project progress. Hands on practice will be gained throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Nodes and links, no previous experience is required. You should however be familiar with risk management processes and terminology. Objectives  By the end of the course you will be able to: Import and validate plans Analyse and review plans Add and model uncertainty Add and model risk Load updated schedules Re run analysis on updated schedules Content Validating your plan Importing a baseline plan Running a health check Analysing the results Reviewing the plan Analysing critical paths Reviewing activities Reviewing resources Adding Uncertainty Setting uncertainty templates Distributions Adding uncertainty Using Inherit Using AI Reviewing activity distributions Modelling Uncertainty Running the Analysis Reviewing the results Reviewing activity results Risk Drivers Filtering for activities Setting up the Risk Register Setting Risk Templates Adding Risks to the Risk Register Independent vs Dependant Events Setting Probability and Impact Modelling Uncertainty and Risk Mapping risks to activities Running the Analysis Reviewing the results Updated Plans Importing a new plan version Comparing plans Tracking progress Trend analysis Analysing Updated Plans Using updated plans Synchronising uncertainly and risk Rerunning analysis

Learn how to use Microsoft Project to create and resource robust project plans and how to maintain and track throughout the project lifecycle. Course overview Duration: 1 day (6.5 hours) Our Project Planning and Control course gives you the essential skills to use Microsoft Project to build, resource and monitor project schedules. It looks at initial setup, building plans, using a work breakdown structure and managing resources through to baselining and progressing your schedule. This course is designed for new or existing users of Microsoft Project, and no previous experience of Project is required. Knowledge of planning techniques would be an advantage. Objectives  By the end of the course you will be able to: Create project schedules Build a Work Breakdown Structure Create relationships Set baselines Manage resources Set deadlines and task properties Print and report on your project Update and track project schedules Content Creating a new project Project defaults Project start date Setting default hours per day/week Setting daily working times Project timeline Building a project Creating a work breakdown structure Adding tasks and durations Estimated durations Setting milestones Recurring tasks Linking, Baselining and Resourcing Setting start dates and dependencies Task Inspector Resourcing Assigning resources Filtering available resources Baseline Setting a baseline Removing a baseline Managing resources Resource properties Dealing with over allocations Tasking information Constraint dates Setting deadline Assigning task specific calendars Task types Updating your project Completing work Completing work per resource Updating tasks Updating the project Rescheduling work Change highlighting Printing and reporting Setup and Printing Visual reports Using the Timeline Creating Dashboard reports

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

Unleash your inner editor with our comprehensive copyediting and proofreading course. Master the skills to polish your writing to perfection and become a sought-after professional.