7919 Object courses

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

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

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

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

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

Formally Safeguarding Children Level 1: One Day Course 10am - 3.30pm Working Together to Safeguard Children 2018 & Keeping Children Safe in Education (2022) Updated This Course can also be run within your organisation for your staff group at a reduced cost contact us for a quote or if you have any other questions about this course talk to an adviser now online.

Our Motivational Intelligence Executive Management course is targeted at transitional leadership development to adapt to market dynamics. AWARD WINNING LEADERSHIP DEVELOPMENT PROGRAMME Executive Diploma: Leading With Motivational Intelligence Leading your team or business through transitions or adapting to change is a vital leadership skill that most find challenging. The Power Within Training is dedicated to giving leaders, managers, and businesses throughout England and the UK the executive leadership skills needed to transform their businesses. Neuroscientists have now discovered why people perceive risk, resist change, and cling to the legacy ways they approach their role. With this discovery, we’ve found a practical approach for removing this resistance and fostering greater employee accountability, adaptability, and resilience. The answer was uncovered in the emerging field of Motivational Intelligence. This course has completely changed my outlook on my responsibilities as a manager/leader. To say I have a new perspective is an understatement; I now have the tools to make a massive difference in how I run my company and my life; it has put a new voice in my head that is now directing me in ways I had not thought of before. "If you want a better chance in life and business, do not hesitate to do this course." MANAGING DIRECTOR RBT UNDERFLOWING LIMITED The Role of Motivational Leadership Our motivational leadership courses are rooted in the science of Motivational Intelligence. Motivational Intelligence is designed as an individual’s ability to identify and manage negative thoughts and self-limiting beliefs to overcome obstacles and accomplish goals. Using motivational intelligence and our management development program provides you with the skills and tools needed to face high-level challenges and put thoughts into action while paving the way to a vision. Motivation relies on the learning process of an individual and their ability to observe the relationship between performance and outcome. Motivational leaders can evoke and see the best in their employees and inspire them to work toward a common goal. LEADING WITH MOTIVATIONAL INTELLIGENCE Objectives of our Motivational Leadership Courses The management development program we offer is the world’s first accredited Executive Diploma specifically designed to help progressive-minded leaders adapt to today’s business environment. We focus on issues and challenges created by disruption and turbulence. Our motivational leadership courses address topics ranging from leading/managing virtual teams to helping employees more readily orient to an ever-changing world. The Power Within focuses on imparting fundamental skills, tactical best practices, and powerful insights into the human side of the business. Leadership training provides valuable knowledge to leaders of all levels. The management portion of our leadership training teaches participants how to define the proper team goals, translate them into actionable plans and communicate them in a way that encourages buy-in. Lastly, the leadership portion focuses on developing people by shifting negative thoughts and self-limiting beliefs such that individuals give themselves permission to learn, grow, and execute new strategies and plans. Here are some additional objects of our motivational leadership courses: To Understand the Role of Motivation in the Workplace To Develop a Deep Understanding of the Different Types of Motivation and How They Can Be Applied to Improve Team Performance To Learn How to Use Motivational Intelligence to Create a Positive and Productive Work Environment To Develop the Skills Needed to Increase Employee Engagement and Drive Business Results To Practice Effective Leadership Techniques that Foster Motivation and Engagement LEADING WITH MOTIVATIONAL INTELLIGENCE Our Leading with Motivational Intelligence (MQ) Executive Diploma Programme is specifically designed to help participants create the “complete game” of leadership and management. Leveraged by more than 40% of the largest Fortune 500 companies and implemented around the world, the Leading with Motivational Intelligence (MQ) consistently receives a participant buy-in rate in excess of 97%. However, the most important statistic is: 12 months after completing the course more than 93% of participants continue to use the skills and techniques taught on a daily basis. ABOUT THE MQ EXECUTIVE DIPLOMA Are There Different Types of Motivational Leadership? Motivation is the fuel that drives the accomplishment of a goal; without any motivation, the goal becomes another difficult task. Motivational leadership means understanding that regardless of whether you’re leading a small group or an entire business, your leadership and motivational style can significantly impact the effectiveness of your effort. There are several leadership and motivation styles, but the challenge comes with finding the most appropriate for you and your team. In our leadership development program, we’ll discuss leadership motivational skills while working with you to find the best one. Motivational leadership either takes the form of intrinsic or extrinsic motivation. Intrinsic motivation motivates your team to be rewarded internally, and extrinsic motivation uses compensation as a driving force. Compensation can be salary, bonuses, goods, money, or even an appraisal. Here are some examples of different intrinsic and extrinsic motivational types: Competence Motivation – This style is driven by curiosity and a willingness to know more and cultivate additional skills. This style’s central pillar is building more expertise on a subject matter as a noncompetition among peers. Achievement Motivation – Achievement motivation is similar to competence, as it aims to achieve personal development goals. This could take the form of a title within the company. An example could be in your sales department, where a leaderboard or wall of fame is used to track sales. Reward-Based Motivation – This is probably the only motivational type most are aware of, as it’s the easiest way to get a fast motivational boost. The main issue with this type of motivation is that employees get used to it, and the effects don’t last long. Understand the Importance of Motivation Skills in Leadership Motivation drives nearly every action of our lives. Motivational leadership drives the why behind every business idea that’s ever been put into action. As a leader or manager, you must understand the importance of motivating team members, and being able to do this effectively is a requirement in every manager, leader, or business owner’s toolkit. Our management development program builds on best practices, strategic insights, and lessons learned over three decades of building leadership universities for Fortune 500 companies. Focusing on imparting fundamental skills to our executive development course offers powerful insights into the human side of the business. You’ll gain the skills needed to foster a growth mindset within your team. Here are some additional reasons why motivational leadership matters: Improved Performance – Motivated employees can drive the performance of your business. When your employees are motivated, you’ll find lower levels of absenteeism, improved relationships between managers and employees, and improved worker performance throughout your business. Enhanced Innovation – Motivation is a significant force behind innovative ideas. You’re more likely to identify workplace improvement opportunities when your team is motivated. Improved Workplace Culture – Employee motivation and your workplace culture are closely linked. When you take our leadership development program, you’ll discover that a motivated workforce brings commitment, and drive, which enhances your business’s overall morale and creates a positive work culture. Register your interest Motivational Leadership Techniques That Foster Engagement When employees are unmotivated or disengaged, it’s easy to blame tools, processes, or contributing factors. Often, disengagement comes down to a lack of effective leadership. Our leadership training program will help you unlock what leaders need to inspire their employees to do their job and find purpose within their roles. Here are some ways you can apply what you learned during your leadership development program to encourage collaborative leadership and inspire your team to do their very best work: Employees Trust Leaders Whom Both Lead and Follow – Good leaders don’t needlessly exhibit authoritative behaviour. Good leaders show their team that they are willing to roll up their sleeves and work with their team to improve the business. Passion and Positivity Increase Employee Performance – Effective motivational leadership combines finding meaning in work, leveraging connection and community, converting stress into opportunity, taking actions despite the risk, and lastly, maintaining the energy of others through motivation. Show enthusiasm in your business, which will convey your passion to others and can help increase performance and employee engagement. Effective Leadership Prioritizes Business – Successful leaders are more about short-term goals than reaching the next milestone and contributing to your overall business. Practical leadership qualities include providing growth opportunities, inspiring and motivating employees, being open and trusting, and assessing and managing risks. These decisions lead to more long-term success for your business. How To Register For Our Leadership Development Program   Our motivational leadership courses are open to leaders, managers, and business owners looking to quickly adapt their team to change and effectively mentor every team member. The modules in our leadership development program are live virtual instructor-led sessions that meet twice per month for about three and a half hours. These modules incorporate insightful discussions and engaging group conversations designed to shift limiting mindsets, isolate best practices and foster actionable strategies that can be applied immediately. To apply for the course, we ask that you register your interest. Once submitted, The Power Within will contact you to discuss options for fully-funded or partially-funded training opportunities. Register your interest today Book Your Motivational Leadership Course Today   The Power Within is the Motivational Intelligence company dedicated to helping your business become more accountable, resilient, adaptable, and capable of handling all the challenges they encounter. Our leading with Motivational Intelligence Executive Diploma course has been built leveraging Nobel Prize-winning research and the latest advancements to ensure everything necessary for meaningful change is in place. Our leadership development program is fully accredited and internationally recognized for its effectiveness in developing world-class leaders. We want to give you the tools, techniques, and knowledge to think bigger, be better, and achieve more. Don’t hesitate to contact us to learn more about our leadership development program.

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

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

