Excel iif työt

FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...

Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel...

I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An unde...

I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in reshaping data i...

I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any projects rel...

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of the she...

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal ca...specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with ...

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

My Excel file is very heavy and unorganized. I want it to get cleaned and effecient

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'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 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...

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'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.

Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final

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 :

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

When replying, reply with the text: "Forensic 4 Project"...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 to co...

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 to hire a skilled Flutter developer to build a job portal app compatible with both iOS and Android devices. The main features to include in the design are: ...Developing the app on Flutter for both iOS and Android - Integrating all necessary employer and job seeker features - Ensuring smooth and easy navigation for optimal user experience - Complete the project on time as agreed( We need this to be completed in couple of weeks) - Sample design attached- Should be something like this or better than this.. This is an exciting opportunity for developers who excel in creating functional, user-friendly applications. An understanding of the recruitment process or previous experience in building job portal apps would definitely put you at an advantage. Looking forwar...

I need a web scraping expert to scrape Title, Price, star ratings, delivery window from a specific e-commerce site on a regular basis. - The scraping should cover a range of products, ideally with the ability to specify categories for tracking. - The data needs to be scraped frequently, so automation and scheduling will be crucial. - It's important that the extracted data is accurate and u...customer service. The ideal freelancer for this project should have: - Proficient experience in web scraping, particularly from E-commerce sites. - Proficiency in programming languages like Python or R for automation. - Good understanding of data management and quality control. - Ability to deliver a scraping tool that is user-friendly and maintainable in the long run. - Expertise in data entry ...

...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...