Most useful excel functions for data analysisdela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

need help with spreadsheet formula

I need to create an Excel dashboard to visualize our inventory data. It's not a complex task and should take around 20 to 30 minutes. What I need: - Display of inventory data on the dashboard using charts and tables - The table should contain: Ideal skills for this project: - Proficiency in Excel and creating visually appealing dashboards - Understanding of inventory data and its representation in tables

I'm seeking a talented professional who can assist in building a large language model (LLM). The primary purpose of this model will be to support a machine learning project and provide a similar performance to either GPT Neo or GPT Cc. Key Tasks and Functions: - Perform natural language processing tasks - Generate text as required - Perform machine translation tasks Ideal Skills & Experience: - Proven track record in developing language models - Strong understanding of NLP and machine learning - Prior experience with GPT Neo or GPT Cc would be a significant advantage. Please provide samples of your previous work in this area.

I'm in need of a robust e-commerce website that is both visually appealing and functional. The website should be designed in a clean and professional style. The most important features I need are: - Customer Reviews: I want customers to be able to leave reviews on services that have been provided - Contact Form: I would like a 'enquire about a quote or information' tab that will send this information to my business email. I'm looking for a freelance web designer and developer who is experienced in creating e-commerce websites and can deliver on both the design and functionality. Your portfolio should reflect a strong grasp of clean, professional design and experience with e-commerce features.

I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus

I'm in need of an experienced content writer who can breathe life into my website. My goal is to inform the general public about my services and offerings, so the content should be clear, engaging, and most importantly, informative. - Key Deliverable: Website copies that speaks directly to the general public and is tailor-suited to their needs and preferences. - Ideal Skills: Exceptional writing abilities, strong research skills, vast vocabulary, understanding of best practices for writing for the web, and experience writing content for a general audience. - Key Goal: The main goal, above all, is to create content that informs the public about various aspects of the website. Looking forward to brilliant applicants who can elevate my platform with the...

I'm in need of someone who can assist with data validation and verification tasks in Microsoft Excel and help with managing payroll. Key Responsibilities: - Data Validation and Verification: This involves assessing the data's accuracy, completeness, timeliness, and consistency. Proper validation ensures that our records are reliable and correct. - Payroll Management: This task involves ensuring that all employees are paid correctly and on time, calculating wages, tracking work hours, and making necessary deductions. Experience in payroll systems or software is a plus. Ideal Skills: - Proficiency in Microsoft Excel - Experience with data validation and verification - Previous payroll processing experience - Attention to detail and accuracy in ...

I am in need of a skillful and experienced writer to create a detailed report focused on analyzing data trends from a statistics chart I will provide. Your report should: - Emphasize on providing context for the data - Combine your analytical skills to understand the underlying patterns or trends - Present findings in a clear and easy-to-understand manner, aimed at an intermediate level readership Ideal freelancers should have a background in report writing and data analysis, to effectively interpret and communicate the data’s implications. Keep in mind the goal is to enable better understanding for those reading the report.

I'm seeking someone to create a top-notch business plan report for me. The main focus should be on establishing key targets and making sound, applicable recommendations. Key Requirements: - Extensive experience in compiling business reports, particularly business plan reports. - Insight into effective tactics for target identification and building actionable recommendations. - Proficient research skills in the business field, able to access a good range of business resources. - Solid understanding of business planning, market strategy, financial analysis, and competitive analysis. Ideal Skills: - Excellent writing and editing skills, as well as strong communication abilities. - An analytical mindset with an attention to detail. - Familiarity with the l...

I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatility is key.

As a dedicated Bloomberg News subscriber, I am looking for a software solution that can enhance my reading experience. Ideally, this software should be able to scrape most of the Bloomberg News articles, list them with their respective headlines, and provide convenient links in a chronological order. This will allow me to easily navigate through the latest content available on Bloomberg News. Key Features: - Automatically skimming and listing most of the Bloomberg News articles - Displaying article headlines with links in a chronological order Technical Requirements: - Development for the Windows platform - A user-friendly desktop application interface - Ability for the user to manually request updates for the article list Ideal Skills & E...

