Excel formula help need onetomany vlookup type of formulaроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Щось перекласти Три роки працюю редактором/копірайтером/новинним журналістом. Фріланс- як сенс життя
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Щось перекласти Знання англійської мови на рівні B1, переклад текстів будь-якого стилю, грамотність гарантована)
ЦЕ продаж плєдів, з новим дизайномІ мені потрібно тексти на сайт , тобто опис, чому саме у нас і тому подібне
Працювала в торгівлі, торговим агентом,зараз в декреті. Маю вищу юридичну освіту. Українська-рідна мова, англійська, російська-базовий рівень.
Написати кілька статей Психологія та поведінка людей
Написання контенту Website . Carpet cleaning. Content
Щось перекласти Вільно володію українською, російською та англійською мовами, а також середній рівень знання французької мови
Написати кілька статей Берусь за будь-яке написання текстів
Щось перекласти Переклад текстів з англійської мови на українську
Щось перекласти Рівень знання англійської мови- високий тому перекладати тексти різних видів не є складним завданням,залишається хоббі ще змалку.
Щось перекласти Близько 10 років займаюсь перекладами з польськоі мови і навпаки. Найближчою є мені юридична, економічна тематика.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
...Requirements: - Extracting Seller Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is cru...
I'm looking for an experienced business planner to help create a detailed business strategy for my upcoming baby milk infant formula brand in Saudi Arabia. I'm targeting a wide range of age groups, from newborns to toddlers, including specialty formula. Key Elements: - **Market Analysis**: This should outline the current market situation in Saudi Arabia, including competitors, market size, and trends. - **Financial Projections**: The business plan should include detailed financial projections over the next 3 years. This will be crucial for securing investments and planning our growth. - **Marketing Strategy**: I need a comprehensive marketing plan that will help us effectively reach our target audience in Saudi Arabia. - **Pricing Struct...
...with specific experience in image especially video analysis to create a script that can process a full mp4 video and identify the positions of noise in the video. The idea is to scan the video, locate identify the different type of noises and their value and externalize this findings into a json file Key Requirements: - The script (OOP based) should be able to read a video in mp4, mkv, mov format. - The library used for reading the video is not fixed. You can choose from libraries like (e.g. OpenCV, PyAV, or MoviePy, but the solution should be compatible with both Windows and Linux (and mac) - The output should have details of the signal, the different type noises, the common ratios and finally the values ... - the frame number ... - the time positio...
I'm in need of a skilled statistician with expertise specifically in regression analysis, particularly with survey data. The dataset I have comprises between 10-20 variables that need to be analyzed in a regression framework. Key Points: - Crombach Alpha testing - Factor analyses - Regression Analysis: You should have a deep understanding and experience in applying regression analysis to survey data. - Survey Data: Experience with survey data is crucial as the analysis needs to be tailored to this type of dataset. - Variable Management: Managing a dataset with between 10-20 variables is a specific skillset. Ideal Skills: - Proficiency in Regression Analysis - Experience with Survey Data - Proficient in Variable Management and Analysis Your abili...
...dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creator to develop a dashboard consisting of...
Напишите код на Python, который будет использовать мои модели Azure Doc Intelligence для обработки загруженного PDF, затем использовать извлеченные данные и создать таблицу в Excel с ними
...and efficient ordering with swift delivery, ensuring customer satisfaction and loyalty. Purpose of the Brand Guide: This document will serve as the authoritative guide for all DankDrop branding efforts. It will ensure consistency and cohesiveness across all platforms and media, reflecting the brand’s sophisticated and professional image. 1. Logo Usage Standard Logo: High-resolution image of the existing logo must be included. Alternate Logos: Show any alternative logo versions and specify appropriate use scenarios. Size Specifications: Define minimum and maximum size constraints. Exclusion Zone: Outline required clear space around the logo. Incorrect Usage: Provide examples of improper logo treatments. 2. Color Palette Primary Colo...
I am in need of a proficient data entry expert to help input numbers from online sources into an Excel sheet. These numbers should be entered as plain numerical values. Key Requirements: - Competence in Excel and data entry - Attention to detail - Ability to extract numeric data from online sources. Based on the nature of this project, having a background in data mining could be a bonus, but is not mandatory. The successful freelancer should have a keen eye for detail and be able to accurately enter numbers without errors. Accuracy and speed are both key in order to complete this project successfully.
I'm in need of a freelancer who has expertise in Excel for a massive data entry project. The sheets are more complex than usual, carrying over 500 rows and columns. Key tasks within the project include: - Data typing that entails input of text, numbers, and dates - Use of a structured data format for effective input The ideal candidate should possess a keen eye for detail to maintain data accuracy, strong familiarity with Excel, and speed typing skills. Prior experience in large Excel data input is also desirable.
...that requires expertise in telecommunications, specifically in designing point to point communication systems like simplex, duplex, using radio as the communication type. To see this project to its fruition, I will need a professional who can design a communication link with various parameters. Thereafter, we'll need to carry out Link-level modeling and simulations in Matlab. The ideal candidate should: - Have a solid understanding of point to point communication systems, specifically both simplex and duplex systems. - Be proficient in using MATLAB for simulations. Following the simulation, we'll analyze the performance of our designed system using several metrics. For the simplex system, we would be interested in assessing its: - Error ...
I'm on the... - An integration of multiple payment options for ease of transactions. - A Review and rating system to obtain and show feedback from users. - Google map embed API for accurate location tracking. - Ability to handle complex fare calculations. - An automatic accept feature to streamline the booking processes. - Options to choose from various rates. - Driver and rider separate console. - Driver application form. - Feedback. - Vehicle condition monitoring. The project also calls for the creation of a comprehensive vehicle selection, which includes: - Non-AC and AC Sedans. - Non-AC and AC SUVs. - Non-AC Hatchbacks and AC Hatchbacks. - Bikes. - Autos. Programmers with experience in booking platforms, API integrations and responsive web design will be id...
I need a proficient Excel professional to efficiently manage data entry and cleaning tasks. The responsibilities of the chosen freelancer will include: - Entry of both numerical and textual data into Excel from various sources. - Pre-entry cleaning and categorization of the provided data, ensuring it's thoroughly structured and void of errors for optimum usage. Ideal Skills and Experience: - Proven experience in Excel data entry and data cleaning. - Highly detailed oriented and organized. - Excellent communication skills to report progress and any issues encountered. - Ability to work within strict deadlines. This role requires a keen eye for detail, a high level of organization, and the ability to handle numerical an...
I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.
I have a large Excel sheet that needs to be typed in, and then analyzed for trends using a variety of statistical analysis techniques. Key Requirements: - Data Entry: The project involves a substantial amount of data that needs to be accurately typed into Excel. This part of the project requires a detail-oriented and precise freelancer. - Trend Analysis: Once the data entry is complete, I need you to analyze the data for trends. This requires a good level of understanding and experience in trend analysis. - Statistical Analysis: The project also involves performing a range of statistical analysis on the data, including: * Descriptive Statistics: This will involve summarizing the main aspects of the data set, such as mean,...
...vibrant and appealing to a young and trendy audience. - **Color Scheme:** I'd also need some assistance with choosing the color scheme for each product type. This means you should be able to suggest different color combinations for t-shirts, hoodies, and sweatshirts that will best complement the design and appeal to the target market. Ideal candidates for this project should have: - **Proficiency in Marathi:** Essential for crafting slogans in the desired language. - **Experience in Apparel Design:** A background in creating design elements for clothing will be highly beneficial. - **Creative Flair:** The ability to come up with fresh and funky design concepts. - **Color Theory Knowledge:** An understanding of color psychology and how different color schemes ...
I'm in need of a talented 3D designer that can create realistic renders of melamine furniture pieces. - The furniture type is melamine, and it will consist of a combination of kitchens, wardrobes and tables. - The finish for this furniture is a custom color, which will be provided by me. - I'll need the designer to work on standard dimensions for the pieces, as I don't have specific measurements. Ideal Skills: - Proficiency in 3D design software - Experience in rendering furniture with decorations - Ability to work with custom colors - Understanding of standard furniture dimensions - Attention to detail and a keen eye for realism Please provide samples of previous work in a similar vein.
I'm looking for a voice recording of 2.5 hours to be used for a personal project. This project is for a radio show, so high-quality is crucial. Only native American English accents will be considered. Ideal Freelancer: - Native American English speaker - Experience in voice recording - Understands the nuances of radio shows Data type: long audio conversation Data format: 48k 16bit two single sides + mixed (at least 32K) Content: You need to communicate around the 6 topics given, 25 minutes for each topic Male to female ratio requirement: one to one (adults over 18 years old) Number of people: 100 people in total (the specific amount depends on the allocation) Delivery documents: 1) Recording file: audio requires 16bit 48000hz 2) Zoom settings, ...
I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.
I'm looking for a skilled analyst to examine and arrange a substantial set of numerical data using Excel. The primary purpose of this project is to facilitate thorough data analysis. However, the data's arrangement or layout has yet to be defined, and I'm open to suggestions from the freelancer on how best to structure the data for optimal analysis. Ideal Skillset: - Strong background in data analysis and numerical data - Proficient in Excel, including its advanced functions - Ability to suggest and implement data arrangement strategies in Excel This project will require strict attention to detail and excellent organizational skills. So, if this project is up your alley, don't hesitate to bid.
I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the data model as it is on...
I have a variety of documents that I need typed. This includes Word documents, PDF files, and handwritten notes. Each of these documents is between 10-50 pages in length. Key Requirements: - Typing of Word documents, PDF files, and handwritten notes - No specific formatting required Ideal Freelancer: - Proficient typist with excellent attention to detail - Familiarity with Word, PDF, and handwritten notes transcription - Able to deliver accurate and timely results on multiple documents of varying type and length
Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. U...
I'm urgently requiring ...should ideally have extensive experience in HR dashboard creation and a strong understanding of HR-related metrics. Key Features: - The dashboard should prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into easy-to-understand visuals. A truly comprehensive understanding of HR metrics and how to effectively displ...
