Advanced excel lessons 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.

PSD file should be encoded in HTML5 as a ...a MySQL database, which is pre-coded. Player makes bitcoin transfer us, and the transfer is calculated to 20-digit binary number which determines a coin shop. 0 = right and 1 = left. Binary and bitcoin transfer calculation are encoded completed, but the playing area and mainsite should be encoded bit in the same style as has been done site. This would be good to manage HTML5, Canvas Advanced Animation Toolkit, jQuery, Windows animateframe, maybe socket open. Mysql database is complete, 20-digit binary number and the database is ready, but the game on the site is not yet as a PSD file. The coin must looking good when it comes down to. The coin must move a the same way as site and the end of the multiplier must be the final effect.

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

I'm seeking a tangible increase in brand awareness for my business amongst young adults (20-34 years) on Facebook. Ideally, you can craft engaging stories and behind-the-scenes content to captivate this target audience and create memorable experiences. Being well-versed in advanced Facebook marketing strategies and particular expertise in story-telling and content creation will be advantageous. This campaign's ultimate goal is to create a flourishing community, enhancing brand consciousness and expanding our digital footprint.

I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.

... - Modify the layout of the theme, including rearranging elements on the page and redesigning the navigation menu. - Integrate new features into the theme. - Improve the functionality of existing features. Other Changes: - Adjust the display per row. - Customize the search page. - Make sorting alterations. - Make it mobile responsive. - Adding new payment processors Key Skills Required: - Advanced PremiumPress theme customization. - Experienced in UX/UI layout changes. - Strong PHP, HTML, CSS, and JavaScript knowledge. - Proven track record with WordPress theme modifications. If you have direct experience with PremiumPress theme alterations and the necessary skills listed, feel free to bid on this project, otherwise, we are not interested and we won't pay for the time y...

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

...machine learning experts capable of creating AI systems focused on preventing physical theft. The primary targets are retail stores, specifically, monitoring theft in aisles and the stock room. Ideal Skills/Experience: - Proficient in Machine Learning - Experience with AI security solutions - Background in retail security systems - Strong understanding of video surveillance tech Duties: - Devise advanced AI systems for theft detection - Prioritize monitoring of aisle and stockroom areas - Implement machine learning to enhance theft prevention - Ensure seamless integration with existing security infrastructure...

I'm looking for a talented video editor who can proficiently use deepfake technology. The task requires replacing celebrities in a famous youtube video with the faces of Arab and other countries' leaders. Key requirements: - Advanced skills in deepfake technologies - Ability to replace faces seamlessly maintaining realism, not comedic effect - Experience in video editing and manipulation - Knowledge of the chosen youtube video (or willingness to get acquainted with it) Successful delivery of this project means a visually convincing result showing world leaders in place of real celebrities. If you have the necessary skills and experience, I invite you to bid.

I am seeking an experienced professional to assist in importing the current version 4.11 of OpenShift Container Platform (OCP) cluster into a new Advanced Cluster Manager (ACM). - Task Details: - The project primarily entails the import of all resources and configurations from the current OCP cluster to the new ACM. - Once imported, the new ACM should only be accessible to selected users with Full Administrator rights. - Essential Skills: - Knowledge and proficiency in OpenShift Container Platform version 4.11. - Adequate understanding of Advanced Cluster Manager. - Familiarity with administration and user access management in an ACM environment. Please ensure to provide relevant experience and demonstrated ability with the requirements stated above befor...

Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I am looking for an expert to assist in creating a dynamic Power Bi 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 Creat...

...be the initial creation of the application, yet this could potentially extend to long-term support. Key Responsibilities: - Create a robust, scalable, and highly interactive web application. - Develop efficient and reusable code that drives complex web applications. - Maintain a deep understanding of Angular + Laravel to optimize application capabilities. Ideal Skills & Experience: - Advanced proficiency in Angular + Laravel development. - Proven record of building highly interactive web applications. - Understanding of user roles for a web app is preferable. - Skilled in troubleshooting and improving existing and in-development applications. Time Frame: Since there were no specific answers regarding user roles and completion time, flexible freelancers open to d...

