Share Projects

opportunity

Excel automate, Power Query, data mapping, dashboard development

I am looking for an experienced Excel and Power Query specialist to complete a multi-level governance and assurance system for a health and social care organisation. The organisation has five service divisions. The workbooks, registers and overall structure have already been designed; I am not looking for someone to start again. I need someone who can review the existing files, improve the formulas and functionality, make the registers smarter and create reliable connections across the system. The required reporting flow is: Service/Practice Observation → Regional Governance → Divisional Governance → Group Governance/Master Dashboard Each division requires its own governance workbook and dashboard. Service and regional information must feed into the relevant divisional workbook, with key information from all five divisions feeding into one Group-level Master Dashboard. Smart governance registers The project includes a suite of existing registers covering areas such as: Risk Safeguarding Incidents and serious incidents Complaints and compliments GDPR and data breaches Restrictive practice Governance actions Service user feedback Audits and improvement Regulatory actions Training and workforce compliance The exact number of files will be confirmed with the successful freelancer following an initial review. The registers need to become functional, consistent and easy to use, rather than simply formatted spreadsheets. Depending on the register, this may include: Unique reference numbers Automated status calculations Open, closed and overdue indicators Due-date and review alerts Automated risk ratings and RAG indicators Dropdown lists and controlled data entry Conditional formatting Automated totals and summary metrics Monthly, quarterly and annual reporting Filtering by service, region, division, category, status and reporting period Identification of themes, recurring issues and required escalations Formula protection without restricting data entry Summary pages or dashboards Connections to the appropriate regional, divisional and Group dashboards The registers will remain the source of truth for individual records. Only relevant totals, themes, trends, risk ratings and outstanding actions should feed into higher-level dashboards. Main requirements The successful freelancer will be required to: Review and inventory the existing workbooks and registers Produce a clear data map showing how information should move through the system Make the registers smarter, more automated and easier to maintain Add, correct and protect formulas across multiple files and tabs Standardise dropdowns, identifiers, categories and reporting periods where required Create calculated metrics, alerts and RAG indicators Link Practice Observation data to Regional Governance workbooks Link Regional Governance workbooks to the relevant Divisional Governance workbook Complete dashboards for each of the five divisions Link all five Divisional Governance workbooks to the Group Master Dashboard Link relevant register data to the correct reporting level Use Power Query or another reliable Excel-based method where appropriate Ensure files work reliably within Microsoft 365/SharePoint Reduce the risk of broken links when files are moved, updated or refreshed Test the complete data flow from source registers through to the Master Dashboard Ensure the system is straightforward for managers with varying levels of Excel experience Deliverables Smart, functioning governance registers Functional Practice Observation templates Regional Governance and Assurance workbooks Five Divisional Governance workbooks and dashboards One Group Governance workbook and Master Dashboard Reliable connections between all relevant files Working formulas, validation, dropdowns, alerts and RAG ratings A complete data map/data dictionary Testing of the full reporting flow Simple refresh and maintenance instructions Final handover and correction of any errors identified during testing Confidentiality The work relates to confidential organisational systems. A Non-Disclosure Agreement must be signed before any files are shared. Anonymised or test data will be used wherever possible. Please include in your proposal: Your experience of creating smart Excel registers and trackers Your experience of linking Excel files stored within SharePoint/Microsoft 365 Your Power Query experience How you would minimise broken connections How you would approach mapping and testing this system Examples of comparable work What you can deliver within the approximate £1,000 budget

WordPress developer needed to build custom theme for publisher

