How to use microsoft excel formulaspráce

K zobrazení podrobností se zaregistrujte nebo přihlaste.

Job Overview: We are seeking a skilled freelance researcher to create a comprehensive directory of therapists and autism specialists located in London. This project encompasses a wide array of therapy disciplines as well as top specialists in autism treatment for children. The ideal candidate should possess excellent research abilities, have a strong understanding of the healthcare sector, and be adept at accessing and verifying professional credentials and contact details. Responsibilities: Systematically collect and verify contact information and qualifications of therapists and autism specialists, ensuring that all data is up-to-date and accurate. Utilize a range of sources such as professional healthcare directories, medical institutions’ databases, specialized Li...

I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.

I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.

I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.

...experienced with Microsoft Exchange to help me resolve a couple of issues. - The first problem is that I'm experiencing connectivity issues with Outlook. I can't seem to get it to connect properly to the Exchange server. - The second issue is that I'm unable to send or receive emails. This has been causing a great inconvenience and it's important that it gets resolved as soon as possible. I'm using Microsoft Exchange on-premises and the issues are across all versions of Outlook. I'm looking for a freelancer who: - Has previous experience and a solid understanding of Microsoft Exchange on-premises. - Can troubleshoot and resolve connectivity issues with Outlook. - Can address email sending and re...

I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is s...

...into a Microsoft Word document. The attached word document has many formulas and some are a bit blurry ( I suspect because they are images, not text). That becomes worse when the file is converted to PDF, as it must be for our purposes. The formulas should be in a format that allows me to edit the text within Word. This will involve creating a clean and readable representation of complex mathematical expressions and also testing that they can be converted to pdf in a clear manner. Ideal Skills: - Strong background in algebra and mathematical notation - Proficiency in Microsoft Word and its equation editor - Attention to detail to ensure correct transcription of equations - Familiarity with formatting mathematical express...

I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab upda...

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 worked on in the past.

I need an expert formatter to clean up and streamline my PowerPoint presentations. Your work will include accurately aligning text, correctly using headings and subheadings, and ensuring a consistent overall look and feel. Skills and Experience: - Proven experience in document formatting, specifically PowerPoint presentations - Strong attention to detail - Mastery over Microsoft PowerPoint software - Ability to adhere to deadlines will be a major advantage.

I'm looking for a talented video editor who can enhance my Y...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 and excel in video edi...

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.

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.

I need a skilled freelancer who can efficiently convert a Google Doc into a Word document. -Significant to the project is maintaining all existing styles and formats on the Google Doc in the converted Word document. -A table of contents is required to be added to the Word file. -A sound understanding of Google Docs and Microsoft Word is ideal, with emphasis on expertise in style preservation during conversion.

Hello, I need someone to customize my UET tag tracking code to report variable revenue on Microsoft ads. The conversion is already set up, but I want it to track the actual revenue from each order. Thanks, Phillip

For this project, I need an expert 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 shou...

I need a proficient graphic designer to transform a 75-page report into a professional, corporate-themed document in Microsoft Word. The project involves: - Incorporating moderate design elements into the report. - Applying a corporate theme and color scheme. - Integrating charts and graphs, as well as images and icons within the document. The ideal freelancer for this job should have significant experience in graphic design and Microsoft Word. You should be comfortable transforming information into eye-catching designs that align with a corporate aesthetic. Expertise in creating and incorporating graphical elements such as charts, graphs, images, and icons is essential. Let's ensure this report not only informs, but impresses.

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 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 similar projects and excellent comm...

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 delete ...

...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. Developer has to...

Hi, I'm trying to update my workflow. I currently manage a lot of images, and I need to do the following: 1) Bulk scan and assess the images for quality. In the past I've used but this isn't the most accurate method. Sometimes it will miss images that are extremely pixelated and blurry, or filter out good images by mistake. I'm not sure if I should be using something like Amazon Rekognition, Google Cloud Vision, or Microsoft Azure instead? Or if I can save money and still get good results with a local option like OpenCV? I guess it depends on speed and accuracy. 2) I'd also like to be able to scan images in bulk and detect any text. Same question as far as whether or not

