Power query combine multiple excel files jobs

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I need an Excel expert to enter a set of numbers and dates into an Excel sheet, and perform some basic calculations. - Data Typing: You'll need to be comfortable working with both numbers and dates, as these will be the primary data types that need to be entered into the sheet. - Calculations: There are two specific calculations that need to be performed on the numbers: - Summation: You will need to calculate the total of all the numbers. - Average Calculation: You will also need to find the average of all the numbers. - Date Formatting: The dates I will provide need to be formatted in both date and time format. This means you should be adept at formatting cells in Excel to ensure the correct display of dates and times. Ideal Candidate: - Proficient in ...

I'm in need of an experienced PHP developer to assist in enhancing my project with specific focus on design modifications and functionality enhancements. Key Tasks: - Design Modifications: The project require...optimizing existing features for better performance. Ideally, you should have: - Strong proficiency in PHP development - Proven experience in design modifications and user interface enhancements - Excellent problem-solving skills and attention to detail - Ability to work within project deadlines - Good communication skills to understand and implement my requirements accurately. Your ability to combine creativity with technical expertise will be invaluable in achieving the project's goals. Looking forward to working with a skilled professional who can bring fresh...

...If you can demonstrate past success in similar projects, and have the creativity and strategic thinking needed to help us grow, we would love to hear from you. Responsibilities: Develop and Execute Marketing Plans: Create comprehensive marketing strategies to increase brand awareness, drive traffic, and generate leads. Campaign Management: Plan, execute, and optimize marketing campaigns across multiple channels, including digital, social media, email, and content marketing. Analytics and Reporting: Track, analyze, and report on marketing campaigns to measure effectiveness and ROI. Market Research: Conduct market research to identify opportunities and trends within the digital signage and SaaS industries. Collaboration: Work closely with sales, product development, and customer s...

I'm currently seeking a skilled graphic designer to create eye-catching flyers and posters to advertise a product. The intention is to leverage on the power of success stories or case studies from satisfied customers, in an effort to attract and engage the general public. Key Project Specifications: - Implement attractive and effective designs to clearly convey case studies of product users. - Ensure designs appeal to a wide demographic range, as the target audience is the general public. - Necessary design elements should carry an easy-to-understand message about the product benefits. The ideal freelancer for this job should have excellent skills in graphics and design, and significant experience in promotional material development, preferably around product advertisement. A...

...Facebook, Instagram, Twitter, Pinterest, and LinkedIn. - Develop and curate engaging and shareable content tailored to each platform. - Monitor and respond to audience comments and engagement. - Implement strategies to increase followers and engagement. - Drive traffic to my website through well-planned campaigns. Ideal candidate: - Demonstrable experience managing social media accounts across multiple platforms. - Strong understanding of each platform's analytics and how to interpret the data to make informed decisions. - Proven track record of growing social media followings and driving website traffic. - Excellent communication and writing skills. - Creative and able to think outside the box to engage audiences. - Experience in running social media advertising campaigns ...

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

...professional to develop an engaging medical education website for a written/video format course with an integrated question bank. Here, the primary objective is e-learning of anatomy through a substantial base of over 1000 multiple-choice, true or false questions and short answer questions. Ideal skills and experience to have: - Expertise in e-commerce website development - Experience in creating intuitive, user-friendly layouts - Knowledge of online education or e-learning websites would be advantageous - Familiarity with designing interactive question types, such as multiple-choice and true or false questions - Capacity to handle widespread content effectively Your job will be to incorporate these aspects to ensure the final product is not just functional but also fost...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes ov...

Please Sign Up or Login to see details.

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

...the Awuor Support Initiative based in Uganda, dedicated to uplifting underprivileged children through education. Today, I'm reaching out to you with a heartfelt plea to support three remarkable children - Alice Alyeko, Ben Otim, and Emma Mukutu - in their educational journey. Education has always been my passion and driving force. Growing up in Uganda, I witnessed firsthand the transformative power of education in breaking the cycle of poverty and empowering individuals to create better lives for themselves and their communities. It's this belief that led me to establish the Awuor Support Initiative, aiming to provide equal educational opportunities to children who are often overlooked and underserved. Donate here

I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals

business profit loss reporting excel(Jan, Feb & March)

...Demonstrated proficiency in creating illustrative UI designs - Solid understanding of user-centered design principles Description: Under this project 1) You have to create home page - header with menu navs (parallax effect) to show the sections and login button on right corner - hero section with background image, heading and description of the product - features sections should create multiple sections for each feature with an image and description. - pricing table with 3 variants. - testimonials - footer with company details. 2) Login page - Login page should be divided vertically into two parts left should have a login form with third-party login images like Google, Facebook etc., Right side should be an image showing images in carousel....

