Excel macro tutorial for beginnersdela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

need help with spreadsheet formula

Tengo una asesoría energética, la cual paga comisión por contrato. La comisión depende de distintos factores. Actualmente tenemos un backend en excel y un frontend en pdf, es decir: Creamos las comisiones en excel para agilizar la creación, las copiamos en un POWERPOINT algo más atractivo y visual, y las convertimos a pdf. Nos gustaría poder implementar la subida de estos excels en una interfaz BONITA, incrustrada en una web. Lo ideal sería poder cargar estos excel a la web y que la web "pintara" estas comisiones a través de una interfaz visualmente atractiva y llamativa para nuestros agentes comerciales. Adjuntamos ejemplo de excel de comisiones de algunas de nuestras compañ&ia...

I'm seeking a detail-oriented Virtual Assistant to assist with data entry tasks, focusin...assist with data entry tasks, focusing on website data editing and publishing. No specific knowledge or expertise is required for these tasks, making this project an excellent opportunity for beginners and experienced freelancers. Skills and Experience Required: - Strong attention to detail - Excellent organizational skills - Proficient in website data editing and publishing - Reliable internet connection for efficient online work The ideal candidate will have experience in similar data entry projects, although it is not a requirement. This project is an opportunity for long-term collaboration for the right candidate. Do you think you could be the pe...

I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!

I'm seeking an expert Python developer to integrate the Sales, Inventory, and Accounting modules of Odoo with WooCommerce. This is an advanced task that requires deep knowledge of Pyt...and WooCommerce platforms. KEY TASKS: - Develop a robust API connection between Odoo and WooCommerce. - Ensure seamless data exchange between the Sales, Inventory, and Accounting modules. REQUIRED SKILLS/EXPERIENCE: - Expert-level Python programming skills. - Extensive experience with Odoo and WooCommerce integration. - Experience with API development and integration. This project is not for beginners or intermediate level programmers. I need someone with a high degree of skill and proven proficiency in Python, Odoo, and WooCommerce. If you meet these requirements, I look forward to ...

For my project, I need a freelancer with strong skills in data scraping and extraction, particularly with textual content and figures, from a specified public website - Tasks: - Effectively pull relevant textual content and figures - Ensuring the scraped data is comprehensive, accurate, and neatly organized Excel Skills: - The data collected must be meticulously stored in an Excel database - The organization method within the database is by entity An effective freelancer must be detail-oriented, proficient in using Excel and knowledgeable about data scraping techniques from public websites. A background in handling similar tasks would be advantageous. Accuracy and neatness in data organization are also paramount. Please indicate you reviewed the informat...

I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this ac...

I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok,...existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail and creativity Being quick, creative, and consistent are the key components...

...be considered for the project. Freelancer – I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from ...

...visuals for presentations, social media, and other purposes. - Video Editing: Proficiency in editing videos for personal and professional purposes. - Building Tutorials: You'll be required to create user-friendly and engaging tutorials. -Bonus if you are able to know WordPress - Email Management: You should be able to manage your emails efficiently, including sorting, responding, and flagging important messages. The ideal candidate should have: - Excellent English language skills and ability to follow directions - Proven experience in data entry, video editing, and graphic design - Good organizational and time-management abilities and knows deadlines - Strong communication skills - Experience with tutorial creation and email management is a plus This is...

I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messaging - Capable of implementing and managing information resources The main functionalities of the bot are: - Sending automated messages: The bot should be able to send pre-determined messages at set intervals. - Receiving user input: It should be able to interact with users and receive text input from them. - Providing information based on user queries: The bot needs to be able to present content from our company's internal library which will be provided upon Bot design by using MENU BUIL...

...website for me. The main goal is for it to provide information about my offline tutorial classes to the potential clients effectively. Key requirements: - Simplistic informational website design and development - User friendly and easy to navigate - Integration of a booking system for offline tutorial classes - Must be responsive and mobile-friendly - SEO optimization Although a payment system is not a must-have right now, I would prefer a developer who has the ability to integrate one in the future. Ideal skills: - Experience in web design and development - Proficiency in writing clean and efficient code - Familiarity with SEO best practices - Experience with booking system integration - Knowledge of potential payment system integration methods - ...

