Spread sheet projectpekerjaan

I'm seeking a highly detail-oriented freelancer for a data entry role. This position requires entering numeric data into a Google Sheet. Key responsibilities: - Inputting numeric data with speed and accuracy. - Delivering the final product in Google Sheet format. Ideally, you'll have previous experience in a similar data entry role, particularly dealing with numeric data. Proficiency in using Google Sheets is a must. Delivering on time, maintaining the confidentiality of the data handled and performing quality check are essential to the role. Please bid with confidence if you have the relevant skills and experience.

I require someone to extract information from a PDF and input it into an Excel/Google Sheet. If someone can apply with the job already completed in a Google Sheet, I will make a direct payment. (remitly or any other way) Only data from the middle column should be extracted, as shown in the screenshot below with the highlighted text. In a secod time i'll ask for a clear and simple explanation (via video) of how the task was accomplished. Attached is the document from which the extraction will be performed.

I have a list of Government offices in different US counties. I need information for the contractors who provide them supplies. Total Offices are in 1000 but for this Test Phase I will go with 50 office. if goes well will hire for whole project. I need copy of Current active Contract, and price sheet or details. Contact details for the office agent. Keep in Mind: Contracts available publicly so need researching skills and understanding. In such cases might be need to contact with office (email or phone) to get copy of contract and details

I need to gather information about rents by day in Agoda, Airbnb, Booking, Facebook of studio, onebedroom condos in Cebu city, Mandaue and Mactan Island: Filter: Condos with 0 ( Studio ) or 1 bedroom , areas of Cebu city, Mandaue and Mactan Island, price Websites to research : Facebook Marketplace , Airbnb , Agoda, Booking Put in a excel or google sheet to share with this structure : Name, Airbnb ( cost of one day ) , Agoda ( cost of one day ), Booking( cost of one day ) , Facebook ( cost of one day , calculate if its one month , or six one year contract ), Type ( Studio / One bedroom )

Hi Semi786, could you please complete addresses in the sheet. As before, the instructions are all in the sheet Instructions. Addresses to be filled in are in rows 203-403.

I'm on the lookout for a skilled digital marketer who can catapult my law firm's presence across Instagram, Facebook, and Google to generate high-quality leads from the Middle East. I need this as soon as possible, leveraging our existing social media accounts or creating new ones if necessary. Ideal Candidate Should: - Have proven experience in s...Skills Required: - Proficient with social media advertising platforms and tools. - Ability to analyze metrics and KPIs to guide strategy. - Strong communication skills and attention to detail. If you can demonstrate a successful track record in similar projects and have the knowledge to navigate the complexities of marketing legal services, I invite you to submit your bid. Let's work together to spread our legal expertis...

Before you bid, check our "Employer Profile" on Freelancer.com Hard work and timely delivery will earn you quick payment and a 5-star review ************************************************************************************************* I have an Excel sheet(attached) Each row has the person's name and previous organization. You'll need to find the email addresses and fill up every row in the BLUE column. The information has to be filled into an Excel sheet and returned to me within 4 hours. There is no automated software to do this, the work has to be done manually. So please bid only if you are willing to work hard and deliver on time. I will randomly check a few records for accuracy before releasing the final milestone, so please work carefu...

I'm looking for a skilled professional who specializes in financial analysis to help me with my project. The key requirement is to perform a common size and comparative balance sheet analysis as this forms the centerpiece of my needs. Here are the specific tasks: - Conducting a detailed analysis of the financial data provided including but not limited to revenue, expenses, assets, liabilities, and equity. - Application of specific financial analysis strategies such as profitability ratios analysis, cash flow forecasting, and break-even analysis is another requirement. The ideal freelancer for this job would be someone who has a robust background in financial analysis and accounting, with a specific skill set in analyzing balance sheets. I need someone who can carefully...

...are seeking a highly skilled and experienced web scraper to undertake a complex project involving scraping a specific website for detailed product information. This project will be divided into two phases and requires the development of a comprehensive Intranet site to manage and parse the scraped data effectively. Project Overview: Initial Requirement: Conduct a feasibility study before starting the project. Successful completion will lead to future collaboration opportunities. Expertise Demanded: Applicants must demonstrate their expertise with samples of previous work. The quality and efficiency of the code will be rigorously tested. Phase 1: Data Scraping and Database Integration Input: Read an Excel sheet listing products. Target Website: Navig...

