Excel macro accounting formatpráce

pasar informacion a excel. pasar informacion a excel

Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.

Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.

Ahoj, Zabýváme se poskytováním vzdělávání v IT prostřednictvím online-videokurzů a máme za cíl tento format převést na novou úroveň - svěží, kvalitní a dostupný content. Hledáme do svého týmu FRONT-END developera, který bude schopný předat své znalosti lidem a pomoct jim dosáhnout úspěchu v tomto oboru. Hledáš práci s možností se neustále rozvíjet, chceš být součástí grandiozního projektu a dělat opravdu úžasné věci? Welcome! Co u nás budete dělat? 1) Záznam výukových lekcí 2) Pomáhat st...

...main focus of the brand is to reduce waste from events and to use and work gently with materials and props. "Eventačka" offers 3 services: - Tailor made events for business partners, employees, or the public. (Family, Kids or sports day, Corporate events, Employee parties, Christmas parties, Opening events, Company anniversaries, Open days, Roadshow, Garden parties, Galaevenings and other new format that are not so known) - External cooperation with agencies. - Production of "Re-decoration" (decoration, props, upcycling material - reuse, remake, recycle system). Claim: TOGETHER we will transform your values ​​INTO ACTION! (maybe there will only be Together into Action - I do not know yet). Concerning the logo, I do not have a specific idea so far. It shou...

1. Need to download product description 2. Need to transfer into plain text 3. Need to format H1, H2 and table result will be well formated text with proper HTML tags See below: FROM THIS ----------------------------------------------------- Popis výrobku Brusinkový čaj na močové cesty Bylinný čaj porcovaný v nálevových sáčcích. Brusinky obsahují antioxidanty, přispívají k normální funkci močové soustavy, podporují přirozenou obranyschopnost. Bříza, šípek a zlatobýl přispívají k normální funkci ledvin a močových cest. Kopřiva a přeslička podporují vylučování. Složen&...

datae

datae

Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl

mise en forme

Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket

Napraviti Excel VBA program

Account out sourcing and legal drafting work

Mame jednoduchy dokument - 4 (stvor) stranovu brozuru () v Adobe Indesigne velkost - format brozury je A5. Tlacime na papier A4 dve kopie dokumentu , brozury. Chceme vytlacit, mat vystup z tlaciarne ako je na obrazku ... teda po vytlaceni a rozrezani A4 papierov dostaneme dve finalne brozury pripravene na vazbu. Otazkou je: ako porgrame Indesign CS3, alebo CS6 nastavit tlac , collate funkciu, aby brozuru vytlacilo ako na ? Funkcne riesenie odmenime.

I'm seeking the expertise of a seasoned designer to create engaging Instagram templates representing my mining and emergency services company. The overall aesthetic should b...effectively communicate our company's values and mission, depict the benefits of our products and services, and provide industry insights and education. - Keep in mind that these templates need to cater to a varied audience; general public, industry professionals, and potential clients/customers. Ideal Skills and Experience: - Strong graphic design skills - Familiarity with Instagram's style and format - Experience in designing with the mining industry would be a plus - Ability to effectively communicate complex concepts visually - Proficient in photo editing and digital manipulation software l...

I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with this type of formatting is an...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

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

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

...Progress Tracking: Implementation of tools that monitor and track the progress of the students as they move through the courses. - Discussion Forum: A forum that allows students to interact with each other, ask questions, and discuss topics related to the course material. Content Offered: - Video Courses: The platform will have video lectures. - Text-based Courses: Supporting materials in text format. - Interactive Quizzes: Regular quizzes to reinforce learning. - Ispring & similar tools: Ability to embed content from these tools. - Multimedia: The platform should support and display pictures, sounds, and picture with sound content. Design and Branding: - I already have a specific design and branding in mind for the platform. You will be responsible for implementing this de...