You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.

I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as the analysis will be used to make important busi...

...set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal skills and expe...

I have a database with 200,000 SKU's from retail sales, unfortunately lacking category, subcategory, and brand det... subcategory, and brand details. I'm seeking a skilled professional who can assist in mapping these details effectively. Key Deliverables: - Utilize a data matching algorithm to automatically map the SKU's with high accuracy (90-95%). - Present the final output in an Excel spreadsheet. Ideal Skills: - Proven experience in data matching and SKU mapping. - Proficiency in using data matching algorithms. - Experience with handling large datasets. Accuracy is paramount for this project, as the mapped details will be used for further data analysis and decision-making in our retail operations. A high level of precision will be crucial in ensu...

I'm in need of a series of short, engaging DIY tutorial videos designed specifically for beginners. Each video should be under 5 minutes in length. The project involves: - Creating a series of beginner-friendly DIY tutorial videos. - Ensuring the videos are clear, engaging and easy to follow. The ideal freelancer for this project will have experience with: - Video production, including editing. - Creating content for beginners. - DIY projects or the subject matter of the tutorials. Please provide a quote for the production of a single tutorial video, and a portfolio or examples of previous work that demonstrate your experience in these areas.

I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.

Create a video tutorial for rendering animation scene in Maya

...major platforms - RERA websites (specifically Maharashtra, Telangana, Haryana, and Delhi), Google, and Justdial. Here's what I am looking for: Details to Scrape: - Name - Mobile Numbers - Locality - City - Address - Pincode Platforms: - RERA Websites (Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivered in an excel file format. If you have the required skills and this project fits your area of expertise, I encourag...

I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.

I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highli...

I'm seeking a specialist with expertise in detailed financial data entry. You'll be tasked with entering intricate numbers and figures for our financial reports. Skills and Experience Required: - Proficient in Microsoft Excel. - Experience with financial report data entry. - Detail-oriented with ability to handle complex numerical data. Main Tasks: - Inputting detailed financial data into our Excel-based financial reports. - Ensuring accuracy of data. - Completing tasks within given deadlines. Please share relevant previous experience and examples of your work when bidding.

I'm in search of a seasoned Excel-savvy bookkeeper to assist with the following tasks: - Accounts Payable: Tracking and managing all outgoing payments in a clear and organized manner. - Accounts Receivable: Overseeing and monitoring all incoming payments, ensuring timeliness and accuracy. - Bank Reconciliation: Regularly reconciling bank statements with our financial records to ensure accuracy. You don't necessarily need to be an expert in accounting software, but you should be fluent in Excel. This project doesn't involve learning new software, but rather meticulously managing and organizing financial data in Excel. I prefer to receive updates and reports via email, so clear and concise communication skills are a must. Experience in bookkeeping or a...

I need an Excel expert to help me document my financial data in a specific text-based format. Key Requirements: - Organizing and documenting financial data in Excel - Following a specific text-based format provided by me Ideal Skills and Experience: - Proven experience in working with financial data - Proficiency in Excel, including advanced functions for data organization - Excellent attention to detail and ability to follow specific instructions accurately and efficiently.

Looking for someone who is highly knowledgeable in Excel functions, formulas, and formatting. The ideal freelancer will have experience performing the following tasks in Excel spreadsheets in portuguese - Implementing a variety of Excel formulas and functions - Applying diverse formatting techniques Unfortunately, I have not specified the exact functions, formulas, or formatting needed, meaning the freelancer must employ a broad range of knowledge and expertise in these areas. Experience with Excel in Portuguese is a definitive plus. The project requires an adaptable and meticulous individual able to meet changing demands efficiently.

I'm on the lookout for a specialist who brings proficiency in both ASHLAR and MIST to the table. Your main objective will be: - Create a small demo App using VB.NET to illustrate implementation of both Ashlar and Microscopy Image Stitching Tool. You're free to employ placeholder images or your own sample images. It's essential that you're adept at using ASHLAR and MIST for seamless task execution. Your bid should evidence your understanding and experience in these software along with VB.NET. Ready to use explanation are available on various sites : Purpose is to understand and learn these two techniques, in VB.NET.

