From the course: Office Scripts In Excel: Automating Tasks

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Challenge: Create a task summary report

Challenge: Create a task summary report - Microsoft Excel Tutorial

From the course: Office Scripts In Excel: Automating Tasks

Start my 1-month free trial Buy for my team

Challenge: Create a task summary report

“

In this chapter, you've been introduced to the basics of working with Office Scripts. Now it's your turn to put that knowledge into practice by building something on your own. For this challenge, you'll apply what you've learned to create a basic task summary report. Start by opening the exercise file named 01-challenge. xlsx to review the raw data. You'll need to tackle a few tasks here. You'll use the Record Actions feature to handle most of the work. First, notice that the Due Date column is not properly formatted. It's currently showing Excel serial number, which can be confusing in reports. Use Record Actions to format Cells D4 through D8 correctly. Next, sum the hours worked in Cells C4 through C8 and display the total in Cell B1. Finally, add some color to the header cells in A3 through D3. Now let's take it a step further. Can you figure out how to modify your Office Script to include a user form that asks the user to select the color they'd like for the headers? Hint: this…

Contents