From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

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 Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

Solution: Manage workbook options and setting

“

(upbeat music) - [Instructor] Welcome to the Solution video for the chapter 2 challenge. For this challenge you use the O2_09 challenge exercise file and the O2_09 commissions file. I challenged you to complete all of the tasks in 10 minutes or less, let's jump right in. First we're going to save the file as My Challenge in the chapter 2 exercise file. We'll go to File and Save As navigate to the desktop where I have my file saved rename it My Challenge and click Save. Next, 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, Formulas, change it to Manual recalculation and recalculate workbook before saving, click okay. Number three, configure the ribbon to display the tab that includes visual basic options, that's our Developer tab. So let's right-click on the Ribbon, Customize the ribbon select Developer…

Contents