From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Manage workbook options and setting

Solution: Manage workbook options and setting

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Solution: Manage workbook options and setting

“

- [Instructor] Welcome to the solution video for the Chapter 2 challenge. For this challenge, we used the 02_05 Challenge exercise file and I challenged you to complete all the tasks for all the projects in seven minutes or less. Let's go ahead and get started. Okay, our first task is to save the file as My 02_05 Challenge. We'll go to File and choose Save As. Make sure we get back to our Chapter 2 folder on the desktop. Click in front of the document title, type My with a space and click Save. Perfect. Task number two, configure Excel so that calculations do not automatically occur and that the workbook is recalculated each time the workbook is saved. Let's go to File and Options and we'll go to Formulas. Here's our workbook Calculation group. Change it to Manual. Leave Recalculate Workbook Before Saving selected. We'll go ahead and click Okay. Number three, show the Developer tab on the ribbon. Okay, notice that it's already showing on mine and that's because it's a global setting…

Contents