WordPress developer needed for custom theme rebuild of I Love Manchester We’re looking for an experienced WordPress developer to help rebuild the I Love Manchester website as a custom WordPress theme. I Love Manchester is an independent news, events, culture and city guide platform for Greater Manchester. The live site has years of content, SEO value, advertising placements, membership functionality and a WooCommerce shop. We are not looking for a basic brochure website, a page builder rebuild, or a custom directory/events system built from scratch. We already have a full design pack covering the design system, header, footer, homepage, single post layout and key page layouts, including Directory/place listings and What’s On/events. We need those designs developed into a fast, stable, SEO-friendly WordPress site. Preferred approach Custom WordPress theme ACF Pro / ACF flexible fields / ACF blocks Native WordPress editor for editorial publishing Reusable blocks/templates for landing pages GeoDirectory for places, venues and business listings GeoDirectory Events for events and What’s On WooCommerce for shop MemberPress for membership/subscriptions Yoast SEO for SEO Advanced Ads for advertising placements Cloudflare and Imagify retained Important We want to use reputable, long-standing plugins with good support. GeoDirectory and GeoDirectory Events should be used as the core directory/events system. We do not want this built bespoke from scratch. The developer’s role is to configure, theme and integrate the chosen plugins properly, so places, events, guides and articles work together cleanly. For example: Place pages should show related articles and upcoming events. Event pages should link clearly to the relevant venue/place page. Things to do pages should pull from GeoDirectory Events. Directory/place pages should match the supplied I Love Manchester design system, not look like generic plugin output. News articles should remain standard WordPress posts, with the ability to embed place and event listings where needed. Current setup The live site is ilovemanchester.com. We already have a cloned/staging site on the server and will share access with the chosen developer. The database has recently been cleaned. Main areas of the website News stories and editorial posts Things to do and event listings Directory of places, venues and businesses Membership and member-only content About us, Marketing and Advertising, Out-of-Home, Charity, Awards and other landing pages WooCommerce shop The work may include Reviewing the current staging setup Building a custom WordPress theme from the supplied designs Setting up global styles, typography, colours and reusable components Building templates for posts, categories, tags, authors and search results Building landing page templates and reusable ACF blocks Setting up ACF fields/flexible content where needed Installing/configuring GeoDirectory and GeoDirectory Events Styling GeoDirectory templates to match the design pack Making sure places, events and articles link together sensibly Making sure MemberPress, WooCommerce, Yoast SEO, Advanced Ads, Cloudflare and Imagify continue to work properly Protecting existing URL structure and SEO value Keeping the site fast and lightweight Checking mobile/responsive design Preparing a safe staging-to-live launch plan Providing handover notes for our team Experience needed Strong custom WordPress theme development ACF Pro, flexible fields or ACF blocks Content-heavy publisher, magazine, local guide or directory websites GeoDirectory or similar directory/event plugins SEO, redirects and URL preservation WooCommerce MemberPress or other membership plugins Advanced Ads or ad placement logic would be useful Strong responsive front-end skills Performance-conscious approach Comfortable working on staging without affecting live site Please include Examples of similar custom WordPress sites Examples of ACF/custom theme work GeoDirectory/GeoDirectory Events experience MemberPress, WooCommerce, Yoast SEO and Advanced Ads experience How you would approach the build Any risks you can see Suggested first phase Availability Day rate or fixed-price estimate We may start with a smaller paid phase before committing to the full rebuild. This could include reviewing the staging site and design pack, confirming the architecture, setting up GeoDirectory/GeoDirectory Events, and building one article template, one archive template, one landing page template, one reusable ACF block, one place template and one event template. Please do not send a generic proposal. We need someone who understands the difference between a good-looking WordPress site and a proper publishing platform.

Webflow Designer for a Small Website Completion Project