...exis9ng image. 2. Technical Characteris9cs Analysis: Using op9cal character recogni9on (OCR) algorithms and handwri9ng analysis, the tool will extract text from the image and analyze technical features of handwri9ng such as size, inclina9on, spacing, pressure, etc. as well as characteris9cs that come from that analysis (extroverts person, shy, etc.) 3. Prac9cal Characteris9cs Analysis: Based on a reference book, the tool will analyze prac9cal features of handwri9ng such as speed, rhythm, le;er shape, readability, etc. 4. Personalized Feedback: Users will receive personalized feedback describing the detected characteris9cs and providing an explana9on of their meaning. Addi9onally, there will be a banner recommending users to consult graphology experts for...

...appreciation over five years, I'm facing a loss upon exit, contrary to expected gains. I'm seeking a forensic audit service to conduct a thorough analysis of this matter. I will provide my observations along with the Audit report and Bank statements. Before bidding, please ensure you have experience in conducting forensic audit investigations and the ability to observe irregularities (which will enable me to engage in a more informed dialogue with the SPV team). Key responsibilities: - Focus is primarily on the review of financial statements - Identify any signs of financial fraud - Deliver a comprehensive report of your findings Ideal candidates for this project should have: - Proven experience in forensic accounting - Comprehensive understanding of financial...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...

...talented Microsoft Power BI Specialist to join us in transforming our data into actionable insights. Job Description: Are you a skilled Microsoft Power BI Specialist with a passion for healthcare? Do you thrive on turning complex data into clear, actionable reports? If so, we want to hear from you! As our Power BI Specialist, you will play a pivotal role in our healthcare practice by compiling crucial reports that will inform our clinical decisions, enhance patient care, and optimize operational efficiency. You will work closely with our medical staff, administrators, and IT team to understand their data needs and deliver insightful analytics solutions. Key Responsibilities: Data Analysis & Reporting: Transform raw data from va...

As a client, I'm seeking a skilled mechanical design engineer for a specific project. - The main responsibilities include structural skid design calculations and tank design calculations. - The skid is required to have a weight between 1000 kg and 5000 kg, with dimensions of 2m x 4m. - The tank in question is a mixing tank. You should be well-versed in mechanical design, with a strong background in: - 3D modeling - Prototyping - Stress analysis Your comprehension of structural skid design and tank design is crucial. The ideal candidate will have relevant design experience and be able to provide efficient, precise, and innovative solutions to meet the project's requirements.

I'm looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to ...

I need a freelancer to google search email addresses (also few addresses which are missing) & copy paste in to an Excel sheet. Need approximately 800-950 records done in 1 day. Will go with the lowest bid.

I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatility is key.

...to leverage machine learning, I'm seeking a professional capable of constructing an efficient predictive analytics model. This project necessitates expertise with structured numeric data, highlighting the necessity for strong proficiency in database management and data analysis. Key tasks include: - Creating a robust predictive analytics model. - Optimizing the model for structured numeric data. - The focus is on predicting a continuous outcome. Ideal candidates will be fully adept in statistical analysis, machine learning algorithms, and software engineering, with a particular emphasis on handling numeric data. Past experience in similar predictive modeling projects will be highly appreciated. I envision success as the de...

In need of a skilled professional with Dabre experience to add names and assist with PNR bookings in Sabre from our airlines. This will be an ongoing role on a casual basis - Expertise in Sabre integration. - Extensive understanding of booking systems. - Problem-solving skills to troubleshoot potential issues. - Ability to train and inform our team on how the new system functions if required Please only those with a solid background in this field and have successfully completed similar projects should apply.

Reputation Management Project I am looking for a freelancer who can help me repair my impaired reputation online. Skills and Experience: - setting up wikipedia page and modifying it - pushing down the negative websites and bringing up the positive ones - Experience in managing and repairing online reputations on Google - Knowledge of effective strategies and techniques for repairing damaged reputations - Familiarity with Google's algorithms and guidelines for managing online reputations Involvement: - I prefer some involvement in the reputation management process - I expect the freelancer to take the lead and handle most of the work - And, I would like to be kept informed about the progress and any major decisions made Please provide examples of previou...

