Excel calculate statistics jobs

I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.

I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes

I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation

I need a Pine Script expert to create an alert for my custom indicator. Key Requirements: - Develop a set of codes to let my custom indicator to send signal - Mainly, I use daily chart but I want the signal to create an alert before the bar close. For instance if the daily bar close at 4:00 am, it has to calculate everything around 3:45 am and then send the signal immediately after that. - Please note that I have my custom indicator finished written so you might like to create the signal only when the conditions are met. Ideal Skills: - Strong Pine Script and Trading Indicator experience. - Excellent understanding of trading and financial markets. - Ability to optimize code for performance. - Effective communication and support for the project.

I'm searching for a skilled Virtual Assistant (VA) to manage a small inventory of less than 100 entries. Your responsibilities will include: - Data entry: Accurately inputting necessary information into our system. - Spreadsheet management: Expertly organizing and managing our inventory data in Excel. - Reporting: Creating clear, concise, and actionable reports based on the inventory data. To execute these tasks proficiently, you should be well-versed in the SUMIF and Pivot Tables functions in Excel. Prior experience in managing small to medium-sized inventories will prove beneficial. Your ability to pay attention to detail, demonstrate excellent problem-solving skills, and deliver results in a timely manner will be important for success in this role.

summarize in a specific table in Excel

Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migration proc...

Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word

I'm looking for a skilled Oracle APEX developer to create a results and statistics page for a quiz platform. I need the form to reveal the correct answers and individual statistics after it's submitted. Each question's answer must be shown right next to the user's choice so they can easily see what they missed. The ultimate score should be displayed in a format of 'achieved score/out of total score' or 'percentage'. Key features: - Display the correct answers alongside participant's responses - Show the participant's score as 'achieved out of total' - Generate overall quiz statistics A background in Oracle APEX is mandatory and previous experience in quiz, survey, or similar interactive form development wi...

I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. T...were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must fo...

I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK...

...seeking a Python developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automation proc...

I need assistance with entering inventory data into Quickbooks Desktop from an Excel file. - I'm looking for a professional who has experience with Quickbooks Desktop. - The job involves bulk data entry, focusing specifically on inventory. - You will be provided with an Excel file containing the inventory data. - Attention to detail is crucial to ensure accurate and efficient data entry. Ideal skills: - Proficiency with Quickbooks Desktop - Experience with data entry, particularly inventory - Attention to detail and accuracy in data entry - Familiarity with Excel files and their import into Quickbooks

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in ...Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...

We are looking for an experienced full-stack developer to create a simple yet effective web app for prospective medical students. The platform will serve as a study aid and must include the following features: login system, course overview, statistics, polls, video and text courses. Further information about each feature aswell as The UI/UX design are already completed and available in a Figma file, which you will use for the frontend development. The ideal candidate should have in-depth knowledge of React.js for the frontend and Node.js for the backend. The UI/UX is in English, but I would want to translate all contents of the webapp to German (myself) once it's done. We would like to start as soon as possible. Project due: 25th May 2024 You can find the Figma link in the ...

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely...can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and a...

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

I need an Excel expert to overhaul my current worksheet. Key needs include formula adjustments, data validation updates, and creating an interactive dashboard. The dashboard should boast the ability for graphical data representation, specifically bar charts, and customizable filters to view data from multiple perspectives. The right candidate will have extensive experience in Excel, knowledge of advanced formulas, data validation techniques and be proficient in creating interactive dashboards.

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

I'm seeking a skilled professional to enter 100-500 text entries for me. Key Responsibilities: - Entry of primarily textual data - Handling 100-500 entries Ideal Skills: - Proficient with Microsoft Excel - Excellent attention to detail - Strong typing and data entry skills. Experience in similar projects will be highly appreciated. I look forward to your bids for an efficient data entry task.

I need a talented ...plugin developer to create a personalized and realistic horse server plugin. I'm striving for a lifelike equestrian experience involving breeding, birth, and horse illnesses. This plugin should also allow for horses to eat and drink. I envision a diverse range of tack sets available for use. Crucial to achieving realism, I seek enhanced features for: - Horse Stats and Training: In-depth horse statistics and training options. - Custom Horse Maker: A tool to create unique horse types and breeds. - Improved Horse Gaits and Models: Focused improvement sought on 'appearance and textures' to add realism. Ideal Experience: - Plugin development - Knowledge of realistic horse behavior and traits - Experience with model and texture design - Familiarity wi...

I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :

