Excel tips and tricks 2016 jobs

Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different data types and uncover v...

...working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previou...

Please Sign Up or Login to see details.

I'm seeking a skilled freelancer to assist me with basic data analysis in Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with basic formulas and functions - Strong attention to detail - Good communication skills

I'm looking for a skilled video designer who has strong expertise in creating 2D animation. The primary objective of this project is to craft a short video that effectively fost...this project is to craft a short video that effectively fosters brand awareness. Key Requirements: - Develop a short 2D animation based on specific design elements provided by me. - Create an engaging narrative that symbolizes and highlights the safety tips for a work place Ideal Skills and Experience: - Proficiency in 2D animation and video designing. - Excellent storytelling abilities to portray our brand's image in the best light. - Previous experience in producing branding videos or related projects would be a significant advantage. - Strong understanding and a...

I am aiming to incorporate and enhance my Parent Company's policy and processes on IT asset management, with particular focus on the documentation process and IT Asset Management Workflow diagram (From registering the asset to retiring the asset). Key deliverables: 1. Provide a document that lists all relevant terminology for IT Asset Management, including formal definitions and simplified definitions. These definitions must be aligned to Parent Company's terminology. 2. Provide a diagram that explains the desired lifecycle of IT Asset Management and how Cybersecurity, ICT Operations, Data office and Business Unit fit into this flow via clear RACI. This must aligned to Parent Company's lifecycle descriptions. 3. Complete an exce...

I am looking for a proactive and detail-oriented lead generation assistant to help me with data research and email outreach/follow-up. The main focus will be on the B2B sector. Key Responsibilities: - Conducting thorough data research to find relevant contacts and organizations in the B2B sector - Managing email outreach and follow-up with these leads Ideal Skills and Experience: - Proficiency in data research and collection to identify potential leads - Experience in email outreach and follow-up to engage and nurture leads - A good understanding of the B2B industry and its dynamics - Ability to deliver leads in an Excel/CSV format If you have a track record in delivering high-quality B2B leads and can assist w...

My company and I are looking for an experienced freelancer to develop an Excel tool for Electrical energy savings. The tool should be able to calculate energy savings, graphically represent data, and compare different scenarios all according to the formulas and calculations I will provide. We prefer to communicate technical details via telephonic discussion. The freelancer should have experience creating similar tools and should present a proposal for development.

croatian text below (please translate it in your language if necessary) Mi trazimo freelancer-a koji ce definirati i izvesti tendera u Europi za igradnju jedne kuce sa tri stana i 3 PGM u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje p...u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje ponuda te izrada usporedbe cijena prema pojedinačnim poslovima - Sudjelovanje u pregovorima s ponuđačima i izrada prijedloga za ugovaranje - Sudjelovanje pri odabiru izvođača Format predaje: Dokumentacija u excel...

...website developer to create a new interior design website catering to both homeowners and businesses. Key features should include: - An online portfolio: This will showcase my interior design work, allowing visitors to explore and appreciate my style and projects. - Appointment booking system: Prospective clients should be able to book consultations with me directly through the website. The system should be user-friendly and fully integrated. - Blog section: I want a space where I can share design tips, ideas, and inspiration. It should support images, videos, and text. Experience specifically in e-commerce website development will be highly advantageous, along with a strong knowledge of modern website aesthetics and user-friendl...

To create a canvas powerapps screens similar to the Excel provided to Florian.

I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.

As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of this project.

I'm in need of a skilled AI programmer to help me with the application of midjourney or another AI service, to intelligently overlay clothing on a mannequin or model. The idea is to feed the program with an image of the model and an image of a piece of clothing, and have it merge the two seamlessly. Key requirements: - Proficiency in AI programming particularly in the area of image recognition and processing - Experience with midjourney or a similar service/program - Ability to develop or integrate an API for this purpose I need help, tips, working examples and so on. The project is time-sensitive, with a completion deadline set within a month. Experience with fashion or garment overlay technology would be a significant advantage.

My project revolves around the conversion and enhancement of specific JPEG images. The enhancements needed pertain to retouching, color correction, background removal in addition to change of format. Ideally, I require someone skilled in photo editing and proficient in using Excel, to transcribe these reformatted images into an Excel document. I would like my JPEGs converted into the Excel , if you have a keen eye for detail and the necessary expertise, I would love to hear from you.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?

