Data organization excel jobs

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to...

I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a me...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a ...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria fo...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

...Keynote presentation for Harmonic Homes, but we need a skilled graphic designer to take it to the next level. This presentation will serve as a pitch deck for investors and potential customers. We want it to be visually inspiring, easy to understand, and aligned with modern architecture aesthetics. Responsibilities: -Refine the existing Keynote presentation. -Add depth and detail to the organization of information. -Enhance branding and style. -Ensure clear communication throughout the slides. Requirements: -Experience in Graphic Design -Experience in designing multiple-page documents -Experience with Keynote, Canva or Illustrator Bonus Skills: -Photoshop -Pitch Deck Design -Architectural Design -Product Design -Rendering Budget: We’re budgeting approximately $12...

...review my Google Ads account focusing on campaign structure and target audience to enhance lead generation. Specifically, I'm looking for someone to review in comparison to another specified month where campaigns were much more successful. Key Areas: - **Campaign Structure**: Your task would be to evaluate and provide feedback on the overall structure of my existing campaigns. This includes the organization of ad groups, the relevance of keywords, and the alignment of ad creatives with the campaign goals. - **Target Audience**: I need a detailed examination of my target audience. This would involve assessing how well my current targeting aligns with the interests and behaviors of my ideal leads. You will be expected to offer recommendations for refining or expanding this s...

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

As a nonprofit organization, we are in need of a competent website developer to design and create a modern, minimalist styled website for us. The main goal of our website includes: - Raising awareness about our cause - Collecting online donations - Sharing information about our organization The ideal candidate should have the following skills and experience: - Proficiency in modern, minimalist design - A strong understanding of how to effectively communicate our brand and mission online - Experience in building donation collection systems into a website We also need key functionality features including but not limited to: - An event calendar system, essential for organizing and promoting our activities - A Blog or News Section for sharing updates, success stories, and m...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

...is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and log...

I have nearly completed my CV, but I'm looking for a professional to help me redesign it. The aim is to create a more modern, minimalist, creative, and visually appealing layout. Key Requirements: - Tweak the content organization for maximum impact - Implement a professional and elegant font choice - Craft a layout that's ideal for job applications. Ideal Skills and Experience: - Proven track record in revamping CVs with a creative touch - Strong understanding of design principles and typography - Ability to tailor CVs for job applications. Please share relevant samples of your previous CV design work.

Apply only if you have this transactions here:

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I require a logo designer to shape a logo for my organization. Key Details: - As I did not specify a particular style for my logo, I'm open to your creative input. - The predominant colors to be used are Blue, Red, and Green. - As for the delivery time, there isn't any rush. Quality takes precedence over speed in this project. Ideal Skills and Experience: - Proven experience in logo design and graphic arts - Prior projects showcasing versatility in style - Ability to apply color theory in designs effectively - Strong communication and adherence to details.

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

I'm having a tough time with my powerapp project and need an expert to step in. There are some crucial issues that need to be fixed quickly. These include: - Data not saving properly - Difficulty in integrating external APIs - Improving formula optimization I've attempted to save multiple screens to PDF and email it, as well as search for employees in my organization but am currently failing. This work needs completion ASAP. Therefore, I am seeking a freelancer who understands powerapp projects and their workings, down to the smallest detail. Your expertise in correcting data saving issues, integration of APIs and mastery of formula optimization will be crucial to get this project completed successfully. If this is your terrain, please make a bid.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, bu...

As a Python Developer, I'm intent on automating specific repetitive tasks related to file management and organization. Key Responsibilities: - Develop scripts in Python to automate repetitive file management tasks. These tasks are slowing down our productivity and we need a solution to streamline them. - Implement an effective, reliable and user-friendly automated system that requires minimal manual intervention. - Ensure the system is highly secure and can handle large volumes of data effectively. The ideal candidate will have: - Proficiency in Python programming language and experience in automation.