I’m looking for a skilled freelancer to convert images of 12 spreadsheet tables into a single Excel file. Each table should be on a separate sheet within the Excel workbook. **Requirements:** - Extract and include formulas from the images - Ensure all 12 tables are fully editable - Organize each table on an individual sheet in one Excel file **Ideal Skills:** - Proficiency in Excel and data entry - Attention to detail for high accuracy - Experience with image-to-Excel conversion - Knowledge of Excel formulas and functions Your task will be to interpret the images accurately and transfer the data, including any visible formulas, into the Excel format. The final product should be meticulously organized, with a premium on accuracy and functionality. If you have a proven...

...guide me through the Sheet Metal Die Forming Manufacturing process for a prototype. The ideal candidate will have experience in sheet metal design and be familiar with the manufacturing process. I don't need an drawings made. This is not a CAD project. You will show me what I need to do to get my prototype made. Skills and experience required for this project: - Sheet metal design: The candidate should have a strong background in sheet metal die forming manufacturing and be able to translate design specifications into functional prototypes. - Manufacturing expertise: The candidate should be knowledgeable about the manufacturing process for sheet metal prototypes and be able to provide guidance and advice on material selection and...

I am seeking passionate individuals to join me in aiding those affected by the crises in Ukraine. Our mission is to provide comprehensive assistance through multiple channels. Here's what we're looking for: - **Financial Support** - Donations of any size to purchase food, clothing, and shelter essentials. - F...Our mission is to provide comprehensive assistance through multiple channels. Here's what we're looking for: - **Financial Support** - Donations of any size to purchase food, clothing, and shelter essentials. - Funds for critical medical expenses. - Contributions toward impactful social projects. Volunteer Efforts. - Social media enthusiasts to amplify our cause. - A network-sharer to spread awareness and drive fundraising efforts. Your con...

I'm seeking a skilled CAD designer who has worked extensively with PET acoustic sheets for interior decoration. The CAD designs should have a contemporary feel, and incorporate geometric patterns. Ideal candidates would have experience in creating CAD designs for interior décor and should be skilled at incorporating geometric shapes into contemporary design. A strong grasp of how PET acoustic sheets work in an interior decor context would be highly beneficial. Proficiency in using vector based CAD design software is a must.

...real-time predictions for various sports. My vision for this app is to make it a go-to tool for fellow sports enthusiasts who enjoy insightful betting. Here are my focused requirements: - **Coverage for Multiple Sports**: The app should support predictions for Football, Basketball, NHL, NCAAB, NCAAF, and WNBA. - **Prediction Types**: It should offer not just winner predictions but also cover point spread and over/under predictions to give a comprehensive betting angle. - **Update Frequency**:   - The algorithm should deliver predictions in real-time, thus requiring integration with live game feeds and swift analytical capabilities. **Ideal Skills/Experience for the Freelancer**: - Proficient in app development for iOS/Android - Experience with sports analytics and predict...

...links per hour. #5 - A report must be given to me by 8 AM EST every day of the week while you maintain a contract with me. The report must be a shared Google sheet, which I will give you the link and you will update. There will be a master list of all links that you have given me. There will be another tab for links you have acquired for the past day's worth of work. #6 - I do not expect internal SEO. This job is for external SEO. You will be given URLs and keywords + key phrases for each page to use as anchor text. #7 - This job will officially start in about a month. #8 - I require constant communication with this project. I am to be given a work schedule of when you will work. My time zone is EST. I expect there to be 4 hours of overlap in your work schedul...

I'm looking for a talented freelancer who can create a 20-second artistic and abstract promotional video that encapsulates the essence of my brand. This will require a keen eye for design and a creative approach to animatio...music (since voice-over/music preferences were not indicated) **Key Points:** - Picture of one map come first in screen from small to fulll screen. (Picture provided) - Map turn into the water mellon (Picture provided) - Seeds of water mellon spread and turn into the text and map goes to the left side. - 4k and orginal project file be provided If you have a passion for crafting unique video materials and can deliver a striking promotional piece that stands out, I want to hear from you! Please provide examples of your previous work relevant to this...

I'm in need of an expert well-versed in managing data and creating formulas in Excel, as well as designing and creating interactive dashboards. Key Responsibilities: - Create excel sheet to test the reconciliation Manage data within Excel spreadsheets and CSV files - Create effective formulas within Excel - Design interactive dashboards using charts, graphs, tables and data grids Ideal Skills and Experience: - Advanced experience with Excel data management - Expert in creating Excel formulas - Proficient in designing interactive dashboards - Experience using charts, graphs, tables, and data grids - Knowledgeable about handling data from Excel spreadsheets and CSV files Your understanding of financial data and ability to present it in an engaging, visual way will be a key ...

