Excel tips and tricks 2013 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.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
...seeking a proficient account manager or customer success manager to concentrate on developing strategies to bolster customer satisfaction. This is to go over data in a QBR I have a task. The task will tell you the company and the hypothetical situation to complete- almost as if you are an interview. There will be two parts. The first part do some research on the company and the competitor mentioned. The second is to look at the data I’ll provide on excel I need you to follow the steps in the task write the answers in a presentation. The task involved analysing data (only excel not code!) The price is fixed for this. 40 pound. If you are skilled in this it should take no longer than an hour to source information then basic presentation skills. Pleas...
I'm in need of a professional eBay manager to assist with the overall handling of my store....specifically want focus on include: - Listing Optimization: The right candidate will ensure every product is meticulously listed to maximize visibility and conversion rates. Essential skills will include pricing strategy, keyword research and photography. - Order Fulfillment: Ensuring that every order from my store is correctly fulfilled in a timely manner is crucial. The ideal manager would excel in order tracking, packaging, shipping, and ensuring customer satisfaction. Given the comprehensive nature of the role, the ideal manager should be well-versed in the eBay platform and have exceptional organizational skills. Good customer service and soli...
...cosmetics company we need to record all ingredients that we buy with their associated data. Then when we make a product using all of the ingredients we need to record per batch which ingredients we use. Example attached and detailed information below: Please see attached spreadsheet and below explanation of each point as well as what we are trying to achieve. Sorry it is a bit long winded but hopefully this explains why we need help!! Ingredients Master Tab Currently: • KAN Unique Code o When a product comes through the door it goes into a box. I then go through this box and write on it with a marker pen its own unique number. This unique number is then placed into Column A • Product Name / Manufacturer / Product Expiry Date / Manufacturer Record Number...
...site setup and sales funnel creation for my upcoming business. Here are the specifics of my project: - Website Design: The design would cover approximately 1-5 pages. The primary focus would be on crafting a visually appealing, user-friendly and professional-looking website. - Membership Site Setup: I intend to set up a membership site with a basic structure, including a few different levels of membership and resources. Understanding the nuances of membership site setup within Kajabi is a must. - Sales Funnels Creation: I need a sales funnel that converts effectively. Your previous experience in creating and implementing high-performing funnels is highly desirable. specifically: 1. WEBSITE HAS BEEN LAID OUT, NEED TO FINISH IT 2. SET UP REGISTR...
...for an individual with proficiency in Microsoft Excel and Microsoft Word to assist me in generating delivery notes. For this project, your tasks include: - Reading data from an Excel spreadsheet and populating it into a Word template for the delivery note. The data to be transferred includes: customer names and addresses, item descriptions, and quantities. - Automating this process for all entries in the spreadsheet in such a way that each entry generates a separate delivery note automatically. - Replicating this delivery note for all the 92 notes captured in the Excel spreadsheet. In addition, you will be creating a PDF copy of each finished delivery note. Possessing experience in visual basic for applications (VBA), data proce...
I'm in need of a skilled Excel data entry operator who can take on the challenge of working with more than 5 files of intermediate to complex data. The ideal candidate should be able to comfortably handle the following tasks: - Data Entry and Formatting: Efficiently input data into Excel sheets, ensuring it’s formatted accurately to maintain consistent, clean data sets. - Formulas and Functions Creation: Develop and implement essential Excel formulas and functions to streamline calculations and data manipulation. - Data Analysis and Reporting: Use Excel’s analysis features to interpret the data, generating informative reports to drive decision-making. Strong fluency in Microsoft Excel, proficiency with...
I am in need of a capable individual who can jugg...capable individual who can juggle a few tasks, namely copywriting, data entry, and account management. This position is open for only US. • Copywriting: The ideal candidate should be able to effectively write content for our website, product descriptions, and marketing material. Good command over the English language is crucial. • Data Entry: Accurate and efficient data input skills are required. Experience with Excel and other data entry platforms will be useful. • Account Management: The ability to efficiently manage and maintain client accounts is essential. Experience at an entry to intermediate level (0-5 years) in these tasks is required. Overall, I'm seeking a reliab...
I urgently require an expert to lift protection from a VBA macro in my Excel 2007 document. A complex password (10+ characters, including symbols) protects the macro. Here's what's needed: - Thorough understanding of Excel 2007 and later - Proficiency in dealing with complex passwords - Demonstrable experience in unlocking protected VBA macros The document itself is not password-protected and remains accessible. However, the VBA macro within is locked. I am specifically looking for a problem-solver with a track record in removing complex macro passwords without affecting the functionality of the macro. Please only apply if you meet these criteria.
...top-notch customer service and sales solutions in the healthcare industry. We prioritize excellence in every interaction and strive to deliver optimal health solutions to our valued customers. Job Description: We are seeking a dynamic and experienced Call Center / Customer Service / Sales Expert to join our team. The ideal candidate will be proficient in utilizing VICIDial and possess extensive experience in voice-based customer service and sales roles. As part of our team, you will play a crucial role in delivering exceptional service to our clients and driving sales conversion initiatives forward. Responsibilities: Utilize VICI Dialer efficiently to manage and handle customer interactions effectively. Provide exemplary customer ser...
Hi Subhash As discussed, project for the 400+ pages of data entry. For Tuesday please. Thanks ! Always a pleasure
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I require an expert in excel that won't need more than 20 mins to fix a sheet with some pivot tables.
...developer to create software capable of extracting data from two provided excel sheets, designed to generate 50 unique outputs. The ideal candidate must: - Have proficiency in Python programming. - Exhibit understanding and competency in handling Excel documents and their formatting. - Display excellent data management competency especially in text, numbers, and dates extraction. The tasks involve: - Extracting data from two existing Excel sheets that contain different data forms involving text, dates, and numbers. - Only simple extraction is needed based on the criterias given and no complex calculations will be required. - Generating 50 individual excel sheet outputs from the extracted data. Experience in data extrac...
Project Description: The task involves sourcing free online images of sneakers and Apple products, including Macs, iPads, and Apple Watches, from websites such as Unsplash, Pexels, and Pixabay. Each image should be accompanied by a hyperlink leading to a website hosting the image, specifically Google Photos. An example is provided in the Excel sheet. Additionally, the release price of each sneaker should be listed in the Excel sheet. For instance, Nike's Air Jordan 3 was released in 2023 with a price tag of $200. I am willing to pay a reasonable price for this work. Furthermore, if the job is done well, I have more work to offer. The excel sheet is attached below. Sincerely,
Hi Subhash, As discussed over the chat, I would have a part 2 of the same project. I sent you the pdf over the chat. Thanks
I am in need of a professional who is proficient in Excel data manipulation. The task involves extracting particular formulas from multiple linked spreadsheets while ensuring to retain original cell formatting. This will require a good command of spreadsheet functions and demonstrable experience in handling linked data. The details of the job include: - Exporting formulas from Excel sheets - Keeping original cell formatting - Handling and maintaining links to other spreadsheets Ideal candidate should possess following skills and experience: - Advanced Excel proficiency - Experience with data exporting - Attention to detail in preserving formatting - Familiarity with managing linked spreadsheets.
We need SEO copywriters for writing large amounts of key. Requirement: more than 2 years experience in SEO content, 1./ Area: IT, such as: how to use topics, tricks for internet, etc. 2./ Language: Vietnam, English. 3./ Skills need: Content SEO, Writing, Content Marketing Analysist.
I am seeking an expert in wireframe design to help me with specific renovation tasks. These include: - Redesigning and rearranging the current layout to simplify the design. - Enhancing the navigation of the wireframe by; a) Making it more intuitive. b) Adding clearer labels. c) Streamlining the user journey. To excel in this project, you should have a strong eye for detail, exceptional spatial awareness, and superior user experience know-how. A deep understanding of visual hierarchy principles and wireframe tools will also be greatly beneficial. The ultimate goal is to simplify the user journey and improve the overall aesthetic and functionality. Your ideas and expert input will be highly valued as we work together to enhance th...
...comprehensive resource designed to help businesses maximize their online presence and achieve their marketing goals. This exhaustive guide covers all aspects of digital marketing, including search engine optimization (SEO), online advertising, social media, content marketing, and data analytics. It offers practical advice, inspiring case studies, and proven tips to help businesses succeed in the ever-evolving digital landscape. Project Details: • Content: The guide will include several detailed chapters on different aspects of digital marketing, each accompanied by real-world examples and practical tips. • Additional Resources: In addition to the guide, supplementary resources such as templates, spreadsheets, and checklists ...
I am seeking a detailed-o...specifically software development, network administration, and data analysis - Proven experience in recruiting entry-level candidates - Strong knowledge in Microsoft Office; Excel, Word and PowerPoint in particular, as they are crucial skills for the roles Responsibilities: - Ability to assess the candidate's proficiency in basic IT skills efficiently - Ability to quickly and accurately vet candidates - Keeping track of all applicants, interviews, and positions filled This project requires a recruiter who has experience in the IT sector and a proven record of successful entry-level placements. A keen understanding of Microsoft Office Suite is essential. An ideal candidate would be someone who is excellent at as...
Hi, I need the following: 1. Get data from a EC website: store name, store details, product details etc. 2. Format: excel file
For my project, I am seeking a meticulous freelancer with strength in data entry. Here's what the task involves: - Entering text-based data sourced fro...strength in data entry. Here's what the task involves: - Entering text-based data sourced from various online resources. - Accurately translating the information provided into an Excel spreadsheet format. The ideal candidate should possess solid data entry skills, attention to detail, experience with Microsoft Excel, and an ability to efficiently surf the web to locate crucial data. A basic understanding of the privacy concerns associated with handling online data will also be advantageous. In summary, I need an efficient individual who can quickly turn online text-based data into ordered and pro...
In need of an experienced Quantity Surveyor who can efficiently deliver on my project by: * Generating an accurate bar bending schedule * Precisely estimating quantities Your proficiency in using Excel and AutoCAD for these tasks is fundamental. This task necessitates immediate attention therefore a capacity to work swiftly and effectively is crucial. Previous experience in a similar role and immediate availability will be favorably considered. Looking forward to your bids.
I'm seeking an expert to craft an automated solution for loading values from TradeStation Data Window into an Excel file on an hourly basis. Essential skillset includes: - Proficiency in TradeStation and Excel - Experience with data extraction - Understanding of financial data, specifically stock prices, financial indicators and volume data The successful freelancer will be tasked with ensuring a seamless automatic extraction from all areas of the Data Window. An understanding of financial market data and how it is structured within TradeStation will be crucial to job success. Please, note this work's focus is on the automation process, ensuring hourly updates without manual intervention.
More details: What specific tasks do you need help with in Excel and accounting? Financial statement preparation What kind of data do you need analyzed and reported? Financial Data Which specific metrics in operational data do you want analyzed? Preparing trial balance and other calculations in Excel
I am looking for an individual with stellar Excel abilities to help me enter under 100 entries. The data input will be simple, related to basic info such as names and emails. A strong attention to detail and speed are crucial for this role. Ideal skills for this job would include proficient use of Excel, quick and accurate typing, and a solid understanding of data privacy principles. Prior experience in a similar data entry role would be a plus.
More details: What specific tasks do you need help with in Excel and accounting? Financial statement preparation What kind of data do you need analyzed and reported? Financial Data Which specific metrics in operational data do you want analyzed? Preparing trial balance and other calculations in Excel
...to keep the audience engaged. - Incorporating b-rolls to enhance the narrative. - Creative use of music and sound effects. - Visually appealing graphics. Proficient editing skills are imperative, understanding of storytelling through editing, and experience with relevant software. Ability to maintain a consistent style - jump cuts and cut-in shots, are a plus. Preference would be given to those who excel at conveying complex ideas in a simplified, easy-to-understand manner and you will be paid 15 dollars per video and the price will be increased according to the performance of the video. To get shotlisted you will be required to create a test video of 8-10 minutes from the raw footage and b rolls that I will be providing . The final vid...
Hello, we work in telecommunications and trading "capacity" such as submarine cables, satellites, fiber, etc. is very complex as every hour we get a lot of requests and offers - tracking these in an excel takes a lot of time and we lose opportunities. I need an AI based tool that : 1 - structure on an excel file or Sql database ALL the capacities that we have and that keep coming every hour. I will provide the structure and the route 2 - a tool that reads in my emails and whatsapp conversation and can extract and fill the database. For example "hello Tony, how are you - I have an urgent need of 100MB of Internet in New York, my target price is 10K USD" -- this would have to be properly read, extract...
...as SEO, SMM, Paid Ads, and website development. With a strong client base and a proven track record of success, we are expanding our team of sales representatives to reach new markets and drive growth. **Job Description:** We are seeking highly motivated and energetic individuals to join our team as Remote Sales Representatives. In this role, you will be responsible for reaching out to potential clients via phone calls, pitching our services, and closing sales. This is a work-from-home opportunity, allowing you to work flexibly and remotely. **Key Responsibilities:** - Make outbound calls to prospects provided by the company. - Present and pitch our digital marketing services to potential clients. - Build and maintain strong cu...
...programming and trading strategies. Here's the outline of the requirements: Conversion of Existing Supply Demand Indicator: The programmer should be able to take an existing Supply Demand indicator which is already in NinjaTrader 8 and add Plots. Tags so I can use it in strategy builder and trade. or convert to strategy. Creation of Plots and Tags: Plots and tags are essential for visualizing supply and demand zones on the chart. The programmer needs to create plots that accurately represent these zones, making them easily identifiable for the trader. Tags should provide additional information or labels for each zone, such as strength, probability of reversal, etc. Development of Auto-Trade Strategy using ATM: The programmer must design a t...
Here's what I need: - Conversion of my PDF file to Excel. Each page of the current PDF must be transferred onto a separate sheet within Excel. - Absolute precision is critical in the conversion, it needs to be 100% accurate. Double-checking of the converted data against the original PDF is expected to confirm accuracy. - The PDF holds only text data, there's no requirement for converting any figures or tables into Excel. Ideal candidates should have: - Proficiency in data entry - Attention to detail to ensure error-free data conversion - Experience in converting PDF files to Excel - Ability to proofread and find any errors in the converted data.
...data and perform some basic mathematical operations on it. The final output should be in the form of excel sheets. Key tasks would include: - Data operation: Efficiently manage large amounts of numeric data - Calculation: Perform basic mathematical operations on the data - Data formatting: The final output should be well-organized excel sheets An ideal candidate for this project will have proven experience in data management and Excel spreadsheet functions. Attention to detail and accuracy in conducting calculations is crucial. Familiarity with basic mathematical operations is a must. A background in data analysis or related field would be a plus. This project requires technical skills in Excel and a keen understanding of da...
I'm in search of a seasoned freelancer with proficient skills in Excel data entry. Tasks will primarily involve the input of a mix of numerical and textual data into spreadsheets. Desired Skills: - Moderate expertise in Excel for creating and applying straightforward formulas. - Experienced in data entry from various sources. - Attention to detail with the ability to accurately compile and enter mixed data. The ideation candidate should have a proven track record of handling similar data entry tasks. Your role will be integral to the organization and interpretation of vital information, hence, precision and consistency are paramount.
I'm in...of a meticulous researcher with strong data mining skills to uncover detailed contact information related to specific mobile phone numbers. I have First nameLinkedIn, email, last name and I need a complete direct phone number and mobile number Primary Task: - Retrieve contact details, specifically direct phone number, mobile phone numbers. Required Sources of Information: - Search through public directories. - Utilize social media platform insights. - Access telecom databases. Ideal candidate should have a demonstrated history of effective and compliant data mining. They should excel at search strategies and have familiarity with browsing multiple types of databases for information retrieval. A background in telecom, information technolo...
I'm in need of a seasoned professional to create a dynamic, easily fillable form in either Word or Excel. This form needs to be highly versatile, accommodating various input types and behaviors. Key features desired include: - Conditional color changes based on text inputs, selections from dropdowns, and checkbox checks. - Seamless conversion to PDF once filled out by our team. Expertise in creating dynamic, interactive forms and firm understanding of input condition coding are essential in order to be successful in this project. I need this project completed as soon as possible, so proficiency under tight deadlines is another critical skill. Attached is the template form for your reference. The template I attached was designed by one of our employees, ...
I need a freelancer adept at Excel and Visual Basic for Applications (VBA) to assist with a project that necessitates basic data manipulations and formulas. The application is primarily dealing with both numerical and textual data. The ideal candidate should possess: - Proficiency in Excel functionalities and VBA scripting. - Experience with handling diverse data types like texts and numbers in Excel. - Ability to quickly comprehend and effectively manipulate data structures using VBA. Kindly submit your bids if you meet these requirements and can efficiently solve complex data problems.
...in various formats; PNG, JPEG, and PDF. Key Responsibilities Include: * Accurately entering invoice data into Microsoft Excel spreadsheets. * Ensuring adherence to specific formatting requirements, details of which will be provided upon project commencement. A deep understanding of Microsoft Excel and precision in data entry is crucial for this role. Experience with processing invoices is highly desirable. Attention to detail and maintaining the integrity of confidential information are also essential for this project. Project Description: We have a pressing requirement for a meticulous and detail-oriented freelancer to assist us with data entry tasks. We possess over 150 Invoice Documents related to Cargo shipping, which primarily come in...
I am looking for a skilled and creative video editor who can present product tips in short, inspirational videos that reflect an Alex Hermozi style. The completed videos should be less than 30 seconds in length, making every single second count. Ideal Skills And Experience: - Proven ability in short form video editing - Experience in creating experimental and inspirational content - Previous work with product showcases would be advantageous - Familiarity with Alex Hermozi's style of video editing - Ability to deliver high-quality work under tight deadlines Key Project Aspects: - Material will focus on providing tips for products - Consistently inspirational and impactful tone - Alex Hermozi style, with a unique personal touch. Will hire fu...
...folks and get the work done. Track in Excel. This all, apart from his core SAP PP/WM ( Warehouse management ). SAP PP/WM Expertise: In depth understanding of SAP PP/WM modules including configuration, customization, and integration with other SAP modules. (Min 2 e2e implementations) Strong understanding of SAP Printing functionality and setup Ability to troubleshoot SAP Printer issues in PP/WM disciplines Proficiency in SAP PP functionalities such as MRP (Material Requirements Planning), production orders, capacity planning, etc. Excellent written and communication skills to interact with stakeholders, team members, and vendors. Individual contributor with ability to collaborate effectively with cross functional te...
I am in need of a skilled bookkeeper, proficient in using Excel. The main task will be daily upkeep of our financial records. Key Responsibilities: - Maintaining daily bookkeeping and financial transactions Ideal Skills and Experience: - Strong knowledge in Excel - Prior experience in bookkeeping Please note, I require daily updates on progress and status. If you're detail-oriented and are comfortable with Excel, you're the perfect candidate for this task!
More details: How do you envision the Monte Carlo Optimization Simulation Equation improving roadway work zone safety? Identifying high risk areas, Optimizing safety measures, Reducing accidents and fatalities Are there any specific safety measures or strategies in place currently at your roadway work zones? Traffic control devices, Speed reduction zones, Warning signs What data or inputs will be used to perform the Monte Carlo Optimization Simulation? Traffic flow data, Accident history data, Work zone layout, Work zone speed limit, Work Zone Length, Work Zone Time Duration, Time of the day work is performed, Presence of Advance Warning signs