Hello, I need complet the Amazon categories catalogue excel in french

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...department is the Newark Youth Career One-Stop Career center, they focus on getting young adults into jobs and career advancement. they have a summer program called the "Summer Youth Employment Program (SYEP)". This is the biggest summer employment program in the state of New Jersey since Newark is the largest city in NJ. I have attached their current department logo to this.. Now they hired my organization to run their SYEP Orientation. This orientation helps jump off their summer youth employment program, we will provide the youth with development workshops. for this contest, i need: 1) 2024 SYEP logo (this will be logo used at orientation and other environments. (this also needs to look cool for the urban teens. 2) we will have shirts, so come up with ideas f...

I'm seeking an experienced Project Manager to take over the planning and organization of an IT project. Responsibilities and Tasks - You will primarily be in charge of project planning and organization. Preferred Methods - A Gantt chart should be used for effectively planning and coordinating the aspects of the project. Industry Knowledge - A firm understanding of IT and Software industry is required. With your industry knowledge, you can guide our team effectively. Ideal Skills and Experience - Prior experience in project management, especially in the IT industry. - Proficiency in Gantt chart for project management. - Excellent team coordination and communication skills. - Adeptness with budget and timeline management.

...need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spre...

I am in need of an expert with comprehensive knowledge of Microsoft Outlook on desktop. My project requires: - Configuration and setup of one email account in my Outlook desktop application. I need assistance in making sure this is configured properly and syncing correctly with my email server. - Enhancing my Email organization and management. I require help in creating a more efficient filing and organization system within my Outlook. The ideal candidate would have significant experience and expertise with Microsoft Outlook and, more specifically, with configuring and managing email accounts. Strong understanding of email management best practices is essential. These skills will allow you to effectively assist me in ensuring my email is organized, manageable, and function...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. P...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accu...

I'm seeking a skilled graphic designer to modernize my organization's image. The focus is creating a symbolic l...organization's image. The focus is creating a symbolic logo and other graphics showcasing the essence of a Model United Nations education platform. Ideal skills include: - Experience in rebranding, specifically in the educational or non-profit sectors. - Ability to work with cool-color palette (blues, greens, violets). - Proficiency in designing symbolic graphics, capturing the mission of our organization. Your task is to elevate our brand recognition and help attract new students, through visuals that represent our work in a modern, influential way. We are Tampa Bay Homeschool Model United Nations, committed to supporting debate education; reflect this ...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

As a TikTok Influencer Outreach Specialist, your main task will be to connect with influencers/KOLs on TikTok within the United States. Key Responsibilities: - Reach out to TikTok influencers with a follower count of over 5K - Encourage the influencers to accept a free premium product sample - Request the influencers to create video cont... Ideal Skills and Experience: - Proven experience in influencer outreach on TikTok - Familiarity with the United States market and TikTok trends - Exceptional communication skills - Ability to close deals with influencers - Knowledge of how to negotiate and motivate influencers to create content Please note that we plan to reach out to more than 20 influencers, so a good level of organization is required to manage the outreach ef...

I am in need of a prof...specifications of this project are as follows: - The forms I need are mainly Registration Forms and Agreement Forms. - The forms are to be designed for digital use only. I do not require physical copies. - The final deliverables should be in PDF and MS Word format. - The forms need to have fillable form fields. - The design must be appealing, professional, and align with the branding of my organization. - Attention to detail is crucial to ensure no mistakes or inaccuracies. I am looking for someone with a strong background in Desktop Publishing (DTP) and graphic design, who can deliver quality work in a timely manner. Experience and familiarity with the creation of form fields within PDFs is a significant plus. Please include samples of similar projects in...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

I'm in need of a thorough professional to create a Project Management Portfolio. As I skipped providing specific deliverables, types of projects, and organization method, I encourage creativity and expect innovative ideas for this project. Ideal candidate should have: - Strong understanding of different aspects of project management - Proven track record of bringing original ideas to complex projects - Flexibility and adaptability to work from a blank slate Your task will involve: - Deciding potential deliverables like the project plans, risk assessments, budget reports etc. - Incorporating diverse types of projects perhaps construction, software development or marketing campaigns - Organising the portfolio in a visually appealing and easy-to-navigate way. Looking forw...

French-speaking candidates only! My organization is currently leveraging several Zoho applications including CRM, Books, Inventory, People, Recruit, Shifts, Project, Survey, and Forms. I am seeking a skilled freelancer who can effectively integrate these applications with our existing ERP system. Key project aims include: - Customer data synchronization: Ensuring consistent, accurate customer information across platforms. - Order management integration: Streamlining order processes for increased business efficiency. - Inventory management synchronization: Maintaining real-time, synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zo...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.