i need to create KPIs for my reconciliation team in an excel sheet that is connected to a dashboard to show the results automatically. I have created a rough draft and i want to develop it. the second part of the project is analyzing the excel sheets they are reconciling each day and create a dashboard that also shows the results. the sheets aren't complicated. i have alot in my mind but i don't know how to make it applicable. i need to create some pivot tables and some formulas in excel to make it easier for reconciling.

I'm in urgent need of someone highly profici...proficient in Excel to filter my data and make one sheet. I have very specific data to be removed. This work will not take more than an hour for expert. IDEAL SKILLS: - Proven expertise in Excel and data management. - Strong experience with advanced functions and conditional formatting. - Capability to write and debug complex formulas. - Bonus: Experience with VBA for potential automation. EXPERIENCE REQUIREMENTS: - Previous projects involving large databases in Excel. - Strong analytical skills with attention to detail. - Efficient and clear communication throughout the project development. I skipped the criteria specifics, but I look for flexibility in approach. Please share your relevant experience and how you would ...

DELIVERABLES Power BI file ADDITIONAL INFORMATION I need a quick Power Bi analysis - basically I am trying to filter this attached csv to identify the Root AND Basename of the files that are (each analysis should be on its own sheet): ARE really OLD (i.e. the 'Created' date is far in the past) Are really OLD AND have not been Accessed recently (i.e. in this case - the 'Created' date is far in the past AND the 'Accessed' date is either EQUAL to the 'Created' date AND/OR it is also far in the past) and ARE really OLD + Have not been Accessed recently and ARE SORTED by SIZE (the bigger number). I have attached a example graphic of a chart that I think would work for these 3 analysis. Specifically, I think maybe a chart something like this might...

...live auction platform. Here's what I need specifically: - Real-time bidding system allowing immediate bid updates. - Comprehensive item catalog with detailed descriptions for each auction item. - A functional bid history tracking for participants. - A live countdown timer for auction urgency. - Platform manageable for less than 500 bidders and 500 items. Key features based on a detailed spec sheet will be provided. The site should be able to handle manual entry of items by an admin. Ideal Freelancer Qualities: - Proficiency in developing custom web platforms (or a hybrid withWordpress). - Experience with real-time web technologies (e.g., WebSockets). - Skilled in database management for inventory and bidding data. - Understanding of creating user-friendly interfaces and ...

...are seeking a highly skilled and experienced web scraper to undertake a complex project involving scraping a specific website for detailed product information. This project will be divided into two phases and requires the development of a comprehensive Intranet site to manage and parse the scraped data effectively. Project Overview: Initial Requirement: Conduct a feasibility study before starting the project. Successful completion will lead to future collaboration opportunities. Expertise Demanded: Applicants must demonstrate their expertise with samples of previous work. The quality and efficiency of the code will be rigorously tested. Phase 1: Data Scraping and Database Integration Input: Read an Excel sheet listing products. Target Website: Navig...

I'm looking for an adept financial analyst with an expertise in preparing financial statements, particularly income statements and balance sheets. To be more specific, the task involves: - Summarizing 10 transactions. - Preparing an income statement for February, 2019. - Creating a balance sheet as of January 31, 2019. - Preparing a comparative balance sheet as of February 28, 2019. All necessary transaction details for the task are available and ready for analysis. The ideal freelancer for this job should: - Display a strong background in financial statement preparation and analysis. - Demonstrate sharp attention to detail. - Be proficient in the use of Excel since the final documents should be delivered in this format. This opportunity is perfect for individuals s...

We are on the lookout for a skilled hashtag#ZohoBooks expert to conduct 3-4 training sessions for our dynamic accounts team. Our focus is on elevating our bookkeeping game and mastering compliance sheet management through Zoho Books. What we're looking for: - Practical insights on Zoho Books functionalities. - Best practices for efficient bookkeeping. - Compliance sheet management tips and tricks. Details: - 3-4 sessions tailored for hands-on learning. - Your proposed agenda and topics. - Your availability.

I'm seeking someone with high attention to detail who can meticulously organize my disparate, varied PDFs of historical blood and health results into a sorted Excel sheet. Key Responsibilities: - Extraction of data from different PDF formats - Data entry into an Excel file - Organisation of data by Test Type Data to Include for Each Test: - Test Name - Date - Test Result - Reference Range Ideal Skills and Experience: The ideal freelancer for this project should have: - Exceptional skills in data extraction and data entry - Experience with PDF conversion to excel - Advanced skills in Excel file organization - Background in health or related data would be beneficial.