I need a talented designer to create a minimalist logo for my company. Here are my requirements: - The primary color scheme should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligatory. Skillful use of it, contingent on how it fits into the design and overall aesthetics, is appreciated. Ideal candidates should possess past experience in minimalist logo design and a keen eye for balancing colors. If you excel in creating attention-grabbing logos with subtle details, then this project is for you.

I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.

Hola, María, necesitaría el trabajo de este excel: https://docs.google.com/spreadsheets/d/1tnP73xrnE0SGNuynpLpnl1r7mThhi4liPCQCYjTRdvE/edit#gid=1193400678 Gracias,

I'm looking for a freelancer who can create a custom Excel sheet to track the daily attendance of my employees. The sheet should: - Be user-friendly and easy to navigate - Allow for automated calculation of total attendance - Be able to handle multiple employees at once - Have the capacity to expand for future growth I'm not looking for anything too complex, just a simple, efficient tracker that can help me keep tabs on my employees' attendance on a daily basis. Ideal Skills: - Proficiency in Excel, including advanced formulas and functions - Experience in developing user-friendly, automated spreadsheets - Strong organizational and communication skills to ensure the tracker meets my needs and is easy to understand and use.

A...preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same data through meaningful visuals to explore its intricate properties and characteristics. - Should additionally facilitate statistical analysis to derive patterns and trends otherwise invisible to the naked eye. The hoped-for end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tasks is essential, as is familiarity with data cleaning and visualization libraries and tools. To thrive in this role, you must be a highly analytical thinker with the ability to separate noise from signal in dataset and excel at drawing cl...

I'm in need of an individual proficient in Excel to streamline data analysis for my sales numbers. The main objective will be to dissect revenue trends within the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis - Proficiency in Excel - Understanding of sales and revenue benchmarks This role will require you to receive raw data and translate it into an easy-to-understand format, highlighting pivotal information. Your focus will be on creating complex formulas to identify revenue trends, which will help inform our future sales strategies.

I'm looking to automate my trading processes using the Zerodha Excel API. As I'm unsure of the API's development, I need a freelancer who is experienced in API integrations and has a good understanding of automated trading systems. Key Elements: - Automation: The primary goal is to automate trades based on predefined criteria. This involves developing a system that can analyze market conditions and execute trades automatically. - Zerodha Excel API: As I am unsure about the development of this API, you should have a good understanding of it or be able to quickly grasp its functionalities. - Trading Experience: It would be beneficial if you have prior experience in developing automated trading systems. - Predefined criteria: The system should be able to automati...

I'm in need of an English tutor who can help me improve my beginner's level proficiency specifically for educational purposes. Key Requirements: - Proficiency in teaching English to beginners - Prior experience in tutoring or teaching - Ability to customize lessons for educational purposes The ideal candidate should be able to provide me with one-on-one lessons, focusing on building my basic English skills. I am looking to improve my reading, writing, speaking, and listening abilities in a way that will benefit my educational pursuits. Your task will be to design lessons that cater to my specific needs and objectives in education. Your experience in teaching English to beginners and your ability to adapt your teaching style will be invaluable. Plea...

- I hav...questions have zero or one figures, a few have more. I have provided Columns Figure A... FigureH for these as required. LOOK AT THE EXAMPLE. task is to put all 1090 questions into an excel file. I have put one question in there as a sample. I have also put one image which shows two additional questions. - If you win the project, you will get the full PDF. You will be able to cut and paste from the PDF. - To bid on this project, you must give me the excel file back with these two sample entries put in after the one that I did. The sample is a JPG file so you must type it in manually. Successful project: - All questions in there, in correct order from the PDF. - No typos. - Correct answer for all. - Done in 1-2 days. Should not take longer. - N...

I'm looking for a reliable freelancer to help with a small-sized project involving Excel data entry. The information will be shared via online documents. Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail is a must - Ability to handle small-scale tasks efficiently

