Microsoft Excel Projects

Microsoft Access Developer

We are currently looking for a freelancer to support us with a few modifications in our existing invoicing system (Winflector). Requirements: Minimum 1 year of experience Proficiency in: - Microsoft Access 2010 Development - Microsoft SQL Server - Working knowledge of Accounting Software

Excel comparison

need prices in the main comparison spreadsheet but the format and layout isn't always going to the the same but the headings will be the same all of the information from the supplier tabs need to pull correctly into the comparison spreadsheet tab with the correct formats

On-Site IT Technician Needed Microsoft 365 / Outlook / Wilmslow

Looking for an experienced IT technician based in or near Wilmslow, Cheshire (SK9) to assist one of our clients on behalf of a small IT consultancy. The work involves: Reviewing and tidying up Microsoft 365 / Outlook setup across laptop, iPhone, and iPad Checking and resolving calendar sync issues (duplicate or uneditable recurring meetings) Verifying DNS and mail flow from 123 Reg to Microsoft 365 Migrating older Exchange mailbox data into Microsoft 365 (if accessible) General on-site IT review and minor fixes (“gremlins”) while there This is a one-off on-site visit — ideally completed within the next week. Future collaboration may be available for reliable freelancers who deliver well. Requirements: Proven experience with Microsoft 365, Outlook, and 123 Reg mail/DNS setup Own transport to Wilmslow (SK9) Good communication and professionalism when representing a company Budget: £90-120 (potential for ongoing work if successful).

Excel financial model

We are seeking an experienced financial modeler to develop a comprehensive Excel financial model inspired by the structure demonstrated in the provided video link. The ideal candidate will possess a strong proficiency in Excel, a solid understanding of financial principles, and the ability to present complex data in a clear, user-friendly format. The model should encompass key financial statements, projections, and analytical tools that facilitate informed decision-making. Attention to detail and adherence to timelines are crucial. We look forward to reviewing your proposals and collaborating on this project. https://www.youtube.com/watch?v=pSz38L6dz1Y

Excel Dashboard

Project: Build a multi-tab Excel sales & marketing tracker with an automated monthly dashboard. What we need A clean, robust Excel file that pulls data from input tabs into a visual Dashboard (monthly selector) showing: Leads, trials booked, trials attended, new monthly subscribers One-off revenue total Conversion rates: Leads → Trials, Trials → Monthly ROI for Sales Employee & Facebook Ad Manager Break-even targets: trials/monthlies needed for each role to cover costs Average revenue per subscriber, Customer lifetime value (LTV) Churn/cancellations per month Cost per lead and cost per trial Lead-source breakdown (FB, referral, word-of-mouth, other) Total monthly revenue (subscriptions + one-offs + trials) Input tabs Sales KPIs (Daily): Date, Calls made, Contacts reached, Bookings (Trials/Monthly), Follow-ups, Notes, Lead Source. Trials (Weekly): Name, Trial date, Trial type (Lego/Engineering/3D Printing), Attended Y/N, Converted Y/N, Conversion date, Non-conversion reason, Notes. Subscriptions (Weekly): Start date, Subscription type, Active (Yes = Green), Cancellation date, Cancellation reason. One-Offs: Date, Name, Product, Paid Y/N, Amount, Notes. Facebook Leads: Date, Leads, Ad Spend, Notes. Built-in pricing & costs (for automation) Sales Employee: £60/week (4 days/week, 4 hours/day). FB Ad Manager: £350/month. Trial prices: £12.99 / £14.99 / £15.99. Monthly prices: £45 / £59 / £64.99. Automations Monthly KPIs via formulas (SUMIFS/COUNTIFS), funnel & trend charts, ROI and break-even (trials/monthlies needed), CPL/CPT, churn, ARPU/LTV, and lead-source split. Data validation (Yes/No, dropdowns), protected formulas, and a tidy, print-friendly layout. Deliver a ready-to-use template with clear instructions.

opportunity

Excel recording& store from live desktop excel sheet. php python

I have live data feeding into an excel sheet, various cols of data etc. I need the data extracting at timed points, ie 30 mins , 10 mins, 5 mins 2 mins etc for chosen cols. The recording of the data needs to stop at a given stop time, the start time of the event. The saved data can be copied/ transferred to a new excel sheet or database ie ACCESS, which i currently use. An excel sheet would be easier to use, but would require the data to be copied to new rows in each sheet, after the last recorded dump. The rows of data to be copied in each new row to the copied master sheet will never exceed 50 for each new data dump, ie the max number of runners per race, so that should make that easy to program. That recorded data then needs to be referenced within another excel sheet for calculation, but that is straightforward using vlookup etc in excel. I believe it to be straightforward, but it needs coding. 15 races would be the maximum no of races that are to be concurrently recorded for data grabbing within each hour. I understand that it can be done in Python / php, with database if required but there may be better ways for capturing the data at timed points. Let me know what you think. I attach a sample sheet of the current live data, with cols to be extracted for reference, highlighted in yellow, at timed points, cols AF:AI, before the start of each race, let me know and thanks v much in advance,

