From the course: Office Scripts In Excel: Automating Tasks

Unlock this course with a free trial

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

Solution: Reporting on tasks

Solution: Reporting on tasks - Microsoft Excel Tutorial

From the course: Office Scripts In Excel: Automating Tasks

Start my 1-month free trial Buy for my team

Solution: Reporting on tasks

“

I hope you enjoyed building your Office Script. Now let's walk through the process step by step. Open the 01-challenge.xlsx workbook from the previous movie to follow along. Before we make any changes, let's turn on the Office Script recorder. This will allow us to easily reapply these steps to future worksheets. To do this, go to the Automate tab, click Record Actions, and from this point forward, Office Scripts will translate our actions into code. The first task is to correct the poorly formatted dates. Let's navigate to Cells D4 through D8. Under the Home tab in the formatting group, change the format to a short date. That looks much better. Awesome. Next, let's move to Cell B1 and sum the values in Cells C4 through C8. Perfect. Finally, we'll select Cells A3 through D3 and change the font color to dark blue. Beautiful. Now that we're done recording, click Stop. I'll rename this script to something like Task Hours Tracker Report. Great. The script is now saved and ready for reuse.…

Contents