From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Manage worksheets and workbooks
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Challenge: Manage worksheets and workbooks
(upbeat techno music) - [Instructor] Welcome to the chapter two challenge. For this challenge, you'll be using the 02_12 challenge exercise file. 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 that timeframe, go back and watch the videos for chapter two, and come try the challenge again. Now because this is your first challenge, let's take a look at the challenge file together. On the instructions page, you'll always have a few tasks to complete before you're asked to move on to the project worksheets. Each project worksheet will have additional tasks for you to complete, some will be completed on this worksheet, and some will reference other worksheets for you to complete tasks on. Once you've completed all of the tasks on all of the project worksheets, go back to your instructions and your final task will always be to save and close the workbook.
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
-
-
-
-
Import TXT or CSV data into a new workbook3m 22s
-
(Locked)
Import TXT or CSV data into an existing workbook3m 7s
-
(Locked)
Search for data within a workbook2m 36s
-
(Locked)
Navigate data with named ranges and hyperlinks5m 27s
-
(Locked)
Format worksheets and workbooks5m 1s
-
(Locked)
Customize headers and footers4m 37s
-
(Locked)
Display and modify content in different views5m
-
(Locked)
Modify basic workbook properties2m 33s
-
(Locked)
Customize the Quick Access Toolbar3m 55s
-
(Locked)
Inspect and export workbooks6m 33s
-
(Locked)
Configure print settings4m 15s
-
(Locked)
Challenge: Manage worksheets and workbooks1m 10s
-
(Locked)
Solution: Manage worksheets and workbooks9m 10s
-
-
-
-
-
-
-