Work in Google Sheets

Tuition — incorrectly specified categories?

11 USD

Project translated automatically. Log in or register, to view the original

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

Proposals 10

Oleksii Nazarchuk

0 0

Projects -
Rating -
Rating 405

Budget: 500 UAH Deadline: 1 day

Hello! Ready to start working right now. If the offer is interesting, I am waiting for feedback)

Yaroslav Bohachuk

2 0

Projects -
Rating -
Rating 411

Budget: 777 UAH Deadline: 1 day

Good day, Bohdan!

I will complete the assigned task according to the specified list.

We work for victory!

Petro Shpak

13 0

Projects 13
Rating -
Rating 419

Budget: 3000 UAH Deadline: 2 days

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.

Mariia P.

36 1

Projects 25
Rating -
Rating 630

Budget: 900 UAH Deadline: 1 day

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.