The excel projects intention was mainly to apply the skills we learned during the Excel Scavenger Hunt. So the use of basic excels formatting and functions as well as Pivot tables.
In the first task we had to work on the given data and create new useful cells with the help of excel functions. I made the first two rows bold and centered the gender column. In addition I froze the first two rows, as it makes it more convenient to scroll through the data.
After that I created several new cells that provide new data information.
· Maximum Heart Rate (Max HR)
· Target Heart Rate (Tgt HR)
· Highest Heart Rate Achieved ( Highest HR)
· Target Achieved (Tgt Achieved)
· Heart Rate Increase (PctIncreaseHR)
![]() |
Excel Sheet |
With these new data it is now possible to give more informative information about the effectiveness of the new workout in the fitness center. To print these data, the printing layout had to be adjusted to make it fit to one page. In addition headings and footers where included for a professional look.
![]() |
Pivot table |
Overall this exercise should prepare us for the daily business in a company, where you often work with Excel. Especially the Pivot table function can save you a lot of time as you can quickly create new tables.
Keine Kommentare:
Kommentar veröffentlichen