Excel power bi downloadpekerjaan

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the portal]". • Automate the process of c...

For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...

I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, that would be an additional bonus.

Hi, I need to link various data between sections in my current Perfex CRM installation. I'll provide you a staging version of the CRM where you can try the customization and then replicate it into the main version. I've attached an explanatory excel where you can see what data is to be shown in other sections of the CRM. (CRM ) Below you can see what data need to be sync in the Perfex CRM. 1. When creating a Lead-related Task, copy the data [Address] [City] [Description] 2. When creating a Proposal related to the Lead, copy the data [Network] In CRM I created a custom Network field (multiselect) for Leads and Customers and the same field within Proposals as well. When creating a proposal associated with a lead or customer the Network data should appear automatically ...

Hi, I need a creative powerpoint specialist who could help in creating an interactive power point slides (3-4 Slides) for my business. Will share the content and concept post shortlisting the freelancer. Thanks, Vaibhav

I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Excel spreadsheets, making t...

...and robust, supporting seamless and high-quality communication. Key Features: - The primary goal of this application is to facilitate video and audio calls. The calls should be clear, stable, and have a high frame rate for video calls. - Security is a priority. The application must ensure end-to-end encryption on all calls. ( peer to peer ) - create link for call , ( not need to register, just download the application ) Skills: - Proficiency in iOS app development, including experience with video and audio call features. - Strong understanding of creating user-friendly interfaces. - Knowledge of security protocols specific to mobile applications. - Prior experience in developing similar applications will be an advantage. Please also include a brief list of your previous work...

I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.

...peripherals, you'll need to carefully consider the connections and power requirements of each component. Here's a basic outline of how you might design such a schematic: 1. Rockchip RK3588: - Connect the RK3588 SoC to the necessary power supplies, clock signals, and peripherals according to its datasheet. 2. 4GB/8GB RAM: - Connect the RAM module(s) to the RK3588 SoC's memory interface, ensuring proper signal routing and power connections. 3. eMMC: - Connect the eMMC storage device to the appropriate interface on the RK3588 SoC, typically using MMC/SDIO or SPI interface. 4. NVMe M.2 SSD Port: - Provide the necessary connections for the NVMe M.2 SSD port, including PCIe lanes and power connections. 5. USB C Type Data + Power...

...GCC TAX GPT, a groundbreaking language model specifically designed to streamline and simplify tax processes. Problem Statement- Tax preparation and filing can be daunting and time-consuming for individuals and businesses alike. Complex tax codes, ever-changing regulations, and the potential for errors can lead to stress and financial penalties. Introducing GCC TAX GPT- GCC TAX GPT utilizes the power of Generative Pre-trained Transformers (GPT) to become your intelligent tax assistant. Here's what it will offer: Automated Data Entry: GCCTAX GPT will be trained on vast amounts of tax data, enabling it to automatically extract relevant information from financial documents like receipts, bank statements, and investment records. This eliminates manual data entry, saving users...

I am in need of an expert in bash scripting with a solid understanding of Google Drive integrations. My current bash script, which is supposed to download "zip" and "tar gz" files from Google Drive, isn't functioning as it should. Here’s a rundown of my issues: - The script is not downloading any files whatsoever. - When a download attempt is made, there are subsequent error messages indicating failure. I require a professional who can: - Evaluate these error messages - Resolve these issues in a time-efficient manner It's critical that all downloads only consist of "zip" and "tar gz" file types from Google Drive. I expect clear communication and updates throughout the progress of this job. The ideal freelancer...

As discussed I have completed the template for Home Team Workbook.

I'm in need of an assistant who can help me make a copy of an online course. The course is more than 60 minutes long, and needs to be entirely recorded using Loom. Your main tasks will be to: - Using my loom account you will screen record all the videos in the course (over 30 of them) - You will download all the supporting documents and organise in a google file I'm not looking for any video editing, just a straightforward copying of the course. Familiarity with Loom and Google Docs is a big plus.