Webflow Designer/ Talented Student for a Small Website Completion Project — $500–$1,000 Fixed Budget Job Ad We are looking for a freelance Webflow Designer talented student to help finish a website that has already been started. This is a straightforward website project. It is not overly complicated, and we are open to working with a talented student designer, newer freelancer, or experienced Webflow designer who is organized, reliable, and able to meet deadlines. The website URL will be shared with shortlisted candidates during the interview process. Project Scope Approximately 10 pages need to be completed or cleaned up. Some pages may need light design improvements, while a few pages may need to be designed more fully using the existing website direction. The main need is for the designer to create a clean, reusable Webflow template page that our admin can use to upload content going forward. The designer will not be responsible for uploading all future content. Our admin will handle content upload, but the designer must create a clear training video showing the admin exactly how to do it. Pages may include: • Service page improvements • Blog page setup or cleanup • Template page creation • Light edits to existing pages • Additional items listed in our project tracker There is a job tracker showing what is remaining for this position. The selected designer will be expected to work from that tracker and keep the project organized. Main Responsibilities 1. Finish approximately 10 Webflow pages 2. Create a reusable page/template structure 3. Make light design improvements where needed 4. Set up or clean up blog-related pages as listed in the tracker 5. Make sure pages are clean, responsive, and easy to manage 6. Prepare the website so our admin can upload content 7. Record a detailed and easy-to-understand training video for the admin 8. Follow the project tracker and communicate progress clearly 9. Meet hard deadlines Training Requirement The designer must create a training video for our admin. The video should clearly explain how to upload and edit content in Webflow. Training may vary depending on the final setup, but it should be simple enough for a non-designer/admin user to follow. The training video should cover things such as: • How to add or update page content • How to use the template page • How to update blog content if needed • How to avoid breaking the page layout Any important Webflow steps the admin needs to know Deadline The project must be fully completed by August 15. This deadline is firm. Please do not apply unless you can complete the work on time and communicate clearly throughout the project. Budget Fixed project budget: $500–$1,000 We are looking for someone who can work efficiently and keep the project moving. This is a good fit for a student designer or freelancer who wants a clear project, a portfolio piece, and possible ongoing work. Future Work There will be continuing work for the right candidate. After this project, we expect to keep expanding the website with new pages, improved design, blog support, and search visibility improvements. If you do a great job, this can turn into ongoing freelance work. Who Should Apply This is a good fit for someone who: • Knows Webflow well • Can design clean, professional pages • Can work from an existing website direction • Can create reusable templates • Can explain things clearly in a training video • Can meet deadlines without needing constant reminders • Is comfortable working with a job tracker • Has good attention to detail • Is friendly, reliable, and organized • Student designers are welcome to apply. Who Should Not Apply Please do not apply if you are an agency. We are looking for an individual freelancer or student designer only. Please also do not apply if you cannot meet the August 15 deadline. To Apply Please include: 1. A few examples of Webflow websites or pages you have built 2. A brief note about your Webflow experience 3. Whether you are available to complete the project by August 15 4. Your fixed-price estimate within the $500–$1,000 range 5. Confirmation that you can create a clear training video for our admin Start your application with this phrase: I can meet deadlines Applications that do not include that phrase may not be reviewed. We are looking for someone who is easy to work with, detail-oriented, and serious about finishing the project correctly.

Part-Time Freelance Spanish Speaking Sales Professional

We have an exciting part-time opportunity for an experienced native Spanish speaking freelance sales professional to join our B2B business development agency. The role will require flexible working on a retainer of 10 hours per month. Initially, the workload is expected to be approximately 15 minutes per day, Monday to Friday, however this may increase as the project develops and call volumes grow. The successful candidate will need to be available to work evenings in Spain where required, to accommodate clients and prospects across South America. This is an on-going project and there is the potential for more hours depending on client projects. We are a UK-based business development agency with global clients. We support our clients' marketing departments by helping them improve the quality of the leads they generate for sales. We qualify existing leads to identify genuine sales opportunities and support business development through prospecting and outreach activities. We are specifically looking for a native or fluent Spanish speaker, ideally based in Spain, who can confidently engage with prospects across both Spain and South America, with a particular focus on South American markets. Our clients operate across a variety of industries, making the work diverse and interesting, but requiring the ability to manage multiple projects and adapt quickly to different business sectors. We all work remotely and offer flexibility around working patterns. We offer a supportive working environment, but we also have high expectations. We pride ourselves on delivering exceptional service and results to our clients and look for team members who share that commitment. If you have a background in sales and are looking for something a little different, we'd love to hear from you. Job Duties: Using VoIP software for telephone calls and creating and sending email introductions to prospects: Secure high-quality sales opportunities on behalf of our clients. Conduct outbound calls with prospects across Spain and South America. Develop and maintain professional relationships with client prospects. Represent our clients professionally and deliver an exceptional prospect experience. Proactively contribute ideas and feedback to improve prospecting processes and campaign performance. Report on activity and outcomes. Attend Microsoft Teams meetings with clients as required. Experience and Essential Skills Required Native Spanish speaker with excellent spoken and written Spanish. Minimum 3 years' experience in a sales or business development role. Proven confidence and success in cold calling and outbound prospecting. Demonstrable track record of achieving results within a B2B sales environment. Excellent written and verbal communication skills. Professional, friendly and client-focused approach. Strong relationship-building skills and ability to act as an extension of the client's team. Positive and professional telephone manner. Understanding of effective sales techniques and lead qualification processes. Strong administrative and organisational skills. Essential experience using HubSpot CRM. Comfortable learning new systems and technology. Ability to work independently and manage a flexible workload.

