Freelance Excel Jobs

opportunity

Help with Excel

Management accounts in Excel

Need someone with excellent Shopify Knowledge

Need someone with excellent Shopify Knowledge to migrate products and their variations from WooCommerce to Shopify?

Convert Excel to Microsoft Lists

We are a small business using MS Teams and I am trying to update how we do things so I can begin to automate processes for my admin team. Initially, I want to convert a couple of logs which we update in Excel into MS Lists so they are easier to use and we can add automation later - for example we when we send a client file this is logged in Excel in a list and given a sequential number to keep a log, I would like to move this to MS lists so users instead fill in a form and the sequential number is automatically calculated - Is this something you can help with please?

Excel Queue management of moulds

A manufacturing company requires an automated queue management system to efficiently allocate moulds for their production process. Currently, the company uses a basic spreadsheet to plan finished product orders by customer. However, there is no functionality to optimize mould utilization across jobs. The proposed project aims to develop a supplementary worksheet within the existing spreadsheet template. This new sheet should provide dynamic visualization of moulds currently in use, as well as a prioritized waiting list for upcoming productions. Mould assignments must be automatically updated in real-time as jobs are completed, to seamlessly transition resources to the next highest priority order. Key requirements for the queue include reversible allocation of moulds to open job slots based on priority rules. Statistical data on mould lifecycles and typical process durations can help estimate theoretical throughput. Conditional formatting should highlight moulds approaching replacement thresholds or impending bottlenecks. Well-designed interfaces will facilitate intuitive management of the schedule by production planners. By centralizing mould queue logic within their existing production planning framework, the company hopes to minimize disruptions from unpredictable tooling failures. Transparent scheduling aims to reduce overtime costs and expedite customer deliveries through optimized resource utilization across all manufacturing jobs.

opportunity

Convert PDF tables to useable Excel file/database

Take approximately 150 pages of a PDF file and convert to Excel phile and possibly a useable database. I know Excel can imports tables in PDF to excel. Need someone to organize it and add additional data columns for importing into another software based upon a given template.

BetAngel - Excel Spreadsheet Required

I require a spreadsheet that halts betting when a specified profit threshold is reached or ceases betting after, for instance, achieving five consecutive wins. All targets would need to be user defined figures.

EBay excel listing

I'm searching for a freelancer who can list the product in ebays

Global Export Sales Expansion Excel Spreadsheet

