Optimize Your Microsoft Excel Projects on Upwork

Hi,

I hope you’re well. I’m coordinating a high-priority development appraisal for a private client and need your expertise to ensure the financial analysis aligns with RICS standards. The project involves a 5,000m² Grade A office (BREEAM Excellent) on a brownfield site, with four key deliverables due by Friday, 5 April.

Scope of Work:

Order of Cost Estimate – Extract 3 BCIS datasets (30+ analyses each), calculate averages, SD, confidence intervals, and select the narrowest CI. Format in Excel with clear assumptions.

Whole Life Costing – Compare two designs (Traditional HVAC vs. Energy-efficient upgrades) over 50 years, modeling NPV and value-for-money risks.

Development Appraisal – Prepare a residual valuation with assumptions on rental rates, finance costs (5.5% discount rate), and professional fees, using market-backed inputs.

Executive Summary – Provide a 1,000-word recommendation on financial viability, sustainability trade-offs, and regional market risks.

What I’ll Provide:

Full brief with client data (land cost: £400k, GIA: 5,000m², etc.).

BCIS screenshots if needed.

Why This Is Time-Sensitive:
The client plans to finalize acquisition by mid-April, so your support is critical this week. Let me know your availability and fee—I can arrange a quick call. Please treat all data as confidential.

Thanks in advance!

Skills: Bluebeam Revu, PlanSwift, Material Take-Off, Autodesk AutoCAD, Construction Estimating, Civil Engineering, Quantity Surveying, Microsoft Excel, On-Screen Takeoff, Tekla Structures, CAD Conversion, Cost Estimate, Bill of Quantity, Construction, Estimator

I am looking for a skilled statistician to help me finalize my statistics project. The ideal candidate should have a strong background in statistical methods and be able to assist with data analysis, interpretation, and presentation of results. Your expertise will be crucial in ensuring the accuracy and clarity of the final report. If you are detail-oriented and can work efficiently under deadlines, I would love to hear from you.

Skills: Statistics, Microsoft Excel, Data Entry, Data Analysis

We are seeking a skilled professional to assist in extracting data to our Google Sheets dashboard and ensuring it updates live every hour. The ideal candidate will have experience with Google Sheets integrations and data automation tools. Your role will involve setting up the necessary connections and scripts to keep our data current and responsive. Attention to detail and problem-solving skills are essential for this project. If you are proficient in data management and automation, we would love to hear from you!

Skills: Google Sheets, Microsoft Excel, Data Entry, Google Docs

We are currently recording our transactions in Quickbooks and we need some expert opinion to systamise the process and accounting practices through Quickbooks online

Skills: Intuit QuickBooks, Bank Reconciliation, Account Reconciliation, Microsoft Excel, Financial Accounting, Bookkeeping, QuickBooks Online, Accounting Software, Light Bookkeeping, Amazon FBA, Accounts Receivable Management, Accounting Basics, Accounts Payable Management, Transaction Data Entry, Real Estate

I need a freelancer to help complete a Power Automate flow. The tasks include:
- Renaming duplicated files automatically.
- Pulling data from a Microsoft List and inserting it into an Excel spreadsheet.

Familiarity with Power Automate, Microsoft Lists, and Excel is essential. This could lead to ongoing projects if you demonstrate expertise in Microsoft tools and integrations.

Skills: Microsoft Power Automate, Microsoft Excel

We are looking for an experienced Forecasting & Inventory Manager to oversee and optimise our inventory operations for our e-commerce business, with a strong focus on Amazon FBA. The ideal candidate will have a deep understanding of demand forecasting, inventory planning, and supply chain management to ensure smooth operations, minimize stockouts, and maximize efficiency.



Key Responsibilities:

• Sales Monitoring & Forecasting: Analyze sales trends, historical data, and market trends to predict demand and optimize inventory levels.

• Stock Reordering & Management: Develop and execute efficient restocking strategies to maintain optimal stock levels while minimizing excess inventory.

• Amazon FBA Operations: Create and manage FBA shipping plans, ensuring timely replenishment and compliance with Amazon’s requirements.

• Stockout Prevention: Implement proactive strategies to prevent stockouts and lost sales opportunities.

• Supplier & Logistics Coordination: Build and maintain strong relationships with suppliers, 3PL providers, and freight forwarders to ensure timely reordering, deliveries and cost-effective shipping.