opportunity

Meta & Google Retargeting Specialist Needed

Meta & Google Retargeting Specialist Needed – Complete Remarketing System Setup We are looking for an experienced Meta and Google tracking specialist to build a complete retargeting and remarketing system for our business. Our primary objective is to re-engage people who have already visited our website, reminding them about our treatments and encouraging them to book a consultation or treatment. This is not simply a Meta Pixel installation. We are looking for someone with strong technical knowledge of tracking, attribution and remarketing who can build the complete system and advise us on best practice. Website We operate a specialist aesthetics and skin treatment clinic offering scar camouflage, stretch mark camouflage, vitiligo camouflage, skin rejuvenation, training courses and consultations. Project Objectives We want visitors to our website to see relevant adverts on Facebook, Instagram and, where appropriate, across Google's Display Network after leaving our website. We would like to build multiple retargeting audiences based on the pages visitors have viewed and the actions they have taken. We also want accurate conversion tracking so we can understand which marketing activities are generating enquiries and bookings. Scope of Work Meta Install and configure Meta Pixel Configure Meta Conversions API (CAPI) Verify our domain Configure Aggregated Event Measurement Test all Meta events Google Install and configure Google Tag Manager Install Google Analytics 4 Configure Google Ads Remarketing Link GA4 with Google Ads where appropriate Conversion Tracking Track all relevant website activity including: Page views Individual treatment pages Training course pages Consultation enquiries Contact forms Telephone clicks Email clicks WhatsApp clicks (if applicable) Booking requests Purchases or deposits (if applicable) Please advise if there are additional conversion events you would recommend. Retargeting Audiences We would like audiences created for: All website visitors Visitors within the last 7, 30 and 180 days Visitors to individual treatment pages Visitors who viewed multiple pages Visitors who reached our contact page but did not enquire Visitors who submitted enquiries Existing customers (for exclusion where appropriate) Please advise on any additional audience strategies that would improve campaign performance. Campaign Strategy As part of this project, we would like your recommendations on: The most effective retargeting strategy for a treatment-based business Recommended campaign structure Audience segmentation Budget recommendations Frequency recommendations Exclusion audiences Lookalike audiences (if appropriate) Creative Advice Please advise us what marketing assets you require in order to build high-performing remarketing campaigns, for example: Image sizes Video specifications Before and after images Testimonials Brand graphics Copy requirements Call-to-action recommendations If there are additional assets that would improve campaign performance, please advise. Reporting & Training We do not simply want the system installed—we want to understand how it works. Before completion, please provide: A walkthrough showing how to view website visitors How to see audience sizes How to monitor conversions How to check whether events are firing correctly How to measure the success of our remarketing campaigns How to interpret the key metrics Basic guidance on maintaining the system A recorded video or live walkthrough is acceptable. Ownership All tracking assets must be created within our own accounts. We must remain the owner of: Meta Business Manager Meta Pixel Meta Conversions API Google Analytics 4 Google Tag Manager Google Ads Any audiences or tracking assets created Please do not create assets under your own account and share access. Everything must remain fully owned by our business. GDPR Please ensure all tracking is configured in accordance with UK GDPR and integrates correctly with our cookie consent platform. Deliverables By the end of the project we expect: Fully functioning Meta Pixel Fully functioning Meta Conversions API Google Tag Manager configured Google Analytics 4 configured Google Ads Remarketing configured All conversion events tested Remarketing audiences created Basic reporting dashboard Guidance on campaign performance Advice on creative assets required Documentation or walkthrough explaining how to use the system Please Include When applying, please provide: Examples of similar retargeting projects Your experience with Meta Pixel, Conversions API, GA4 and Google Tag Manager Your experience with remarketing for service-based businesses Your estimated completion time Your fixed project price We are looking for a technical specialist with genuine experience in attribution, tracking and remarketing rather than someone who simply manages Facebook adverts.