Descripción del Proyecto: Registro de Envíos: Seguimiento detallado de cada paquete, incluyendo número de seguimiento, descripción, fecha de recepción en Miami y estado actual. Dashboard de Control: Visualización clara y precisa de la cantidad de paquetes en bodega de Miami, en tránsito y en bodega/aduana. Base de Datos de Clientes: Gestión de información de clientes, incluyendo nombre, número de teléfono, dirección y saldo recargado de tarifas premium. Análisis de Rentabilidad: Generación de costos previstos para cada embarque, incluyendo costos de transporte, tarifas de aduana, impuestos, entre otros. Cálculo de la rentabilidad de cada embarque y visualización comp...

I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizational Skills: Ability to manag...

I'm seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, efficient, and reliable ...

I require a coder proficient in Ctrader Indicator development to execute my vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the s...vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a body and total size of the CURRENT candle in the current time frame. It should also display the following on a new line according to this Excel formula: =IF(BODY<=(CANDLE/2);"LLX";"...

We have our own ERP...in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel/CSV files - Directly integrated into accounting software Ideal Skills and Experience: - Proficiency in OCR technology - Strong background in invoice processing and automation - Experience with integrating software systems, particularly accounting and invoicing modules - Ability to work with both scanned image and digital PDFs - Proficient in data export to Excel/CSV files If you have a track record of successfully implementing OCR-based automation solutions and you're confident in your ability to handle these tasks, I would ...

Dynamic content, on the other hand, gives marketers the power to personalize every step of the customer journey to an individual's preferences, behavior and real-time context. Each user sees timely, relevant content, which in turn encourages clicks and sales. One of the well-known dynamic content example is Amazon's recommendation engine.

I need a skilled developer to craft an Android app that's geared towards both streaming RTSP video and performing basic video editing tasks. The app will be used with both live and pre-recorded streams. For video editing, features needed will focus on basic tasks like trimming and cropping, streamlining the user experience while maintaining power and flexibility. This app should be ideally designed and created by an individual proficient in mobile app development, particularly in video editing and streaming on the Android platform. Key requirements include: - Support both Live and Recorded Streams - Video Streaming and Basic Editing (Trimming & Cropping) - Experience in Android App Development - Familiarity with RTSP protocol and video editing tools.

I need a system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily adopted by non-technical team members. - Working with...

I have a Google sheet where bi I want to send automatic WhatsApp message to people when I enter something on the Google sheet cell this should be automatic and real time

I want to build anything which enables me to send customized whatsapp message as well as images from excel sheets

I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet

I'm looking to add ...my website with 15-20 questions. - I'd like it to include a mix of question types, such as multiple choice, open-ended, and rating scale questions. - The survey form doesn't necessarily need to be integrated with any existing databases or systems, though I'm open to this if it would be beneficial. - I don't require real-time visualization of the survey results - just the ability to view and download the data. Ideal Skills and Experience: - Proficiency in web development and survey form creation - Experience in designing and implementing multi-question surveys - Familiarity with database integration (though not mandatory) - Data visualization skills are a plus, but not necessary - Good communication skills to understand the requirem...

...kits on Alibaba and Amazon and Temu that are to be assembled. These may not have the most up-to-date sensor, connections that are best for the recommended power supply and not in a case that is waterproof. Also, perhaps the coding is not where it needs to be in order to meet my requirements. It is OK to buy one of these kits and tailor it appropriately. Be great to adjust angle of sensor but perhaps could do this with a wedge I make or shims. Will be mounted on outside of garage trim about 2 feet up from ground. Intend to power by a transformer or USB adapter- you determine. Cord will be run about 25 feet to outlet. You can exclude power supply from cost and the long cable which I can obtain. -I do not expect parts to cost more than $50, but am willing to t...

Here is a list of 35000 phone numbers. I need the american country code, +1, added to each entry. There is a way on excel to do this pretty quickly, I just dont know if, hoping you do.

I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.

I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...

I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.

I'm in need of a professional proficient in Excel and data entry to support two key tasks: data analysis and spreadsheet management. Here are the tasks in detail: - Data Analysis & Visualization: I've collected customer feedback data which need to be efficiently analysed and visualized. - Spreadsheet Creation & Management: The data mentioned above should be incorporated into comprehensible spreadsheets. In terms of analysis, the focus should be on customer segmentation. Ideal candidates should have: - Advanced proficiency in Excel for data analysis and visualization - Strong understanding of data cleaning and formatting to ensure accurate analysis - Experience with customer segmentation based on feedback data.

...where students from each grade can subscribe and receive science and mathematics summaries. - It has an intuitive and easy-to-use interface for a smooth experience. - School notes and summaries will be in the student’s file after subscription. He is allowed to participate in more than one category. - He can browse school notes and summaries, edit them in his file, and print them, but he cannot download them to his personal device. The files remain with him for a specified period, and then he is asked to renew the subscription. - Supports Word and PowerPoint formats - Editing Word and PowerPoint files through the website editor, whether it is cloud-based or linked to external editors such as Google, Microsoft, or others. Ideal candidate: The ideal candidate should ha...

I'm looking for an experienced data analyst who possesses expert skills in Excel and/or Google Sheets and a proficient understanding of Football, Basketball, and Baseball data. Ideally, someone who is skillful with analyzing and interpreting commercial level sports data into the form a betting model that understands, quantifies, and predicts based on specific metrics. The key characteristics of the models are: - Focus on the following sports: Football, Basketball, Baseball - Analyze the following data: Team performance, Player statistics and Game score projections to forecast point spread, totals, and moneyline bets. I have historical data ready to be applied to these models. This is a project where being communicative, organized, and knowledgeable in sports data ana...

as per communication, transfer data from DPF to excel.

I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.

...from Excel sheet to What's app Number (At certain condition and without opening the internet browser). Ideal Candidate: - Strong experience in integrating Excel with external systems. - Proficiency in WhatsApp and Excel automation. - Ability to create a reliable and efficient sync process. - Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quantities all the time. Requirements: **Data Synchroni...

I'm looking for a seasoned elect...circuit board with a microcontroller with ethernet connectivity, POE power and addressable LEDs, with the design done using EasyEDA software to be fully manufactured by JLCPCB (or equivalent). The core functionality of this project focuses on power management. Your skills and expertise should include: - Comprehensive understanding of EasyEDA software (can take other suggestions) - Proven experience in multi-layer circuit board design - Extensive knowledge in PCB design for power management This project requires intricate knowledge of these areas, so please only bid if you're confident in your ability to deliver. Looking forward to working with experienced and dedicated specialists. Proven portfolio related to power...

With expertise in blockchain technology, I'm focused on creating a sophisticated staking platform that fully utilizes the power of smart contracts. I’m specifically interested in the effective management of staking pools. To achieve this: - The ideal freelancer would be proficient in the design and implementation of smart contracts that expedite transactions and agreements. - Experience in developing decentralized applications and immutable records is also key. - Demonstrated experience in creating and managing staking platforms. - Prior work with implementing procedures for staking pool management is especially advantageous. The goal is to build a reliable, automated, and efficient staking platform using smart contracts. Experience with similar past projects will ...

...need to edit these into a single video, switching between the shots dynamically and sometimes combining 2 or 3 at the same time. Here are a few references: Below is the folder with the music and the videos, all in sync. I provide three links, if Google Drive says "Download Quota Exceeded" just use a different link: (mirror 1) (mirror 2) Requirements: - Choose the best shot(s) for every moment of the song. - All videos have been glued from smaller

I am seeking a skilled professional who is proficient in Microsoft Power Automate to streamline our business processes. These processes include automating our data entry tasks, setting up email notifications, file syncing, working with Sharepoint Lists, and Power Apps. The primary goal is to efficiently manage our business-critical data. Ideal Skills and Experience: - Expertise in Microsoft Power Automate - Experience with SharePoint and Power Apps - Strong understanding of data entry automation - Familiarity with email notification setup and file syncing - Proven ability to handle business-critical data securely If you can bring efficiency to our workflow processes with your experience in automating tasks, I want to hear from you.

I'm looking for a skilled freelancer who can create an automated Excel spreadsheet calculation for me. I need this spreadsheet to perform calculations based on cumulative data, specifically organized by date. You will need to be adept at Excel and have experience in creating automated spreadsheets. Knowledge of data organization and basic statistics would be a plus. I'm looking for a quick turnaround on this project. Please watch my videos for more details on what exactly is required.

I'm looking for an experienced MATLAB-Simulink professional to help me simulate DC arc faults in PV system. Key Project Details: - The primary purpose of the PV system is power generation. - I need the simulation to provide details on basic electrical parameters and arc dynamics. - I need the simulation using different arc models (Cassie, Mayr, Habedank, Kema, Paukert, Modified Paukert, Heuristic). - The Pv system (20 kW) should be connected to the grid. - The Pv system should have a dc-dc converter and inverter. The ideal freelancer for this project should have: - Strong expertise in MATLAB - Simulink - Experience with simulating electrical systems - Familiarity with photovoltaic systems would be a plus

...understand what the data says about our operations and ultimately enable us to make strategic project decisions. Details - The task involves analyzing complex financial data associated with our road construction projects. - We need to focus on key financial metrics, including project costs, ROI, profit margins and forecasting future financial scenarios. Skills and Experience - Proficiency in Excel at an advanced level - Background in finance, ideally with a focus in project finance. - Experience in construction sector would be an advantage. - Ability to analyze and interpret complex financial data and present in an understandable format. - Knowledge of financial forecasting and prediction methodologies. This project would demand a keen eye for detail, analytical acumen, and ...

...include reaching a target score, clearing a certain number of treats, or achieving a special pattern on the game board. - Obstacles: As players progress through the game, they encounter various obstacles that add complexity to the gameplay. These obstacles may include blockers which must be cleared to reach treats underneath. - Power-Ups and Boosters: Players can use power-ups and boosters to help them clear obstacles and achieve their objectives more easily. These power-ups have special effects when matched, however, at a score cost. - Limited Moves: In most levels, players have a limited number of moves to complete the objectives. If they run out of moves before completing the objectives, they fail the level and must try again, however, at a score cost. - Level Pr...

I'm looking for an internet speed tester that can evaluate three important aspects of internet connection: download speed, upload speed, and latency (ping). The test should be conducted on , a popular platform for internet speed testing. The results should be displayed in a graphical chart format for easy interpretation. Ideal skills and experience for this project include: - Proficiency in web development and network analysis - Experience in developing internet speed testing tools - Familiarity with 's API - Strong ability to visualize data in graphical form.

I'm looking for an Excel expert to automate various tasks relating to our tracking system and create an intuitive dashboard. The tasks will involve automation of formula calculations and report generation, to streamline our data processing workflow, and reduce human error. Key tasks include: - Automate formula calculations: Efficiently automate intricate excel formula calculations. - Automatic report generation: Create a mechanism for generating immediate, error-free reports that highlight key aspects. - Dashboard creation: Design a user-friendly dashboard displaying information based on Automatic report Generation. The ideal freelancer for this job should have: - A deep understanding of Excel's advanced features; - Previous experience with automations and ...

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet

I'm looking to upgrade my current ESP8266 controller to an ESP32 C3 Mini controller. I am primarily interested in freelancers with specific experience in this upgrade. Here's what I need: Requirement -1 : 1. Update existing Master Controller board based of ESP8266 to support ESP32 ...support ESP32 C3 IPEX/ (EasyEDA PCB design) 2. Retain GPIO connections and other circuits and components. 3. Ensure the position of LEDs, buttons and interfaces are as in current design 4. Ensure that the device supports handling loads upto 3A total without any heat with each port support upto 1 A Requirement -2 : 1. Redesign existing Zone Expander PCB board from Eagle to EasyEDA 2. Add LED Power indicator option 3. Ensure that the Expander handle upto 3A without any heating and each port...

...well-versed in the sidereal time system to create an Excel sheet that provides the planetary positions in Vedic Astrology of Sun, Moon, Mercury, Venus, Mars, Jupiter, Saturn, Rahu, and Ketu. The final deliverable should have the planetary positions presented in degrees, minutes, and seconds format and zodiac placement of planet and if the planet is retrograde or not. Successful applicants should provide examples of their past work in Vedic astrology, especially on planetary positioning. A detailed project proposal would also be well appreciated. Ideal skills and experience for the job include: - Programming skills of C, C++, Python or Java and a bit of Vedic astrology knowledge, particularly on planetary positions - Proficiency in Excel - Experience in presenting comp...

I have printed documents that need to be typed into an Excel sheet. The final spreadsheet must also be formatted according to specific requirements. Ideal Skills and Experience: - Proficiency in data entry with high accuracy - Strong understanding of Excel, including: - Use of formulas - Conditional formatting - Data sorting and filtering - Attention to detail to ensure accurate data entry and formatting