I seek a professional capable of conducting a detailed analysis on fluoride concentrations in portable water sources. The deliverable for this project is a comprehensive report that includes all findings, statistical interpretations, and recommen...is a critical aspect of the project, and I need someone who can work efficiently without compromising the quality of the analysis. - **Format**: The final report should be presented in a Word Document format. You should be experienced in environmental science or chemistry analysis, and should be able to provide me with a clear understanding of the implications of the findings. A background in statistics and data interpretation will be very beneficial. Please submit your proposal if you have the expertise and experience required for thi...

2 pages of data sheet need to be recreated with zero mistakes and dito copy i am attaching the 2 pages i need to be recreated same to same, the top logo will change which i will provide you the screw picture and the text i am attaching with this for your review the sheets should be totally editable either make in word or excel or it should be edited in PDF the lowest quote below the price of $15 will be awarded the project thank you

I'm in need of an experienced IoT device developer to create a production-level device specifically tailored to calculate current flowing through a phase in a transformer. Ideally, the skill-set of the successful freelancer will include: - Experience with ESP3266 and clamp current sensor. - Expertise in the development of IoT devices that can perform real-time monitoring. - Capable of crafting a solution that concentrates specifically on current level monitoring. - Should be more efficient and accurate current flow value - AWS iot core experience will advantage - Open for suggestions for production level. This project could potentially roll into a long-term contract depending on the success of the initial task. So, if you have the skills and experience, please place your bi...

When replying, rep...please share name and details 6) What qualifications you have? 7) If you have any experience in working in Singapore financial projects do highlight those as well. 8) What do you understand of the SIBOR / SOR / LIBOR scandal and how could it have affected borrowers? Work scope: Go through letter of offers and loan statements, find the faults, calculate the excess paid, calculate damages All works should be done in Google Sheets or Microsoft Excel with formulas to prevent any calculation errors. Your output should clearly show what was charged, what should have been charged, difference and damages. Need someone who has a decent amount of time available, if you do not have alot of time to spare, this may not be ideal as this will take some time t...

We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of animation principles and ...caliber of content we're aiming for. We aspire to achieve a similar level of ingenuity and amusement in our mascot character Instagram Reels. How to Apply: If you're passionate about animation and possess a talent for crafting entertaining Instagram Reels and understand cryptocurrencies and trading we're eager to hear from you! Please include your portfolio and a brief statement outlining why you'd excel in this role in your application. Additionally, feel free to share any relevant experience or ideas on bringing our mascot c...

I need a dedicated professional to assist with a crucial data entry project. The work involves: - Encoding textual data sourced from digital documents. - Delivering accurately encoded data into an Excel spreadsheet. This task requires keen attention to detail to ensure the absolute accuracy of the data entry. The ideal candidate must have extensive experience handling textual data and an aptitude for meticulous data entry work. Proficiency in Excel and working with digital documents is also vital.

I have a data transcription and cleaning/validation project that requires a skilled individual. All data will be provided in Excel and PDF formats. Key Responsibilities: - Transcribing data accurately from multiple sources - Cleaning and validating the data to ensure accuracy - Working primarily within Microsoft Excel Skills/Experience Required: - Proficiency in data entry, transcription, and data cleaning - Strong command over Microsoft Excel - Attention to detail and accuracy are key I am looking for a detail-oriented individual with relevant experience to help me complete this task efficiently and accurately. Please include examples of similar projects you have completed in your proposal.

I'm looking for an Excel expert to help me refine some of my current templates. The ideal candidate will have experience with building templates for dashboards, organizing data, generating reports, and analyzing various types of data including sales, financial, customer, and inventory data. Key Requirements: - Experience in building templates for dashboards is a must. - Adept at organizing and analyzing complex sets of data. - Ability to translate data into clear and visually appealing reports. - Proficiency in working with various types of data, including sales, financial, customer, and inventory data. - Understanding of creating customizable templates in Excel. - A keen eye for design with a focus on clean and simple layouts would be appreciated. The project involves...

I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.

I'm looking for an Excel expert to help me create a comprehensive tool that will serve as a project scheduler, lead manager, and accounts system. Specifically, I'd like the tool to have the following features: - **Project Scheduler** - Task tracking: I need to be able to input tasks and track their progress. - Gantt chart: Visualization of tasks and their timelines. - Resource allocation: The ability to allocate resources to tasks and track their usage. - **Lead Manager** - Lead tracking: The tool should allow me to input and track leads. - Contact management: I need to be able to store and manage lead contact information. - Sales pipeline: Visualization of the sales pipeline, including lead progression and conversion rates. - **Accounts Management** - Ex...