• Inventory Optimization: Monitor Amazon storage limits, IPI scores, and excess inventory to avoid penalties and optimize storage costs.

• Data Analysis & Reporting: Generate reports on inventory performance, landed costs, sales velocity, and replenishment cycles to improve decision-making.

• Process Improvement: Continuously refine inventory management workflows to improve efficiency and accuracy.



Qualifications & Requirements:

• Proven experience in inventory management and forecasting for Amazon FBA or similar platforms.

• Strong analytical skills with experience using tools like Excel, Google Sheets, or inventory management software (e.g., InventoryLab, Forecastly, SoStocked).

• Familiarity with Amazon’s inventory performance index (IPI), storage limits, and FBA replenishment strategies.

• Experience with 3PL logistics, freight forwarding, and international supply chains.

• Detail-oriented with strong problem-solving skills and the ability to work independently.

• Knowledge of SKU management, lead times, and demand planning.

• Excellent communication and negotiation skills for managing supplier relationships.



Preferred Skills:

• Experience with Amazon Seller Central to create shipping plans and monitor sales

• Familiarity with global supply chain challenges, customs clearance, and import/export regulations.

• Understanding of financial implications related to inventory management, including cash flow impact and carrying costs.



Why Join Us?

• Work with a growing e-commerce business that values your skills

• Opportunity to optimize and scale inventory operations with autonomy.

• Competitive salary with potential performance-based incentives.

Work remotely with freedom and flexibility with no fixed hours or timings

Apply now and please let us know what your favourite book or movie is when your reply!

If you have the experience and expertise in inventory forecasting and Amazon FBA operations, we’d love to hear from you!

Skills: Inventory Management, Order Management, Microsoft Excel, Logistics Management, Demand Planning

1)
Create an EXCEL VBA project that has macro/function/sub to create and destroy a VBA form with name and age fields and two button cancel and ok.
2)
the function above should be executed via a button created in the Add-Ins menu.
3) it should not reset the project when calling function #1 to create and destroy the form. Create two global variables and init them in worksheet open, make sure these variables do not get reset to empty once we destroy and create the form again.

Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming

Login to a supplier site and collect data, or we will provide you a competitor site that you can collect pricing. You will maintain and excel sheet or google document of the items' description, enter all attributes, and price including shipping if available.

Skills: Online Research, Typing, Microsoft Office, Copy & Paste, Data Entry, Data Mining, Microsoft Excel

Job Description:
We’re a residential homebuilding company based in Australia, looking for a reliable and detail-focused Procurement Assistant to support our day-to-day quoting and purchasing operations. This role is ideal for someone with experience in the construction industry, strong communication skills, and the ability to work independently.

You’ll be helping us stay ahead by managing quote requests, preparing takeoffs using Bluebeam, drafting orders, and following up with suppliers. You’ll be working closely with the business owner and team via email, Bluebeam, Buildertrend and the google suite.

Key Responsibilities:
Request and follow up on quotes from suppliers (using Gmail and supplied templates)

Track and compare pricing in Google Sheets

Draft clear, well-formatted orders for review before sending

Perform basic quantity takeoffs using Bluebeam from PDFs (mostly architectural and construction drawings)

Keep records of quotes, orders, and supplier communication in our shared drive

Alert the team to price changes, supply delays, or discrepancies

Support in scheduling deliveries or checking lead times, when needed

Requirements:
Proficiency in Bluebeam for takeoffs

Strong experience with Bluebeam, Gmail, Google Drive, and Google Sheets

Familiarity with residential construction materials and processes (especially framing, cladding, windows, etc.)

Excellent written English and clear communication

High attention to detail and ability to self-check work

Comfortable with recurring weekly tasks and structured workflows

Able to work in the AEST time zone for at least 1–2 hours daily (flexible otherwise)

Preferred But Not Required:
Experience working with Australian builders or suppliers

Knowledge of Buildertrend or other construction software

Background in estimating or construction administration

Hours & Rate:
Approx. 10–15 hours per week, with potential to grow

Hourly or milestone-based depending on workflow

Long-term opportunity for the right person

To Apply:
Please include:

A brief cover letter outlining your relevant experience

Examples of similar work (e.g. takeoffs, supplier emails, order formatting)

