This ESS course is suitable for operatives who during the daily activities have to wear a safety harness. It will give the delegate an understanding of the safe use of a harness, methods of inspection and awareness of the regulations. Book via our website @ ESS | Working at Heights training | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346
LOVE SPELL
This is a specialist training course for senior managers or newly appointed safeguarding leads who are responsible for safeguarding adults from neglect and harm
A half day workshop exploring practical ways we can invest in our workplace happiness.
This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print
This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report
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
Starting a small business can be a rewarding journey, but it requires careful planning and the right strategies to succeed. From creating a solid business plan to organizing finances and finding the right support, this guide will help you establish a foundation for a thriving business. For entrepreneurs in Calgary, key resources like reliable bookkeeping services can make a significant difference. Here’s how to start a small business and set it up for lasting success. Developing a business plan A clear, well-researched business plan serves as a roadmap for your business. It outlines your goals, target market, competitive advantage, and financial projections. This plan will also help attract investors or secure loans. To create an effective business plan: Define your mission and vision: Explain why your business exists and what you aim to achieve. Identify your target audience: Determine who your customers are and what problems your business will solve for them. Analyze competitors: Study your competitors to understand what they offer and find ways to differentiate your business. Set realistic financial projections: Estimate costs, revenue, and profits. This will give potential investors confidence in your business. Choosing a business structure Selecting the right business structure is essential, as it affects your taxes, liability, and daily operations. Common options include: Sole proprietorship: Simple to set up, with minimal paperwork, but offers no separation of personal and business liability. Partnership: Ideal for two or more owners, allowing shared responsibilities, but partners share liabilities. Corporation: Provides liability protection, but involves more paperwork and regulatory requirements. LLC (Limited Liability Company): Offers liability protection without the complexity of a corporation. Choose a structure that best suits your needs, and consult a legal professional to ensure compliance with Calgary’s business regulations. Securing funding Most small businesses require some level of funding to get started. Consider various financing options to find the best fit: Personal savings or family support: Often the first source of funding for many entrepreneurs. Business loans: Many banks offer small business loans with varying interest rates. Grants and government programs: Explore government grants and programs specifically designed to support small businesses in Calgary. Angel investors or venture capital: For businesses with high growth potential, attracting investors may be an option. Registering your business To operate legally, you’ll need to register your business. This process involves choosing a unique name, filing the necessary documents, and obtaining a business license in Calgary. You may also need specific permits depending on your industry. Completing these steps ensures that your business complies with all local regulations. Organizing your finances Managing finances effectively is crucial for any small business. Accurate bookkeeping keeps your business organized, tracks income and expenses, and prepares you for tax season. Many small businesses in Calgary choose to hire a bookkeeper in Calgary to handle these responsibilities, allowing owners to focus on growth. Working with one of the best bookkeeping services in Calgary can provide: Accurate financial records: Professional bookkeepers help maintain up-to-date records, which is essential for financial health. Compliance with tax laws: Calgary’s best bookkeeping services are familiar with local tax regulations, ensuring that you file correctly and on time. Insights for decision-making: With accurate records, you can make informed decisions on budgeting, spending, and investments. Creating a strong brand identity Building a brand that resonates with your target audience is essential. Your brand identity includes your business name, logo, colors, and messaging, as well as the experience you offer customers. Developing a consistent brand identity sets you apart from competitors and builds trust with customers. Here are some steps to create a strong brand identity: Design a logo and visual theme: Choose a professional logo, color scheme, and design elements that reflect your brand’s personality. Develop a unique brand voice: Whether it’s friendly, professional, or playful, keep your brand voice consistent in all communications. Focus on customer experience: Aim to provide exceptional service that keeps customers coming back and sharing their positive experiences. Building an online presence In today’s digital world, an online presence is crucial for reaching potential customers. Start by creating a professional website where customers can learn more about your products or services. Next, consider establishing a presence on social media platforms that suit your audience. Key components of a strong online presence include: User-friendly website: Make sure your website is easy to navigate, mobile-friendly, and includes essential information about your business. Social media profiles: Engage with customers and share updates on platforms like Facebook, Instagram, or LinkedIn. Google My Business: Setting up a Google My Business profile helps customers in Calgary find you more easily. Building a support network Running a small business can be challenging, and having a network of support is invaluable. Surround yourself with people who can provide advice, resources, and encouragement. Consider these ways to build a support network: Join local business associations: Groups like the Calgary Chamber of Commerce offer networking opportunities, resources, and workshops. Seek mentorship: Experienced business owners can offer guidance and insights that help you avoid common pitfalls. Hire professionals for specialized tasks: For financial and legal matters, work with professionals like accountants, lawyers, and bookkeepers. Tracking progress and making adjustments As your business grows, it’s essential to review your progress and adjust your strategies. Regularly assessing financial performance, customer feedback, and market trends can help you refine your approach and stay competitive. Working with one of the best bookkeeping services in Calgary can make tracking your financial performance much easier, giving you insight into profit margins, cash flow, and budgeting. Consider these strategies for tracking progress: Set measurable goals: Establish specific goals for growth, such as revenue targets or customer acquisition numbers. Analyze performance data: Use financial statements, sales reports, and customer feedback to assess performance. Stay flexible: Be willing to make changes to products, services, or marketing strategies if they aren’t meeting customer needs. Conclusion Starting a small business takes effort, planning, and ongoing management. By creating a solid business plan, organizing your finances, and developing a strong brand, you can set your business up for success. In Calgary, many new business owners choose to hire a bookkeeper in Calgary to ensure accurate financial management and stay compliant with local regulations. Taking advantage of the best bookkeeping services in Calgary can free up your time, allowing you to focus on growing your business and achieving long-term success. With dedication and the right strategies, your small business can thrive in today’s competitive market.
Course Duration: Full-day program (or two half-day modules), with options for virtual delivery or leadership retreats Target Audience: Mid to senior-level leaders, team managers, project leads, or high-potential employees who are responsible for leading through disruption, complexity, or organisational transformation. Course Objectives By the end of this course, participants will be able to: Understand the principles of adaptive leadership and why it's essential in unpredictable environments. Recognise the difference between technical and adaptive challenges. Build the mindset and behaviours needed to lead with resilience and flexibility. Engage and empower teams in the face of uncertainty and resistance. Apply practical tools to lead through change, conflict, and complexity. Course Outline Module 1: Understanding Adaptive Leadership What is adaptive leadership? Origins (Harvard Kennedy School, Ronald Heifetz model) How adaptive leadership differs from traditional leadership The link between complexity, uncertainty, and the need for adaptability Module 2: The Nature of Change and Challenge Technical vs adaptive challenges Why some problems can’t be solved with expertise alone Common leadership traps during crisis or disruption Adaptive work: reframing problems and shifting mindsets Module 3: The Core Principles of Adaptive Leadership Get on the balcony – seeing the bigger picture Regulate distress – maintaining productive tension Maintain disciplined attention – keeping teams focused Give the work back – empowering others to lead Protect voices of leadership from below – enabling diverse input Module 4: Leading Yourself Through Uncertainty Developing personal resilience and emotional agility Navigating ambiguity, setbacks, and pressure Identifying your leadership default style under stress Reflection: What kind of leader does your team need now? Module 5: Engaging Others in Times of Uncertainty Building trust and psychological safety during turbulence Managing resistance to change with curiosity and empathy Tools for courageous conversations and adaptive dialogue Creating shared purpose and distributed leadership in teams Module 6: Adaptive Tools and Techniques Scenario planning and sensemaking Stakeholder mapping in dynamic environments Using inquiry over advocacy Holding space for experimentation and learning Leading with both confidence and humility Module 7: Action Planning and Application Identify one adaptive challenge in your role/team Map your adaptive leadership response Peer coaching conversations Build a 30-day Adaptive Leadership Plan Delivery Style Workshop-style, highly interactive Case studies, breakout discussions, and guided self-reflection Scenario-based practice and small group exercises Option to include pre-work, post-session coaching or check-ins Course Materials Provided Adaptive Leadership workbook Reflection tools and leader self-assessment Conversation guide for adaptive challenges Change resistance diagnostic Personal Leadership Development Plan template Optional Add-ons Executive coaching package 360 feedback or team diagnostic on adaptive capacity Integration with change management or innovation programs Customisation for specific industries (e.g., public sector, healthcare, education, finance)
Course Duration: Half-day or full-day session (with options for virtual delivery or multi-part series) Target Audience: People leaders, team members, HR professionals, and employees at all levels who want to foster a mindset of continuous improvement, learning, and innovation within their team or organisation. Course Objectives By the end of this course, participants will be able to: Understand what a growth mindset is and how it contrasts with a fixed mindset. Recognise the impact of mindset on learning, collaboration, leadership, and performance. Identify individual and team mindset behaviours. Apply strategies to shift thinking and encourage a culture of experimentation, feedback, and perseverance. Create an action plan to promote growth mindset behaviours in their workplace. Course Outline Module 1: Understanding Growth Mindset What is a growth mindset? (Based on Carol Dweck’s research) Growth vs fixed mindset: beliefs, language, and behaviours How mindsets impact learning, feedback, risk-taking, and innovation Common myths and misconceptions about growth mindset Module 2: The Neuroscience of Change and Learning How the brain learns and rewires through effort and repetition The science behind resilience, motivation, and behaviour change Reframing failure as feedback Why psychological safety is critical for learning cultures Module 3: Identifying Mindsets at Work Recognising fixed mindset triggers (e.g., fear of failure, comparison, perfectionism) Team culture audit: are we reinforcing learning or performance-only behaviours? Case studies: organisations that built growth cultures Self-reflection: where do I show fixed vs growth mindset? Module 4: Cultivating Growth Mindset Behaviours Shifting language: praise effort, strategy, and persistence—not just results Giving and receiving feedback to promote learning Normalising experimentation and learning from setbacks Encouraging reflective practice and continuous improvement Module 5: Leadership and Culture Shaping The leader’s role in modelling a growth mindset Embedding growth mindset into performance conversations, goal setting, and team rituals Aligning rewards, recognition, and development frameworks Avoiding the "false growth mindset" trap Module 6: Building a Growth Mindset Action Plan Identify 3 key mindset-shifting strategies for your team or organisation Personal mindset goal: what will you shift in your daily language or habits? Commit to culture practices: team experiments, learning debriefs, celebration of effort Optional: accountability partner and 30-day mindset challenge Delivery Style Interactive workshop format Storytelling, real-world examples, and reflection Pair and group discussions, case scenarios, and mindset mapping Tools and templates to apply immediately in the workplace Course Materials Provided Growth Mindset Field Guide Growth vs Fixed Mindset Behaviour Grid Conversation prompts and feedback scripts Personal Mindset Reflection and Tracker 30-Day Growth Culture Challenge Template Optional Add-ons Pre-course mindset diagnostic or self-assessment Leader/Manager booster session on modelling growth mindset Follow-up team challenge or learning sprint Integration with performance management or onboarding programs