Statutory Accounts & budget templates for a CIC in excel

I need an excel advanced user to create statutory accounts and budget templates for a UK Community Interest Company (CIC) format. A layout will be provided with a trial balance in excel to create the templates. I need your best price and delivery time frame for project. Thee workbooks will require use of advance formulae, Macro's, pivot tables and graphs.

opportunity

Excel Dashboard Developer – Performance Tracker

Project Overview: I’m looking for an experienced Excel specialist to build an automated performance dashboard for my estate agency group. We have six Sales offices and six Lettings offices, and I want to track daily performance metrics from two data sources: 1. Call logs (exported from our phone system) 2. Reapit CRM reports (valuations, viewings, instructions, offers, sales agreed, exchanges, etc.) The aim is to have one Excel workbook that I can easily update each day by pasting in new data or refreshing Power Query connections. The dashboard should automatically show: • Individual Negotiator activity (calls, talk time, performance vs target) • Office-level summaries for each of the 12 branches • Department-level views (combined Sales and Lettings totals) • A simple front page with clear charts, slicers (Office / Negotiator / Date), and key KPIs. ⸻ What I Need: • Build an Excel-based dashboard with dynamic visuals and KPIs • Automate data refresh (via Power Query or macros) • Create clean dashboards for: • Individual negotiators • Each office (6 Sales, 6 Lettings) • Department summaries (Sales & Lettings) • Use a clean blue and white theme with easy navigation • Include a short guide or Loom video showing how to update the data daily ⸻ Skills Required: • Advanced Excel (Power Query, PivotTables, Dashboard Design) • Strong visual layout and performance reporting experience • Familiar with CRM or sales data structures (Reapit experience a plus) • VBA experience (nice to have but not essential)

Google & Microsoft Ads Specialist (Freelance / White Label)

I’m looking for a reliable and experienced freelancer to help manage Google and Microsoft Ads accounts under my brand. The work won’t always be consistent. Sometimes it’ll be on short notice or just me asking you to take on specific bits of work or look into things for me. You need to be comfortable working independently and getting stuck in without a lot of hand holding. What I’m after: - At least 5 years of hands-on experience running PPC campaigns - A portfolio or case studies that show real results - Strong skills in conversion tracking and optimisation - Confident using scripts, rules and automations - Fast communicator with a solid grasp of written and spoken English - Reliable and easy to work with Bonus if you have: - Experience with more advanced account setups and scaling strategies - Knowledge of tracking setups beyond basic conversions When you apply, please include: - A short intro about you - Examples of your past work or case studies - How you’d approach managing my clients’ accounts - Your rates and availability

Migrate Excel Schedule to MS Project

Delivery needed in 2 hours. It is a simple migration. I have a fully-built project plan sitting in Excel, complete with start dates, durations, and every task-to-task dependency already mapped out. What I need now is that same plan reconstructed in Microsoft Project so I can use the software’s Gantt views, critical-path calculations, and built-in reporting for day-to-day project scheduling. Because all predecessors and successors are already spelled out, the job is largely a matter of importing the data accurately, matching each Excel column to the correct MS Project field, and confirming that the resulting network logic mirrors what is in the spreadsheet. I am aiming for a highly detailed file with every task linked, so the finish-to-start, start-to-start, or other relationship types must transfer flawlessly.

opportunity

KPI Reporting & Dashboard System

We’re a UK-based courier and logistics company looking to improve how we track and report on business performance. At the moment, we export our operational data in CSV format, but our reporting is largely manual and spread across multiple spreadsheets. We’d like to create a simple, professional KPI reporting system that brings everything together in one place — giving us accurate monthly reports and a clear, visual dashboard. What We’re Looking For We need a reporting setup (ideally in Microsoft Excel, but open to Power BI if preferred) that can: - Import and process CSV data each month. - Calculate and display key KPIs across revenue, operations, and client performance. - Generate a printable monthly KPI report suitable for board meetings. - Include a dashboard view showing headline KPIs and trends at a glance. - Be easy to update and refresh each month without specialist skills. - Be designed with clarity, consistency, and presentation quality in mind. Deliverables: - A working Excel (or Power BI) file that: - Loads CSV data automatically or with minimal setup. - Calculates key performance metrics. - Includes a printable monthly report tab. - Includes a visual dashboard tab. - A short written or video guide explaining how to refresh and update the report. *place holder price, potential for ongoing reporting work as the business evolves.

