Work in Google Sheets
11 USD The work needs to be done in Google Sheets, each task on a separate sheet.
1.2. Format the data table for convenience,
1.3. Using a logical function, calculate the Budget Sum in hryvnia on the current date. When calculating, consider the current exchange rate for each currency (dollar, euro, Canadian dollar, Swiss franc, Swedish krona, and others)
1.4. Calculate the budget amount donated by a donor country (choose the country yourself)
1.5. Calculate the amount of budget aid provided by the USA and Germany
1.6. Sort the first 15 records in the table in descending order of Budget in hryvnia, using the appropriate formula
1.7. Copy 10 records with the table header to a new sheet. Sort the data sheet in ascending order of the Beneficiary field, using the Data tab
1.8. Select unique data by the Sector field, using the appropriate formula
1.9. Using the QUERY formula, calculate the total budget amount in each currency
Each subsequent task should be performed on a new sheet, before performing the task, copy the sheet with the original table
1.10. Make the filtered table dynamic instead of static (create a dropdown list that allows changing information)
1.11. Using the filter from the Data tab, select data on international aid projects in the Banking and Financial sector
1.12. Using the filter from the Data tab, select data on international aid projects ending after January 01, 2022
1.13. Build a summary table displaying aid data in hryvnia by each donor broken down by sectors. Add a Slice by the Currency field
1.14. Build a summary table showing the end date of international aid projects, the currency to which the aid will be received, and the total amount of this aid. Group the data by quarters
Part 2
2.2. Add a Project Status column and using the Dropdown function, create an arbitrary dropdown list of 3-4 items and choose a color from the suggested palette for each
2.3. Using variable colors, create and apply a Special style to the entire table
2.4. Using conditional formatting, color code the Bonuses to the salary scale. Choose the color palette scale from minimum to maximum values yourself
2.5. Using conditional formatting, set different font formats (colors) for each position
2.6. Create 4 mini-charts (standard; standard with a randomly chosen color; standard with arbitrary thickness and color; bar chart with a randomly chosen color)
2.7. Create a line chart with arbitrarily selected data
2.8. Create a gauge chart with arbitrarily selected data
2.9. Build a chart displaying average bonuses to salary for each position, choose the chart type yourself
2.10. Create a dynamic chart displaying the bonus to salary depending on the position and changing according to the IT project Status
Applications 2
-
1 day11 USD
405 1 day11 USD
Hello! Ready to start working right now. If the offer is interesting, I am waiting for feedback)
-
1 day17 USD
459 2 0 1 day17 USD
Good day, Bohdan!
I will complete the assigned task according to the specified list.
We work for victory!
-
2 days67 USD
421 13 0 2 days67 USD
Greetings!
I work with Excel and Google spreadsheets.
Ready to help with formulas or macros (scripts).
Integration of Telegram bot and email with Google spreadsheets.
Looking forward to collaborating.
Hello.
I work with Excel and Google spreadsheets.
Ready to help with formulas macros (scripts).
… Communication with Telegram bot and email with Google spreadsheets.
I will be glad to cooperate.
-
1 day20 USD
630 36 1 1 day20 USD
Hello!
I have extensive experience working with Excel, as it is part of my profession)
I will be glad to work on your project, I can start working on it immediately.
-
1 day20 USD
543 19 2 1 day20 USD
Good evening, ready to complete your task quickly and qualitatively
-
1 day17 USD
647 11 1 1 day17 USD
Good evening.
Ready to complete the order within the specified deadline.
I specialize in working with Google Sheets.
-
7 days67 USD
417 5 0 7 days67 USD
Hello, ready to work with the given tables. Have experience working with Excel.
Current freelance projects in the category Tuition
Assistance with Shopify and EtsyHello. I need help with Shopify and Etsy. Accounts are set up, and Nova Poshta and WesternBid are configured. Ten products have been added. Needed: to check the settings, to consult on the order processing, to choose a country to start sales (Europe), to help set everything up… Online Stores & E-commerce, Tuition ∙ 3 days 15 hours back ∙ 9 proposals |
I am looking for a mentor with Claude Code to launch a web project from scratch.Brief about the task: I am a beginner with no programming experience. I have a ready specification for website development (42 pages, Next.js, PostgreSQL). I want to implement it myself using Claude Code - I need a specialist who will set up the environment and teach me how to… Javascript and Typescript, Tuition ∙ 4 days 19 hours back ∙ 18 proposals |
French language tutor |
Setting up work with MetaQuest 3 / PC
89 USD
Need help setting up MetaQuest 3 and PC. We can agree on any point separately - setting up YouTube, TikTok stream - setting up chroma key (for MetaQuest) - assistance with software and game installation Tuition, Video Processing ∙ 16 days 9 hours back ∙ 4 proposals |
BOT for sending forwarded messages from Telegram to Viber. How to do it? Where to find?Hello, is there a bot for forwarding messages from Viber to Telegram or WhatsApp Instagram? I found one from work, need help setting it up CrossPost Bot — One post, three platforms Info from the site Program for cross-posting messages in Viber (automatic sending of content… Content Management, Tuition ∙ 2 months 1 day back ∙ 29 proposals |
Kyiv