Microsoft excel spreadsheet managerial work jobs
I have ongoing work related to our previous project 'Graduation Yard Sign'
I have ongoing work related to our previous project 'Graduation Yard Sign'
I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using Power Qu...
Enhance an Excel file about real estate investment. I'll highlight entry values in green, correct and insert formulas when needed.
I'm looking for a custom Excel template to organize my extensive sports memorabilia collection. The collection includes various types of items, such as: - Autographed items - Trading cards - Game-used items - Pop figures - Jerseys - Balls - Movie memorabilia The template should be user-friendly, allowing for easy input and tracking of each item. Ideal candidates should have experience in creating digital templates, preferably for memorabilia or similar collections. Skills needed: - Advanced proficiency in spreadsheet software - Experience in template creation - Knowledge of sports memorabilia is a plus. Please submit your proposal if you have the required skills and experience. I am not looking to create a logo or websitr
I need an Excel dashboard created from our data that we currently track in Excel across multiple locations. The dashboard should display a variety of key metrics including: - Sales data - YOY Data - Membership Sales - Membership Conversions - Labor as a percentage of revenue - Birthday party revenue and YOY data for same week LY - Concessions Revenue and YOY data for same week LY The ideal freelancer should have: - Expert proficiency in Excel - Experience in creating dynamic dashboards - Ability to visualize data using bar charts and line graphs - Understanding of sales and revenue tracking The dashboard should be able to visualize data using bar charts and line graphs, as well as dynamic dashboard visuals. The dashboard will need to refresh data on a weekly basis. ...
I'm in need of a detailed Excel sheet for my company, specifically for the Operations department. This sheet should include various registers and time sheets, all interlinked with formulas for seamless data flow. Key Components: - Invoice Register - Expense Register - Salary Register - Employee Time Sheet - Invoice Incoming - Invoice Outgoing - Outgoing Purchase Order - Purchase Order Incoming (Sales Order) - Apex and Opex Register - Asset List - Billing Forecast - Expense Forecast - Hire Employee List and Salary Register - Payroll Master and ESOB Calculator and Register The project also requires the creation of a single dashboard. The main purpose of this dashboard is to track the financial performance of the company. It should prominently display: - Total revenue and exp...
I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solutions w...
Scrape agent's full name, company, mobile number, and suburb from the provided RealCommercial link. Store the data in a structured spreadsheet format. Remove duplicate entries to ensure clean data. Deliver the final CSV or Excel file.
I'm i...shape with the letters "OCT" - Simple and clean typography, yet bold, readable, and elegant Color Scheme: - Navy Blue (#1F3A93, RGB: 31, 58, 147) - Silver Gray (#B2B2B2, RGB: 178, 178, 178) - White (#FFFFFF, RGB: 255, 255, 255) The logo should be suitable for various branding materials including business cards and letterheads. It is crucial that the design does not include generic icons from Microsoft or Canva. Bonus Points For: - A design that conveys trust, reliability, and professionalism - A sleek, high-end corporate aesthetic - Delivery in vector format (AI, SVG, PNG, JPEG, PDF) Ideal Skills and Experience: - Graphic design with a focus on logo creation - Experience in delivering minimalist and modern designs - Proficiency in using design software t...
I'm seeking an expert with experience in Industrial Hygiene Consulting Firms in Canada to develop a comprehensive Industrial Hygiene Proposal Template for me. Key Sections: The template should include an Executive Summary, Project Scope, Methodology, Rates, and other relevant sections. ...Key Sections: The template should include an Executive Summary, Project Scope, Methodology, Rates, and other relevant sections. Regulatory Guidelines: The proposal template must address the Canadian National Standards, Provincial Standards, and Company-specific Guidelines. Format: The final deliverables should be a Microsoft Word Document and a PDF. Ideal Skills: - Expertise in Industrial Hygiene - Familiarity with Canadian Industrial Hygiene Standards - Proficient in Microsoft W...
I'm seeking a skilled photo editor to insert a logo onto images of a blue work uniform. Requirements: - Expert in photo editing, particularly object insertion - Proven experience with brand/logo placement - Able to maintain the integrity of the uniform's design and color - Quick turnaround time Please provide samples of similar work you've done in the past.
...to): • Scientific research labs • Medical and clinical labs • School/educational labs • Governmental labs • Food testing labs • HPLC labs • Cytogenetics labs • Industrial labs Data Requirements: Each laboratory entry must include the following: 1. Laboratory Name 2. Address 3. Telephone Number 4. Email Address (mandatory) 5. Website (if available) Project Deliverables: • A spreadsheet (Excel, Google Sheets, or CSV format) containing at least 1,500 unique laboratory contacts. • Each row should represent one laboratory, with columns for the required data points above. Important Details: • Labs from Mexico or Brazil will NOT be accepted. Please do not include any contacts from those countries. • ...
I'm looking for a professional with expertise in SharePoint and Microsoft Forms to implement a specific logic for a form I'm creating. The form will collect: 1. Name 2. Serial Number 3. Country The task involves validating the submitted serial numbers against a list I've organized by country. If a serial number doesn't match the corresponding country, I need a customized inline error message to be displayed. application can use sharepoint , forms , power app - I already have the list of valid serial numbers and their corresponding countries. - The payment for this task is fixed. Ideal candidates should have: - Extensive experience with Microsoft Forms and SharePoint. - Ability to implement custom logic in forms. - Experience with creating inline erro...
I need assistance in exporting questions, answers, and explanations from a ChatGPT report into an Excel document. The data consists of 400 items formatted as text paragraphs in the report. Please see example link below: If you open the file above, you will see there are 400 questions organised into: 1) questions 2) correct answer 3) Explanations When you try to ask ChatGPT to export all data into an excel document it doesn't do this properly. It only gives a sample of the questions. I want a freelancer to find a way so that you can instruct ChatGPT to properly export all data so it matches what is produced from before. We have over 100+ documents with each document containing 400+ questions. If you can do it for 1 correctly
...document for a Property Owners Association. Key Tasks: - Accurately retype the entire document into Microsoft Word. - Maintain the original formatting, including structure, headings, and sections. - Incorporate original seals and notary stamps from the scanned PDF into the Word document. - Ensure all legal text is preserved without errors. - Follow a modern, clean look for the formatting. Ideal Candidate: - Excellent typing accuracy and attention to detail. - Experience with legal or formal documents. - Proficiency in Microsoft Word formatting. - Ability to insert and align images (seals and stamps) properly at the exact location from the original document. Deliverables: - A fully formatted Microsoft Word version of the CC&R document that retains the original...
I'm looking for a freelancer who can set up an automated process that transfers my inventory details from QuickBooks Desktop to an Excel sheet on a daily basis. Key Requirements: - Data Transfer: The project entails transferring inventory details from QuickBooks to an Excel sheet on a daily basis. - Data Processing: After the data is transferred, I need it to be summarized in the Excel sheet. Ideal Skills: - Proficiency in QuickBooks Desktop - Advanced Excel skills - Experience with data automation Please ensure you have the relevant experience and skills before bidding. I look forward to your proposals.
I'm seeking a proficient accountant with strong financial analysis skills and expertise in Microsoft Excel. Key Responsibilities: - Conduct comprehensive financial analysis - Manage accounts payable and receivable Ideal Skills: - Proficient in Microsoft Excel - Strong financial analysis capabilities - Experienced in managing accounts payable/receivable
...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Idea...
I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.
I'm looking for an Excel expert to help me create a comprehensive spreadsheet for an educational charity. Key Responsibilities: - The main purpose of the Excel Spreadsheet will be to compare various metrics of specific areas (London Boroughs) within the Region. - We need to compare a variety of metrics. The specific metrics will be populated later, but they could include population statistics, crime rates, and educational outcomes. - The level of detail in the comparison needs to cater for both high-level overviews and detailed analyses. Ideal Skills and Experience: - Proficiency in Excel is a must, with experience in data analysis and spreadsheet creation. - Understanding of educational metrics and social statistics would be a plus. - Abi...
I'm loo...skills, particularly on the Microsoft platform, to assist with automating my website. Key Responsibilities: - Using programming and coding skills to automate my website - Primarily focusing on automating content updates on the site Ideal Skills and Experience: - Strong programming and web development background - Experience with the Microsoft platform - Demonstrated ability in automating tasks on web pages - Proficient in coding with a focus on automation The purpose of the website is to automate various tasks, primarily content updates on the web pages. The tasks to be automated include data entry, email management and file organization. This project is a great fit for individuals with a passion for coding and web development and a strong understanding of t...
I'm looking for a skilled professional to assist me with a report in Microsoft Word. Key Responsibilities: - Formatting the report according to Chicago style - Assisting with content creation - Helping with data analysis Ideal Candidates: - Proficient in Microsoft Word - Experienced in report writing and formatting - Familiar with the Chicago style - Capable of assisting with data analysis and content creation
I have an old and heavy Excel sheet that often lags. I need an updated, optimized, and improved version without any errors. My primary use for this Excel sheet is data analysis. Specifically, I use it for: - Statistical analysis - Data visualization - Using pivot tables The sheet typically handles more than 100,000 rows of data. Ideal skills for the job include: - Advanced expertise in Excel - Experience with data analysis - Skills in optimizing Excel sheets for heavy data usage - Proficiency in creating error-free and efficient spreadsheets Please note, I need this task completed as soon as possible.
I'm looking for an Excel expert who can help me automate my spreadsheets to reduce manual data entry, specifically dealing with financial data. The ideal freelancer for this job should have extensive experience in Excel, particularly in spreadsheet automation. Skills in handling financial data and creating efficient solutions to streamline processes are a plus. Please include your relevant experience in your bid.
...enhance our customer relationship management, streamline project management, and improve our financial tracking and reporting. Key Responsibilities: - Implement and integrate Zoho CRM, Zoho Books, and Zoho Projects into our operations via Zoho One. - Ensure the systems work seamlessly together to enhance efficiency and productivity. - Facilitate improved tracking and reporting of our financials through Zoho Books. - Optimize our project management processes through Zoho Projects. Data Migration: - I have existing data from excel on customers and past histrorical data that needs to be migrated from another accounting software to Zoho Books. This includes financial records, customer data, and project history. Ideal Skills: - Proven experience in Zoho One implementation a...
I'm looking for an experienced data analyst who excels in working with Excel spreadsheets. Your primary tasks will involve: - Data entry and formatting: I have a substantial amount of data that needs to be inputted and formatted correctly in Excel. - Data analysis: Once the data is properly formatted, you'll be responsible for analyzing it in Excel. The ideal candidate will have: - Proficiency in Excel, including advanced functions and formulas - Strong skills in statistical analysis - Attention to detail to ensure data accuracy - Ability to meet deadlines If you're up for the challenge, I'd love to hear from you!
I'm seeking a skilled PowerApps and Power Automate developer to assist in creating an application tailored for automating business workflows, specifically focused on approval processes. The application will need to integrate seamlessly with Microsoft SharePoint. Ideal Skills and Experience: - Proficient in PowerApps and Power Automate - Extensive experience in developing business workflow automation applications - Deep understanding of Microsoft SharePoint - Prior experience automating approval workflows - Excellent problem-solving skills and attention to detail
I'm having trouble connecting to my Windows 11 Pro machine remotely from a public Wi-Fi network. I receive an error message when the remote computer is not on the same network. Here are some specifics: - Type of remote access: Microsoft Windows 11 Pro - Network type: Public Wi-Fi - Security measures: Both security software and firewall are active I need a professional who can help troubleshoot and fix this issue. Ideal skills for this job include: - Expertise in Windows 11 and Remote Desktop Protocol (RDP) - Strong understanding of network configurations, particularly with public Wi-Fi - Experience in troubleshooting Windows remote connection errors - Knowledge in assessing and adjusting firewall and security software settings for remote access Please reach out if you can a...
I need a straightforward Excel sheet that helps me calculate my monthly expenses. I want to be able to input daily amounts and have them total automatically. Expenses to Track: - Material - Invoices - Tools - Gas - Other - W9 - Cash - Cows Key Requirements: - The Excel sheet should be organized for daily entries with a monthly total - No charts or visual aids are required, just a simple, functional design Ideal skills for this project include: - Proficiency in Excel - Experience in creating user-friendly spreadsheets - Ability to understand and cater to specific data tracking needs
I'm looking for a professional to apply on my behalf to various job platforms like Indeed, LinkedIn and Glassdoor. Apply For The following 1. software developer 2. desktop support analyst 3. programmer analyst Ideal skills for the job:...Indeed, LinkedIn and Glassdoor. Apply For The following 1. software developer 2. desktop support analyst 3. programmer analyst Ideal skills for the job: - The roles should be mid level or senior-level with a salary of 70K or more - I'm only interested in jobs located in Orange County or LA County in California. - You will need to send my resume to each application. - I expect a comprehensive excel list of all applications made. Please note that the applications should be tailored to each platform and role, showcasing my relevant ski...
I need expert assistance to set up and manage my MySQL database on a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set u...a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set up in a certain way - Generally need advice on how to update the database - Report generation: I need specific reports generated . I'm not sure the best tool to do this but maybe excel? I'd like to form an ongoing relationship with an expert to help me develop the database an...
I'm seeking an experienced dat...seeking an experienced data engineer for a project focused on building and managing a data warehouse using Amazon Redshift. Key Responsibilities: - Design and implement a comprehensive data warehouse on Amazon Redshift. - Work on optimizing the performance of the warehouse. - Able to potentially integrate various data sources in the future. Ideal Skills: - Proficient in Amazon Redshift. - Strong background in data warehousing concepts. - Experience with performance tuning of data warehouses. - Knowledge of various data source types (Relational databases, NoSQL databases, CSV/Excel files). Please note that the integration of diverse data sources is a potential future requirement, so having the skills and experience to handle this would...
as discussed in chat the work description and delivery timeline has been fixed. we will work with it
...experience in job applications, recruitment, or HR to assist with my job search in the software development sector. The role is remote but requires availability between 8:00 AM – 7:00 PM EST. Key Responsibilities: - Tailor my resume and cover letter to match job descriptions in the technology sector - Submit applications on relevant platforms (LinkedIn, Indeed, company sites) - Maintain a spreadsheet of job submissions and responses Ideal Skills: - Experience in job applications, recruitment, or HR - Detail-oriented and proactive - Familiarity with the software development sector - Proficient in English, both written and spoken Compensation: $2-$3/hr with a bonus package open for discussion. If you're interested or know someone who fits the role, please DM me or d...
I need assistance with combining 1-2 Excel documents for the purpose of archiving. Ideal Skills and Experience: - Proficiency in Excel - Attention to detail - Data management skills
I need a comprehensive Excel-based ERP application that focuses primarily on Financial Management. This mini-ERP should help me manage my processes, see projections, and calculate finances seamlessly. Key features of this Excel Dashboard should include: - Real-time tracking of income, expenses, and cash flow. - Advanced income and expense categorization and tracking (e.g., specific projects, departments). - Trend analysis and forecasting capabilities. - Automatic bank reconciliation with accounting records. I require a professional who has: - Proficient Excel skills and experience in creating ERP applications. - Strong understanding of financial management principles. - Ability to incorporate advanced tracking and forecasting features. Please note, while Financial ...
...proficient Excel macro developer who can automate a series of tasks for me. The primary objectives include: - Data Cleaning: Streamlining and organizing data to enhance its quality and usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and ability to integ...
I have ongoing work related to our previous project 'Ducknpigz 247'
I'm seeking an intermediate-level virtual assistant to support various facets of my business. Key Responsibili...assistant to support various facets of my business. Key Responsibilities: - Administrative Tasks: Keeping my schedule organized, managing emails, and coordinating meetings. - Customer Support: Assisting with inquiries and providing top-notch service to clients. - Content Creation: Helping create engaging content for my business. Required Skills: - Proficiency in Mailchimp is a must. Experience with Microsoft Office Suite, Google Workspace, and Zendesk is a plus. - Strong communication skills. - Creative mindset for content creation. If you're an intermediate virtual assistant with a knack for administration, customer support, and content creation, I would lo...
I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional cell behavior - Under...
I need a freelancer who can help me to create a bill from an Excel sheet and convert it into both an Excel file and a PDF. Ideal skills and experience for the job: - Proficiency with Excel - Experience with creating bills - Knowledge of PDF conversion - Attention to detail - Ability to meet deadlines
I'm looking to hire a freelancer who can assist in populating a spreadsheet with data by conducting web research. Key tasks: - Conducting basic web searches to gather data - Populating a spreadsheet with the collected data The ideal candidate should be capable of conducting web searches efficiently and accurately. Attention to detail is crucial, as the quality of the data collected will directly impact the project's success.
...dedicated professional who can manage data entry tasks with precision and speed. The main focus will be on: - Spreadsheet Management: You'll be responsible for handling and organizing data on spreadsheets, ensuring accuracy and efficiency. - Microsoft Access Database Updates: Regular updates to my Microsoft Access database will be a key part of this role. The ideal candidate for this project should have: - Proven experience in data entry, particularly with spreadsheet management. - Proficiency in Microsoft Access, with the ability to navigate and update databases with ease. - Excellent attention to detail, ensuring all data is entered accurately. - A commitment to delivering high-quality work with a fast turnaround time. This role is c...
Hello! I just need simple excel sheet work in under 5 hours!
I have ongoing work related to our previous project 'Logo for a Bat Mitzvah (Logo Light, Logo for Sweatshirt, Logo for Pants Sweats, and Logo for Book, Logo for Napkins)'
...Dashboard as a Microsoft Teams Application. Microsoft Teams has a developer toolkit which does the scaffolding for a Microsoft Teams App (DOCS: ). Your Task is to run the bought Dashboard as a Teams App with SSO. When The App is rendered you have the Teams App Context which gives you the values if Teams is used in Dark or Lite Mode and you should pass this to the Dashboard where a Dark or Lite Mode is also implemented. Here are links to the Dashboard Documentation: Installation Guide: (we removed the complete Next Auth Part form the Dashboard because the SSO is handled by Microsoft Teams as Application