Advanced excel tutorial jobs
I'm looking for a virtual assistant to support me with email handling and sales data maintenance in Excel. This role is important as it directly involves customer communication and data management. Key Responsibilities: - Responding to customer inquiries in a timely and professional manner - Efficiently sorting and organizing emails - Implementing appropriate spam management and filtering strategies - Updating product sales, revenue and customer information in Excel Ideal Skills and Experience: - Proven experience as a virtual assistant, customer service representative or related role - Strong proficiency in Excel and data management - Excellent written and verbal communication skills - Exceptional organizational abilities and attention to detail - Familiarity w...
I need a seasoned WordPress developer who is proficient in Advanced Custom Fields Pro. I already have a WordPress website up and running - your assistance is required to configure ACF fields for the creation of more dynamic content pages. Key Requirements: - Proficiency in Advanced Custom Fields Pro - Experience with WordPress development - Strong understanding of dynamic content creation Your role will be focused solely on configuring and output ACF fields. I will provide you with the details and specifications for the dynamic content pages to be created. The main goal is to ensure that the website's content is not only visually appealing but also functional and easy to manage. Your past experience with similar projects is very crucial, and examples of your work will...
I am in need of a skilled Excel professional who can create a comprehensive Excel dashboard focused on data analysis. The dashboard will integrate with various Excel files to provide real-time data updates. Key Requirements: - Create an Excel dashboard that primarily focuses on data analysis - Integrate the dashboard with multiple Excel files - Ensure that the data updates are in real-time Ideal Skills: - Proficiency in Excel - Experience in creating complex and dynamic dashboards - Knowledge of data analysis techniques - Familiarity with real-time data integration This project is ideal for an Excel expert who can not only design a visually appealing dashboard but also ensure that it is highly functional for data analysis purposes.
...a project of enhancing the visual appeal of an existing Excel spreadsheet. This entails more than just a simple makeover, but applies a professional visual identity to the spreadsheet. The spreadsheet is a database to show service times and the parts required for that service. I need it to be easy to read and professional. You can use our logo. Key Responsibilities: - I would like customized fonts and formatting integrated throughout. This isn't limited to a specific area, so use your judgment to decide what gets modified. It's essential that the spreadsheet no longer resembles a generic 'Excel' one. - I want the spreadsheet to look and feel intuitive, maintaining the professional aesthetic. Preferred Skills: - Mastery of Excel and its vari...
We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simplicity and functionality without the need for a commercial product presentation. **Key Features Needed:** - A user-friendly Excel workbook that manages electronic components, their stock levels, and inventory updates post-sales efficiently. - BOM creation from inventory items with an ability to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow ea...
I'm...This dashboard will primarily focus on showcasing our sales and market data. Most of the data would be related to Transportation and Logistics Domain, for eg : Port Wise Performance Customer Support Analysis Database would be PostgreSQL Key Components: - Incorporation of various visuals such as line and bar graphs, pie and doughnut charts and maps to effectively represent geographical data. - Advanced skills in handling complex sales and market data, and ability to visualize this in a digestible manner are essential for this task. - Familiarity with creating reporting tools using similar datasets will be highly appreciated. Your task will be to transform raw sales and market data into an intuitive dashboard, offering clear insight and accessibility to vital data trend...
I'm in need of an experienced video editor to create a compelling commercial. It will serve as a promotional tool for my business. The editing style I'm looking for is live-action. Key Messages: - This video should highlight the unique features and benefits of my product. - It should also effectively communicate my brand's story and values. - Lastly, it should incorporate a how-to or tutorial style to inform and engage our audience. The ideal candidate for this job should have a proven track record in video editing, especially for commercial purposes. Proficiency in live-action editing is a must. Experience in creating a narrative that seamlessly integrates product information, brand values, and educational content is highly desirable. Your editing skills will pl...
I'm seeking an individual who is well-versed with Excel for data entry tasks. This primarily involves typing and organizing data. Here's what you'll be doing: - Typing out data and organizing it in Excel spreadsheets - Ensuring accuracy and efficiency in data entry Applications should include: - Examples of past work, particularly those related to data entry and Excel Ideal freelancers for this job are those who: - Have prior experience in data entry - Are proficient in using Excel - Possess strong attention to detail, ensuring accuracy in their work.
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'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.
I need a proficient video editor skilled in advanced editing techniques like special effects and transitions. The project involves enhancing an instructional/tutorial video using animated graphics and text. CRUCIAL REQUIREMENTS: - Proven experience in advanced video editing - Excellent in animated graphics and text production - Background in creating engaging instructional videos Your expertise and creativity will help bring these tutorial videos to life, enhancing their effectiveness and engagement level.
I'm seeking a video creator to produce a 1-3 minute promotional video for our esteemed "Postgraduate Diploma in Counselling Psychology" program. The video will target career changers specifically. Key requirements and details: - The video should effectively highlight the program's three main selling points: its course recognition by Singapore Association of Counselli...platforms. The ideal candidate for this job will have: - Proven experience in creating promotional videos, ideally for educational programs or courses - A solid understanding of the psychology of career changers and how to appeal to this specific audience - Excellent storytelling and video editing skills to bring our program's unique strengths to life If this project sounds like something you'...
...need of a Python expert who can develop a content spinning tool for me. The tool should be capable of automatically generating unique variations of basic text, like blog posts and articles. Key Requirements: - I'm looking for a tool that can automatically generate spun content from existing text, without any manual input needed. - File upload option - If I upload an Excel sheet, the tool spin content in that sheet and export excel sheet with spin content. - It needs to be able to handle the text complexity level of blog posts and articles, 50-500 words - THe purpose of this tool is to rewrite content to make content ZeropGPT free Ideal Skills: - Proficiency in Python programming. - Prior experience in developing content spinning tools. - Knowledge of natural langu...
...an Excel table. The icons are for various amenities that will be listed on a real estate website. Responsibilities: • Search for icons on that match the list of amenities provided. The premium version of Flaticon may be used. • Ensure each icon matches the style and aesthetic suitable for a modern real estate website (in the style as attached files). • Document each icon in an Excel table with two columns: Title and Classname. List of Amenities: • See attached file. Requirements: • Experience with and familiarity with downloading and organizing icons. • Proficiency in Excel. • Attention to detail to ensure the icons are correctly matched to the amenity titles. • Ability to deliver the task within a specified timeframe....
I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.
I'm looking for someone to help me enhance my knowledge of cybersecurity, specifically network security. Key Project Requirements: - I'm aiming to get to an advanced level of understanding in cybersecurity, so the ideal freelancer will have strong skills and experience in this area. - In terms of areas of cybersecurity, I'm particularly interested in network security. The ideal candidate should be able to tailor their lessons and practical activities to focus on this niche. - This is a personal learning project, so the freelancer should be patient and able to explain complex concepts in an understandable way. Ideal skills and experience: - Proven expertise in cybersecurity, ideally with a focus on network security. - Experience in teaching or tutoring in this fiel...
I have an Excel file that needs to be formatted with some basic arithmetic formulas. Key Requirements: - I need the data in the cells to be formatted to phone number style. - Basic arithmetic formulas are required for this project. The level of statistical analysis you'd need to provide is basic, such as mean, median, or mode. Ideal Skills/Experience: - Proficiency in Excel and formulas is a must. - Experience with basic statistical analysis is preferred. Please get in touch with your credentials and prior work samples. Thank you.
I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
This is the variant table with these fields CREATE TABLE ( id varchar(255) NOT NULL DEFAULT uuid_generate_v4(), name_lang json NOT NULL DEFAULT '{}'::json, data_area varchar(255) NULL, description json NULL DEFAULT '{}'::json, "type" bit(1) NULL, active bool NULL, created_by varchar(128) NOT NULL DEFAULT 'system'::character varying, created_on timestamp NOT NULL DEFAULT now(), updated_by varchar(128) NOT NULL DEFAULT 'system'::character varying, updated_on timestamp NOT NULL DEFAULT now(), CONSTRAINT category_pkey_1 PRIMARY KEY (id) ); this is the variant data table with these fields CREATE TABLE public.variant_data ( id varchar(255) NOT NULL DEFAULT uuid_generate_v4(), name_lang json NOT NULL DEFAULT '{}'...
I need a tool that can scrape text content and tables from LinkedIn quickly and efficiently into an Excel format. The tool needs to be able to: - Extract text content and tables from LinkedIn - Export the scraped information into Excel format - Operate quickly and efficiently to meet a tight deadline The ideal candidate should have: - Experience in web scraping, particularly with LinkedIn - Proficiency in Excel - Ability to develop a tool that can operate quickly and effectively Given the urgency of this project, I need someone who can start ASAP and deliver the tool in a timely manner. Experience with rapid tool development would be a huge plus.
I need an experienced video editor/content creator to produce three short video adds I want to use to announce...Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experienced in creating content for various social media platforms, particularly Facebook, TikTok, and YouTube - Highly creative with a strong visual aesthetic - Knowledge of copyright laws and usage of royalty-free music - Strong communication skills to understand and execute my vision If this sounds like a project you'd excel at, I'd love to see some examples of your previous work preferably a college home coming event or alumni reunion event announcement teaser video. I will provide longer version videos of past events. You'll need to use shorter clips from the long video...
...is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous...
... It's crucial that the tool supports this language for seamless integration with our existing systems and infrastructure. - Chatbot Functionalities: The tool needs to focus on "Learning and Adaptation." This is critical to ensure our chatbots continuously improve their responses and overall performance based on real-time customer interactions. - Chatbot Customization: I'm looking for an "Advanced" level of chatbot appearance customization. This includes a fully customizable UI, allowing us to align the chatbots with our brand's aesthetics and maintain a consistent user experience. Ideal Skills and Experience: - Proficiency in JavaScript/ reactJS and NodeJS is a must. - Prior experience in developing AI tools for chatbot creation and train...
...CISSP certified instructor with an advanced level of knowledge. The ideal candidate should be able to deliver these classes in an in-person format. Key Training Areas: - Security and Risk Management - Asset Security - Security Architecture and Engineering I need someone who can provide thorough explanations and practical examples of these topics. Your role will be to break down complex concepts into understandable parts for the students. This means ensuring the content is clear, concise, and engaging. Ideal Skills and Experience: - Advanced CISSP certification - Experience in in-person training - Strong communication and presentation skills - Ability to simplify complex ideas - Understanding of adult learning principles Please only apply if you are an Advanced ...
...are several essential tasks that need to be completed in the process: - Advanced Inventory Management: Setting up a comprehensive inventory management system that allows for efficient tracking, control, and optimization. - Odoo Website Customization: I'm looking for customization of the Odoo website to better reflect and serve my business needs. - POS Customization: Tailoring the point-of-sale system within Odoo to ensure it's user-friendly, efficient and meets specific business requirements. - Multi-branch Capabilities: Implementing the necessary features to support multi-branch operations. The successful bidder will have: - Extensive experience in Odoo (OpenERP) migration projects. - Proven track record in advanced inventory management and POS customizations....
I need an advanced web application developed. This application will include complex user interactions and data processing. Technical requirements include: - Expertise in Angular for frontend development - Knowledge of Spring Boot for application framework operations - Proficiency in Java Persistence API (JPA) for managing database operations Ideal candidates should have proven track record in building complex, dynamic and interactive web applications using these frameworks. Understanding best practices for each of these frameworks is highly desirable.
...explaining the process by which you calculated these statistics. Calculate the mean, median, mode, and standard deviation of the stock volume. Put in table format for easy review. Write a sentence explaining the process by which you calculated these statistics. Ideal freelancers for this project would be those experienced in statistical analysis and data visualization. Skills in using tools like Excel. If this sounds like your kind of project, get in touch and showcase your skills. The information to use is attached...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
I need a high-quality 3D rendering specialist to create a detailed architectural visualization of an urban setting for me. This project requires a high level of skill and attention to detail. Key Points: - Focus: The primary focus of the rendering will be showcasing the architectural design specifically in an urban environment. - Level of Detail: I require advanced level of detail in the 3D rendering including realistic lighting and landscaping elements. - Experience: It would be beneficial if you have prior experience in architectural visualization and urban settings. - Software: Proficiency in software such as 3ds Max, V-Ray, SketchUp, or similar is preferred. Your task will be to bring my concept to life and make it engaging and realistic. The final output should be suitable f...
I'm in need of an experienced...- Proficiency in API integration for seamless data transfer and communication - Prior experience in designing and implementing CRM front-end and back-end relations The most crucial aspect of this project for me is the user interface design and experience. I want a website that not only functions efficiently, but also looks and feels intuitive for users. I'm looking for someone who: - Is an advanced-level developer - Has a strong background in CRM development - Can demonstrate a portfolio of high-quality, custom job - Has experience in Java, YAML, database scripting, API integration, and front-end/back-end relationship management. If you meet these criteria and are up for the challenge of creating a top-tier CRM database website, I'...
...ratings. Include multimedia integration for a richer insight. 3. Job Posting and Application Management -Customizable Job Listings: Design forms with fields for job title, description, skills required, employment type, and location, including special tags for urgency. -Application Process: Interface for direct applications and a dashboard for candidates to track their application status. -Advanced Filtering and Recommender System: Search interfaces that allow dynamic filtering and display the integration of a machine learning-based recommender system. 4. Recruitment Process Management -Interview Scheduling: Calendar integration to show available time slots and scheduled interviews. -Automated Notifications: Design for email and SMS notifications setup. -In-Platform Messag...
As the core of this project, I need a highly skilled DevOps Engineer who is proficient in both Amazon Web Services (AWS) and Microsoft Azure. Your primary tasks would be: - Infrastructure Provisioning on both AWS and Azure. - Setup Continuous Integration/Continuous Deployment (CI/CD) pipelines. - Implement robust monitoring and logging systems. - Additional expertise in Kubernetes, Docker, and Ansible would be an immense advantage. The key aspect of this role is the ability to fully automate these tasks. Your talent in automation should position you at the forefront of modern DevOps best practices. I'm looking forward to working hand in hand with a driven, quality-focused, and experienced DevOps engineer on these essential operations.
I'm looking for a professional and creative PowerPoint expert who can convert my content in...The presentation will highlight market parameters including Competition, Consumer Behavior, and Market Trends. - It's crucial that you convey the information in a captivating and understandable manner, aiming to pitch our sales strategies effectively. Ideal Skills: - Proven experience in designing PowerPoint presentations, preferably for the sales/marketing sector. - Proficiency in utilizing advanced PowerPoint tools and graphics. - Strong understanding of effective presentation techniques for sales/marketing. - Experience with successfully communicating complex market analysis. Please showcase your previous related work in your bid. Looking forward to an attractive and infor...
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
I'm in need of a skilled video editor who can take my raw footage and transform it into engaging content for various social media platforms. Key Responsibilities: - Implement advanced editing techniques: Color correction, visual effects, etc. - Tailor video content to suit Instagram, YouTube, and TikTok. - Ensure content is engaging and aligns with the intended purpose of each platform. Ideal Candidate: - Proficient with video editing software and advanced editing techniques. - Prior experience creating content for social media platforms. - Able to work efficiently and meet deadlines. - Good communication skills to understand and execute my vision. Looking forward to seeing your portfolio and discussing how you can help me elevate my social media presence through pr...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
I am looking for someone skilled in photo editing to eliminate certain individuals from my group photos. This task requires a careful and thoughtful touch to ensure that the final product looks authentic and unaffected. The People to be Removed: - Ex-partners - Ex-friends The Photos: - Group photos Ideal skills and experience include: - Advanced proficiency in photo editing software - Attention to detail - Experience with removing people from complex images - Demonstrated ability to maintain the integrity of photos after editing.
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I am searching for a skilled video editor to create engaging content for my YouTube channel. The ideal candidate will have experience in a variety of editing styles, including documentary, podcast, cinematic, tutorials, vlogs, and montages. Requirements: - Strong command of advanced editing techniques - Ability to incorporate a range of styles seamlessly - Proficiency in color grading and audio enhancement - Experience with YouTube content creation Please provide examples of your previous work that demonstrate your proficiency in these areas. Your creativity and ability to engage audiences will be key in this project.
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and t...
...tracking for traffic sources, conversion rates, page views and user interactions on my e-commerce website. You should have a strong background in data analysis and be able to provide actionable insights based on the data. Skills and Experience: - Strong Proficiency in Google Analytics: As I am currently using Google Analytics, you should be experienced with the platform and be able to set up advanced tracking and reporting. - E-commerce Analytics: Experience with e-commerce tracking methodologies, such as tracking of specific sales funnels, cart abandonment rates, and product performance. - Data Analysis: A comprehensive understanding of web analytics and the ability to derive valuable insights from the data. - Communication: Strong communication skills are essential for this pr...
I'm looking for a Fusion 360 expert to assist with a highly detailed 2D drafting project. The task involves creating complex, detailed technical drawings for architectural structures. Key Requirements: - Fusion 360 Proficiency: Advanced skills in Fusion 360 are a must to handle the complexities of the drafting task. - 2D Drafting Experience: Prior experience with intricate 2D drafting is highly preferred. - Attention to Detail: The final output needs to be highly detailed, including textures and materials, so a keen eye for detail is essential. Please apply if you have the required expertise in Fusion 360, particularly in the realm of detailed 2D drafting. Your engagement will greatly help in bringing this architectural project to life.
I'm in need of a WordPress expert with advanced knowledge in both plugin and theme development. The perfect candidate for this project should have a good grasp of PHP, JavaScript and databases. Key Responsibilities: - Develop and customize WordPress plugins - Develop and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Strong problem-solving ski...