...I'm in need of a developer capable of creating a tool to store data in bulk and automatically remove duplicates each time new data is added to the existing database. Storage of large datasets: The tool should allow for storing a large quantity of data. Duplicate removal: It should be possible to remove duplicates in the Excel files to maintain a clean and organized database. In addition to these features, it would also be necessary to be able to edit data in the tool and export the changes made to an Excel file. Furthermore, an archiving feature would be desirable, allowing for downloading of the used data for future reference. I would appreciate it if you could confirm whether you are able to develop such a tool and provide me with a qu...

I'm seeking a proficient AI researcher. The main focus is to research all the AI tools and suggest best tools for the following activities, 1. PPT, Excel & word document creation 2. Prompt engineering for Chatgpt & similar 3. Project management : Auto schedule creation, task tracking, followups, resource management, report generation, auto reply for emails, risk management 4. Sentiment analysis of text 5. Engineering document creation : System Requirements, SW Requirements, Architecture creation, software detailed design, software coding, Test case creation. 6. Images, Animation creations Your primary task will be to understand different AI tools, create a list of all the AI tools, its corresponding usage for both free & paid tools. The industry targeted is...

I'm looking for a comprehensive guide or mentorship to launch my full-time freelancing career. As I'm uncertain about my specific interests, the guidance should encompass various skills or services a freelancer can offer. Key deliverables should include: - An...guidance should encompass various skills or services a freelancer can offer. Key deliverables should include: - An overview of profitable freelancing opportunities - Strategic planning to align freelancing goals with lifestyle choice - Essential skills required for successful freelancing - How to build and promote a powerful portfolio - Tips to win bids and client management advice Experience in freelancing field and tutoring is highly appreciated. Ability to provide practical insights ...

...researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries for clar...

I need a skilled writer who specializes in crafting en...have: - A knack for healthy kitchen creations, well-versed in ways to make traditional dishes healthy - Strong writing skills and the ability to create compelling, easy-to-read content - An understanding of the needs and interests of everyday home cooks - The ability to provide detailed recipe instructions, complete with tips and tricks to make cooking easier and more enjoyable. Experience with food photography would be a plus, as I'd like the recipes to be accompanied by enticing step-by-step photos. This project calls for not just a basic overview, but an in-depth, accessible, and exciting guide to healthy home cooking. If you have a passion for healthy eats and can tra...

