1245 Courses in Manchester

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

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

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.

Moving and Handling is so much more than lifting and carrying. Whether we lift, carry, support, push, pull and hold any load then we need to be aware of the correct way to do it. We are only born with one back and we need to look after it. This course will inform you of the legislation surrounding any moving and handling operation, the correct techniques to employ, the process of ergonomics and risk assessing. You should always be safe when moving and handling any load so this course is essential for your health. Course Aims: Explain the theory behind moving and handling Be aware of safe practice using a range of techniques when moving a variety of inanimate loads Manual handling defines “any transporting or supporting of a load by hand or by bodily force This includes: Lifting, putting down, pushing, pulling, carrying or moving Use of mechanical aids, e.g. tr By the end of this module you will be able to: Explain the term manual handling and provide examples Know who to contact Techniques for lifting Techniques for pushing and pulling Carry out manual handling safely Legislation

Infection prevention and control is essential for all businesses, particularly where the working environment or work activities could put employees and those around them at risk of infection. This includes those working in healthcare, in close contact with people or animals, and those involved in the cleaning of human and animal waste. Infections can be easily spread, but by understanding the correct steps to take, the risk of their occurrence can be both prevented and controlled.

Falls prevention is a variety of actions to help reduce the number of accidental falls suffered by older people. Falls and fall-related injuries are among the most severe and common medical problems experienced by older adults. Training, supervision and tailored exercise programmes can reduce falls by as much as 54%.

You never know when fire, explosions or gas leaks are around the corner, but while you can’t control what happens tomorrow, you can control how ready you are to react, help and limit any damage – and that’s where fire marshal training comes in.

To be able to provide First Aid in the workplace, as identified by the workplace risk assessment, and to a standard recognised by the HSE. This course is designed for people who want to receive our most thorough first aid training.

Equality is everyone’s right and everyone’s responsibility’. This training promotes the requirements of the Equality and Diversity Act. This session will strengthen understanding of Equality & Diversity.