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.
Challenge: Manage workbook options and settings
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Challenge: Manage workbook options and settings
(upbeat techno music) - [Instructor] Welcome to the Chapter 2 Challenge. For this challenge, you'll be using the 02_09 challenge exercise file and the 02_09 commissions workbook. I believe you should be able to complete all of the tasks in 10 minutes or less. Now, if you find that you're unable to complete all of the tasks within 10 minutes, watch the videos for Chapter 2 again, and then come back and try the challenge one more time. Now because this is our first challenge, let's take a look at the exercise files, Chapter 2, and look at the challenge file and the commissions file that we'll be using. My files are stored on my desktop. And here are the contents of the Chapter 2 folder. We'll be using 02_09 Challenge and 02_09 Commissions. When you open the challenge file, it should bring you right to the instructions tab, and the first step will always be to save the file as My Challenge. And the reason I ask you to do…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Enable macros3m 38s
-
Create simple macros and copy to another workbook7m 10s
-
Reference data in other workbooks7m 36s
-
Manage workbook versions6m 17s
-
Protect workbooks and worksheets7m 37s
-
Configure formula calculation options9m 52s
-
Manage comments5m 11s
-
Configure editing and display languages4m 58s
-
Challenge: Manage workbook options and settings2m 1s
-
Solution: Manage workbook options and setting9m 37s
-
-
-
-
-
-