Hi Zainab528, I noticed your profile and would like to ask about getting you to redesign / reproduce a couple of Leaflets for me. I have some existing ones for 2 of my products, and will shortly need a third one. The two I already have I need producing into a format that I can upload to my website. I can send you PDF copies of them for you to look at and give me a price? Thanks, Dan

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

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

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

I am urgently in need of an expert in Docparser. I have several PDF documents from which I need to extract specific information in the form of both text and tables. Therefore, the successful candidate mus...details. I have all of the pdfs most are in my docparser account. What we need extracted from each is: invoice number invoice date item id-SKU # artist name album title number purchased number backordered price we paid-unit price recommended sale price description of item album release date notes about album (limited edition, vinyl color, number of albums in each product, Mobile fidelity) format of the product (cd, vinyl, blu ray etc.) I can share pdf examples of each if that would help. Let me know what questions that you have. I look forward to hearing back from you. ...

...transactions 4. prepare the accounting schedule (The “schedules”); A. Account Receivable, B. Account Payable, C. Payroll (Included MPF) D. Loan, E. Accrued expense. F. Amount due from/to G. Bank transaction. H. Fixed asset (with depreciation) 5. Prepare monthly financial statement (with the schedules Above) "Additional Scope" (I want you to do) 6. Using the accounting system "Odoo" for better recording process A. The Ideal scenario is keeping all the records at the Odoo. 7. Advise and enhance better workflow in accounting with our colleagues. 8. Translation from the Chinese to English from both. “Advance Scope” (I hope you to do) 9. Recording in manner of Managerial Accounting (costing schedule by projects) 10. Comm...