Your availability in AEST and preferred hourly rate

Skills: Microsoft Excel, Construction Estimating, Estimator, Material Take-Off, Bluebeam Revu

We are looking for a Data Entry Clerk to join our team. This role offers the flexibility to work remotely. In this role, you will assist our team by updating and maintaining information in our databases and provide administrative support as needed. As the ideal candidate, you will have exceptional attention to detail and be self-motivated to keep yourself focused on assigned tasks.

Skills: Data Entry, Microsoft Excel, Accuracy Verification, Customer Service, Administrative Support, Database

We are seeking a skilled financial modeler with experience in renewable energy, particularly solar PV projects, to assist with evaluating project feasibility, optimizing capital structures, and preparing financial models for investment and development decisions.

Responsibilities:
- Develop and maintain dynamic financial models for solar PV and energy storage projects (residential, commercial, and utility-scale)
- Perform scenario analysis, sensitivity analysis, and risk assessments
- Model tax equity, depreciation, loan structures, and incentive programs (e.g., ITC, MACRS, IRA-related credits)
- Estimate project IRR, NPV, DSCR, payback period, and LCOE
- Support decision-making for PPAs, leases, and ownership models
- Prepare financial summaries, reports, and investor-ready presentations

Requirements:
- Proven experience with financial modeling in the solar or renewable energy sector
- Strong proficiency in Excel (macros, formulas, charts, etc.); experience with Google Sheets is a plus
- Ability to communicate clearly and deliver well-structured outputs
- Degree in finance, engineering, economics, or a related field

Preferred Qualifications:
- Understanding of U.S. solar incentives and financing structures
- Experience working with solar developers, EPCs, or investment firms
- Familiarity with tools like Energy Toolbase, Helioscope, or SAM

Skills: Financial Report, Presentations, Financial Modeling, Financial Analysis, Microsoft Excel

We are seeking a detail-oriented Data Mining Specialist to assist with contact scraping for our project. The ideal candidate will have experience in extracting prospect and relevant contact information from various online sources. Your expertise will help us build a comprehensive database that supports our marketing strategies. If you have a proven track record in data mining and are proficient in using scraping tools, we want to hear from you. Please include examples of your previous work in your application.

Skills: Data Scraping, Data Mining, Microsoft Excel, Data Entry

We are looking for a strong great person with a great attitude looking to build their portfolio and work experience!

Duncan Power Washing is looking to grow our team to the next level and with your help it will allow us to grow and develop as a company!

Tasks will range from CRM Data entry, Email communication with customers, Email follow ups, quote creation, sending emails, inputting new customers into our system, managing our CRM, keeping track of customer quotes and schedule. You will be working very closely with John.

All of these tasks are great and simple to learn and are essential to our company!

We also look for YOUR SKILLS and YOUR Strengths! If you have something that you think will make the team better let us know!

Skills: Microsoft Excel, Communications, Virtual Assistance, Customer Service, Administrative Support, Email Communication, Data Entry, Email Etiquette, Communication Skills, Organizational Plan

Hope you are doing well.

Planet Earth Garden Supply, Inc in need of a professional Help Desk and IT support as our small company grows. We are a cannabis farm supply company who are frequently onboarding remote appointment setters. We use Microsoft 365 applications and would appreciate a professional to assist with Teams, ODOO CRM and various technical issues that may arise with these applications.

Please provide a proposal sharing your extensive experience with ODOO CRM, Teams, Sharepoint and how you can create a Help Desk for our team.

Skills: Business with 1-9 Employees, Microsoft Windows, macOS, Administrative Support, Microsoft Excel

Looknig for someone to edit some forms for me as soon as possible. Just need to make minor adjustments of numbers. Turn around time needs to be within a day

Skills: WordPress, Microsoft Word, Microsoft Excel, Graphic Design, HTML

We are seeking a skilled Commercial Flooring Estimator to assist with ongoing takeoffs and project liason. The ideal candidate will have experience in accurately estimating flooring materials and costs. You will collaborate with our project team to provide precise takeoff services and support in the bidding process. If you have a keen eye for detail and a background in commercial flooring estimation, we would love to hear from you!

Skills: Material Take-Off, Construction Estimating, Microsoft Excel, Estimator, Construction