I'm in immediate need of a Solidworks expert to assist with multiple tasks related to creating and manipulating sheet metal panel drawings. The work will primarily involve: - Creating 3D models from 2D drawings - Making modifications to these models - Generating flat patterns needed for manufacturing - Setting up configurations and global variances for sizes, materials, and thicknesses Moreover, the final goal is to establish a DriveWorks automation project. I'm looking for someone to ensure it encompasses: - A customizable user interface for parameter input - The ability to automatically generate reports or documentation I need this project to be completed as soon as possible. Ideal candidates should have a strong background in Solidworks, with extensive experience...

Please Sign Up or Login to see details.

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the...

I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to detail are paramount on this project.

I'm in the process of developing a new platform and need help with the design and user interface. The main goal is to create an engaging and intuitive experience for users. The target...platform and need help with the design and user interface. The main goal is to create an engaging and intuitive experience for users. The target audience will include a wide range of people, and I want to ensure the design appeals to a broad demographic. I need 2 quotations. 1. UI/UX 2. Cost of Development Ideal Skills and Experience: - Proficiency in UI/UX design - Experience in designing for multiple platforms (web and mobile) - Ability to create engaging and intuitive user experiences - Understanding of design principles and best practices - Familiarity with designing for a wide range of t...

ACDP is an enterprise and on the lookout for a skilled IT professional to help bring a va...solid track record and be comfortable tackling the complexities of IT development without needing extensive oversight. - **Skills and Expertise:** - Proficiency in relevant programming languages (Must have: Codeigniter, WordPress, Microsoft technologies like Azure, Power Apps) - Strong understanding of the full development cycle - Experience with both front-end and back-end development (specific skills depend on the project type) - Problem-solving abilities and a keen eye for detail This collaboration could span multiple projects, so I'm keen to establish a reliable, long-term relationship. If you're passionate about IT and ready to tackle diverse challenges, I'...

As an individual working in the unclaimed funds sector, I'm seeking a seasoned cold calling and appointment setting professional. Your main respo...Extensive experience in cold calling, preferably in the unclaimed funds or similar financial sector. * Familiarity with the North American market, and understanding the nuances involved in setting appointments in this region. * Excellent communication and rapport-building skills. * Experience in dealing with individuals rather than businesses. * Highly organized and able to manage and keep track of multiple appointments. Ultimately, I need a professional that is tenacious, trustworthy, and dedicated to aiding individuals to recover what's rightfully theirs. If you think you're that individual, I'd love to connect and...

Please Sign Up or Login to see details.

...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...

I am seeking an experienced video editor for a conversion project. - The core task is to convert files into MP4 format. - There are approx 50 videos that require conversion. Ideal candidates should possess: - Proficiency in video editing software, particularly in conversion tasks I look forward to your bids.

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

I'm looking to source voiceover work from 4 different talents, spanning both male and female voices. The aim is to have a diverse pool of vocal talents for a 1 minute ad. Pry 30 seconds of total voiceover work is needed and needs to be layered on top of a video. Key Requirements: - Diverse gender representation: Both male and female voices are neede...portfolio showcasing previous work with different tones and age ranges would be highly beneficial. - American English Proficiency: A strong grasp of the nuances of American English accents is key. - Availability: Given the number of voices needed, punctuality and availability to meet deadlines is crucial. If you think you can deliver high-quality, engaging American English voiceover work across multiple age groups, I'd lo...

I'm looking for a skilled social media scheduler who can manage and ...scheduler who can manage and schedule posts on Facebook, Instagram, Youtube, and Tiktok. Key Requirements: - Must be proficient at scheduling posts on Facebook, Instagram, Youtube, and Tiktok. - I will provide the posts, reels and shorts. - You schedule, edit titles, captions, etc. This role would suit someone with social media experience who is particularly adept at scheduling content and managing multiple platforms. The key focus will be on efficiency and consistency in posting the provided text content at the optimal times across all platforms. These are Christian Channels (two). We will start with one and grow. Bonus: Since we are dealing with the Bible and scripture, your knowledge of the Bible will...

I am seeking an expert in machine learning and computer vision who can craft an advanced object detection algorithm. This algorithm will be employed in outdoor settings and must have the capability to accurately identify vehicles, animals, and pede...identify vehicles, animals, and pedestrians. Essential Skills and Experience: - Expertise in Machine Learning and Computer Vision - Understanding of outdoor environments and their varied conditions - Prior experience in developing object detection algorithms - Familiarity with vehicles, animals, and pedestrian detection The goal is to devise an algorithm that can track and distinguish between multiple objects in outdoor scenes with different weather, light, and visibility conditions. It should perform reliably under these compounde...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I am looking for a talented developer to help me implement a comprehensive quiz management system for my personal project. Key requirements include: - Ability to manage multiple choice, true or false, and open-ended quizzes - Provide access to these quizzes through both a website and a mobile application - Incorporate user account management for both quiz administration and participation Skills and experience in the following areas are essential: - Full stack development - Proficiency in developing both web and mobile applications - Previous experience with managing and implementing complex systems with multiple user roles The successful candidate should be able to deliver a high quality, user-friendly system within a reasonable timeframe. 1. Quiz manager: Implement a q...

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

