Excel shortcuts for data analysis 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.
in attached ....................................................
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.
Are you passionate about un...Our company is seeking an experienced Online Marketing Research Specialist to join our team. Here’s what we’re looking for: Product Research: Dive deep into online products, gathering essential details about features, specifications, and availability. Manufacturers and Suppliers: Identify reliable manufacturers and suppliers, ensuring access to top-quality products. Pricing Insights: Analyze pricing trends to empower informed decision-making. Market Understanding: With a sharp eye for product marketing, provide valuable insights into positioning and promotion strategies. Qualifications: Bachelor’s degree in Marketing, Business, or related field. Proficiency in data analysis tools. Excellent communication skills. ...
I am in search of an experienced SEO professional to help my website gain more v...traffic, search engine rankings, and lead generation - Implement on-page optimization techniques to improve the website's performance on search engines - Conduct detailed technical SEO analysis and suggest/implement changes - Regularly monitor, report, and adjust SEO campaigns for optimal performance Ideal skills and experience: - Proven experience in SEO management with a track record of increasing website traffic, search engine rankings, and lead generation - In-depth understanding of on-page optimization and technical SEO - Excellent analytical skills to measure effectiveness of SEO strategies and make data-driven decisions - Strong communication skills to provide regular update...
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
business profit loss reporting excel(Jan, Feb & March)
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regres...
Being familiar with grocery industry finances, I need an expert to conduct a detailed analysis regarding a store's annual profitability. This involves but is not confined to: - Breaking down costs and expenses - Calculating and understanding profit margins The ideal professional must have experience in financial data analysis with exquisite accuracy. Favorably, knowledge or background within the grocery retail sector is advantageous. The final analysis report should be delivered in a well-structured PowerPoint presentation that encompasses all key findings. It's important for the report to be clear, and easy to understand for non-finance personnel. I am open for any approaches or suggestions, as long as they fulfill the core object...
...education to develop an engaging seminar for college students. The aim is not only to build upon their basic understanding of AI, but also to highlight its ethical usage in an academic context and potential repercussions of AI-enabled cheating. Your responsibilities will include: - Creating a comprehensive presentation that explains AI's role in research and data analysis. - Demonstrating how AI can be used effectively for school purposes while also maintaining academic integrity. - Addressing the possible consequences of AI cheating in a straightforward and memorable way. Ideal candidates should have: - A solid background in AI and a deep understanding of its application in education. - Proven experience creating engaging educational content for...
...search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previous WPJM Plugin and Smyles Plugin Projects you have previously worked...
...business case and financial analysis document specifically tailored to secure financing and government approval for a real estate project. Key Aspects: - Market Analysis and Trends: The document should provide a thorough examination of the target market's demographics, a comprehensive competitor analysis and an in-depth look at supply and demand dynamics. - Risk Assessment and Mitigation Strategies: I need someone who can analyze potential risks associated with the project and suggest effective mitigation strategies to counteract them. - Projected Financial Performance: The document should include detailed financial projections for the project, outlining expected returns and potential challenges. Ideal Skills and Experience: - Extensive experi...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid ...
I'm looking for an expert who can put together a precise and comprehensive multifamily proforma that focuses on cash flow details. Specifics Required: - Include data on net operating income, debt service, and cash on cash return. - An in-depth monthly breakdown of these values. Skills & Experience: - Proven track record in financial analysis, specifically real estate and multifamily property market. - Professional approach with strong attention to detail. - High-level proficiency in using proforma software or Excel. - Understanding of the specifics of rental property cash flows.
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
I'm seeking a professional to create an Information Memorandum specifically aimed at securing financing from venture capitalists and or private equity. This document should include detailed financial ...aimed at securing financing from venture capitalists and or private equity. This document should include detailed financial information, such as: - Revenue projections - Profit and loss statement - Balance sheet - Adopt government statistics - Market & Industry Analysis - Design funding models The ideal candidate for this job should have a solid background in finance, business analysis, and experience in creating successful Information Memorandums for the Australian market. They should be able to present complex financial data in a clear and c...
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
...the field of research methodology. Key Objectives: - Develop a module consisting of 5 to 10 engaging lectures - Covering key topics such as Introduction to Research Methodology, Data Collection Methods, Data Analysis Techniques, Basic Statistics, and Writing Manuscripts for Publication - Ensure the content is beginner-friendly Ideal Skills and Experience: - Experience in developing educational content or courses in the field of research methodology - Strong understanding of research methodology and the ability to simplify complex concepts for beginners - Good knowledge of basic statistics and manuscript writing for publication Your role will involve creating engaging powerpoint presentation. A background in teaching or instructional design wo...
I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.
I am seeking a proficient Revit and AUTOCAD and ETABS. Looking forward to working with you. Thank you.
...LIMITED RANGE. Your expertise in designing systems with the necessary navigation strategies and motion control algorithms will be required. - Providing real-time position feedback to the user. Your extensive understanding of feedback mechanisms particular to these types of systems is a must. Ideal expertise for the job includes: - Comprehensive knowledge in machine systems control and design. - A thorough understanding of motion control strategies. - A background in data analysis and logs processing. The machine is a Bandsaw to cut small logs into planks. The 2-off, NEMA 23 stepper motor movements are sequential, ie, first one moves then the second stepper moves. The controller is a Raspberry Pi 4, the prefered language is Python. Input to the co...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a...
I ordered a 16’ x 24’ storage shed from Heartland Sheds company, but they could not install it due to my steep slope here. But I already submitted my permit request for it and it was approved. The contractor who supposed to assemble the shed on site suggested to build a cinder block foundation than he could put the shed on it. I did that, but now the building inspector wants me to get an Appendix G form filled out and stamped by a PE to verify the footer and foundation meets NC building codes. Luckily I have plenty of photos and receipts documenting the entire project from excavation to finish. I offer $1,000.00 to get the job done.
...skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task will be to fetch data, analyze it, and p...
I am seeking a YouTube analytics expert to help improve the watch time analytics of my cha...time analytics of my channel. Key Responsibilities: - Analyze current watch time patterns and identify areas for improvement - Provide recommendations to boost viewer engagement and retention - Suggest strategies to enhance the overall analytics of my channel Ideal Candidate: - Proven experience in improving watch time analytics on YouTube - Strong understanding of viewer behavior and engagement on the platform - Excellent data analysis skills - Up-to-date knowledge of YouTube algorithms and best practices - Experience in the entertainment content industry would be a plus Please note, I am looking for someone who can not only analyze the data but also provide ...
...experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement ...
I'm looking for a skilled freelancer with prior experience in data scraping to help me extract specific text content and URLs from a public site. Key Details: - Your main task will be to collect the text content and URLs from the site. - Previous experience in a similar project is a must. - Please provide me with details regarding your experience in your application. The purpose of this data scraping project is for market analysis.
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19....
...professional who can help me draft a comprehensive business plan for my digital library project. The plan will play a crucial role in securing a sponsor to support our objective of promoting literacy and education through a digital platform, targeting the general public. The Idea of the project is to translate sceintific papers/articles onto the Arabic language. Articles will be primerly from the English language for the time being but the longer aim is to include more languages, like chinese/russian/german/french..etc. some articles will require permissions but we can start with open source articles as a start. the articles will be published after translating them into arabic in a website and then they will be available to read for free, but for downloading ...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performanc...
I'm in search of a skilled data analyst with expertise in health and medicine for a comprehensive meta-analysis project - Focusing on the health and medicine subject area - Including data sources from peer-reviewed journals - Presenting the results in graphical charts, statistical tables, and a narrative summary Ideally, you should have experience in: - Meta-analysis, especially within the health and medicine domain - Working with various data sources, particularly from peer-reviewed journals - Proficiency in creating and interpreting graphical charts and statistical tables - Crafting a concise and informative narrative summary from the analysis This project requires attention to detail, critical thinking, and the ability to synthes...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
...a LIMITED RANGE. Your expertise in designing systems with the necessary navigation strategies and motion control algorithms will be required. - Providing real-time position feedback to the user. Your extensive understanding of feedback mechanisms particular to these types of systems is a must. Ideal expertise for the job includes: - Comprehensive knowledge in machine systems control and design. - A thorough understanding of motion control strategies. - A background in data analysis and logs processing. The machine is a Bandsaw to cut small logs into planks. The 2-off, NEMA 23 stepper motor movements are sequential, ie, first one moves then the second stepper moves. The controller is a Raspberry Pi 4, the prefered language is Python. Input to the controller vi...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
...comprehensive analysis of the youth demographics including the religious inclinations within my nonprofit area. Key areas of focus should be: - Demographic Breakdown: This includes age, gender, and ethnicity of the young people in the area. - Church Attendance/Religion Stats: Quantify the religious tendencies, including the specific denominations if applicable, and frequency of church attendance. The purpose of this analysis is threefold: - Target Audience Identification: Understanding who the majority of young persons in my area are, allowing better tailoring of our outreach programs. - Community Needs Assessment: Identifying specific needs within the young demographic based on their religious and societal norms. - Outreach Program Planning: The data will as...
I'm seeking an experienced professional to develop a comprehensive and effective Confidential Information Memorandum (CIM) for my technology business. This document will be a key tool in the sale of the company and needs to be of a high standard to attract potential investors. Key Requirements: - Industry Expertise: A strong background in the technology sector and a good understanding of the current market trends is crucial. Previous experience in creating CIMs for tech companies will be highly valued. - Financial Information: You will need to provide detailed historical financial information of the company, likely the past 3-5 years. This will need to be presented in a professional and engaging manner to showcase the company's financial health and growth potential...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
...Competitor Analysis: While the primary focus is on Talens, it will be valuable to understand how other brands like Nike, Adidas, and Apple are being displayed in the retail outlets. - Customer Behavior: I'm particularly interested in how the retail displays are shaping customer behavior and purchase decisions. Ideal candidates should have a background in visual merchandising, market research, or a related field. Specific qualifications include: - Proven track record in conducting retail research, especially within the Chinese market. - Strong analytical skills to interpret the data and provide meaningful insights. - Familiarity with art supply brands and the retail industry would be beneficial. The output of this project will be a detailed report with act...
I'm seeking an expert to analyze a key aspect of my HR paper from journal with title Building organisational resilience capability in small and medium-sized enterprises: The role of high-performance work systems. The intent of the analysis is to analyse paper Key Requirements: he main structure of the analysis contains the following : Introduction Research context Methodology with results Discussion Overview Critique and significance of the paper the outcome is report and power point slides the due date is 22-5-2024
...focusing on marketing strategies within the retail industry. Key Deliverables: - Thorough Analysis: The case study should delve into various effective marketing strategies within the retail sector, potentially highlighting particular successes and failures. - Practical Recommendations: Based on the case study's findings, the report should provide actionable recommendations for developing appropriate marketing strategies in the industry. Ideal Skills and Experience: - Proven Experience in Case Study Writing: You should have a strong track record of creating engaging and insightful case studies. - Retail Marketing Expertise: A deep understanding of the retail sector and its marketing dynamics is crucial for this project. - Strategic Thinker: The ability to iden...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the ...
...hacker to primarily focus on data security. By extensively exploring the potential weaknesses and vulnerabilities, your primary goal will be to prevent unauthorized access. Here's what I require: * In-depth evaluation and analysis of our data security framework * Identification of any potential vulnerabilities and security loopholes * Devise strategies to fortify the data security dimensions against malicious hackers The ideal candidate should possess: * Extensive experience in ethical hacking and data security * Strong analytical skills and a keen eye for spotting weaknesses and vulnerabilities in data security * Ability to devise actionable strategies to address the identified issues Rest assured, full access to the necessa...
...looking for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Pytho...
...this pitch deck is to secure funding for my project. Key Sections: - Market Analysis: You'll need to conduct comprehensive market research and present it in a succinct, engaging way. - Business Model: I need a clear, concise explanation of how my business functions, generates revenue, and its scalability. - Financial Projections: It's crucial that the pitch deck includes realistic financial projections and data to back them up. - Technical Concept: The technical aspect of the project will need to be explained in a way that non-technical investors can understand. - Unique Selling Proposition (USP): You should highlight the unique value that my project brings to the market and why it's a worthwhile investment. In terms of the length, I'm loo...
