In the materials for this section you find the files and exercises of this project.

Project 1: Basics First

Goal -> A nicely formatted data set that is ready for printing (see image in the pdf)

Start:

The data set you receive needs a bit of fixing. Let’s start with the missing data in the booking
conversion column. Enter the percentage values you see in the solution and format the values as
percentages with 2 decimals.
Hide the gridlines on the sheet
Apply a blue fill color to the header and a white font color.
Merge the 5 cells for partner 1 in the first column and update the formatting.
Apply border lines as shown in the solution image.
Add euro symbols to the columns “Cost per Click” and “Revenue from Clickouts”.
What are the numbers you see in the date column? Can you update the formatting so that it only shows the month and year (so don’t just overwrite the numbers with Jan 2021).
Make sure it prints out nicely

Srushti Sakhare

--