I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.

...application. This tool will structure reports from user inputs and is required to be fully compatible with Microsoft Excel. Therefore, proficiency in Excel-integrated application development is essential. Key Tasks and Specifications include: - Designing and coding a desktop application for report generation - Ensuring the application can accurately convert user input data into structured reports - Implementing compatibility with Microsoft Excel for the accessible and seamless transfer of data The ideal freelancer for this project has a strong background in software development, particularly with creating desktop applications and working with Excel. Experience with coding Excel-integrated apps and understanding of user-friendly UX design would set yo...

I'm in need of an Excel Expert to create a functional and visually cohesive form for my company. The form should have various action buttons and cell locking features to ensure data integrity. Key Features Required: - Action Buttons: The form needs to have a 'Submit' button for data submission and a 'Clear' button for form reset. - Time Store Function: This unique feature should automatically calculate time spent on the form, store time values in a specific cell, and generate a report of time spent. Its implementation should be seamless and user-friendly. - Cell Locking: Certain cells in the form must be locked to prevent accidental changes. This is crucial for the form's operational integrity. Design Requirements: - The form should be designe...

I'm seeking an experienced presentation designer and strategist to ...project: - Proven experience in crafting persuasive presentations - Solid understanding of corporate strategic planning - Exceptional design and communication skills - Experience in presenting to Executive audiences - Proficient in using presentation tools such as PowerPoint, Keynote etc. Deliverables include: - A complete, engaging, and meticulously structured presentation - Relevant graphics, statistics, and supporting materials - Incorporating our company branding in the design - Recommendations for presenting to maximize impact and persuasion This is an opportunity to play a pivotal role in shaping the future direction of our organization. I look forward to seeing your creative and dynamic approach...

I'm in need of a website that is secure and provides my clients with the ability to register and login. The key features of the site should be: - User registration - User login - User profile creation My clients should also be able to access an Excel file on our Onedrive cloud and extract pricing information from there. Finally, they should be able to submit their orders directly to us via email. This includes order details such as description, price, and delivery instructions. Additionally, clients should be able to attach relevant files to their orders. The ideal candidate for this project would have vast experience in secure website development, Microsoft Onedrive integration, and email integration. Familiarity with order processing systems would also be a key advantage.

...tasks primarily centered around Excel and Word. - Excel: The emphasis will be on crafting sophisticated formulas and performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. Ideal candidates should have proficient ex...

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data

...solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: • Collect up-to-date statistics on the UAE education sector, including details on student enrollments, enrollment trends, and the diversity of curricula offered. • Acquire data on the cultural and national diversity of student bodies across schools to ensure our directory caters comprehensively to all segments of society. Competitive Analysis: • Identify and analyz...

I am in urgent need of a meticulous freelancer to assist with data entry and the organization of several Excel spreadsheets. Your primary task will involve entering data from various not-specified sources into Excel, as well as categorizing and structuring this data in a logical and efficient manner. Desirable Skills & Experience Required: - Mastery of Excel functions and formatting features - Strong attention to detail and accuracy - Proven experience in data entry - Ability to work with limited supervision - Data analysis and detection of irregularities is considered a plus. The task doesn't necessarily require prior relevant experience but being familiar with Excel and data structuring principles would be advantageous. Due to the nature of the...

...solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: • Collect up-to-date statistics on the UAE education sector, including details on student enrollments, enrollment trends, and the diversity of curricula offered. • Acquire data on the cultural and national diversity of student bodies across schools to ensure our directory caters comprehensively to all segments of society. Competitive Analysis: • Identify and analyz...

I need assistance transferring my handwritten notes into a digital spreadsheet. Ideal skills and experience include: - Proficiency in data entry - Ability to decipher handwritten text - Expertise in spreadsheet software, such as Excel or Google Sheets

As an advanced Excel user, I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Stron...

I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: ...help me extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right f...

I'm in need of a skilled mathematician with a specialization in statistics to assist me in data analysis. Essential Points: - Specialization: Your main focus should be on advanced statistics, specifically at a graduate level. - Experience: Proven experience handling complex statistical data analysis is a must. - Communication: You should be able to translate your findings into actionable insights. - Tools: Proficiency in statistical software like R, Python, or SPSS is essential. This role is crucial in helping me make sense of large datasets, so it's important that you are comfortable with the analytical side of data interpretation. Your findings will help me make informed decisions based on the data. Please reach out if you think you're the right fit for th...