Hello there, pI am seeking an experienced Excel and data modelling expert to create a comprehensive global export sales template for our premium spirits brand. This project is crucial to our international expansion strategy and requires expertise in advanced Excel formulas, market-specific cost analysis, and a deep understanding of COGS (Cost of Goods Sold) and pricing structures across multiple territories. Key Deliverables: 1. Global Template Framework: • A functional and dynamic Excel template tailored for global export sales, including editable fields and automated calculations. • Consolidated summary tab providing a dynamic overview of all markets. 2. Market-Specific Tabs: • Include dedicated tabs for Australia, China (Hong Kong and Beijing), the US, and South America. • Market research data integrated into the model to calculate COGS, duties, shipping costs, and RRP (Recommended Retail Price) per SKU. 3. Product SKU Calculations: • Accurately calculate excise and duties for spirits with 40% ABV (applying Australian regulations as an example). • Incorporate formulas to reflect costs for London Dry Gin, Pink Gin, Barrel-Aged Gin, Botanical Rum, Aged Rum, and Vodka. 4. Automated Features: • Dynamic fields and formulas for profit margins and other key metrics. • Editable fields for local tax rates, shipping, and market-specific costs. Step-by-Step Guide: Global Expansion Pricing Spreadsheet 1. Structure of the Spreadsheet The spreadsheet includes: • Tabs for each market: Australia, China, US, South America. • A Global Summary Tab: Consolidated view of costs, margins, and profitability across markets. 2. Columns in Each Market Tab Each market tab includes the following columns: 1. SKU: Product name (e.g., London Dry Gin, Pink Gin, etc.). 2. Base COGS (GBP): Fixed production costs in GBP. 3. Shipping (Local Currency): Editable field for shipping costs in the market’s currency. 4. Freight (Local Currency): Editable field for freight costs in the market’s currency. 5. Duty (Local Currency, per bottle): Editable field for excise or duty costs, based on the market’s regulations. 6. Total COGS (GBP): • Formula: = [Base COGS] + ([Shipping] × Exchange Rate) + ([Freight] × Exchange Rate) + ([Duty] × Exchange Rate) 7. UK RRP (GBP): Fixed recommended retail price in GBP. 8. Adjusted RRP (Local Currency): Editable field for suggested RRP in the market. 9. Margin (%): • Formula: = ((Adjusted RRP - Total COGS) / Adjusted RRP) × 100 10. Profit (100 Cases GBP): • Formula: = (Adjusted RRP - Total COGS) × 100 11. Profit (1000 Cases GBP): • Formula: = (Adjusted RRP - Total COGS) × 1000 3. Market-Specific Adjustments 1. Australia: • Excise duty per bottle based on 40% ABV (current rate: AUD 28.52, converted to GBP). • Exchange rate: 1 AUD = 0.54 GBP. 2. China (Hong Kong & Beijing): • Unique excise and duty rates for each region, editable fields. • Exchange rate: 1 CNY = 0.11 GBP. 3. US: • Include local taxes and tariffs. • Exchange rate: 1 USD = 0.74 GBP. 4. South America: • Account for import tariffs and duties (e.g., Brazil-specific rates). • Exchange rate: 1 BRL = 0.18 GBP. 4. Global Summary Tab 1. Pulls data dynamically from all market tabs: • Total COGS by SKU. • Average margins across markets. • Consolidated profit projections for 100 and 1,000 cases. 2. Formulas reference each market tab using =SUM(Australia!Cell, China!Cell, US!Cell, SouthAmerica!Cell). 5. Editable Fields • Ensure all shipping, freight, and duty costs are editable for flexibility. • Adjust exchange rates dynamically for real-time updates. 6. Tools for Collaboration • Conditional Formatting: • Highlight margins below 30% in red for easy visibility. • Data Validation: • Add dropdown menus for currency selection or pre-set SKUs. Candidate Requirements: • Proven expertise in creating complex Excel templates. • Strong understanding of international trade costs and pricing strategies. • Ability to incorporate multiple data points into clear and concise spreadsheets. • Experience working in FMCG, particularly in spirits or beverages, is a plus. If you are passionate about crafting game-changing tools and have the expertise to deliver on this high-stakes project, I’d love to hear from you! Please include examples of similar work or projects when applying. Looking forward to your proposals!

A4 FLYER (AMENDABLE) AND SMALL EXCEL SPREADSHEET TIDY UP

I require the design of a professional looking A4 flyer that allows for easy editing of logos and details before saving as a PDF. The initial flyer design has already been created, however it needs refinement and formatting to allow for flexible updates. In addition, an Excel checklist needs organization and styling to appear polished. For the flyer component, the ideal file format would be a PowerPoint or Word document to permit adjustment of branding elements and specifics prior to finalizing the PDF version. Clean and customizable layouts are essential. Regarding the spreadsheet, the current checklist lacks a coherent structure and formatting. It necessitates rearrangement and standardization of cells, rows, columns as well as consistent styling like font, alignment, borders to advance its professional look and usability. Both projects involve creatively enhancing provided initial drafts to build out polished and user-friendly end products. The flyer requires a dynamic template while the spreadsheet needs thorough organizing and beautifying. Strong attention to detail and design-minded solutions will be important to effectively meet these dual presentation and organization objectives. Collaboration is welcomed to clarify any aspect of the brief. Concise, high quality work delivered within the agreed upon timeframe will be appreciated. Please provide relevant experience and examples of similar projects in your response if interested. I look forward to reviewing proposals from qualified designers.

Excel Formula/Sheet

We are a payroll bureau and clients submit their data to us in excel time-sheet format. We have done a quick video to explain what is needed in Excel to pull data through from 4 weekly sheets into a summary sheet to allow the data to be collated. I think it would also need a gross total column which isn't covered in the video. Could you confirm whether you could build a sheet to do this for us and what the timescales/costs would be? Link to video: https://www.loom.com/share/c64679e841864a5285a69c9fd4f5e2f4?sid=600bf3d9-aa3a-4837-b897-9de3eb5e61a4

opportunity

Excel Lead tracking Managment