...that allows me to calculate total price based on numerous factors: Various products with different prices per user and minimum sale prices Total Price based on a calculation of User Count (factoring a minimum that must be met - Hard set) Price factoring in a margin that can be manually entered and calculated Price that factors off of the previous input with an additional margin calculation that can be manually changed Key Requirements: - Data Entry: I will manually input sales data into the spreadsheet. - Calculation: The spreadsheet should be able to calculate unit prices and margins based on the sales data provided. Ideal Skills: - Advanced Excel skills: Proficiency in creating complex formulas for unit price and margin calculations is essential. - Data ...

I need a 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 to detail - Ba...

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: ...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 skil...

...attaching supporting files as necessary. * Conduct searches for additional information to complete incomplete documents. * Verify, correct, and manage data integrity, including deletion of unnecessary data and data consolidation. This position demands meticulous attention to detail, a college degree, proficiency in basic software tools (Microsoft Office - Word & Excel), and accessibility to email and devices (computer or phone). We require individuals who can deliver fast, accurate, and specialized assistance to our clients. Job Duration & Hours: The job duration is flexible, ranging from 1 month to ongoing/undefined, with weekly hours varying between 10-30 hours (4-8 hours per day). Candidates will be expected to manage ...

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 the work on zoom and will connect an...

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

I'm looking for a diligent freelancer to help me with a straightforward data entry task. The task involves: - Collecting text data from various websites - Organizing and inputting the data into Word documents. The ideal candidate should be: - Skilled at conducting online research - Proficient in Microsoft Word - Detail-oriented and able to maintain accuracy - Good at time management to ensure timely completion of the task. Your role will be pivotal in creating a structured, comprehensive database from the web content I provide.

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 link for filling in th...

I would like to receive a price quote for making phone calls according to the following details: Territory: Netherlands Number of records: 58 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 Netherlands. 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 link for filling in the resu...

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.

...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 this project can help streamline our data manipulation process and en...

...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 crucial for this...

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

...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 complete two test works before the project is awarded. 1. Watching instructional video which explains the task. 2. Completing an 11 question quiz based on the video instructions. 3. Completing a small sample test on 5 medical centres to demonstrate understanding of...

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 looking for a skilled professional who can ensure my Microsoft Word tri-fold brochure prints correctly on A4 paper. Key responsibilities include: - Ensuring the layout and content align correctly with the tri-fold format of the brochure. - Correcting any issues that arise when printing, such as: - Misalignment of content - Pages printing in the incorrect order - Text and images being cut off - Correcting colour scheme around the logo to be full from top to bottom - Removing a blank page (Page 3) that is not required The ideal candidate for this project has: - Proficiency in Microsoft Word - Expertise in print design and layout - Experience in fixing common printing issues - Ability to communicate clearly and work independently

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 previously resolved issues related to duplicati...

I am seeking a virtual personal assistant based in Croatia. This communication-focused role will involve various tasks, prim...am seeking a virtual personal assistant based in Croatia. This communication-focused role will involve various tasks, primarily offering personal assistance to me in addition to some administrative support tasks. While not required, proficiency in Microsoft Office Suite and experience in calendar management will be viewed favorably. The ideal candidate should be highly organised, dependable and detail-oriented. A high level of English proficiency is required and fluency in Croatian language is desirable, but not necessary. Honest, pro-active and comfortable in a remote role, the preferred person has a can-do attitude and a keenness to gr...

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 clients and your port...

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'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should prefe...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 business sect...

...Key responsibilities include but are not limited to: - Create a corporate PowerPoint template incorporating our existing style guide. The template will need elements such as logo placement, specific font styles, sizes, a colour scheme, slide layout options, iconography, and relevant images. - Develop a pitch deck using the supplied content while adhering to a distinct visual theme provided. Skills & Experience needed: - Graphic Design - Corporate Branding - Microsoft PowerPoint - Infographic Design - Strong Visual Communication Attention to detail and a keen design eye is essential to succeed in this project. This will be an ongoing project with the potential for additional work if the initial design is satisfactory. We're looking forward ...

K zobrazení podrobností se zaregistrujte nebo přihlaste.