We are seeking a skilled data visualization expert to create an executive dashboard that displays key business metrics through graphs and data visualizations. The project includes designing an intuitive Excel input sheet that allows for real-time updates to the dashboard. The ideal candidate will have a strong understanding of data analysis and visualization principles to ensure the dashboard is both functional and visually appealing.

Skills: Microsoft Excel, Data Visualization, Visual Basic for Applications, Microsoft Power BI, Tableau

We looking for someone who can conduct surveys from large retailers from different industries on an urgent basis.

Skills: Market Research, Data Entry, Market Analysis, Microsoft Excel, Data Analysis

We are seeking a proactive Executive Assistant to support our CFO with essential administrative tasks. Your responsibilities will include data entry, handling calls and emails, and building and managing spreadsheets. The ideal candidate will be organized, detail-oriented, and able to manage multiple tasks efficiently. If you have excellent communication skills and a background in administrative support, we would love to hear from you!

Skills: Data Entry, Microsoft Excel, Administrative Support, Google Docs, Customer Service

Frontline is looking to hire someone for three or four hours a day that can create estimates for every appointment on our calendar for the following day.

This can be done between 8 PM central time and 8 AM central time. Estimated hours per day is 3 to 4 hours maximum.

Skills: Copy Editing, Data Entry, Market Research, GoodData, Yahoo! Search Marketing, Google Docs, Mathematics Tutoring, Microsoft Word, Administrative Support, Microsoft Excel, Clerical Skills, Microsoft PowerPoint

We looking for someone who can conduct surveys from large retailers from different industries on an urgent basis.

Skills: Market Research, Data Entry, Market Analysis, Microsoft Excel, Data Analysis

We are seeking an experienced accounting process expert with a strong background in Workday Accounting Center. The ideal candidate will be responsible for optimizing our accounting workflows and ensuring compliance with financial regulations. You should be familiar with the latest accounting software trends and have hands-on experience with Workday implementations. This role requires strong analytical skills and the ability to communicate effectively with stakeholders. If you are based in Dallas and have a proven track record in accounting processes, we would love to hear from you!

1. Develop and implement the overall strategy for automating core accounting processes (e.g., accounts payable/receivable, month-end close) to improve operational efficiency.
2. Identify inefficiencies in accounting workflows and lead process improvement initiatives to streamline operations and reduce manual tasks.
3. Oversee end-to-end automation projects, including planning, execution, and post-implementation analysis, ensuring they align with business objectives and timelines.
4. Work closely with IT, finance, and other departments to integrate automation solutions and ensure successful implementation.
5. Ensure that automated accounting processes comply with financial regulations, accounting standards, and internal control frameworks.
6. Lead change management efforts to ensure smooth adoption of automation tools and train staff on new systems and processes.
7. Leverage data analytics to identify trends and opportunities for further process improvements or cost savings in accounting operations.
8. Ensure the accuracy and integrity of financial data, particularly within automated environments, and manage risks associated with automation.

Skills: Financial Accounting, GAAP, Bank Reconciliation, General Ledger, Microsoft Excel, Accounting, Accounting Tools Setup

Looking for a polished Excel or graphic designer to format a construction proposal EXCEL file

We’ve built a working Excel file to create construction proposals (including pricing, scope, exclusions, etc.). Now we want someone to:
• Make it look visually professional and pretty and easy to read
• Apply consistent branding (colors, fonts, layout)
• Clean up spacing and alignment
• Maintain formulas and structure already in place
Ideal candidate has strong Excel skills + an eye for design.

Skills: Interaction Design, Graphic Design, Microsoft Excel, User Flow

We looking for someone who can conduct surveys from large retailers from different industries on an urgent basis.

Skills: Market Research, Data Entry, Market Analysis, Microsoft Excel, Data Analysis

We are seeking a proactive freelancer to identify and compile a list of ecommerce groups based in the USA. The ideal candidate will have experience in online research and possess a keen understanding of ecommerce trends. Your task will include finding active groups on social media platforms and forums where ecommerce professionals network. If you are detail-oriented and have a passion for ecommerce, we want to hear from you!

Skills: Data Entry, Market Analysis, Microsoft Excel

I run a growing nonprofit and public sector consulting business supporting clients in the biotech, public health, and systems-change space. I'm seeking a detail-oriented, research-savvy assistant to help me stay on top of grant and sponsorship prospecting across multiple client projects.