IT support Analyst M365/Google Workspace

Job Title: IT Support Specialist (Managed Services) Employment Type: Managed Service Location: Remote The analyst have to be available Monday-Friday 07:00–19:00 BST. About the Role We are seeking a customer-focused IT Support Specialist to deliver remote managed IT support services across Google Workspace and Microsoft 365 environments. This role is responsible for providing end-user support during extended business hours, managing identity and access requests, administering collaboration platforms, supporting mobile device management (MDM), and ensuring a consistent, high-quality user experience. The successful candidate will work within a managed services framework, adhering to agreed service level agreements (SLAs), maintaining accurate documentation, and proactively identifying opportunities for service improvement. Working Hours Provide remote support coverage during extended business hours. Participate in scheduled shift rotations to ensure continuous service availability. Support priority incidents and service requests in accordance with defined SLAs and escalation procedures. Provide occasional out-of-hours support for critical business incidents, as required. Key Responsibilities End-User Support Deliver Level 1 and Level 2 remote technical support for end users. Log, categorize, prioritize, and resolve incidents and service requests through the IT service management platform. Provide timely communication and status updates to users and stakeholders. Troubleshoot issues related to operating systems, productivity applications, collaboration tools, and endpoint devices. Escalate complex issues to specialized support teams when necessary. Identity and Access Management Manage user identities and access across Google Workspace and Microsoft 365. Execute Joiner, Mover, and Leaver (JML) processes, including: User account provisioning and deprovisioning Role and permission changes License allocation and recovery Group membership administration Support password resets, multi-factor authentication (MFA), and account recovery processes. Ensure compliance with security and access governance policies. Collaboration Platform Administration Administer and support Google Workspace and Microsoft 365 services, including: Gmail and Microsoft Outlook Google Drive and OneDrive Google Meet and Microsoft Teams Shared mailboxes and distribution lists SharePoint Online and Shared Drives Configure, maintain, and troubleshoot: Email forwarding Mail flow issues Inbox and transport rules Shared mailbox access Calendar permissions and delegation Mobile Device Management (MDM) Administer and support MDM solutions for corporate devices. Enroll, configure, and maintain Android, iOS, Windows, and macOS devices. Apply security policies, compliance settings, and conditional access controls. Troubleshoot device enrollment, synchronization, and application deployment issues. Perform remote device actions, including lock, wipe, and compliance remediation. Service Management Meet or exceed contractual SLAs and key performance indicators (KPIs). Maintain accurate ticket documentation, asset records, and support procedures. Develop and update knowledge base articles and standard operating procedures. Identify recurring issues and recommend service improvements. Collaborate with customer stakeholders and internal teams to ensure service excellence. Required Skills and Experience Minimum 3 years of experience in an IT support, service desk, or managed services environment. Hands-on administration experience with Google Workspace and Microsoft 365. Experience managing Joiner, Mover, and Leaver processes. Strong understanding of identity and access management principles. Experience troubleshooting email systems, forwarding rules, and mailbox configurations. Practical experience with MDM platforms such as Microsoft Intune, Google Endpoint Management, Jamf, or equivalent solutions. Familiarity with ITSM platforms such as ServiceNow, Jira Service Management, Zendesk, or Freshservice. Strong knowledge of Windows, macOS, Android, and iOS environments. Understanding of ITIL service management principles. Excellent verbal and written communication skills in English. Preferred Qualifications Microsoft 365 Certified: Endpoint Administrator Associate Google Workspace Administrator Certification ITIL Foundation Certification Experience supporting hybrid cloud environments Key Competencies Strong customer service orientation Excellent troubleshooting and analytical skills Ability to work independently in a remote environment Strong organizational and time management skills Attention to detail Ability to manage multiple priorities effectively Commitment to continuous improvement and service excellence