I have built an Android app in Android Studio (Iguan...upload it to the Google Play store. Hence, I am seeking a qualified freelancer to provide a 1-hour virtual tutorial explaining the app submission process. I want to be on VTC and share my screen while someone guides me through the process. This tutorial should primarily focus on: - The process of submitting an app to the store. - Understanding the app store's guidelines. - Tips on app signing and security. Upon successful completion of the class, an opportunity to build additional apps may arise. Remember, the ideal freelancer should have verifiable experience in Android app development, app store submissions and previous training/tutoring experience may be an advantage. One additional note,...

I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.

I have a PDF list which contains text and numbers. The list is structured with columns and rows. The task is to convert this list into an Excel sheet. The Excel list should be organized in a sorted manner, either alphabetically or numerically. Ideal Freelancer: - Proficient in data entry and conversion - Experience in handling PDF to Excel conversion - Excellent understanding of sorting data appropriately - Attention to detail is crucial

...experienced Google Excel expert to assist me in refining and optimizing my current Excel tables for business purposes. Key Requirements: - **Formatting**: I need assistance in improving the aesthetic appeal and readability of my tables. This includes changes to font style and size, cell borders, and background color. - **Formulas**: The expert should be proficient in implementing essential formulas such as Sum, Average, and Count. They will play a crucial part in calculating and managing data effectively. - **Data Validation**: I need guidance on implementing data validation processes to ensure the accuracy and consistency of my data entries. Ideal Skills and Experience: - Proven experience in working with Google ...

I have image form i want to make the form in excel to print it directly

...any language you're comfortable with, whether it's Python, Java, C++, or another language or excel sheet. - Technical Requirements: The program should be highly accurate, providing predictions with an accuracy rate of over 90%. - Data Sources: The program should utilize a range of data sources to inform its predictions. These should include historical stock data for the Saudi market and any other relevant information that you can source. Be creative with your data sources and demonstrate a strong understanding of the market. Ideal Skills and Experience: - Strong background in programming and algorithm development - Experience in working with financial data and ideally in stock prediction - Creative and resourceful approach to s...

I am searching for a dynamic Sales Executive well-versed in technology, specifically software solutions, to drive sales in the business sector. Key Responsibilities: - Building and maintaining relationships with business clients - Presenting and selling software solutions ( web designing and social media marketing and management ) Ideal Profile: - Experience in B2B sales, particularly in technology - Understanding and passion for software solutions - Excellent communication, presentation and negotiation skills. This is a commission-based role offering the opportunity to excel within the tech industry while working closely with businesses. Comession is based on deals you will it is going to be between 8% - 20% on every successful sale

I have an urg...conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals with strong credent...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and im...

...cutting-edge VR simulations. We're currently seeking a seasoned Senior Machine Learning Engineer to join our team and lead our efforts in integrating machine learning technology into our VR simulations. This unique opportunity offers an equity-only partnership initially to facilitate the Proof of Concept (POC) phase. During this period, the partner's contribution will be instrumental in securing further funding, already committed by an investor. Upon successful completion of the POC, we'll transition to full time position at the company and a payment structure, starting at $6,000 per month for the first year with opportunities for growth in subsequent years. We understand the need for flexibility and are open to part-time arrangements to accommodate o...

I'm looking for someone to assist in transferring data from digital files (mainly PDF and Word) into Excel spreadsheets. Key Responsibilities: - Accurately inputting data from PDFs and Word documents into Excel - Ensuring data integrity and quality is maintained throughout the process Ideal Skills and Experience: - Prior experience with data entry, particularly with Excel - Meticulous attention to detail to ensure accurate data transfer - Proficiency in Excel and ideally some experience with PDF and Word files - Ability to work independently and meet deadlines

I have a large PDF file with a mix of text and numbers. It contains over 300 pages, but there are generally less than 10-20 lines of data on each page. I'm looking for a freelancer to convert this data into an Excel spreadsheet. I'm only in need of data entry, not analysis, so the task is straightforward. Ideal Skills: - Proficiency in Adobe Acrobat - Strong knowledge of Excel - Experience in data entry This is a simple but time-consuming job, so please provide a realistic timeframe for completion when bidding. Accuracy is important, as the data will be used for further analysis.

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and im...

I have an urg...conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals with strong credent...

...professional who can collate and organize details about the Corporate Social Responsibility (CSR) activities of a specified list of 400 companies, together with LinkedIn profile URLs of respective team members. Key Task Requirements: - Research and compilation of CSR project details of the identified companies - Use of Excel for data presentation in an organized manner - Gathering of LinkedIn URLs of team members from each company Ideal Skill Set: - Proficiency in web research - Expertise in data entry and data organization - Familiarity with LinkedIn and its functionalities - Detail-oriented approach - Experience in Corporate Social Responsibility research is a plus. Your job will be instrumental in providing in-depth insights about the afore...

...looking for a talented and experienced social media manager to create and manage the social media profiles for our professional cycling team. Key Responsibilities: - Establishing and maintaining active and engaging profiles on Facebook, Instagram, Twitter, TikTok, and Snapchat. - Creating and sharing engaging content across the platforms. - Regularly posting race highlights, training tips, special events and meetings, and announcements. - Monitoring and responding to audience comments and messages. Ideal Skills and Experience: - Proven experience in social media management, particularly within the sports industry. - Strong understanding of Facebook, Instagram, Twitter, TikTok, and Snapchat. - E...

...business card scans into a detailed Excel database. Each card has been scanned using the CamScanner app and they vary widely in design, content, and layout and all of them are different. (90% of the cards are in english, 10% are in urdu and arabic) Objective: Looking for innovative, no-code methods that automate the conversion of these business card images to an Excel sheet with minimal human interaction. The best method should be fast, cost-effective (minimal or zero cost), and capable of handling high variability in card designs without any coding or manual programming. Submission Guidelines: * Propose a no-code solution using online tools or existing software that can intelligently organize varied information into consistent Exc...

- Daily Accounts: Should have a mechanism for daily tracking of accounts. - Sales Management: An organized way to manage all sales. - Customer Management: The system must be able to maintain a proper client record. - Purchase Management: Need to keep track of all the purchases. - Supplier Management: Managing interactions with the suppliers effectively. - Database Management: Ability to handle a growing database. - Inventory Management: Keeping up with fish inventory.

I have an excel exercise as part of a financial modeling course which i need to solve It is regarding determining debt size and repayment profile while keeping DSCR at a fixed ratio. I will also need to record a Macro of the debt sizing, sculpting and leveling profile

...15 with missing data) with n events / n total in ACA analysis and n missing in both intervention and control groups (in Excel format) Key Responsibilities: - Impute missing data: The primary task will be to impute missing data in the clinical trial dataset. This is crucial for maintaining the integrity and accuracy of the overall analysis. - Generate ACA, ICA-0, ICA-1, ICA-pc, ICA-pe, ICA-p, ICA-b, ICA-w, Gamble Hollis analysis and IMRO (2/0.5 and 0.5/2) analysis plots - Generate L'Abbe plot(s) (for further details please see attached file) Ideal Skills and Experience: - Proficiency in SAS / Stata: As I specifically prefer to present the data with SAS / Stata for this project, it's essential that you have strong experience ...

