How to use power query in excel 2016dela
Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server
Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent
Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..
TRANSLATING DOCUMENTS FROM ENGLISH TO ARABIC & ARABIC TO ENGLISH MICROSOFT OFFICE PACKAGE (WORD, EXCEL, POWER POINT & VISIO) PHOTOSHOP PRORAMME CORPORATE ORGAISATIONAL STURCUTRE, EVALUATION REPORTS & PROMOTION TYPING: 40 WORDS PER MINUTE IN BOTH ARABIC & ENGLISH
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've wor...
I'm looking for...editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling, even though I've not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation a...
...tools to tell you what’s already trending, as well as finding the next big stories yourself. Editing and posting stories and videos on our social pages while coming up with new creative ways to drive traffic to our sites and grow our audiences. You will be forward planning social media content and coverage, covering live events and breaking news on social media while monitoring the external landscape to identify trends – and communicate findings while sharing knowledge and best practice across the business, but particularly in the newsroom. Shift Patterns & Working Location This is an office based role working from our New York office, we are therefore open to candidates based in or commutable to New York. Please...
TRANSLATING DOCUMENTS FROM ENGLISH TO ARABIC & ARABIC TO ENGLISH MICROSOFT OFFICE PACKAGE (WORD, EXCEL, POWER POINT & VISIO) PHOTOSHOP PRORAMME CORPORATE ORGAISATIONAL STURCUTRE, EVALUATION REPORTS & PROMOTION TYPING: 40 WORDS PER MINUTE IN BOTH ARABIC & ENGLISH
I am looking for a freelancer to assist me with specific data cleaning and transformation tasks in Microsoft Power BI. Skills and Experience: - Strong proficiency in Microsoft Power BI - Experience in data cleaning and transformation techniques - Ability to work with large datasets Data Output: - The preferred format for the data output is data sets Data Collection: - I already have the data, so the freelancer will not need to collect it.
We req...mechanical hardware systems like circuit boards, power supply, control systems, and communication systems. Your role requires you to create a detailed questionnaire and out of it to create a comprehensive analysis document for managuing risks. The ideal candidate must posess: - Proven experience conducting multiple FMEA activities in the past 24 months (provide evidence) - Specialised knowledge on electrical/ mechanical hardware analysis - Proficiency in examining circuit boards, power supply units, and control systems Kindly note that those without proof of previous FMEA execution need not apply. We seek someone who can help us entirely avoid or reduce risk. Your proficiency in identifying, analysing, and mitigating potential s...
I'm seeking expert assistance to work on the planning and design phase of my hydroelectric power project. This encompasses a range of tasks: - Site Assessment: Thorough evaluation of the proposed site for feasibility and environmental considerations. Experience in multiple site assessments for hydro projects required. - Technology Selection: Guidance for identifying the most efficient and suitable hydro technology for the project. Experts with a strong background in hydro tech preferred. - Engineering Design: Well-versed in creating an optimized and robust design layout for the hydro plant. Must have a proven record in designing successful hydroelectric infrastructural plans. Expertise in hydroelectric energy and infrastructure desi...
I NEED TO JOB READ Please My name is mojtaba from iran And i living in turkey because i cant live to iran and i need to leave turkey and go to armenia That's why i need to find freelancering job I am Professional and i can do your work goodly im new in freelancer As a photo and videographer with 18 years of experience, I have extensive knowledge of camera settings, lighting techniques, and composition principles. I am proficient in software programs such as Photoshop, Premiere, Davinci, and Lightroom for editing and color grading. I am creative and excel at coming up with unique ideas, and I love working with clients to understand their needs and bring their ideas to life. Communication is key to...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
...well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioriti...
I am searching for a highly skilled app developer to create an e-commerce application that will power a new online shopping experience for my business. Key responsibilities: - App Development from start to end - Troubleshooting and optimization after the launch Requirements: - Proven experience in app development, particularly e-commerce applications - Ability to make strategic decisions relating to app design and functionality - Understanding of the latest app trends and willingness to implement them where necessary While it is not specified which platform the app will be for, the developer should have experience with iOS, Android, and web app development. It is not yet determined what specific e-commerce features I want in the ...
...owner in North Yorkshire, I am looking for an experienced electrical engineer who can successfully perform a detailed power system analysis for me. Your foremost task will include: - Analyzing the reason behind the overreading meters, potentially due to harmonics. - Recommending a solution to address the problem. - If the solution is outside the property presenting a paper to OFGEM detailing the science behind the problem, the solution and the party responsible for implementing the solution (Power Supplier or Electricity Board) Ideal Skills: - Strong understanding of single phase domestic supply systems. - Expertise in load flow studies and power system analysis. - Proficient in diagnosing and resolving issues...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I need a PowerBI specialist for unint...for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in si...
I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or ...
...Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Develope...
Looking for a freelancer with expertise in managing and manipulating numeric data sourced from Excel spreadsheets. The work involves: - Efficient management of extensive numeric data - Organizing the data effectively onto separate worksheets according to their specific types Ideal candidates are those with previous experience in data entry and strong proficiency in Excel. Your responsibility would not only be to perform accurate data entry, but also structure it logically and intuitively. It requires excellent attention to detail, precision, and the ability to understand data categories. We value those with a proactive approach who can offer insights into improved data organization. Solid experience in similar projects...
...Introduction: In the contemporary business landscape, understanding and catering to the needs of customers is paramount for organizational success. To achieve this, businesses must gather, organize, and analyze data about their potential and existing customers. This project focuses on developing a comprehensive system to streamline the process of collecting, integrating, and leveraging customer data to create personalized marketing campaigns. Objective: The primary objective of this project is to establish a dynamic and continuously updated database that empowers personalized marketing strategies. By gathering, cleaning, integrating, and analyzing customer data, the system aims to provide insights into customer preferences, behaviors, an...
...understand. Read first We are in search of a proficient Laravel/PHP developer to assist in the development of APIs for our upcoming matrimonial app. The backend infrastructure is based on Laravel, and we require the creation of several API endpoints to power core functionalities of the application. Notification API: Enable notifications for user interactions and events within the Code: Implement coupon code management for user promotions, including creation, validation, and : Develop APIs to manage user messages, including sending, receiving, deleting, and reading Active/Online: Track and display users' last active time and online Match: Calculate similarity scores between user profiles to facilitate
...professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your proposals.
I'm urgently in need of a Python specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show t...
I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.
...want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle]() containing information of companies from 1857-2020. My initial approach is to use appwrite for backend and react for frontend. populate the appwrite db with information from the csv file. then build the react frontend. however I can't help but wonder that there must be an easier way to do this. How would you
...experienced Power BI developer to revamp my existing dashboard. I have a few specific requirements I need to meet, and I'm on a tight deadline. - **DAX Calculations**: I need some DAX calculations to be added in the dashboard. Specifically, I require help with Time Intelligence and Aggregations. - **Neatening the Dashboard**: The visual elements in the dashboard need to be reorganized for better clarity and user experience. I need the dashboard to look clean, organized, and easy to understand for the end user. - **Drill-through Feature**: I require a drill-through feature that allows the user to navigate from a summary level to more detailed data. This is an important functionality that needs to ...
I would like to receive a price quote for making phone calls according to the following details: Territory: Scandinavia Number of records: 400 The purpose of the conversation: to find out if the company still exists and why they stopped buying Background: We are a company that sells aluminum frames for the sign industry to sign manufacturers in the world, including Scandinavia Zone]. These records are of companies that have purchased from us in the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated l...
I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.
I'm looking for help in combining multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in...
...looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is cr...
Only two site links need to be implemented identically: = One-time check of Naver Place ranking = Daily check of Naver Place ranking for keywords and registered businesses Use the following credentials for testing: ID: qmfh123 PW: qmfh123! You'll understand better by trying it yourself. After implementing the two links above identically, additional features should be added: When registering for Naver Place ranking check, users can register up to three keywords: For example: "강남맛집, 압구정맛집, 서울맛집" (Keywords) - "강남로코컴플렉스" (Business name) For example: "강남맛집(강남로코컴플렉스) 11위, 압구정맛집(강남로코컴플렉스) 6위, 서울맛집(강남로코컴플렉스) 30위" Member functions - Permission separation into Master, Manager, and Team Leader: Master
I'm looking for a creative designer to convert a JPEG image into an AI format. The purpose of this conversion is to allow for further editing, scaling, and color customization. Additionally, I need the designer to create two distinct color schemes for the image: - Green and Light Green - Dark Navy and Navy - Logo font to be changed to Thai Power TP - Make into large resolution file
Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to comple...
Looking for someone to go to a few sites and make me an excel sheet with all the listings on the site . Must speak fluent English
I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previ...
I am in need of a professional in Anaheim, CA with a strong IT background to handle an on-site installation of computer peripherals and networking devices, including a DVR/NVR and Point of Sale (POS) systems to a retail shop inside the Airport terminal. Key Details: - The project involves the following: 1. Connecting a POS computer, monitor, receipt printer, USB card reader and providing remote access to our helpdesk so our techs can configure the system. Work with our helpdesk to test the printer, touchscreen and card reader. 2. Connect a USB camera that measures foot traffic and work with our help desk to configure and test. 3. The building contractor has already set up Ethernet cables and a patch panel. Ideally, you will ha...
I need an adept data entry freelancer to skillfully convert text data from various online sources into an organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its features. The testimonials of your past ...
I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.
I am looking for a detail-oriented writer to help me create a comprehensive Industrial Experience Report highlighting my internship at Electrical Shelf - an electrical engineering firm. I would like the report to focus on the following aspects: - Electrical system design: This includes designing circuit diagrams, calculating power requirements, and selecting the right components. A good understanding of electrical engineering principles and practices will be required for this. - Switching board assembly: This involves understanding wiring diagrams, troubleshooting electrical faults, and ensuring proper insulation and safety measures. Experience in handling electrical assembly tasks will be beneficial. - Problem-solving techniques: My internship entailed...
I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt wit...
I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should preferably contain reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medical and ...
Ayuda para entender algunos temas especificos basicos de power bi y como generar graficos correctamente.
Prosimo, vpišite se ali se prijavite za več podrobnosti.
I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.