I need Sales qulaified web design leads through email outreach From INDIA only. We need intrsted candidate who are looking for web design service. We are intrested in the niche Astrologers, Realesate, Event Company, eCommerce etc. Atleast 3 to 5 emmail outreach should be done to warm up the cold lead. lea...design leads through email outreach From INDIA only. We need intrsted candidate who are looking for web design service. We are intrested in the niche Astrologers, Realesate, Event Company, eCommerce etc. Atleast 3 to 5 emmail outreach should be done to warm up the cold lead. leads Count atleast 100 intrested leads who are having interest in web design for their business. Need a downloadable excel sheet in which their business name, Mobile nummber, email and their owners name...

I need a quick, insightful, and dedicated researcher skilled in delving into Google Scholar. Your task will be to gather material mainly. I will give you an excel sheet with list of publications and your task is to fill the table with missing values such as Author, Year, Publication Type (Journal, Conference) etc. The ideal candidate has a keen eye for detail, strong researching skills, and should be able to deliver the work ASAP. Candidates with a background in Machine Learning or MLOps will be highly prioritized. Please bring along your previous work samples. Feel free to place your bid if you can comply swiftly to the project’s urgency.

I need an Excel spreadsheet designed to meticulously track my finances. It should include three main sections to monitor: - Income and expenses - Assets and liabilities - Sales and purchases The sheet should be capable of automatically calculating the sum of total income, total expenses and also the income minus expenses for quick financial analysis. It's paramount for me that the spreadsheet design is professional and minimalistic, providing clarity and ease of use without unnecessary distractions. In terms of skills, a full understanding of Excel formulas and the fundamentals of accounting are essential. The ability to create professional designs within Excel would also be highly valued. Previous experience in finance or accounting related projects would be advantageous.

I’m in need of a freelancer for a data entry task. Your main responsibility will be to enter numerical data into an Excel sheet with high accuracy and efficiency. No analysis of the data is expected after entry. Here's what you'll do: - Input numerical data accurately - Ensure no data failure or inconsistency - Final output to be delivered in Excel Workbook format Ideal skills and experience: - Previous data entry experience - Proficient in MS Excel - High attention to detail - Solid understanding of data confidentiality principles - Good typing speed and accuracy.

...Migrate income statement, balance sheet, and cash flow statement data. - Data is ready in Tally/Excel format. - Perform basic categorization of income/expenses. **Ideal Candidate:** - Proficient with QuickBooks online. - Experience with accounting data entry. - Understanding of financial statements. - Ability to manage time effectively to meet the one-week deadline. **Objective:** - Ensure data is accurately reflected in QuickBooks. - Prepare for upcoming audit by having P&L and Balance Sheet readily available. **What You'll Deliver:** - Complete transfer of financial data to QuickBooks. - Verification of data accuracy post-migration. - A report summarizing the data uploaded and any potential discrepancies. If you have the necessary skills to complete this ...

...customer a tablet instead of a piece of paper and they will fill out the form and sign it as well with their signature (with their finger). The information will then be saved into a google sheet where I can run reports on the data. I have a basic google sheet/google form that does most of this but I want more customization. The current information will be imported so its not lost. Also key features will be emailing a copy to the customer under certain circumstances, emailing our review department a copy of the form filled out. Not all fields for security reasons will be emailed. The current google sheet/form will be used as the foundation so it will be easy to copy over the data. I would like the application to also run on a computer (example windows tablet). It c...

...estimating about 8 hours of work in total. Here's what the project entails: - Converting data from PDF into Excel spreadsheets - Ensuring accuracy while inputting the information - Some interpretation of data based on rules I will provide you It is critical you possess a keen eye for detail, to confirm you are able to understand and complete what is required I am asking you to complete a small trial which should take up to 5 minutes. I have posted three files with this job: - Example - Data - - Trial - I have entered the Example timesheet in the excel file. If you could enter the "Trial - entry" timesheet in the same format and post the excel file with your submission. The example sheet has highlighted the sections the data is to come from