1.对添加到软件的资源进行浏览、添加、删除。资源包含Word、Excel、PPT、PDF音视频。 2.对访问软件资源的用户以账号形式进行权限管理，并可以通过管理账号进行用户账号的权限编辑。 3.如果是网页形式，需要能在本地和局域网进行访问网站。

I'm in urgent need of an experienced thumbnail creator to generate striking, vibrant thumbnails for various platforms such as YouTube, websites, and social media. *Style and Theme* Your designs should exude a colorful theme that's enticing and eye-catching. *Thumbnail Content* Each thumbnail should have captions incorporated in the design. The text should be readable without distracting from the overall appeal. To excel in this project, you need to be a skilled designer with a knack for creating visually stunning and colorful thumbnails. You should also have practical knowledge of designing for different platforms, and understand how to incorporate text seamlessly into your work. Past experience in a similar role will be advantageous.

I'm seeking an AI expert who can develop a highly accurate animal recognition system that specifically focuses on cats and dogs. The system should be designed to: - Achieve very high accuracy in identifying the animals - Differentiate between cats and dogs in the images - Prioritize the identification of the most prominent animal in an image In essence, the AI should be capable of matching a single photo of a cat or a dog to multiple images of lost animals in my archive, enabling me to identify the lost pet more efficiently. I expect the freelancer to have a profound understanding of artificial intelligence, machine learning, image recognition technologies, and ideally prior experience in developing similar systems. The system's accuracy and efficiency are essential, as...

...my YouTube channel. Your expertise lies not just in understanding social media algorithms and viral content, but also in having useful contacts within the industry. Key Responsibilities: 1. Manage my social media platform - Primary focus is on YouTube 2. Increase followers - Implement effective strategies to significantly boost the channel's followers 3. Boost Engagement - Develop creative strategies to increase audience interaction with the channel 4. Obtain Work - Use your contacts in the industry to secure potential collaboration or work opportunities for the channel. Please, abstain from creating and uploading video content, as this task is not required for this role. Ideal Candidate: 1. You have significant experience as a social media manager, speci...

I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to wor...

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

I'm seeking an experienced architect with a keen eye for modern design. The project involves creating a structure with a large floor area—over 5,000 sq ft. Key Responsibilities: - Develop architectural designs in line with modern styles - Include space planning and structural analysis Ideal Candidate: - Demonstrable experience with large projects - Proficiency in modern architectural design - Strong in space planning and structural analysis

Financial presentation on the analysis of two stocks with the help of the financial Discounted cash flow model that has already been prepared. You will need to complete:- 1. Powerpoint presentation slides 2. A 1000-word MS-Word document that will tell the speaker what needs to be spoken for each of the slides. 3. A 200-word reflection

I have a data entry task that involves inputting text data into a digital format (e.g., Excel, Word). The primary goal of this task is record keeping. Key Points: - Data Type: The task involves handling text data only. - Data Source: The data will be provided in a digital format. - Task Goal: The primary objective is to maintain records in a systematic way. Ideal Freelancer: - Proficient in Text Data Entry: The ideal freelancer should have experience with accurately and efficiently entering text data. - Familiarity with Excel/Word: Proficiency in using Excel and Word is necessary for the task. - Attention to Detail: Given that the task involves record keeping, the freelancer should have good attention to ...

I need a professional to convert my 1-page Word document into a .dotx file. This form needs to be minimalistic and easy to fill out. Key Requirements: - Convert an already laid out Word document into a .dotx file. - Include content control fields for a date picker, checkboxes, and empty text fields. - Design the form in a minimalistic and professional manner. Ideal Skills and Experience: - Proficient in Microsoft Word and creating fillable forms. - Knowledge of .dotx file format. - Experience with content control functions in Word. - Ability to design simple and professional forms. - Attention to detail to ensure the form is user-friendly. Please provide examples of similar work in your proposal.