I am looking for an advanced AI expert who is proficient in Python to help me understand and manipulate a developed Python package on a tutoring basis. The link of the package is: I am interested in the cylinder problem here: Key Responsibilities: The tutor should help me to make changes in the code, track the flow of the data, know the dimensions of the data, debug errors that I may encounter, and how to create more figures as well. Level of Expertise: Advanced. It's important that the tutor is proficient in AI and Python, and can guide me through the learning process at an advanced level.

I'm seeking expertise to develop an AI solution addressing specific communication challenges in my operations. This advanced technology will aid in requesting more specific information for document retrieval, task completion, and progress updates that are currently barriers. Key Features and Responsibilities: - Construct an AI system that can precisely request added details - The AI tool should nurutre informations mainly for document retrieval, tasks execution, and progress report. - Should work effectively with email platforms as the primary communication tool. Ideal Experience: - Proven experience in AI and machine learning technology - Familiarity with corporate communication systems - Experience in integrating AI with Email services. This project aims at enhancing effic...

For the game Dead by Daylight, I would like someone to create an equalizer to isolate the sound of a specific character, and amplify that sound so its easier to hear while im gaming. Ideally Peace Equalizer running in the back that i can switch on and off. The sound is comparable to breathing but is more like a distinct grunting sound. There will be 3 different eq...but is more like a distinct grunting sound. There will be 3 different equalizers, with 3 different sounds at the base. The end goal would be 3 files for peace equalizer I can download. I will provide all the input, so I can send all the audio files required to make the EQs. Looking for a developer who knows how to utilize programs to translate sounds into Hz ranges & into eq's + ideally other advanced techniques...

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

I am looking for a skilled WordPress designer to create an engaging blog website. As client details were not provided, the site should be versatile enough to work...the site should be versatile enough to work for a personal, business, or news blog. - Design: While no specific design elements were specified, the site should be modern, user-friendly, and visually compelling. - Freelancer Applications: Potential freelancers should include examples of past work, their experience, and detailed project proposals when applying. Ideal Skills and Experience: - Advanced proficiency in WordPress. - Previous experience designing blog websites. - The ability to incorporate versatile features to suit various types of blogs. - Strong communication skills to comprehend and execute my vision ef...

I currently use Hawksoft CMS and Marketing 360 CRM. My project requires a platform that integrates these systems with a document signe...signatures and document tracking. - A calculator that includes formulas for interest and payment schedules. Ideal Skills: - Proficiency in CMS and CRM integration, particularly with Hawksoft CMS and Marketing 360 CRM. - Experience in developing document signing features with elements such as electronic signatures and document tracking. - Strong background in building calculators with advanced financial formulas, particularly those related to interest and payment schedules. - UI/UX design skills, to create a user-friendly interface that seamlessly integrates all these features. If you have experience in these areas, please bid on thi...

As a business focused on making data-driven decisions, I am seeking an expert to create a data analytics tool from scratch using ReactJS and AWS. The tool will analyze an array of data sources and present the results using insightful visualization techniques. Here are the requirements: - Implement Amazon Cognito for user authentication and authorization - Utilize AWS Amplify for the app's development and deployment - Integrate AWS API Gateway for efficient data exchange - Integrate Stripe for payments. Need complete flow Our tech stack looks like: - Amazon Amplify for app backend, and front end - Gatsby JS coupled with AppSync for front end - Amplify UI and MUI Material for UI components Features that I need: - End to end user journey - from login/registration to offering profile ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

...team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Features to Include: Adva...

...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...

Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas

... fraud detection, need my website to be viewed even while customers are at work in a government agency with no restrictions to entering websites. Key Features Needed: - Product Customization Options: The ability for my customers to tailor and personalize their purchases. - User Accounts and Profiles: A seamless system for users to create accounts, save preferences, and view order history. - Advanced Search and Filter Options: A robust search functionality with filters to help customers find products quickly and easily. This project will involve not just the migration of the current site but also the creation of a new domain. I need a skilled web developer who has experience with E-commerce websites, particularly on WordPress. Familiarity with Shopify migration would be a plus...

I'm looking for a qualified English teacher specializing in Business English to help a student at an intermediate level. The lessons should be delivered online. The right professional for this job should have: - Proven experience in teaching English, particularly Business English - Proficiency in online teaching techniques - Strong understanding of intermediate-level English - Ability to customize lessons to suit the student's needs - Patience and good communication skills If this sounds like you, I look forward to hearing from you.