Hello, I am looking for a Excel spreadsheet that will track incoming leads, allocate the lead to a sales person on a seperate google sheets/shares spreadsheet, for them to update with status of lead. All controlled by central spreadsheet 1 Sheet - Lead Entry, Name, Address, Tel, e-mail 2nd Sheet, central spreadsheet for all leads - Data from above with the date entered. Plus a drop down of sales person, when drop down activated, it is then auto entered to the spreadsheet of the sales person, Lead status, (which can be updated from Sales persons Spreadshet when lead is actioned and date updated and a 2 notes column (one for notes on main spreadsheet only, another for notes on Salespersons spreadsheet Sheet 3-12 - 9 Spreadsheets for the sales person with, Date of lead, Name, Phone and E-mail, all not editable on this spreadsheet. The lead status (selected from a drop down) and Notes Final sheet, a reporting sheet, Date Range selection Total leads, Lead per status, % of leads in the lead stats, lead per salesperson, etc Want to start straight away Thanks

Convert .wrd doc into dynamic excel form.

Convert attached word document (which is an assessment form) onto Excel ensuring the form can be completing more easily. Form presentation must be clear, modern and tidy and the form must follow the question order in the word document.

opportunity

Document Conversion & Design for CRM

I'm in need of a seasoned freelancer who can convert and design various types of documents that will smoothly integrate with our CRM system. This project primarily involves working with invoices and converting PDFs, Microsoft Word, and Excel files. You must be proficient in: - Document Layout: Ensuring all documents are well-structured and aesthetically pleasing. - Technical Skills: You should possess strong technical abilities to handle complex document conversion tasks. - Communication: Excellent communication skills are essential for understanding project requirements and providing updates. Experience with document conversion and design, as well as CRM system integration, will be highly beneficial.

opportunity

UK chartered accountant for easy non-VAT LLP accounts today

Hi, I need a UK accountant to prepare accounts for a LLP company without VAT. All bank is in excel. Very simple a few sales and then just contractors and travel expenses. Thanks for your offers!

Need a Simple Kids Clothing Ecommerce Store in LARAVAL

Reference Site: https://thelittlebunny.in/ Timeline: 7-8 Days Payment Gateway: Payu, Rajorpay Shipping Integration also I will reply only if you send me detailed proposal with estimate work effort points in excel

Analyze Excell Spreadsheet Dataset - Answer only 7 questions

You will look over the data set and answer all the questions I've attached. You can use chat GPT to verify your answers, but they must be accurate.

Custom excel spreadsheets linked to Sage 50 accounts package

Need someone that has experience compiling spreadsheets using queries and connections to Sage 50 accounts.

pre-funded

SEO Optimization

I am looking for a skilled professional to optimize my tutoring website, www.amenglishtutoring.co.uk, and help me reach more families seeking quality 11+ English tuition and creative writing support. AM English Tutoring is dedicated to providing exceptional one-to-one and group tuition, helping students excel in 11+ grammar school tests, Common Entrance exams, and beyond. With a reputation for excellence, we want to ensure that parents can easily discover our services online. What I need: Conduct an SEO audit of the website. Identify and target relevant keywords (e.g., "11+ English tutor," "creative writing classes"). Improve on-page and technical SEO, including meta descriptions, site structure, and page load speed. Develop a strategy for local SEO to attract parents in my target areas. Advise on and implement content improvements to boost visibility. I'm looking for someone with: Proven experience in SEO (with examples of previous results). Knowledge of educational or tutoring markets is a plus. Ability to communicate strategies and results clearly.

Book Designer

We are looking for a talented Book Designer to help us Revise a book for a course module on basics of electronics. The book should be visually appealing, easy to read, and suitable for both print and digital formats. The ideal candidate should have a strong background in graphic design, specifically in book layout and typography. They should also have knowledge of electronics terminology and concepts. Strong attention to detail, creativity, and excellent communication skills are essential for this role. This book is addressed for kids between 8 Years and above

Landing Page to be hosted - design has been created.

The design of the landing page has been created, some minor adjustment may be requiresd - see below what needs to be done: 1. Host landing page (I have hostinger account) and link this to domain name (I have domain name) 2. From the "Register your interest" we need to collect data from the people that have register their interest e.g. Parent name; Parent email; Child name; Child’s year group; Child’s school (optional) 4. I need to be able to collect the data in excel/xls form form.