I'm looking for a comprehensive Excel dashboard that can help me manage resources for my projects. This project will involve visualising project management data, with a focus on resources management and planning. The key elements of this dashboard will include: - Resources Planning: Visualising the availability of team members, their skills and current project assignments. This should help me in efficiently allocating resources for various tasks. In addition to these, I'm also interested in other data such as budget tracking and milestone tracking. The ideal candidate for this project should have experience in: - Advanced Excel skills, with a focus on creating visually appealing and user-friendly dashboards - Experience in designing ...

...expertise in Excel, as well as a strong foundation in data security. As a result of this project, we need a highly functional, secure Excel template that meets the following requirements: - Advanced Excel Features: The template should involve data entry forms, complex calculations and formulas, and strict data validation rules. It should also facilitate costing, inventory management, attendance tracking, salary calculation, profit/loss calculations, and accounting. An integrated dashboard and graphical representation of data is also needed. - Security: Due to the sensitive nature of the information to be processed, we require an array of security measures. These include password protection, restrictions for specific users, and da...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and im...

I am seeking someone to retrieve specific contact details for a Chinese company located in Tibet. Key Deliverables: - Company Name - Contact Person - Address - Email - Phone Number - WhatsApp Number Preferred Form...seeking someone to retrieve specific contact details for a Chinese company located in Tibet. Key Deliverables: - Company Name - Contact Person - Address - Email - Phone Number - WhatsApp Number Preferred Format: The final deliverable should be in Excel or CSV format. Experience Required: - Proficiency in Chinese language and familiarity with Chinese business conventions. - Previous experience in retrieving contact information. - Attention to detail and accuracy in data collection. Please reach out if you believe you have the necessary skills an...

...clean energy company. Job is Monday, through Friday via different tasks we will send you. Job half hybrid in our NYC office/half remote. (no cold calling) Job includes: -Scheduling clients with company for installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Ple...

I require an Excel expert to assist with a complex data analysis. The dataset is quite large (more than 1000 rows) and involves matching combinations. Key Requirements: - Data Analysis: The main purpose of your task is to help me analyze the data available. This will involve identifying patterns and matching combinations. - Excel Skills: You are expected to have advanced Excel skills to handle this large dataset effectively. - Combination Matching: The combinations you will be working with are complex, and may require manipulation of the data. I'm looking for someone with extensive experience in Excel, particularly in data analysis and matching complex combinations. Your ability to efficiently handle large datasets and w...

I need a freelancer to gather contact info for 42 recruitment companies based in UAE. This information will be used for job seeking purposes. Key Requirement: You will need to find the contact name and email (and any additional possible info) for each and every recruitment/HR/Headhunting person within each company. This could be anywhere between 10 to 30 people per company. Total number of contacts would be between 350 and 700. Hays - Robert Half - Michael Page - Charterhouse - BAC Middle East - Adecco Middle East - SOS Recruitment Consultants - GulfTalent - Manpower Middle East - https://lnkd

i will create 1 power power point and 1 excel sheet adding the equations