Vba refresh excel web query jobs
...specific business problem - enhancing our sales performance. Key Tasks: - Utilize advanced analytics techniques to interpret data and derive meaningful insights. - Create interactive and visually engaging dashboards in Power BI or Excel to monitor KPIs and sales metrics. - Simplify complex data sets into easy-to-understand visuals, facilitating informed decision-making. The final deliverable should be a comprehensive PowerPoint presentation that includes: - Interactive charts and graphs to illustrate our data journey and findings. Ideal Skills: - Proficiency in MS Excel, Power BI, and Data Visualization tools. - Experience in creating engaging PowerPoint presentations. - Strong understanding of sales metrics and KPIs. - Ability to simplify complex data. Please note, th...
I'm looking for a Wix specialist to enhance my small 6-page website (). The updates include: - Minor tweaks to text and layout, mainly focused on rewriting sections and adjusting the overall layout structure. - A refresh of the testimonials page, which will only include text-only testimonials. - The addition of a Privacy Notice, which should be placed on a dedicated Privacy Policy page. In terms of ideal skills and experience, I'm looking for someone with a strong background in web design, particularly on the Wix platform. Good textual and layout restructuring capabilities are essential, as well as the ability to create a clear and professional Privacy Policy page. Please provide examples of previous Wix projects you've worked on, particularly those involvin...
I'm looking for someone to edit my inventory data in Excel. The task involves moving data from one file to a new one with a different layout. The new layout requires: - Reordering columns - Adding new fields - Combining data from multiple sheets There are specific formatting requirements for the new layout, which includes the use of certain cell colors and font styles. Ideal candidates for this project should have: - Extensive experience with Excel - Strong attention to detail - Ability to follow specific formatting guidelines - Experience working with inventory data.
... and financial reporting processes. • Design and optimize SAP BW/4HANA models, including: o DSOs, ADSOs, Composite Providers, and InfoObjects. o Develop BW queries using BEx Query Designer. o Implement ETL pipelines for structured data loading and transformation. • Support integration between SAC and SAP BW using live and acquired connections. • Assist in system testing, debugging, and troubleshooting. • Prepare and maintain technical documentation for analytics solutions. Specific Skills Required: • Proficiency in SAC Story Design, data blending, and linked analysis. • Strong experience with SAP BW Modeling and Query Design • Hands-on knowledge of Data Acquisition Tools in SAC and BW. • Experience in Finance Planning and Performan...
Copywriting, pdf, data entry, excel, word
...ensure quality output (I will provide access to best LLMs if you need) Be able to work independently and provide regular updates. Provide clear documentation for all changes, work using my github repo, including migration steps, setup instructions, and code comments. Proven track record of optimizing high-traffic websites. Familiarity with database optimization techniques (indexes, partitioning, query optimization). Current Stack: Backend: Symfony 3.3 (PHP 7.1) Frontend: Partially migrated from AngularJS to Vue.js Database: MySQL 5.7 Other Tools: Doctrine ORM, Sonata, FOSUserBundle, AWS integrations You should be comfortable with ubuntu and comfortable with installing packages, upgrading php/mysql etc over the command prompt. I want to complete the angular to vuejs, Symfony ...
I'm seeking a skilled web developer to create an informational web application intended for internal team use. The primary function of this platform is to serve as a hub of important information, with a dedicated contact form for team queries and feedback. Key Features: - An intuitive and user-friendly interface that allows easy navigation and information access. - A secure and private environment, with appropriate access controls to protect sensitive information. - A responsive design, ensuring usability across various devices. Define the basic requirements: Basic features: User management: Log in users (admin, employee, etc.). Create a quote(jobe): Enter customer details, products or services, prices, and taxes. Jobs section (airport/ land /sea) Convert to invoice: C...
I'm seeking a skilled WordPress developer to enhance my website. The project entails troubleshooting and fixing plugin errors, updating text and images, and improving overall functionality. Please ensure your proposal showcases your relevant experience and expertise, particularly in WordPress troubleshooting and content management. Itemised tasks as follows: 1. Migrate existing website from domain to 2. Sort out the Team profile picture page so that all pictures display and can be subsequently updated without issues 3. update some graphic and text content (very minimal) 4. replace all “Carent Oil” text/logo to “Carent Energy” 5. ensure the social media hyper links works 6. Add a redirection from to new domain 7. sort out any plugin errors Existing web...
I'm conducting academic research and need help analyzing survey responses. I need a statistitan that can help me identify and give the correct sample size calculation for the bellow Total population 118 Stratum A) 70 Stratum B) 48 Z-score (default: 1.96) For 95% confidence level) 1.96 Proportion (default: 0.5) 0.5 Margin of ...academic research and need help analyzing survey responses. I need a statistitan that can help me identify and give the correct sample size calculation for the bellow Total population 118 Stratum A) 70 Stratum B) 48 Z-score (default: 1.96) For 95% confidence level) 1.96 Proportion (default: 0.5) 0.5 Margin of Error (e.g., 5%) 0.05 is Finite Population Adjusted Sample Size needed? I need an excel with the formula and the steps broken down to a...
I'm a beginner eager to excel in the field of copywriting and looking to transition into a professional role. I'm seeking an experienced mentor or a comprehensive copywriting course that can provide guidance, practical exercises, and feedback to sharpen my skills. Here's what I'm looking for: - A mentor with a strong portfolio of copywriting work who can offer personalized advice and tips. - Engaging learning materials that cover the basics of copywriting, including writing for different mediums and understanding target audiences. - Interactive sessions or a course with hands-on activities to practice and improve my writing. - Feedback on my work to help me refine my copywriting techniques and develop my own style. - Insights into the copywriting industry, inclu...
Dear Freelancers, I hope this message finds you well. I am reaching out to outline a comprehensive plan for creating Excel sheets with detailed product information from the following link: Grab Mart Merchant Link. ( ) Project Overview The goal is to compile full product information, including price, product photos (edited with a white background), product weight, and product category. Each category will have its own separate Excel sheet and corresponding Google Drive folder for storing photos. The product name on the photo and in the Excel sheet must match. Additionally, we will need to find barcodes for all products, as none are provided in the link. The total number of products
I need a spreadsheet expert to help me streamline my expense tracking tables with automatic calculations. My spreadsheet contains financial data and is primarily used for tracking expenses. The goal is to make the tracking process easier and more efficient. Ideal Skills: - Proficient in Excel or Google Sheets - Experience with financial spreadsheets - Knowledge of creating automatic calculations - Attention to detail for tracking accuracy - Ability to optimize and improve existing tables Please provide examples of similar projects you have completed in the past.
...clear and professional formatting suitable for entry-level positions in marketing or project management. Provide both one-page and two-page versions of the resume in PDF and editable formats. Details to Include: Education: From high school to bachelor’s degree. Internship Experience: Responsibilities and accomplishments at BrightFuture Solutions as a Marketing Intern. Skills: Technical tools (Excel, Tableau, Canva, etc.), soft skills (communication, collaboration). Hobbies/Interests: Basketball, photography, traveling, and graphic design. Career Goals: Focus on marketing and project management roles. Requirements: Proven experience in creating professional resumes, preferably for recent graduates. Strong design and formatting skills (knowledge of ATS compliance is a plus)...
I'm looking for a talented graphic designer who can create a modern and sleek flyer for The Word Church. The flyer is to be sized 1024X768 and should prominently feature our 2025 theme: "Upgrade, Elevate, & Excel" (Ephesians 3:20). Key elements to be included: - The text: "The Word Church", "2025: Upgrade, Elevate & Excel (Ephesians 3:20)", "Tony Ray Smith, Senior Pastor", "". - A focus on the theme of 2025: Upgrade, Elevate, & Excel. - Our church logo. - A photo of our pastor. Example IMG_9673 ' Design specifications: - A modern and sleek style. - A dominant blue and silver color scheme.
I'm looking for a skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its folder structure - Ability to write...
I'm in need of a professional who can assist me with entering financial records into spreadsheets and making cold calls. Data Entry: - You'll be enteri...financial records into spreadsheets. - I have a general idea of how the spreadsheets should look, but I will need your input and expertise to create a clear and efficient format. Cold Calling: - You'll also be making cold calls on my behalf. - Excellent communication skills and a persuasive demeanor are essential. Ideal Skills: - Proficiency in data entry and spreadsheet software (preferably Excel). - Previous experience with financial data is a plus. - Strong communication skills for cold calling. - Ability to understand and contribute to spreadsheet design. Please provide examples of your previous work tha...
We need to add thousands of products to our ecommerce website. Most of our suppliers do not provide the product images and product documents like specification and installation documents. We need help getting these images and documents from supplier websites. You will be provided with excel files for each supplier with the full list of product for which to get images and documents
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I need a fillable PDF created from an Excel worksheet. The PDF will be used to conduct a survey and will include both multiple choice and short answer questions. Key Requirements: - Convert specified Excel worksheet into a fillable PDF. - Incorporate various types of survey questions (multiple choice and short answer). - Ensure the PDF can be easily returned via email once completed. Ideal Skills: - Proficiency with Excel and PDF creation software. - Experience in designing user-friendly fillable PDFs. - Understanding of survey design and data collection processes.
I need an expert in Excel to assist me in merging two files. The task involves transforming the data in these files before the merge. Ideal Skills: - Proficient in Excel, particularly in data transformation techniques - Experience with data merging - Attention to detail for accurate data handling
I have 6 excel spreadsheets containing attendee information for some small upcoming events. I need the data sorted into groups by age and other specific requests. Additionally, I need some standard data cleaning to be done, specifically standardizing phone numbers and removing duplicates. Ideal skills for this project include: - Strong proficiency in Excel - Attention to detail - Good understanding of data sorting and cleaning techniques Please bid if you can assist with this task.
I'm seeking a solution to expedite job posting updates on Clasified website. I refresh my page every minute but still miss listings. I need a faster, more reliable way to track job if i update the browser every appears new ad appears for example with this message "posted 8 minutes ago"
I need help with reworking an existing venture capital excel model for a new investment. The model should provide accurate financial returns for this investment. Specific Sections: - Revenue projections - Expense forecasts - Return calculations Assumptions to Update: - Market growth rate - Cost of goods sold - Operating expenses New Financial Metrics to Incorporate: - Internal Rate of Return (IRR) Ideal Skills: - Expertise in Excel and financial modeling - Understanding of venture capital and investment analysis - Strong analytical and problem-solving skills Experience: - Prior experience reworking venture capital models - Proven track record of accurate financial forecasting I'm looking for a freelancer who is detail-oriented and can deliver a robust model that me...
My website, , is experiencing login errors. It appears to be a PHP issue. - On login or registration, the page turns blank requiring a refresh. - A security token message appears during registration. - We want to remove the security token message and allow direct access to the site after registration without needing to log in or refresh. Skills Needed: - Proficiency in PHP - Extensive experience with WordPress - Familiarity with debugging WordPress issues - Knowledge of security token and session handling in WordPress
...statements for each account have already been converted to excel format. You must go through the transactions for each year and properly itemize each transaction and creat the Businesses Financial Statements (PNL & BS) for tax filing purposes. This role also involves reviewing my personal bank account statements to identify any business-related transactions made that should be included such as making a payment for a business credit card, owner investments, and Etc. I need this to be completed ASAP perferably by the end of this week if possible. Key Responsibilities 1. Organize and Classify Transactions: Review and categorize all business-related transactions from each accounts transactions that have already been converted to excel from the PDF statements, including: ...
I need a Data Entry Specialist, preferably with an engineering background, for a 3-hour task. This project involves: - Transferring mixed data (numerical and textual) from a PDF document into an Excel spreadsheet. - Organizing the data by categories or sections in a clear and user-friendly format. - Applying both totals and averages using basic Excel functions or formulas. The ideal candidate for this task must: - Have a strong proficiency in Excel. - Possess keen attention to detail and accuracy. - Be able to complete the task within 3 hours. Given the nature of the task, an engineering background would be beneficial due to the need for precision, analytical skills, and a structured approach.
I need assistance pulling all followers from my business Instagram account. Specifically, I'm looking for their username, email, and name (if available). Ideal skills for this project include: - Proficiency in data extraction and web scraping - Familiarity with Instagram's platform and its data privacy rules - Experience in data presentation using Excel or CSV formats Please bid only if you can deliver the data as a neatly organized spreadsheet (Excel, CSV).
I'm in need of a comprehensive spreadsheet to track various employee absences. The types of absences I want to monitor include sick leave, call-o...spreadsheet should capture the date and time, the reason for the absence, whether the employee gave late notice or not, and the number of "attendance points". - Identification: Employees should be identifiable by their full name. Here are some links to tutorial for similar trackers: Ideal Skills: - Proficiency in Excel or Google Sheets. - Experience in creating tracking spreadsheets. - Understanding of HR metrics would be a plus. Please ensure that the spreadsheet is user-friendly and can be easily updated on a regular basis. Looking forward to your bids.
I have two Excel files detailing my wine collection - one is from 2023 and the other is an update. I'm looking for someone to identify the differences between the two files. Specifically, I need to see: - Changes in item quantities - Any addition or deletion of items After the comparison, I would like the results to be compiled into a summary report. Additionally, if possible, a visual chart illustrating the differences would be appreciated. Ideal candidates should have extensive experience with Excel and data analysis. Familiarity with inventory management and wine collections would be a plus.
I am looking for a skilled Django Python developer to i...with preset responses based on the type of user inquiries. Key Features: - Handle diverse queries: The system should be capable of addressing services inquiries, technical support questions, and general information requests pertaining to the service - Automatic Query Categorization: I require the system to automatically categorize incoming queries for efficient response managemen and generate relevant response. - Multi-Platform Synchronization: Besides WhatsApp, the system responses should be synchronized with Email, SMS, and Web chat. Ideal Skills: - Proficiency in Django and Python - Experience with WhatsApp API integration - Knowledge in developing automated categorization systems - Familiarity with multi-platfor...
I require an excel sheet that tracks and analyzes the changes in open interest data of the NIFTY index. This sheet should be able to provide insights into market sentiment based on this data. Key Requirements: - The excel sheet should continuously update the data every minute. - The sheet should be able to provide a text summary of inferences about market sentiment from the open interest data. Ideal Skills: - Proficiency in Excel with experience in financial data analysis. - Understanding of open interest and its implications on market sentiment. - Ability to create an automated Excel sheet that updates data every minute. Please note that I'm looking for a freelancer who can deliver a high-quality, reliable tool for tracking and interpreting NIFTY index...
I need a excel sheet (some columns protected), as soon as date are entered in Sheet 1 on a specific column the entire row needs to more to tab2, same at tab 2 as soon as date entered the row needs to move automatically to tab 3, same to tab 4, 5, 6. (All the rows are protected, can not be deleted, they will only move between tabs as the project runs) - Production Job Tracking report I would like to do the project together with the freelancer on teams (within the next hour is possible) I assume the project will take maximum an hour
I'm looking for an Excel developer to create an inventory management system. While specifics on the functions of the system haven't been detailed yet, the system will need to track stock levels and generate reports. As such, the ideal freelancer for this project should have prior experience in developing similar systems on Excel. Skills and experience required: - Advanced knowledge of Excel - Prior experience in developing inventory management systems - Ability to generate and interpret detailed reports - Excellent understanding of tracking stock levels
We have a current website and need a Redesign. The Logo Part with Header need to be the same like the current website. The rest need a complete refresh. Homepage and one Subpage for services. #fixedbudget
...freelancer who can assist me with entering part numbers and costs from a supplier's website into an Excel spreadsheet. This spreadsheet contains makes and models for every vehicle listed in the UK. Key Responsibilities: - Accurately input part numbers and costs from a supplier's website into designated columns of an Excel spreadsheet. - Follow specific formatting and column header requirements as detailed below. Specific Columns and Formatting: - The data needs to be entered under specific column headers in a predefined order: makes, models, costs, part numbers. - Conditional formatting or color-coding will need to be applied at times according to supplied guidelines. Ideal Skills: - Familiarity with Excel and its data entry requirements. - Attention to...
I need a comprehensive dataset prepared for Tableau that encompasses a variety of data types including sales, customer, and financial information. The data is currently in Excel/CSV format. Key Requirements: - Transform and clean various data types (sales, customer, financial) from Excel/CSV for Tableau - Prepare the dataset to allow for a variety of analyses and insights, including but not limited to sales trends over time, customer demographics, and expense versus revenue tracking. Ideal Skills: - Proficiency in Excel/CSV data handling - Expertise in data preparation for Tableau - Strong analytical skills to understand and anticipate necessary data transformations for desired insights Please note that the final dataset should be versatile enough to facilitate a wi...
I'm looking for an Excel expert to design a template for tracking my total monthly/yearly sales. This template should also allow for comparison over time. Key Features: - Total sales tracking - Comprehensive data visualization features: Bar charts, Pie charts, Line graphs - User-friendly manual data input Ideal Skills: - Advanced Excel skills - Experience in data visualization - Knowledge in sales data tracking
I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.
...dependents. The app will have two user roles: employees and employers. Key Features: Employee Login: Enter Employee ID to access the app. Display Details: Show the employee's name and their dependents. Admission Form: Select the person to admit (employee or dependent). Input fields for hospital name and admission date. Submit Button: Sends the data to a backend. Employer Dashboard: Generate an Excel sheet with all admission records....
... Key Responsibilities: • Set up and manage Facebook Ad campaigns, including campaign groups, ad sets, and individual ads. • Collaborate on Google Ads campaigns, refining bidding strategies and audience targeting through regular Zoom sessions. • Optimize ad campaigns to ensure maximum ROI, including A/B testing and data analysis. • Work with contact lists from tools like Seamless to upload Excel files containing 1,000-2,000 targeted contacts into the backend of Facebook Ads Manager and Google Ads for custom audience creation. • Create and manage remarketing campaigns using these custom audiences to deliver video ads tailored specifically to this list. • Provide regular performance analyses and actionable recommendations based on campaign data. ...
... which makes sharing links easier and is beneficial for SEO. Question 5: What happens if a customer already has a selected vehicle but uses the store’s search function? Answer: In that situation, the search engine should account for the currently selected vehicle and mark any products that fit that vehicle. In other words, the search results display products that match the search query and also filter them by vehicle compatibility—or highlight those that fit (e.g., “Fits your vehicle”). Question 6: Why can’t this module be implemented as an EAV attribute? Answer: Storing a large amount of vehicle data as an EAV attribute could significantly burden Magento because it would increase the number of records and database queries. A solution based on custo...
Transform Excel Sheet Data to Charts and Stats using Power BI, we need interpretation for each chart.
I am seeking a highly experienced circuit design engineer with expertise in digital and analog electronics, proficient in using Eagle for PCB design. The ideal candidate will have a strong background in signal conditioning, low-noise circuit design, and power management for compact, low-po...power management for compact, low-power applications. Familiarity with integrating multiple sensors, including PPG, glucose, HRV, and electrolytes, into electronic systems is a significant advantage. The role requires exceptional problem-solving skills, attention to detail, and the ability to deliver efficient, production-ready designs, including schematics, PCB layouts, and prototypes. If you excel in creating innovative circuit solutions and thrive in challenging projects, I would love to hear...
Hi, Statistics is my favorite subject and will be glad to help. I have skills in Data Processing, Statistics, R Programming Language, SPSS, Tableau and Excel. Hire me for your methodology and data analysis chapters for your dissertation.
I'm seeking a proficient Excel Solver expert to help me analyze my inventory data. The tasks involve moving averages, Mean Absolute Deviation (MAD) calculations, and time series forecasting. Key Tasks: - Help with moving average calculations - Calculate MAD - Apply time series analysis for forecasting Ideal skills for this project include: - Advanced Excel skills, especially with Solver - Strong understanding of inventory data analysis - Proficiency in time series forecasting methods
I'm seeking a skilled app developer for creating a live streaming...streaming app compatible with both iOS and Android. This app should allow me to stream videos while simultaneously talking and playing music. Key Features: - A built-in web browser with comprehensive functions including basic browsing features (back, forward, refresh), bookmarking and history, and private browsing mode. - Login and user account features with integration to social media platforms and also an option for traditional email and password login. Ideal Skills and Experience: - Proven track record of cross-platform app development. - Experience with creating live streaming applications. - Familiarity with developing in-app web browsers. - Competence in implementing secure login systems w...
...currently using an Excel template to visually represent all our projects in a Gantt chart. I need an expert to enhance this template for me by adding a sales target function. This function should calculate and sum up the revenue for each job based on the percentage of the job completed in each month. - Example: For a $100k job with 75% of the work days in January and 25% in February, the system should automatically allocate $75k to January and $25k to February, and sum up all the jobs for each month. The work days are automatically calculated by the existing template. The only adjustment needed is the division of revenue by month and the presentation of this in total. I have an example of the desired output, just built manually. Ideal skills and experience: - Proficiency in ...
...Visualization and Reporting: - Create interactive dashboards using tools like Power BI or Tableau. - Provide meaningful visualizations such as charts, graphs, and heatmaps for easy interpretation. - Prepare a detailed final report with actionable recommendations. Requirements: - Proficiency in Python, R, or other statistical programming languages. - Experience with tools like Excel, Power BI, or Tableau for visualization. - Strong understanding of statistical methods and data modeling. - Ability to communicate insights effectively. Project Timeline: Expected completion within 3 days from the project start date. If you have the required skills and can deliver high-quality results within the timeline, we’d love to hear from you. Please include e...