I need a skilled developer to help me collect data from various websites to find a competitive edge. Key Requirements: - Prior experience in web data scraping - Ability to scrape data in real-time to ensure the information is up-to-date - Understanding of data analysis and how to interpret the results - Familiarity with competitive research The data collected will be used to inform my business strategies, so it's crucial that it is collected accurately and efficiently. Although not the immediate priority, I'm also interested in exploring the possibility of creating a discord bot and potentially web design in the future. A developer with experience in these areas would be preferred, though not essential. The developer must be located...

I am needing a committed and creative individual to aid in running a TikTok account focused on showcasing my product. Key Requirements: 1. Although the target audience includes parents, the content does not exclusively address them. Hence, your creativity should be versatile enough t...involve creating engaging, creative and viral-worthy content highlighting the product in various contexts. Ideal Skills: - Proven experience in TikTok account management - Expertise in creating viral content on TikTok - Strong product promotion skills - Excellent understanding of how to engage audience on TikTok This is a unique opportunity to show your creativity while promoting a product. Most importantly, relevant experience and a keen understanding of TikTok’s platform and audience a...

I am seeking an experienced market analyst who's knowledgeable about the logistics industry, specifically in the area of transportation and distribution. Key tasks will include: - Providing in-depth analysis of last mile delivery, including identifying and studying trends, challenges, and solutions. - Research and provide insights about effective entry points and custom clearance methods regularly used in the industry. - Investigate and analyze courier services, including their efficiency and impact on the overall distribution process. - Examine the use and effectiveness of locker and PUDO (pick up drop off) points in modern logistics. - Who are the main ecommerce sellers. Suitable candidates should have extensive experience in transportation and distribution within the l...

I'm seeking an experienced power app developer to build a small, yet crucial, data-driven application. The app will mainly focus on data input and storage, as well as calculations and analysis. Key Project Details: - The app should be capable of managing both text and numeric data. - The calculations and analysis will be unique, thus the need for custom scripts. The developer should be able to create the necessary algorithms and functions to support this. Ideal Skills and Experience: - Proficient in Power App development - Strong understanding of data input, storage, and calculations - Ability to create custom scripts for analysis - Experience with similar data-driven projects Please note that this proje...

I'm in need of a professional who can build a tool that scrapes product data from Walmart and exports it into an Excel spreadsheet. Key Requirements: - Develop a web scraping tool specifically for Walmart website - Extract essentials (price, upc, title) Skills and Experience: - Proficiency in web scraping using Python, Scrapy, or similar tools Please let me know your availability and estimated time for completion. This is an urgent project, so a quick turnaround would be highly appreciated.

...involves writing 3 comprehensive health-related articles. Each article should be 3000 words long. Key Requirements: - **Topic:** The articles should focus on sports - **Methodology:** The methods section in each article must be detailed with a critical analysis and comparative insights. - **Content Focus:** The articles should predominantly focus on recent studies, preferably those published in the last 5 years. Ideal Freelancer: - Proficient in health writing. - Capable of conducting in-depth research. - Experienced in critical analysis and comparison of studies. - Skilled in crafting engaging, informative articles. - Able to deliver high-quality work within the set deadline. This project is time-sensitive, with the assignment due on Friday 17th May. If you have the...

Hello I'd like you to create an ePaper module PCB used for an electronic shelf tag based on the ESP32 chip. This device is similar to what you would find at a modern retail store, dynamically updating the tag as prices change. Attached are schematics and references for my desired components. I'd like to use the new ESP32-C6-MINI-1-N4 unit as the main controller, as I'm very familiar with ESP programming already, and want to take advantage of its many connectivity options including BLE, Zigbee, and Thread. The ePaper display itself will be the Pervasive 2.13" display using the ZIF25 connector and SPI protocol. Schematics and additional reference details are attached, please read these carefully to ensure the ePaper display module functions accordin...

