From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep
Unlock the full course today
Join today to access over 25,200 courses taught by industry experts.
Challenge: Manage workbook options and settings - Microsoft Excel Tutorial
From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep
Challenge: Manage workbook options and settings
- [Presenter] Welcome to the chapter two challenge. For your first challenge, you'll be using two files, the 02_06 Challenge Workbook and the 02_06 Commission's Workbook. You should be able to complete all the tasks in 10 minutes or less. Since this is your first challenge, let's take a look at where to find those files. I'm in Excel. I have stored my exercise files on the desktop. Here's the chapter two folder and if you scroll down, you'll see the Commission's Workbook and the Challenge Workbook. You will also find a solution file and one called "My Challenge". These two are exactly the same and this will allow you to compare your final document with my final document. You can also watch my solution video to see how I completed each of the tasks. Now, if you find you're having trouble completing all the tasks in under 10 minutes, watch the videos for chapter two and come back and try the challenge…
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
-
-
-
-
Manage macros6m 43s
-
(Locked)
Reference data in other workbooks7m 15s
-
(Locked)
Manage workbook versions5m 12s
-
(Locked)
Protect workbooks and worksheets7m 20s
-
(Locked)
Configure formula calculation options3m 22s
-
(Locked)
Challenge: Manage workbook options and settings1m 7s
-
(Locked)
Solution: Manage workbook options and settings7m 37s
-
-
-
-
-