In this video, learn how to solve the challenge.
(upbeat music) … - [Instructor] Welcome to the solution video … for the Chapter 2 Challenge. … For this challenge, we use the 02_12 challenge exercise file … and I challenged you to complete … all the tasks in 10 minutes or less. … Let's jump right in. … First, we'll save the file … in the Chapter 2 folder as My Challenge. … File, Save As, we'll go to the Desktop … where my files are saved and rename it My Challenge. … Number two, insert a new worksheet named 2019 Customers … and move it after the Project 2 worksheet. … We'll click here to insert a new sheet, … double click, type 2019 Customers … and we are going to move it after the Project 2 worksheet. … I'll click on the tab, hold my mouse down, … and drag and drop it after Project 2. … Next, we'll unhide the New Customers worksheet … and move it before the Disclaimer worksheet. … Right click on any of the tabs … and go to Unhide, New Customers, and then OK. … And let's hop it right over Disclaimer, … let's go back to instructions. …
Author
Jennifer McBee
Released
7/1/2019- Importing data
- Formatting worksheets and workbooks
- Exporting workbooks
- Pasting data
- Modifying columns, rows, and cells
- Formatting cells
- Conditional formatting
- Creating tables
- Filtering and sorting table data
- Using references
- Performing calculations with functions
- Formatting text with functions
- Creating charts
- Taking the practice exam
Skill Level Intermediate
Duration
Views
-
Introduction
-
Who should take this course?1m 15s
-
1. Microsoft Office Specialist Exam Overview
-
2. Manage Worksheets and Workbooks
-
Inspect and export workbooks6m 33s
-
Configure print settings4m 15s
-
3. Manage Data Cells and Ranges
-
Format cells and ranges5m 39s
-
Insert sparklines5m 35s
-
4. Manage Tables and Table Data
-
Create and format tables3m 23s
-
Modify tables4m 19s
-
-
5. Perform Operations Using Formulas and Functions
-
6. Manage Charts
-
Create charts3m 40s
-
Modify charts2m 45s
-
Format charts3m 4s
-
Solution: Manage charts4m 31s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps22s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Solution: Manage worksheets and workbooks