...financial modeler to craft a robust Excel model with the following key components: - **Income Statement** - **Balance Sheet** - **Cash Flow Statement** These statements should reflect: - Annual figures - Incorporation of both historical data and future projections Ideal candidate qualifications: - Strong background in finance or accounting - Advanced Excel skills including formulas, pivot tables, and charts - Experience with financial analysis and modeling - Keen attention to detail and accuracy - Ability to interpret historical financial data - Proficiency in forecasting and creating financial scenarios What I expect: - A clear, easy-to-understand model - Assumptions sheet for projections - Dashboard with financial summary and key metrics - Charts/graphs for visual...

...discussion. - Create a safe and supportive environment for confidence building. Requirements: - Strong understanding of bullying issues faced by the age group. - Ability to design and implement creative and engaging activities. Skills: - Strong skills in creating interactive content and group management. Results: Detailed Outline about each day of the workshops including: - Table of Contents Daily: - Sheet with activities (games) - Topics and contents to be discussed - prepared documents for activities ready for printing if needed - etc. I need a finished workshop outline so that i can start teaching. This opportunity is perfect for someone passionate about empowering youth and experienced in delivering meaningful educational experiences. If you have a background in education...

Google sheet updates.

...apartment block to life. The task will involve delivering concept designs and a 3D render that embody the sophistication of modern architecture. Key Project Requirements: - Create initial concept plans for a modern-style apartment block - Develop a 3D render of the concept Project summary: - Incorporate 4-bedrooms, 4 bathrooms, laundry, study, media room, health retreat (sauna and spa), and pool (infinity edge on balcony) into each unit design - Ensure each apartment covers 400m2 (including balcony / alfresco & pool space), with a total site coverage of 59% on a 689m2 block - one per floor apartment across 4 levels with the penthouse spread across 2 levels - 5 level building total plus basement carparking Ideal Freelancer Skills: - Proficiency in architectura...

I'm seeking an experienced Microsoft 365 Powerapps developer to help streamline operations in my team. With direct Excel sheet editing proving troublesome, I need a robust solution that ensures data integrity and boasts comprehensive reporting features. Key functionalities include: - Data capture forms: These need to be adept at capturing various types of data - including text, numbers, dates, currency, and time inputs. - Excel sheet replacement: I need the data capture process to substitute our direct Excel sheet editing procedures accurately and seamlessly. -Custom Reports and Analytics: The application should focus on product type, income channels, locations, customers, and calculated values. This directive demands a developer well-versed with transf...

I would like a CSV/Excel file of 500 vodka companies ( or ). I want a email of a contact at the company, like CEO. I want three column sheet with company name, contact email, and contact name.

I would like a CSV/Excel file of 500 sports nutrition companies ( or ). I want a email of a contact at the company, like CEO. I want three column sheet with company name, contact email, and contact name.

I need an Excel whiz for crafting smart, user-friendly macros and buttons that'll simplify my workflow. Here's what I envision: - Automating the insertion of a new row at the top of my sheet, each with a sequential number. - Ensuring this process is neatly formatted and aligns with the sheet's existing style for consistency and professionalism. For this task, a freelancer with the following qualifications would be ideal: - Strong Excel macro programming skills, preferably with VBA expertise. - Proven experience with Excel's formatting functions, ensuring neat and efficient automation. - Ability to work quickly and accurately, delivering a solution that's both effective and user-friendly. I'm aiming for a straightforward, easy-to-use system that make...

Greetings from BROS Translation! I hope you are doing well. We are looking for colleagues who can translate from Arabic to Kurdish Sorani (Iraq). This project will have a large volume. We may use the SmartCat translation platform (we will send invitations) for you to see and implement the repetitions quickly and to have more consistence translation. (Or we may use Excel sheet, this will be decided.) We are planning to start this week as soon as the client approves the project. The subject is cosmetic product descriptions. Please let us know as soon as possible if you are available for this potential project. Thank you in advance!

I'm seeking a meticulous individual to adjust a series of misaligned dates within an existing Excel sheet. The project requires attention to detail and proficiency in Excel. The successful freelancer will be responsible for correcting 1500 dates to follow a DD/MM/YYYY format based on recognizable patterns. **Key Tasks:** - Correct 1500 dates in the current Excel sheet. - Ensure dates follow the DD/MM/YYYY format. - Identify and correct months and days using logical patterns (e.g., month never over 12). **Skills Required:** - Advanced Excel knowledge. - Strong attention to detail. - Ability to follow patterns and logical rules. **Experience Needed:** - Proven experience with similar data correction tasks. - Prior work involving large datasets in Excel is idea...