This is a remote, part-time role (5–15 hours/week) that could expand with performance. You’ll be working from pre-curated lists and research priorities to extract relevant information, conduct website reviews, and organize findings into summaries and spreadsheets. Some clients are for-profit biotech startups, others are nonprofits or coalitions.

Key Responsibilities:
Review client-provided leads and funder/sponsor websites to extract:

-Funding priorities and eligibility

-Submission instructions and deadlines (fixed or rolling)

-Contact information or online portals

-Summarize and QA information using structured templates

-Enter data into Google Sheets or Notion for internal tracking

-Use ChatGPT prompts provided to assist with summary drafting, then proofread and refine output

Use my shared Candid Foundation Directory Online (FDO) Pro license to:

-Review lists of open RFPs

-Pull key information into a centralized, filterable format

-Tag opportunities relevant to multiple clients (not just one)

-Flag urgent deadlines or client-fit matches during weekly assignments

Required Skills & Experience:
-Experience with nonprofit or for-profit research, fundraising, grant work, or sponsorship outreach

-Strong attention to detail and ability to extract signal from noise on websites

-Proficient with Google Sheets/Excel and basic database organization

-Comfortable using ChatGPT or other AI tools and reviewing AI-generated content

-Familiarity with Foundation Directory Online or similar prospecting tools is a big plus

-Organized, responsive, and able to work independently with weekly task check-ins

Time Commitment & Expectations:
5–15 hours/week depending on workload

Weekly check-in required to align on focus areas and deliverables

Flexible schedule but reliability is critical

Skills: Prospect List, Market Research, Data Entry, Critical Thinking Skills, Grant Research & Prospect List, Company Research, Microsoft Excel, List Building, Lead Generation, Contact List

We looking for someone who can conduct surveys from large retailers from different industries on an urgent basis.

Skills: Market Research, Data Entry, Market Analysis, Microsoft Excel, Data Analysis

We’re looking for someone who lives and breathes spreadsheets. If you're highly skilled in Excel/Google Sheets and have a sharp eye for detail, this role might be a perfect fit. You'll support our e-commerce operations through data management, product listings, and a variety of ongoing admin tasks.

🔧 Key Responsibilities

Work extensively in Excel and Google Sheets to clean, organize, and manipulate large sets of data

Use formulas (VLOOKUP/XLOOKUP, INDEX/MATCH, IF statements, etc.), pivot tables, filters, and conditional formatting to automate and streamline data workflows

Perform regular quality checks to ensure data accuracy and consistency

Manage product listings (Product details only) in our PIM

Maintain and update pricing, stock levels, and supplier sheets

Assist with general data entry, categorization, and other admin support tasks as needed

✅ Must-Have Skills

Advanced experience with Excel and Google Sheets — you’re comfortable building formulas and working with hundreds/thousands of rows

Strong attention to detail — spotting inconsistencies or formatting issues is second nature to you

Comfortable working with repetitive tasks and structured processes

Proactive, organized, and able to work independently

Communicates clearly in English

✨ Nice to Have

Experience with e-commerce platforms (Shopify, WooCommerce, or similar)

Familiarity with product data, SKUs, pricing models, or vendor sheets

Interest in e-commerce, tech, or product-based businesses


Part-time (10–20 hours/week to start) and great potential to full-time. Long-term opportunity for the right person

Skills: Google Docs, Data Entry, Microsoft Excel

You need to unlock the sheet and brand it according to my brand

Skills: Microsoft Excel, Spreadsheet Software

We looking for someone who can conduct surveys from large retailers from different industries on an urgent basis.

Skills: Market Research, Data Entry, Market Analysis, Microsoft Excel, Data Analysis

📢 We’re Hiring!

Looking for a proactive assistant to handle key tasks in finance & client management:

✔️ Follow up on Mutual Fund transactions 📊
✔️ Sales pitching via cold calls & emails 📞✉️
✔️ Guide clients on investments, insurance & wealth planning 💰
✔️ Manage schedules & set reminders 🗓️
✔️ Engage on social media across platforms 📲
✔️ Explore finance & physiotherapy synergies 💼🏥

💡 If you’re organized, communicative & eager to grow, we want you on our team!

📩 DM or apply now! 🚀

Skills: Microsoft Excel, Communications, Data Entry, Customer Service