How to use excel pivot tables to organize datapráce
Potřebovala bych sestavit v Excel nebo v jiném programu algoritmy na manuální zadání nebo načtení přes SD kartu 8mi výstupů z měření na váze Tanita (množství tuku, viscerální tuk, metabolický věk, množství vody, ...) tak, aby se tyto hodnoty převedly do grafické analýzy v podobě grafů, "koláčů" či obrázků zatížení tuku na těle (podobně jak výstup z GMON tanita nebo InBody softwaru). Účel je pro použití pro výstup pro klienty výživového poradce a pro ios systém (MacBook Air). Hledám cenově dostupnou varientu, klidně pro cenovou efektivitu jen v Excelu, ale zajímaly by mě mož...
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
...woocommerce product to enrol in a course created in LearnDash… the products and courses are linked together by custom plugin… the custom pugin is migrated to the staging site and all functionalities working… when we started the development on the staging site, we duplicated the live site and restore it in the staging site, the development took 4 months, so in the last 4 months we don’t have the data on the staging site. That’s what we need to now migrate from LIVE to STAGING. We need to migrate Users, Users metadata, WooCommerce Orders, and anything related to users, and we need to migrate the learndash data which is the LMS plugin, and we have online classes, so some users have made progres...
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
...Facebook a jiné elektronické komunikaci, na potisku triček a jiného oblečení Chceme jednobarevnou variantu loga. Ukažte prosím logo jak na bílém, tak na černém podkladu - viz ukázka současného loga v příloze. Díky ---------------- We would like a new logo for club (company) that organize a women running coursers for beginners. Target customers: woman 25-35 years old, working, wants t start running. Logo shoud contain: - logotype hand written style: "jdu běhat" (it means in czech: I go to run) - and in smaller letters the subtitle: "běžecké kurzy pro ženy" (it means: running courses for women) - logo - pictogram with woman's running shoes ...
Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.
I'm seeking a proficient developer to create an AI agent for me. The agent's primary function will be to locate fitness-related businesses in multiple specific regions. The collected data will need to be organized into an Excel table, including details such as: - Name and website of the business - Location and contact details - Person name and job title An example of the task would be finding all personal trainers in Redcliffe, Australia, Postcode 4020. Ideal Skills and Experience: - AI and machine learning development - Data mining and web scraping - Proficient in Excel and data organization - Understanding of fitness industry would be a plus
I'm looking for an Excel expert who can help me create a file that meets specific conditions. Here's the situation: - I have an Excel sheet with 4 columns: address (A), city (B), state (C), and zip code (D). I want in column E to automatically display the word "IMAGE". However, this word should function as a trigger: when hovering over it, a photo corresponding to the location will pop up as a note. This needs to work for every cell in that column. - There is address list - I need this to be done in an automated way. Requirements: 1. I want to be able to understand the solution, so I need you to explain it to me via video call. 2. I have experience with Excel but have hit a roadblock, so a ...
...purpose of use, and lighting requirements should be specified. 2. Explanation of the Modeling Process and Modifications The modeling process using software such as Dialux should be explained. Any modifications made in the model compared to the real situation (e.g., replacing specific light sources with alternatives, adjustments based on ideal conditions) should be described. The reasons and methods behind these modifications should be clarified. 3. Scenarios and Parameters Different scenarios tested during the modeling process should be explained (e.g., varying light levels, different lamp types, daylight simulations). The lighting parameters used (such as light intensity, color temperature, glare control) should be specified. Acceptable minimum values, standards, and ...
I have an excel sheet consisting of about 5000 lines and about 15 columns. The data is a bit random and requires advanced logic to organize. Due to company restrictions, I can't share the excel sheet directly, but I can provide snapshots and detailed descriptions of the tasks and formulas required. Key Responsibilities: - Utilize advanced Excel formula logic to sort data into specific categories. - Implement conditional calculations, data aggregation, and advanced filtering as per the project needs. Ideal Skills and Experience: - Proficiency in advanced Excel is a must. - Prior experience in data sorting and organization. - Strong analytical skills to understand and apply the required logic...
Dear [Client's Name], I am excited to apply for this data entry project. With experience in handling various data types, including text and numerical information, I can ensure accurate and efficient entry from Excel, Word, and PDF files into designated platforms. I have a strong eye for detail, excellent typing speed, and proficiency in Microsoft Office tools, ensuring high-quality and error-free data processing. My commitment to accuracy and efficiency makes me confident in delivering results that meet your expectations. I look forward to the opportunity to assist you. Let’s discuss how I can contribute to your project. Best regards, Wan Zakwan Fitri
I'm looking for someone to help me create a line chart in a spreadsheet to display comparable equipment data. This chart will need to compare more than 3 sets of data. Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in data visualization - Strong analytical skills - Attention to detail Please provide examples of similar work you have done in the past.
I have a set of last year's ticket sale data that needs to be entered into Excel. - Data Entry: The tickets are currently in Excel 10, and I need someone to accurately input all relevant data. - Excel Skills: Proficiency in Excel 10 is crucial, as the data will be entered into this software. - No Analysis Required: At this stage, I do not require any data analysis or reports generated from the entered data. However, a keen eye for detail will be beneficial to ensure accurate data entry.
I'm looking for a professional data entry expert to help me input mixed data from various digital files. Key Responsibilities: - Accurately enter mixed data (text and numerical) from various digital sources into designated platforms. - The data source will primarily consist of digital files such as Excel, Word, and PDF. - Ensure all data is entered correctly and efficiently. Ideal Skills and Experience: - Proven experience in data entry, particularly with mixed data types. - Proficiency in handling and navigating through Excel, Word, and PDF files. - Attention to detail and ability to maintain accuracy under pressure. - Excellent typing speed and computer skills.
Job Description: We are seeking an experienced Microsoft Excel specialist to develop a dynamic and automated spreadsheet to monitor the status of a loan contract. The spreadsheet should efficiently track loan payments, calculate interest, and provide a structured yearly overview of the loan’s status, including the available credit line. The final solution must be compatible with both Microsoft Excel for Windows and Microsoft Excel for Mac. Project Requirements: Input Data: Loan start and end date Interest rate (%) Maximum loan amount (credit limit) Loan payment records (date and amount) Core Calculations: Interest calculation for each loan payment Cumulative interest tracking Available credit line (credit limit minus utilized loan amount) Ye...
I need immediate help from an Excel expert to identify why my total on one financial sheet doesn't align with the revenue summary on another sheet. The task needs to be completed within 15 minutes. Ideal Skills: - Proficient in Excel - Quick analytical skills - Able to deliver under time pressure
I need a proficient Excel expert who can create a comprehensive profit and loss sheet for my agricultural business. Key Requirements: - The spreadsheet should be able to track profits and losses on an individual job basis. - The design of the sheet should be intuitive and user-friendly, with clear delineation of different sections. Ideal Skills: - Proficiency in Excel and data analysis. - Experience in creating financial tracking tools. - Understanding of the agriculture industry. Please provide a portfolio of similar projects you've completed, as well as any relevant industry experience.
As a Site Verifier, you will verify a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Moo.10, Sukhumvit, Sukhumvit Rd, Samrong Nua, Mueng, Samut Prakan 10270, Thailand • Has a camera or phone/tabl...
Translator (Egyptian Arabic to English) – Technical & Programming Files Overview We are seeking a skilled translator with expertise in translating technical and programming-related content from Egyptian Arabic to English. The role involves accurately translating programming files, code comments, documentation, and other technical content while ensuring clarity, consistency, and proper technical terminology. The ideal candidate should have a strong understanding of both software development concepts and linguistic accuracy. Key Responsibilities Technical Translation: Translate programming files, code comments, documentation, and technical guides from Egyptian Arabic to English. Ensure translations maintain technical accuracy without altering the code’...
I need assistance to convert a PDF file into an editable Word document. The primary purpose of this conversion is to enable me to edit the text freely. The ideal freelancer for this project will have: - Strong attention to detail to ensure all formatting from the PDF is preserved in the Word document. This includes fonts, colours, spacing, etc. - Proficiency in Microsoft Word to handle potentially complex formatting. Please note, while the document does not contain any specific elements that need special attention, a general familiarity with handling tables, headers and footers, bullet points and lists will be beneficial.
...solution, as they all have purchase invoices to organize. The aim is to help them save time, optimize their accounting and better structure their financial documents. Core business: Invoice centralization EcoBill offers an online platform where companies can easily store, organize and retrieve their invoices. Key features - Centralized invoice storage - Easy import via file or photo - Organization and tracking for improved accounting management - Fast, structured access to facilitate financial management Automation technology is being developed to improve invoice processing, including automatic document recognition (OCR) and other tools to facilitate invoice import and classification. EcoBill also offers a loyalty option that enabl...
Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel.
...freelancer to design and implement a predictive maintenance system using big data analytics. The system should collect real-time sensor data (temperature, vibration, lubrication levels) and apply machine learning models to predict equipment failures. The goal is to optimize maintenance schedules, minimize downtime, and improve operational efficiency. Requirements: ✅ Data collection from real or synthetic datasets (Kaggle, HuggingFace, or generated data). ✅ Big Data technologies (Hadoop, Apache Spark) for real-time processing. ✅ Machine Learning models (e.g., Scikit-learn, TensorFlow) for failure prediction. ✅ Dashboard for visualization (e.g., Streamlit, Grafana). ✅ Clean and well-documented code (preferably in Python). Deliverab...
I have a spreadsheet that requires some help with data formatting, particularly with date and time entries. I need someone who can fix the incorrect date/time entries so that the spreadsheet is accurate and usable. Ideal skills for the job include: - Proficiency in Excel or similar spreadsheet software - Strong attention to detail - Experience with data formatting and troubleshooting
I'm looking for someone to help me organize my Gmail account. The primary goal is to categorize my emails into folders. Ideal skills and experience for the job: - Proficient in using Gmail - Experience with email management - Excellent organizational skills - Strong attention to detail
I'm seeking ... will need to be in French and include 5-7 pages of Excel sheets, featuring repetitive content. Key Aspects of the Project: - The most critical element of the presentation will be highlighting the company's growth potential. - The Excel sheets will be provided, so there will be no need for complex data analysis, but attention to detail and ability to present the data clearly will be essential. - Strong French language skills are a must, as is experience with financial presentations. Ideal Skills and Experience: - Proficiency in French, particularly in a business context - Experience creating financial presentations, especially for institutional investors - Ability to highlight key aspects of a business in ...
I'm seeking an experienced professional to design a compressed air piping layout for an industrial facility. The primary application of the compressed air will be for machinery operations. Key Requirements: - Design and layout of compressed air piping - Use of steel as the primary material for the piping - Consideration for industrial machinery operations in the design Ideal Skills: - Proficiency in industrial piping design - Extensive experience with steel piping - Knowledge of compressed air systems for machinery Please provide examples of similar projects you've completed, as well as your approach to ensuring efficient and safe design.
More details: Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? ASAP The target market for this project is tech companies. Targeting the global market for sales campaigns. The main goal is closed sales.
I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.
...professional data analyst with exceptional statistical expertise and experience in creating clear and informative data visualizations. The project involves analyzing pre and post data for two groups (Group A: ages 18 to 65 and Group B) and their various outcome measures. Key tasks include: - Conducting statistical analysis for all outcome measures across both groups. - Creating pre-post data graphs. - Preparing statistical tables and visualizations of these analyses. - Producing histograms or graphs depicting normality. - Calculating effect sizes. The ideal freelancer for this project would be highly proficient in statistical software and data visualization tools, with a proven track record of similar projects. Clear and concise comm...
Vlog Editing & Video Editor Description Are you looking to transform raw footage into compelling, high-quality vlogs that captivate and grow your audience? We’re searching for (or offering) a skilled Video Editor who specializes in vlog editing and is adept at creating attention-grabbing thumbnails. The ideal candidate stays on top of the latest editing trends, YouTube best practices, and storytelling techniques, ensuring each video engages viewers from start to finish. Key Responsibilities Video Editing & Storytelling Review and assemble raw footage into a cohesive story that highlights the best moments. Perform color correction, audio mixing, and seamless transitions to maintain professional consistency. Incorporate motion graphics, titles, and lower-...
...professional data analyst with exceptional statistical expertise and experience in creating clear and informative data visualizations. The project involves analyzing pre and post data for two groups (Group A: ages 18 to 65 and Group B) and their various outcome measures. Key tasks include: - Conducting statistical analysis for all outcome measures across both groups. - Creating pre-post data graphs. - Preparing statistical tables and visualizations of these analyses. - Producing histograms or graphs depicting normality. - Calculating effect sizes. The ideal freelancer for this project would be highly proficient in statistical software and data visualization tools, with a proven track record of similar projects. Clear and concise comm...
I need a freelancer to fully set up two websites using a paid WordPress template that I will provide. The freelancer must handle everything from design setup, image selection, keyword research, and SEO content writing (100% AI-proof and unique). Scope of Work: Website Setup & Customization – Install and set up the provided WP template, organize pages, and ensure a professional layout. Image Selection & Optimization – Find high-quality images, Logo design, edit if needed, and optimize them for web performance . Keyword Research – Identify high-ranking, low-competition keywords for SEO. Content Writing (100% Unique & AI-Proof) – Write engaging, SEO-optimized content that passes AI detection and plagiarism checks. On-Page SEO – Optimize...
...for a developer to create a cross-platform mobile application (iOS and Android) similar to Uber, BlinkIt, or Urban Company. The app will primarily be focused on service booking and scheduling. Key Features: - The app should support two main user roles: Customers and Service Providers. - An intuitive interface for both user types is crucial, allowing customers to easily book services and service providers to manage their availabilities and bookings. - An administrative backend to oversee operations and manage users will also be necessary. - Payment Integration: Enable secure in-app payments via credit card, debit card, and popular payment gateways like PayPal and Stripe. - Geo-Location Services: Integrate location tracking to find nearby servic...
I'm looking for a skilled data scraper who can extract all available information from a specific e-commerce website. This includes, but is not limited to, product details, customer reviews, and pricing information. I need all available information. Please consider that there are also product variants. Work needs to be done today! The ideal candidate should: - Have a strong background in data scraping - Be proficient in using data extraction tools - Have experience dealing with e-commerce websites. The scraped data should be delivered in an Excel format. Please note, this is a one-time project, I do not require ongoing data scraping. If you read everything, please write "DATA" in your message.
I'm looking for a skilled developer to create a web-based stock market application enriched with AI capabilities. The app should allow users to query data from several database tables using Natural Language Processing (NLP). I prefer the use of Open AI or any other affordable and reliable alternative. Key Features: - User-friendly UI for both regular users and admin - Admin panel with options for query monitoring, usage tracking, limit settings, etc. - Basic user authentication system with email and password The application will need to integrate with various Stock Market APIs. Ideal Skills: - Proficiency in web application development - Experience with AI and NLP - UI/UX design skills - Knowledge of Stock Market and AI api - Backend devel...
...first book, which I plan to publish independently. The book will focus on how ma nagers can effectively handle difficult personalities in the workplace. The working title is Mastering Workplace Dynamics: How to Lead and Manage the Most Difficult People. I’m seeking an experienced book writer who can help me bring this vision to life. The writer will work with me to develop the manuscript, refine the structure, and ensure the content resonates with the target audience. Scope and Word Count: Word Count: Approximately 50,000 - 75,000 words The book will be divided into chapters, each focusing on a different difficult personality type found in work environments. Target Audience: This book is intended for managers, team leaders, a...
I need a skilled data analyst and visualization expert to create an interactive dashboard to track and analyze my online sales data. The dashboard should connect to a variety of data sources, primarily my sales database. Key Responsibilities: - Use complex parameters to drill down in the worksheet and customize using filters and slicers. - Create connections, join new tables, and perform calculations to manipulate data and enable user-driven parameters for visualizations. - Use different types of customized visualizations (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicer, etc.) The primary purpose of this dashboard is to track sales performa...
I need a skilled video creator to plan, shoot, and edit 30 engaging Instagram reels each month. The primary goal of these reels is to enhance brand awareness. Key Responsibilities: - Collaborate with our team to conceptualize, plan, and execute 8-10 engaging content pieces per week. - Stay updated with the latest video editing trends and tools to enhance content quality. - Maintain and organize video files for easy access and future use. Ideal Skills: Proficiency in video recording and editing, with a strong portfolio showcasing past work. Must own an iPhone for video recording and editing. Creative eye for detail, storytelling, and visual aesthetics. Strong time management skills to meet tight deadlines. Ability to work both indep...
...Coursera, and other platforms. post content on various platforms like medium substack vocal media ✅ Handle call-to-action campaigns, SEO, and social media promotions. ✅ Research and implement growth strategies to expand online reach. ✅ Assist in executing new ideas, business strategies, and brand promotions. 2️⃣ Marketing Personnel (Part-time) ✅ Flood the web with the company's banners, posters, and videos. ✅ Handle mass content distribution across multiple platforms. ✅ Assist in basic marketing tasks & repetitive work. ? Flexible work schedule, long-term opportunity for the right person. ? Apply with your experience in digital marketing and content execution. Please ensure to track social media engagement as a key performance indicator. We are looking...
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