UVDesk Helpdesk Setup & Customization

I need UVDesk installed, configured, and ready for daily use on my server integrated with emails (Microsoft Office 365) so incoming messages automatically generate tickets. You’re free to recommend the cleanest way to host UVDesk (Docker and or direct or LAMP stack, etc.) as long as the final result is secure, documented, and simple for me to maintain. As the hsoted server is on prem and credentials cannot be shared so whole process will be done with a shared screen.

opportunity

Excel Dashboard

We are seeking a skilled Excel specialist to develop a comprehensive multi-tab spreadsheet designed to track our sales and marketing performance. This automated dashboard will consolidate data from various sources, including sales, trials, subscriptions, one-off payments, and advertising metrics. Key features will include a visually appealing monthly overview, daily input areas for KPIs, and detailed insights into lead sources, ROI, and customer lifetime value. The final deliverable will encompass an Excel workbook with dynamic charts, pre-set formulas, and an instructional guide for updates and maintenance.

opportunity

Microsoft Bot Service Developer & Zoom

Looking for an experienced developer of Teams and Zoom SDK for build meeting bots. In your application please point me to an app in the marketplace you built.

opportunity

Integrate a web based Avatar into Microsoft Teams

We are looking for a prototype in Node.JS that will bring a web based avatar into a Teams meeting as a participant and the audio and video to be streamed between.

Power Automate Expert Needed for Workflow Automation (via Teams)

We are looking for an experienced Microsoft Power Automate freelancer to help design and configure a workflow for our payroll process. The automation will involve: Detecting new payroll files in a SharePoint folder. Applying metadata tags based on file names (e.g., site, month, year). Routing files: One file to a Microsoft Teams channel. Another file to a SharePoint HR folder, dynamically based on metadata. Key Requirements: Proven experience with Power Automate and SharePoint integrations. Ability to parse file names and apply metadata dynamically. Familiarity with Teams integration for file posting. Strong understanding of conditional logic and dynamic folder paths. Important Notes: No direct access to our SharePoint site will be provided for security reasons. You will join a Teams call with me to walk through the automation steps and guide me in building the flow. Clear communication and the ability to explain technical steps are essential. Deliverables: A fully documented workflow design. Step-by-step guidance during the Teams session. Best practices for metadata schema and error handling. Budget & Timeline: Please provide your hourly rate and estimated time for completion. Skills Required: Microsoft Power Automate SharePoint Online Microsoft Teams Workflow Automation

I need somebody for administration tasks for a travel agency

We are seeking a highly organized and detail-oriented individual to assist with administrative tasks for our travel agency. The ideal candidate will manage scheduling, coordinate bookings, maintain client databases, and handle correspondence efficiently. Proficiency in travel management software and a strong understanding of the travel industry are essential. Excellent communication skills and the ability to multitask in a fast-paced environment are required. This is an excellent opportunity for someone passionate about travel and eager to contribute to our dynamic team.

urgent

I need someone who is excellent with photo shop and creativity

I am seeking a highly skilled and creative Photoshop expert to transform and edit photographs, ensuring they bear little resemblance to the originals. The ideal candidate should possess exceptional proficiency in photo manipulation techniques and a keen artistic vision. Your role will involve seamlessly blending elements, altering backgrounds, and enhancing images to create strikingly unique visuals. If you have a portfolio showcasing your innovative work and a passion for pushing creative boundaries, I invite you to submit your proposal for this exciting project.

Data arrangement in excel sheet

We are seeking a proficient freelancer to assist with the meticulous organization of data within an Excel spreadsheet. The project entails structuring, categorizing, and formatting large datasets to enhance readability and usability. Ideal candidates should possess advanced knowledge of Excel functions, including sorting, filtering, and utilizing formulas. Attention to detail and the ability to adhere to specific guidelines are paramount. If you are adept at transforming chaotic data into coherent, well-organized spreadsheets, we welcome your proposals. Your expertise will be instrumental in optimizing our data management process.

Translate English to Flemish

We are conducting an online survey and need someone to translate to Flemish for a Belgium market. The document will be in Excel and we need someone to read the the column in English and add a new translated column in Flemish. It will be approximately 3000 words but until we receive the document we won’t know the exact number of words.