...grasp of information organization and UI/UX design principles. The end product should be user-friendly, visually appealing and fully functional with the capacity to capture all the necessary details. Implement an online CV The site will consists of 2 parts: user area As a user I can view the CV and also be able to download it. admin area This page is protected by a login From here I can add multiple languages and add translation for each language From here I can also change the text that is displayed on the page Structure for page (minimum requirements): Page: header biography portfolio contact form footer At least 3 different animations are used The user can change the theme: dark vs light The user can change the language: at least en and ro It will be responsive at lea...

Hi VJ IT Services, combine like last time, Data sheet has main data and secondary data (if you cant find a name)

I'm seeking a skilled PCB circuit designer to create a digital circuit f. The primary function of the circuit is PWM Motor Speed Control Key requirements: Input supply voltage: DC 2.5V-25V The maximum output power: 350W The maximum continuous output current :15A The overload and short circuit protecting current is 25A PWM frequency: 25-30kHz Duty Cycle adjustable: 0-100% The operation environment temperature:-20℃-40℃ Ideal freelancer would have: - Proven experience in digital PCB circuit design - Strong knowledge of signal amplification principles - Familiarity with radio technology and its requirements - Ability to optimize circuits for low gain

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...

Description We are seeking an experienced and creative jewelry artist/designer to collaborate with us on creating unique tungsten ring designs for our business. The ideal candidate will have expertise in CAD software, a strong understanding of materials and manufac...SolidWorks) and other design tools. *Strong knowledge of materials, and manufacturing techniques relevant to jewelry production. *Creative flair and ability to translate conceptual ideas into tangible design concepts. *Good communication in English, and ability to work collaboratively in a remote way. Additional Information: * This is a freelance position with the potential for ongoing collaboration on multiple design projects. *Remote candidates are welcome . Budget: *Budget is negotiable based on experience and proj...

I'm in need of a Point of Sale (POS) interface that works on both Android and iOS devices. The main functionality requirement for this interface is barcode scanning. Additionally, I need this POS interface to support multiple user profiles, each with their unique access levels. Key Project Requirements: - Develop a Point of Sale interface that functions on Android and iOS platforms. - Implement barcode scanning capabilities within the interface. - Create a multi-user system with different access levels for each user. I'm looking for a developer with experience in: - Android and iOS development - Barcode scanning integration - User management systems

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

...suspicious activity on my devices. While I've taken measures on some accounts to secure them, it's not enough and I need professional intervention. The compromised accounts include apps, social media, GPS and financial. The activity on my devices sparks concern, particularly regarding showing activity in my history I did not do and I'm looking for expert guidance I have already wiped my device multiple times and have even gone as far as establishing all new digital identifiers such as new phone number, email, and Apple ID to no avail. Skills/Requirements: - Knowledge of cybersecurity measures - Experience in dealing with compromised online accounts - Network security proficiency The project will entail: - setting up a closed in-home network in m...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a talented...branding guidelines - Creating a variety of visuals for posts, stories, and ads on the specified social media platforms - Ensuring all designs are modern and minimalistic in line with the overall theme Ideal candidates would be able to take the provided colour and branding guidelines and translate them into engaging and effective social media content. Experience in creating visual content for multiple platforms would be a big plus. Looking forward to seeing your portfolios and offers. Tasks Include : - Logo for the brand - Facebook - Cover + Profile Pic - Insta - Profile Pic - Twitter - Cover + Profile Pic - LinkedIn - Cover + Profile Pic All of the covers & profile pics will have some minor adjustments according to the platform, graphic...

Logo needed for brand offering fundraising services for charitable causes. Desi... > The core design should be in vector format, with .ai (CS3 compatible) and .eps formats required. Other formats are welcome and appreciated. > Fonts used should be identified and either commonly and freely available or be included with the design files. >>> Submissions should be made as soon as possible, <<< as they need to be reviewed by multiple parties before a decision is made. Early submissions will have a greater chance of being reviewed and selected. > Award of the contest prize will convey all ownership rights to buyer. All files used to create the entry should be delivered when prize is awarded. If you have any questions, please ask. We appreci...

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I am in need of a creative and professional video editor to assist in repurposing one of my videos into five smaller, engaging marketing videos. Purpose: - These videos will be used to promote a specific product or service across multiple platforms. Platforms: - The final products will be optimized for social media, web and also suitable for email marketing campaigns. Audience: - Specifically targeting age group 36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating content for age group 36+ - Ability to deliver on time, maintaining the high quality. Should ...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I'm seeking an expert to analyze a key aspect of my HR paper from journal with title Building organisational resilience capability in small and medium-sized enterprises: The role of high-performance work systems. The intent of the analysis is to analyse paper Key Requirements: he main structure of the analysis contains the following : Introduction Res...Building organisational resilience capability in small and medium-sized enterprises: The role of high-performance work systems. The intent of the analysis is to analyse paper Key Requirements: he main structure of the analysis contains the following : Introduction Research context Methodology with results Discussion Overview Critique and significance of the paper the outcome is report and power point slides the due da...