...growers face challenges in accessing markets due to high air and sea freight costs. To support these farmers and producer groups, our organization provides upfront funding for freight expenses. However, the existing process lacks a robust database system with simple bookkeeping features. We need a comprehensive solution that streamlines the entire process, ensures transparency, and automates accounting and reporting tasks. 2. Solution: Commodity Transportation and Funding App Key Features: User Registration and Application: Commodity growers, shipping companies, and airline carriers register through a user-friendly web interface. User details, including CRM data, are captured during registration. Freight Tracking and Reimbursement: Record transportation details (departure, arriv...

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

I need a skilled VBA developer who can help with an important task -- Macro Programming. The main purpose of this programming will be to improve the output of data in a more coherent and meaningful way. Here's what the project involves: - Macro Programming: I am specifically looking for someone who can build macros in our system to ease the process and make it more efficient. - Data Output Formatting: The second important part of the task is to navigate data output formatting. Even though I haven't specified the kind of formatting, this is a crucial aspect of the job. Skills and experience necessary for this project include: - Proficiency in VBA development and Macro programming - Experience in managing and manipulating data - Skills in data output for...

I'm seeking an experienced Moodle plugin developer for personal use. The main requirement is to ensure that the plugin fosters good user interface with functionalities that can make it modern and clean. Here are the project's details: -The idea for the plugin is that it uses the already existing format seen in the grading view for submissions and instead uses that as the foundation with the online text replacing the pdf panel (left) and the feedback panel (right) will instead store instructor provided resources such as assignment-relevant description, links, and most importantly, the assignment rubric for easy viewing. - The plugin should have a good user interface. This will significantly improve user experience and interaction with the platform. - Only barebones struc...

I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus

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

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

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

I'm in need of a software that can handle all my accounting needs, as well as the management of employee-related tasks. Here are the specifics: - **Expense Tracking:** - Automatically import expenses from bank statements - Generate detailed expense reports - **Payroll Management:** - Calculate salary, deductions, and taxes for each employee - **HR Functionality:** - Manage employee profiles and contact information - Store and retrieve employee-related documents The ideal candidate should have extensive experience in developing accounting software, payroll systems, and HR management tools. The software should be comprehensive, yet user-friendly, with a focus on efficiency and accuracy. Prior experience in handling Arabic language requirements is a plus.

I'm seeking a skilled animator to create a marketing 2 video ads. Requirements: - Use your creative skills to translate complex business information into a visually engaging and easy-to-understand animation. - The video should be polished and professional, aligning with the expectations of a corporate audience. Ideal skills/experience: - Proficiency in 2D animation and video creation - ...animation. - The video should be polished and professional, aligning with the expectations of a corporate audience. Ideal skills/experience: - Proficiency in 2D animation and video creation - Strong understanding of marketing and advertising principles - Experience in creating content for corporate or business audiences - Ability to translate complex information into a clear and visually appealin...

As a tax accounting firm, we need a modern and minimalist brochure/front page template created on Canva. This design will be a vital part of our client communications, underlining our commitment to transparency and professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. I...

I'm in need of a Java developer to create Rest API(s) that will facilitate user customization of a default travel itinerary. The APIs should have the following features: - Loading Default Itinerary: The API sh...required for a visit, the best time to visit, and any other relevant details. The ideal candidate for this project should have: - Proficiency in Java, as the Rest API(s) need to be developed in this language. - Experience in Rest API development, particularly in creating APIs that handle different types of data and can be customized by users. - Knowledge of JSON, as this is the preferred data format for the API responses. If you're a skilled Java developer with experience in Rest API development and can deliver a high-quality, customizable itinerary API, I'...

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

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

I'm seeking an experienced architect or designer to create a detailed commercial floor plan as I am apply for a liquor license permit and it is required to have a floor plan with current occupancy stamp that is not less then 1 year old. These plans need to go beyond the basic layout and should include furniture placement. I am not sure whether I need a 2D or 3D format, I am open to suggestions based on your professional opinion. Previous experience with commercial design is crucial for this project. Your bid should include: - Demonstrated experience in commercial floor plan design - Expertise in both 2D and 3D formats - Suggestions based on your professional experience for 2D and/or 3D floor design Please factor these requirements into your time and cost estimates. Thank you ...

I need a professional to convert my existing coffee packaging design from PDF to diecut file format. I have the design ready and it's in PDF format. I'm looking for someone to prepare a diecut file of the design for submission. The packaging types I require the diecut for are: - Coffee cup (paper-plastic) - Paper bag - Sweet packaging The project is urgent, and I'm looking for someone who can deliver the diecut files quickly. Ideal Skills and Experience: - Proficient in graphic design software - Experience in diecut file preparation for packaging - Ability to work under tight deadlines - Good communication skills for quick project updates.

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

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

...within the game. The project must be compatible with Windows 10. Candidates should be proficient in at least one of the following programming languages: C++, Python, or Pascal. Payment will be made upon successful demonstration of the emulator working within the game. Note: This project does not involve breaking any game's security measures or installing unsigned drivers. Important Information: Macro usage in the game is permitted and is not considered illegal. Before bidding on the project, please confirm that you have reviewed the code provided in the attachment. The project requires more in-depth and lower-level coding knowledge than the example provided in the attachment. It necessitates knowledge of ring0 level coding." By submitting a proposal for this project,...

I need a Python program to parse a JSON file and format it correctly to be JSON compliant. Key Requirements: - Input Data: The input data is in JSON format. - Output Data: The JSON output should be properly formatted and adhere to a specific schema or structure. Skills and Experience Required: - Proficiency in Python programming. - Strong understanding of JSON parsing and formatting. - Experience in adhering to specific JSON schemas or structures. Please let me know your experience in similar projects and any relevant information that would make you a strong candidate for this job. You will pass the name of the input file as an argument and the output file should be the same file name with the .output extension. The input file is attached. Pay attention to the backsla...

In need of a talented graphic designer who can effortlessly bring together various sports team logos into a single image. You will have at least one month to complete the task. Must haves include: • Knowledge of different image formats. I don't have a specific format in mind, so feel free to use what you think works best. • Strong graphic design experience, particularly with sports team logos. • Positive history of delivering projects on time. Your expertise will determine the result, but keep in mind that I'm looking for a design that can seamlessly incorporate different team logos. If this sounds like you, feel free to bid.

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