...to bring my outline to life, creating a live-action demonstration video for my web app. Key project features: - Outline provided: I've got a clear outline of what the video should cover, but need a professional to turn it into a compelling narrative. - Live-action format: The video will require real people and settings, rather than animation or screencasting. - Voiceover: You'll also be responsible for providing a professional voiceover that complements and enhances the on-screen action. Ideal skills and experience: - Video production: You should have experience in creating engaging live-action videos with a clear educational purpose. - Script development: While an outline is provided, you'll need to have an eye for turning ideas into a coherent, en...

I'm looking for a skilled sales closer with a strong track record in retail sales. The ideal candidate should have a versatile background, capable of handling both brick-and-mortar and e-commerce environments. Experience in the pharmaceutical or healthcare industry is a plus. Key responsibilities include: - Engaging with potential customers and guiding them through the sales process - Closing deals with efficiency and a customer-centric approach - Nurturing leads and maintaining strong relationships with existing clients The main products you'll be dealing with are pharmaceuticals, so any previous experience in this specific area is highly desirable. Your success will be measured on your ability to generate sales, retain customers, and ensure their satisfaction with our ...

I wil...changes daily , One such project should be made I'm seeking a proficient Excel specialist to take on a project that primarily involves formatting and creating advanced formulas. Key Responsibilities: - Take charge of the spreadsheet's aesthetic and logical formatting - Develop and implement formulas to aid data analysis and interpretation - Arrange numerical data alphabetically from A to Z Ideal Skills: - Proficiency in Excel functions and formulas - Strong attention to detail, particularly regarding formatting - Excellent problem-solving skills Project Timeline: This project needs to be completed within a month, demonstrating your ability to meet deadlines is crucial. So, if you have good experience with Excel, particularly with formatting an...

I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.

...maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel...

...menciptakan konten video yang menarik dan sesuai tren. Tugasnya mencakup: - Membuat video bertema gerakan viral dan filter di TikTok. - Menghasilkan video penjelasan, tutorial, dan demonstrasi produk yang engaging. Tidak ada batas waktu khusus untuk penyelesaian proyek ini, jadi saya mengutamakan kualitas hasil kerja daripada kecepatan. Anda akan memiliki kebebasan kreatif penuh dalam merancang dan mengimplementasikan ide Anda. Skill yang ideal untuk proyek ini adalah: - Ahli dalam membuat dan mengedit video. - Memahami tren TikTok dan dapat menerapkannya dalam konten video. - Memiliki pengalaman dalam pembuatan video penjelasan, tutorial, dan demonstrasi produk. - Kreatif dan inovatif dalam pendekatan mereka untuk menciptakan konten video menarik. - Komunikatif dan da...

I'm in need of a proficient individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from SPSS. Here's what I'm looking for: • Skilled in analyzing questionnaires using SPSS • Able to export data into tables • Analysis should be done based on patterns of behavior • Writing a brief description of data based on hypotheses The data is on an Excel file right now. Please bid only if you have relevant skills and experience as it will demand a high level of expertise and detail orientation. Don't hesitate to ask if you have any queries. Thank you!

We are looking for a candidate who can edit YouTube videos for us. We typically have YouTube videos with a length of 5-15 mins which can be tutorial based or demo based. Following are the requirements - 1. Provide edited YouTube video for the given raw recording. 2. The edited video need to have required effects like text overlays, effects like zoom-in/ zoom-out effects etc. as per the need to present it more interesting way 3. Background music from YouTube audio library 4. Thumbnail for the YouTube video 5. Edit YouTube shorts video 6. Editing style to be formal and professional. The aim is to make the content easy to follow and engaging. We are targeting around 4-5 long format videos & 4-5 YouTube shorts per month.

As a Media TV Channel, we are seeking a UDAID Contract Compliance Specialist to review our contracts, ensure compliance with cont...adhere to all terms and conditions outlined in our contracts. - Auditing financial records: You will need to conduct detailed audits of our financial records to guarantee compliance. Industry Experience: While not mandatory, if you've previously worked in the media TV channel sector, it would be an added advantage. Understanding the unique nuances and challenges of this industry will help you excel in this role. Ideal Skills and Experience: - Experience with USAID contracts is a must. - Previous work in media TV channels would be beneficial. - Strong background in contract compliance and financial auditing. - Detail-oriented with excellent commun...