We use it everyday but there are so many additional tools to save you time and make your work in Outlook more efficient and less stressful. Course overview Duration: 4 hours People tend to think they know how to use Outlook however there are so many lesser known features that can make working in Outlook so much more efficient. Simply understanding the layouts, how to turn things on and off and customising the environment to your preferences can save time and frustration. You then have search features, things such as conversation clean up and quick steps that can help to tidy up and organise what you do. Objectives  By the end of the course you will be able to: Customise Outlook to your preferences Manage email conversations Setup and use Quick Steps Create folders and organise information Setup rules Search for information Work effectively with calendars Content Customising the user interface Using the Navigation Pane and “To-do Bar” Setting folder pane options Adding favourites Peak preview Customising the quick access bar Setting reading pane and message preview Customizing email mail views Using the field chooser Email options Email conversations Conversation clean up Using Quick Steps Creating folders and organising information Setting email options Setting up rules Searching for information Using the Search bar Setting what to search for Setting where to search Searching for categories Adding more search options Working with calendars Setting what to view Using Schedule View Setting calendar options Weather bar Adding different time zones Adding meetings and appointments Setting up and using categories Opening other people’s calendars Setting calendar permissions Calendar groups Working with Tasks Lists Setting task options Adding and amending tasks Setting dates, deadlines and reminders Adding attachments to tasks Assigning tasks to others Flagging tasks Using and setting Quick Click Recurring tasks Flagging emails to appear on your task list Converting emails to tasks Converting tasks to calendar appointments