Create automated planning application spreadsheet

I am looking for someone to create an automated spreadsheet/report that pulls the previous week’s UK planning applications from the UK PlanIt data/API. The purpose of the report is to help identify potential trade opportunities for builders, loft conversion companies, kitchen/renovation firms, roofers and other home improvement trades. I need the spreadsheet to be refreshable each week, so I can update it with the latest planning applications and then export or share the data with ChatGPT for analysis. What I need is a spreadsheet system, ideally in Google Sheets or Excel, that can: 1. Pull planning application data from UK PlanIt. 2. Refresh the report weekly to show the previous 7 days of applications. 3. Cover all UK counties / planning areas, not just one local authority. 4. Handle multiple planning authorities within each county where needed. 5. Pull clean, structured data into a spreadsheet. 6. Allow me to filter by county, planning authority, date, application type and likely trade opportunity. 7. Create summary tabs that make the data easy to review. 8. Be simple enough for a non-technical user to refresh each week. **Important functionality required:** The spreadsheet should include: * A refresh button or clear refresh process. * A date range selector, ideally defaulting to the last 7 days. * County / area filtering. * Planning authority filtering. * Keyword filtering for relevant trade opportunities. * Automatic categorisation where possible, for example: * Extensions * Loft conversions * Garage conversions * Renovations/refurbishments * Kitchens * Roofing * Outbuildings * Commercial fit-outs * Other building works * A clean export tab that can be copied into ChatGPT for analysis. * Basic error handling if the API limit is reached or if a request fails. * A simple instruction tab explaining how I refresh and use the report. **Suggested spreadsheet tabs:** 1. **Instructions** Simple user guide explaining how to refresh the data and use the spreadsheet. 2. **Settings / Control Panel** Date range, counties/areas to include, keywords, refresh controls and any API settings. 3. **Raw Planning Applications** The unedited data pulled from PlanIt. 4. **Cleaned Applications** Clean version of the data with standardised columns. 5. **Trade Categorisation** Applications categorised by likely trade relevance. 6. **County Summary** Number of opportunities by county and trade type. 7. **Planning Authority Summary** Number of opportunities by local authority. 8. **ChatGPT Export** A clean tab designed specifically so I can copy/export the data and ask ChatGPT to analyse it. **Required data fields:** Where available from PlanIt, I would like the spreadsheet to include: * Application name/reference * Planning authority * County / area * Application start date * Address * Description * Application type * Development type * Status * Decision, if available * Applicant / agent details, if available * Link to planning application * Latitude / longitude, if available * Last scraped / last changed date * Suggested trade category * Opportunity score, if possible **Trade opportunity scoring:** Ideally, I would like a simple scoring system to highlight the best opportunities. For example: * High relevance: extension, loft conversion, conversion, major renovation * Medium relevance: alterations, outbuildings, roof works, garage conversion * Low relevance: tree works, signage, minor admin applications, discharge of conditions I am happy for the freelancer to suggest the best scoring approach. **Technical requirements:** The freelancer should be comfortable working with: * APIs * Google Sheets Apps Script and/or Excel Power Query * CSV/JSON data imports * Pagination * Rate limits * Data cleaning * Building refreshable dashboards/reports The PlanIt API has paging and request limits, so the system must be built responsibly and should not rely on one huge request. **End goal:** Each week I want to be able to refresh the spreadsheet, see the latest planning applications across all counties, identify the best trade opportunities, and then ask ChatGPT to analyse the data by county, trade type and opportunity quality. **Deliverables:** 1. A working Google Sheet or Excel workbook. 2. Automated or semi-automated weekly refresh process. 3. All required tabs and filters. 4. Clean data structure ready for ChatGPT analysis. 5. Simple instructions for use. 6. A short handover call or written walkthrough. 7. Notes on any limitations of the PlanIt API or recommended future improvements. **Please include in your response:** * Whether you recommend Google Sheets or Excel for this. * Examples of similar API/spreadsheet automation work. * How you would handle all counties and multiple planning authorities. * How you would manage API limits and pagination. * Estimated delivery time. * Fixed price quote.