I'm seeking a skilled AI developer to prototype and document the technical requirements for an AI powered webapp. Key Project Details: - The primary AI functionality needed is in the area of text generation from user inputs and AI output. - Ability to build website prototype utilizing an AI API (most likely OpenAI) Ideal Skills and Experience: - Proficiency in AI development. - Experience in creating webapps or web design - Understand the technical coding languages required for this project. Please reach out if you believe you're equipped for this task in addition to a strong portfolio of similar projects to demonstrate your capabilities.

I'm looking for a Telegram bot expert to help me with several tasks. Please see attached document for specific instructions of job. Do not send a quote you are not able to do the job for!! - Automating Messages: I want the bot to send automated messages on my behalf - Resending Messages: You'll need to reword messages I receive and send them to my group While the project does not require any specific design or branding, it's crucial that you have a good understanding of how Telegram bots work and the ability to implement these features flawlessly. Ideal Skills: - Previous experience in creating Telegram bots - Proficient in Python and/or Node.js - Strong communication skills to ensure the bot functions as intended. - Must have great Englis...

...real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data...

I am looking for a proactive freelancer to help in setting up an affiliate marketing campaign targeting small business owners and tech enthusiasts. Since the specific IT skills for the campaign were not provided, the freelancer should be versatile enough to cover a broad spectrum of skills from programming, web design to data analysis. The campaign will be driven through the creation and distribution of blog articles, videos, and infographics. Therefore, expertise in content creation, particularly in those formats, is essential. In summary, the ideal freelancer should possess: - Knowledge and experience in Programming, Web Design, and Data Analysis - Ability to create engaging and informative content in form of blogs, videos, and infograph...

...Your primary task would be to recover deleted content from a PDF, despite the lack of the original for comparison. The recovered data will be utilized for data analysis. Key Details: - Urgency: The project needs to be completed within the next two days, so please only apply if you can meet this deadline. - Purpose: The primary objective is data analysis, so the quality and completeness of the recovered content is crucial. Ideal Candidate: - Strong Background: A professional with proven experience in digital forensics. - Time Management: Ability to work quickly and effectively to meet the ASAP deadline. - Attention to Detail: A meticulous approach to recovering, examining, and presenting the data. - Good Communication: The ability...

I'm seeking a skilled researcher to delve into the various challenges professionals face in their work environments in Jaipur, India. The objective is to pinpoint the key reasons behind th...coworking spaces, including factors like cost, amenities, and overall convenience. - Probe deeper into the less tangible aspects such as lack of awareness, ambiance, and the culture of coworking spaces. Ideal Skills: - Deep research on coworking spaces and its trends. - Proficient in market research and analysis. - Familiarity with Jaipur's professional landscape and coworking culture. - Excellent communication skills for potential interviews or focus groups. - Critical thinking to interpret the data and present actionable insights. DEADLINE - TODAY ANYHOW if you are i...

I am currently in search of a seasoned Business System Analyst with an ...stakeholders involved in the construction process. - Implement sales matrix and improve financial reports to provide more data-driven insights and decisions. Ideal Skills and Experience: - Proven experience in Residential and Commercial Construction. - Strong skills in business system analysis, project management, cost estimation, and stakeholder communication. - Familiarity with sales matrixes and financial reporting. - Experience in construction-related tech is a huge plus. In this role, you will play a signficant part in refining our operational and financial processes, as well as fostering more efficient communications in our company. Expertise in both construction and system analysis is c...

I'm in need of a skilled Python and C++ developer to create combinations of 2048 distinct objects, each with precisely 12 words. These combinations are intended for data analysis, so they need to meet specific statistical criteria. Key Requirements: - Create the combinations in Python and C++ - Ensure the combinations are statistically valid for data analysis Ideal Skillset: - Proficient in Python and C++ - Strong background in combinatorics - Experience with statistical analysis - Good understanding of data analysis techniques Once these combinations are generated, they will be utilized to conduct data analysis, so ensuring their accuracy and statistical relevance is crucial. Please only apply if you have...