I am looking for an SPSS expert who can help me with running Case-Control Matching analysis on my dataset. Key Requirements: - Advanced SPSS skills, particularly in Case-Control Matching. - Ability to troubleshoot and resolve errors efficiently. Your primary role will be to help me run the Case-Control Matching analysis and ensure it is correctly applied to my data.

I'm in need of a virtual assistant to support me with a range of tasks related to real estate and administration. Can work from 12pm spanish time. Ideally from ARGENTINA or an equivalent/closer time zone to Spain. English level: Upper intermediate or higher. Spanish level: Advanced or higher. Key responsibilities include: - Managing my inbox and responding to emails - Handling various administrative tasks - Conducting research on different topics - Organizing information in Excel - Scheduling appointments and managing my calendar The ideal candidate should: - Be able to dedicate between 10-20 hours per week to this role. - You can make calls and videocalls and mantain fluid communication. - Possess strong organizational and time management skills. - Have a backgroun...

...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...

As a jewelry aficionado, I'm on the lookout for someone with a cutting-edge and innovative mindset to create a stunning design for a modern ring. Ideal Skills: - Advanced familiarity with 2D jewelry design - Expertise in various styles, specifically modern ones - Sensibility about how different materials affect the look and feel of a ring The material speculated to be used in the ring design is open-ended since the third question was left unanswered. Therefore, freelancers are encouraged to make suggestions based on their professional experience and comprehension of current trends and fashions. Your creativity is much appreciated in the making of a truly one-of-a-kind piece. Take this opportunity to showcase your talents and skills in jewelry design!

...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create...

I'm in need of a skilled UI/UX designer who can use Figma to redesign my current app. Here's a little more detail about what I'm looking for: - **Current Platform:** The app is currently available on bot...the new design. I will provide those examples of other apps and drawings to you. I will also give you access to the current assets we have for our mobile and desktop app now in Figma. The ideal candidate for this project would have: - Expertise in UI/UX design for both iOS and Android - Proficiency in Figma - A portfolio showcasing sleek, clean, and intuitive mobile app designs - Experience in advanced app design would be a plus I'd love to see how you can turn my vision into a visually appealing and user-friendly reality. I believe I need 9 screens for thi...

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...

...Homeowners, real estate agents, and developers looking to sell their properties. Website Features Property Listings: A user-friendly interface to browse properties by location, type, price range, and other relevant filters. Property Details: Detailed property pages with high-quality photos, virtual tours (optional), descriptions, key features, and agent contact information. Search Functionality: An advanced search bar allowing users to filter properties based on their specific needs and preferences. Contact Forms: Easy-to-use contact forms for users to inquire about properties or schedule viewings. Agent Directory: A directory showcasing our team of experienced real estate agents. About Us: A page outlining our company's mission, values, and team expertise. Blog (optional):...

I have a single image that I need to have enlarged. Right now, it's fairly small, and I require a high-quality enlargement with advanced techniques. Key Requirements: - Image Enlargement: The image needs to be stretched to a larger size while maintaining a high level of quality. - Advanced Techniques: It's important that the resizing process uses advanced techniques to ensure the quality of the image is not compromised. Ideal Skills and Experience: - Image Editing: You should have a strong background in image editing, particularly in the area of enlargement. - Advanced Techniques: Experience with various advanced techniques for image resizing will be highly beneficial. Overall, I'm looking for a freelancer who can deliver a high-qualit...

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...

...comprehensive and compelling, highlighting the key features and benefits of the product while simultaneously being SEO-friendly. 3. **Accurate Product Specifications:** The specifications need to be 100% accurate, eliminating any potential for customer dissatisfaction or returns. Ideal Freelancer's Skills and Experience: - Proven track record in managing Amazon inventory effectively - Robust knowledge on advanced SEO practices specifically in e-commerce context - Exceptional attention to detail particularly in regards to product imaging, descriptions, and specifications - Proficient with Amazon product listing best practices. The ideal freelancer will have successfully improved visibility and sales for other Amazon stores previously. If you believe you're a great fit,...

...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...