Power query excel for macроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Mac Інше або не впевнений Потрібно зробити хайп проект
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
Доброго дня, Шукаю freelancers які уміют професіно виконувати презентації формату power Point у Prezi (), Power Point або інших програмах на високому рівні. На даний момент потрібно зробити презентацію (приблизно 15 сторінок) з використанням інфографіки, модернових шрифтів, футурістічніх фото що відображатімут динаміку, інновації та відчуття новизни. Деталі проєкту, приклади фото та презентаціий надаются. Якщо вас зацікавив даний проєкт звертайтес за додатковою інформацією.. Буд-ласка передайте приклад виконаної вами роботи та очікування щодо оплати. Дякую Анна
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
I'm in need of an experienced freelancer capable of extracting data from scanned documents and entering them into Excel in a simple tabular structure without the need for tables or visualizations. The project involves: - Accurate data entry from PDF files into Excel - Interpretation of simple data without need for merging or referencing Ideal freelancers should possess: - Strong data entry skills with a keen eye for details - Proficiency in Excel and ability to understand simple tabular structures - Experience in dealing with PDF files for data extraction - High level of accuracy and ability to verify their own work for completeness and correctness - A keen sense of responsibility to meet project timeline.
This project requires a freelancer with advanced skills in Excel. I am outsourcing tasks revolving data management. Key Aspects include: - Advanced manipulation of Excel functions - Complex calculations - Refined data analysis When applying, please focus on: - Your practical experience with similar tasks Having realized the depth of this project, it's pivotal that you have an advanced understanding of Excel. Ideally, your background should perfectly align with data management, advanced calculations, and analytical tasks. Demonstrating this through past projects and describing your specific insights gained from those experiences will be a big plus.
...Standard Operating Procedure (SOP) developed for the electrical installation of IT equipment in our facility. The SOP must cover the standardization of electrical setups for: - Desktop computers - Servers - Networking equipment The SOP must adhere to and align with both the International Electrotechnical Commission (IEC) standards and Occupational Safety and Health Administration (OSHA) regulations. The sources of Power are: State Electricity Company, Generator and Solar Panel. The level of standardization required is advanced. This means that the SOP should be detailed and specific, leaving no room for ambiguity or deviation from the set standards. Ideal skills and experience for this job include: - Proven experience in electrical installations ...
...skilled freelancer to undertake a multifaceted project involving the detailed completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramo...
...technology based on our client’s needs. We’re primarily building web-based applications but have opportunities for mobile development as well. You’ll need: In-depth working knowledge of functional React, preferably 16.8+ In-depth knowledge of ES6 syntax Fluent in Typescript Experience using a 3rd party component library (e.g. MaterialUI) and/or CSS frameworks Experience working with state management tools (e.g. React Query) Familiar with Git, including standard development lifecycle (feature branching, pull requests, CI/CD) Experience with React testing methodologies, or a strong desire to write testing An interest in all aspects of the SDLC, including talking to clients is ideal When you work for us, you’ll enjoy: Rapid career advancemen...
1. Preciso de um aplicativo para fazer uma lista de patrimônios da empresa com alguns campos específicos de fácil consulta e inclusão com as fotos e detalhamento do material. 2. Preciso de app que me ajude no ponto diário da empresa com geolocalização e foto, como se fosse um formulário. Detalhes para passar depois.
I require an Excel specialist proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good understanding of GP indicator...
I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box t...
I need this to be done IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experience in handling this ...
I would like to hire a developer that is familiar with coding C++ on an Arduino platform. Project Description: - Control a poker game via addressable LED light strips & buttons for each player, including the dealer. I have a flow chart built for the functionality I am looking for (see attached pdf) and the effects I want to happen once certain conditions/states have been met. Hardware details: - W2812B LED Strip - Individually Addressable 16.4ft, 60 pixels/m - DC5V - AC100-240V to DC5V/30A Power Supply - Max 150W - Arduino Mega 2560 R3 - (10) Push-Button Switches I would ideally like this to be completed within the next few weeks. We can lower the complexity if that will make it more feasible / less buggy. Thank you!
...project is causing CPU usage to spike to 100% due to complex queries. I need an expert to optimize the project's performance. Key Responsibilities: - Diagnose the root cause of the performance issue, specifically tied to the high CPU usage - Implement Laravel best practices for handling complex queries - Provide recommendations and implement changes to optimize the project's performance Ideal Skills and Experience: - Proven experience in optimizing Laravel projects - Solid understanding of database indexing and query optimization - Familiarity with caching strategies and how to implement them in a Laravel project This is a high-priority task. Immediate availability and quick turnaround will be highly appreciated. Duevto cpu usage website is not accessible. I...
I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.
Tengo una asesoría energética, la cual paga comisión por contrato. La comisión depende de distintos factores. Actualmente tenemos un backend en excel y un frontend en pdf, es decir: Creamos las comisiones en excel para agilizar la creación, las copiamos en un POWERPOINT algo más atractivo y visual, y las convertimos a pdf. Nos gustaría poder implementar la subida de estos excels en una interfaz BONITA, incrustrada en una web. Lo ideal sería poder cargar estos excel a la web y que la web "pintara" estas comisiones a través de una interfaz visualmente atractiva y llamativa para nuestros agentes comerciales. Adjuntamos ejemplo de excel de comisiones de algunas de nuestras compa...
Hello All , I want you to design a small machine which will clearly show the power consumption of a hub bearing , when hub bearing is rotating at 300 rpm or less . The power consumption of the bearing can be shown through a digital meter or oscilloscope. I need to compare the power consumption of various hub bearings . In this , you can measure torque of hub bearing and that torque of hub bearing can be converted in to ampere or other which will clearly show the power consumption . For your reference I have attached herewith the hub bearing , which required to be tested ; in attached document. Hub bearings have two flanges . I want you to fix one flange by some method and rotate other flange at 300 rpm or less . Scope of the project : 1. Detailed compon...
I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation
I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!
...Tech Conference in Toronto, Canada **Position Type:** Temporary (June, with potential for future collaboration) **About Us:** is redefining winter travel with an innovative approach through local business partnerships. Our platforms, including , SnowClub, and , simplify winter bookings by offering comprehensive services like transport, rentals, activities, tickets, accommodations, and more, creating an "Expedia for mountain resorts." SnowClub, a membership-based SaaS, adds a social network, exclusive discounts, and an online store. Our mission is to reshape the winter travel experience by filling an industry gap and creating the ultimate ecosystem for 140 million skiers and boarders worldwide. **Job Overview:** We're seeking an enthusiastic
I'm in search of an experienced and skilled developer who can create a remote desktop control application for Windows and Mac. Key Features: - File Transfer: The application should allow for seamless transfer of files between the remote system and the controlling device. - Real-time Chat: It should include a chat functionality to enable communication between the remote system and the controlling device. - WiFi Connection: The application should be able to function over a WiFi Connection. The program has to run in both windows and mac systems. The ideal candidate will have: - Proficiency in Windows and Mac application development - Experience in developing remote control applications - Familiarity with features like file transfer, real-time chat, scr...
I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this ac...
My aim is to significantly enhance user engagement. The project will focus on captivating young adults aged between 18 and 34 years. I wish to leverage the power of social media, websites, and mobile applications to achieve this goal. - Ideal skills: Experience in digital marketing, social media management, website and mobile app design. - Experience: Proven record of building an appealing digital identity targeting young adults, and enhancing user engagement across multiple platforms.
I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok,...existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail and creativity Being quick, creative, and consistent are the key components...
...be considered for the project. Freelancer – I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from ...
**Need someone to take over this project. ...files that need modifications.** SprayGon to Go will be a self-contained overspray reduction system designed for mobile sunless spray tan artists. The unit needs to be roughly the size of a large suitcase, with large wheels to ease pulling the box up stairs. The unit will contain a high velocity fan with 2 stage washable filters in front of the fan that can be removed for daily cleaning, an on-board HVLP air compressor with quick connect coupling for HVLP spray gun hoses, a storage compartment for spray service supplies, an on-board power strip or accessory outlets, a retractable 10' grounded power cord and a retractable pull handle. The case should be made of molded ABS plastic for durabilit...
I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messaging - Capable of implementing and managing information resources The main functionalities of the bot are: - Sending automated messages: The bot should be able to send pre-determined messages at set intervals. - Receiving user input: It should be able to interact with users and receive text input from them. - Providing information based on user queries: The bot needs to be able to present content from our company's internal library which will be provided upon Bot design by using MENU BUIL...
You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.
...is suitable for the generator. - Ensure the floor can withstand the weight of the generator for emergency backup power. - If necessary, provide recommendations for additional structural support. Location is 2nd level of a parking structure - Generator to be located along 2 walls in a parking spot. Please note that the generator will be used for emergency backup power, so it's crucial that the floor can handle the load without any issues. I am not certain if additional structural support will be necessary, but I need a comprehensive evaluation on this. Skills & Experience: - Structural Engineer with experience in load-bearing certifications and assessments. - Knowledge of generator installations and their specific requirements. - Abi...
I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as the analysis will be used to make important busi...
...set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal skills and expe...
I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.
I'm in need of a professional who can help me with transferring specific project data from QuickBooks to SharePoint using Power BI Desktop. The primary goal is to leverage the integration capabilities of Power BI and create a seamless process for porting this data. Key Responsibilities: - Importing and transforming project data from QuickBooks to SharePoint - Setting up a system for recurring data transfer - Ensuring data integrity and security throughout the process Ideal Skills and Experience: - Proficiency in Power BI Desktop - Extensive experience in data integration and transformation - Prior experience with QuickBooks and SharePoint is a plus - Strong understanding of data security and compliance - Ability to create an efficient and scalable ...
I require a highly-skilled freelancer to design and develop a Near Field Communication (NFC) reader circuit. The circuit will focus on reading NFC tags (NTAG 215) v...operating range of the NFC reader antenna should be between 1 to 2cm. - It must be capable of detecting specific tags without unnecessarily scanning nearby ones. - Furthermore, the circuit will be integrated with a specified embedded system, developing compatibility is a must-have. For this project, strong experience in circuit design, NFC technology understanding and embedded systems integration is required. Attention to detail to ensure accurate tag scanning and low power usage is also a critical skill for this task. Potential freelancers should demonstrate their knowledge of NFC reader ICs and corre...
...major platforms - RERA websites (specifically Maharashtra, Telangana, Haryana, and Delhi), Google, and Justdial. Here's what I am looking for: Details to Scrape: - Name - Mobile Numbers - Locality - City - Address - Pincode Platforms: - RERA Websites (Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivered in an excel file format. If you have the required skills and this project fits your area of expertise, I encourag...
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highli...
As a business owner seeking to improve my online presence, I am looking for an experienced professional to undertake a digital marketing campaign with specific goals: - Increase website traffic - Generate leads - Enhance brand awareness I am aiming my campaign at the Millennial demographic, requiring a marketer who understands the unique preferences, motivations, and buying behaviors of this group. Thus, the project will involve: - Utilizing the power of social media advertising for outreach - Implementing effective search engine optimization techniques to enhance visibility Ideal candidates for this job should have: - Proven track record in delivering similar projects - Deep understanding of the Millennial demographic - Expertise in social media adve...
I'm seeking a specialist with expertise in detailed financial data entry. You'll be tasked with entering intricate numbers and figures for our financial reports. Skills and Experience Required: - Proficient in Microsoft Excel. - Experience with financial report data entry. - Detail-oriented with ability to handle complex numerical data. Main Tasks: - Inputting detailed financial data into our Excel-based financial reports. - Ensuring accuracy of data. - Completing tasks within given deadlines. Please share relevant previous experience and examples of your work when bidding.
I'm in search of a seasoned Excel-savvy bookkeeper to assist with the following tasks: - Accounts Payable: Tracking and managing all outgoing payments in a clear and organized manner. - Accounts Receivable: Overseeing and monitoring all incoming payments, ensuring timeliness and accuracy. - Bank Reconciliation: Regularly reconciling bank statements with our financial records to ensure accuracy. You don't necessarily need to be an expert in accounting software, but you should be fluent in Excel. This project doesn't involve learning new software, but rather meticulously managing and organizing financial data in Excel. I prefer to receive updates and reports via email, so clear and concise communication skills are a must. Experience in bookkeeping or a...
I need an Excel expert to help me document my financial data in a specific text-based format. Key Requirements: - Organizing and documenting financial data in Excel - Following a specific text-based format provided by me Ideal Skills and Experience: - Proven experience in working with financial data - Proficiency in Excel, including advanced functions for data organization - Excellent attention to detail and ability to follow specific instructions accurately and efficiently.
Looking for someone who is highly knowledgeable in Excel functions, formulas, and formatting. The ideal freelancer will have experience performing the following tasks in Excel spreadsheets in portuguese - Implementing a variety of Excel formulas and functions - Applying diverse formatting techniques Unfortunately, I have not specified the exact functions, formulas, or formatting needed, meaning the freelancer must employ a broad range of knowledge and expertise in these areas. Experience with Excel in Portuguese is a definitive plus. The project requires an adaptable and meticulous individual able to meet changing demands efficiently.
I'm searching for a highly skilled architect or designer to create plans for an energy-efficient, sustainable housing unit - I need 5 units total. My vision is to have each unit fully powered by renewable energy, mainly solar power. We may also utilize solar heating, on-demand hydrogen, among other appropriate technologies. Key Project Details: - The project should be completed within a 1-month timeline. - The designs should include advanced energy-saving features such as energy-efficient insulation, LED lighting, and smart home automation. - It's also essential the design minimises air leakage to enhance the overall efficiency. Ideal Skills & Experience: - An architect or designer with a thorough understanding of renewable energy systems. - Proven ex...
I need a talented designer to create a minimalist logo for my company. Here are my requirements: - The primary color scheme should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligatory. Skillful use of it, contingent on how it fits into the design and overall aesthetics, is appreciated. Ideal candidates should possess past experience in minimalist logo design and a keen eye for balancing colors. If you excel in creating attention-grabbing logos with subtle details, then this project is for you.
I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.
...of this work. I want the Node application to make a connection to MongoDB using the *native Mongo* driver. NOT Mongoose. NodeMon - Project is setup with file monitoring to save development time. Also, the Visual Studio debugger is enabled and appears to be working well. Here is a link to a Visual Studio project which contains a test version of the application error. It has had files removed for security and to reduce the file size. Here’s some rough instructions, I’m not a Node/Docker expert but this should get you going. 1 - Download and uncompressed the Visual Studio zip file 2 - Open the workspace in Visual Studio 3 - Open a new terminal window in the project root folder and run "docker compose