I’m looking for a resourceful developer to create an innovative Chrome extension tailored for efficiency. - Extension Purpose: Generate a spec sheet link and download it as PDF and Word documents—excluding item prices and source details. - Key Features: - One-click functionality. - Automatic file naming based on product name. - Inclusion of product name, description, technical specs, product images, and additional information. - Requirements: - Proficiency in Chrome extension development. - Familiarity with JavaScript, HTML, CSS. - Experience in PDF and Word API integration. - Ability to manipulate DOM to extract specified content. - Knowledge in file generation and download without server-side dependence. - The extension price is $1 per month for use...

...all my expenses and income in a simple and easy to understand schedule I will contact him daily to tell him my expenses and income I will need to know what is my monthly budget How much income and expenses i need to know for the next months How much im spending We will start gathering all the information from my side up then i will tell him daily my expenses and income. I need in my excel sheet to be delivered for my real estate business just to double check what i will give him other accountant in regards of income only. my car business how much each car cost me and what is my profit divided in % for some cars as some cars i have partners in them. All my personal expense, on my kid, Wife, ordering out and all this. budgeting for big expenses This will be a long job i wi...

I am looking for a skilled developer with expertise in Laravel and PHP platforms to create a unique website for my business. The website should have flexible server access subscription functionality. Details: - Develop a page on existing website . - Implement a serve...month. Total price will be display In next line in bold. Requirements comment box keep as it's. CHECKOUT BUTTON WILL DISPLAY Customer will proceed for payment. you can add this checkout to existing payment gateway it should work for domestic and internation payment. Payment test successfully will be done by developer Server access customer data that should be store in admin site in excel sheet. WE ALREADY HAVE EXISTING BACKEND WHERE YOU CAN WORK. Please visit website for server access menu

As a business owner, I am seeking an accountant and/ or a bookkeeper who can assist me in crafting a meticulously detailed three-way budget template. I need a tool that will allow me to effectively manage and oversee my company's finances. Key Aspects: - The template should include an income statement, balance sheet and a cash flow statement. Each of these statements is critical in comprehending the financial position of my business. - I would prefer a template which provides a monthly breakdown of the data. This would allow for a more thorough analysis and management of my company’s finances over time. Ideal Candidate: - An experienced accountant or bookkeeper, - Familiar with Microsoft Excel and financial management, - Has previously developed or used three-way budget...

I need to send data entered by website visitor in Wix Website to specific cell in google sheet and fetch calculated value from google sheet and display it. (Pls mentione code 4+5 = ? response to start conversation. Check this website link and gsheet link Both input values and fetched value need to be stored in a Wix CM. Project delivery: 1. once complete we will test the values are posted and fetech properly 2. you need to provide us integration steps in a document or video record 3. once we are able to follow the guide we will release the milestone

I seek a dedicated professional to build an email parser that unceasingly operates on my web server. The software should be designed to monitor my Gmail inbox closely, tri...include: - Keyword Recognition: It must be programmed to recognize a particular subject in each email. - Data Extraction: Upon the identification of the unique subject, the parser should extract certain information - email addresses, names, and specific prize values embedded within the content. - Google Sheets integration: The extracted data should then be systematically added to a designated Google Sheet. Practical experience in parsing emails and excellent knowledge of Google Sheets API will be a plus. Interested candidates should also possess strong communication skills for seamless collaboration and troubl...

I am looking for a PowerShell expert to assist with a unique project. The objective is to automate the process of importing query results from an SQL database into Excel. Further requirements include: - Applying column filters to the raw data. - Constructing a pivot table with the imported and filtered data. - Finally, embedding a snapshot of the generated pivot table into the body of an email. The freelancer must have a solid understanding of PowerShell programming and SQL databases. They should be proficient at manipulating data with Excel and using email generation modules in PowerShell. Familiarity with SQL query writing is essential since the process revolves around accurate results. An ideal candidate would be someone who is detail-oriented and can determine appropriate filt...

I require a seasoned Excel wizard to create an intricate spreadsheet for me. My necessity involves handling both text and date/time data. The optimal organization for this data on the sheet would be a mixture of columns and rows. Hence, understanding the context and logic in data placement is key. Additionally, the project would extensively require text and string operations. Ideal candidates should be familiar with various string-related functions such as LEN, RIGHT, LEFT, MID, SUBSTITUTE, and REPT, among others. Your proposal should clearly mention previous similar projects you've undertaken. An understanding of VBA to create customized functions would be a bonus, but is not a compulsory requirement. Parametres Each entry has 2 lessons that must be one hour apart (i...