From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Solution: Create and manage workbooks and worksheets
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Solution: Create and manage workbooks and worksheets
(chime) - [Instructor] Welcome to the solution video for the Chapter Two Challenge. For this challenge we used the 02_07 challenge file that you can find in your Chapter Two folder, and I challenged you to complete all of the tasks in 10 minutes or less. Let's go ahead and get started. Our first task is to save the file as My 02_07 Challenge. I'll do File, Save As. Goes right back to that Chapter Two folder. Just click in front of the document title and type My and a space and click save. Great. Next, we're going to insert a new worksheet named 2017 Customers and move it after the Project 2 worksheet. I'll click my New Sheet icon, double click on the tab, title it 2017 Customers, and I am going to click and drag and drop it on the other side of Project 2. Let's go back to instructions. Unhide the Web Sales worksheet. I'm just going to right-click on any of the worksheet tabs, go to Unhide, here is Web Sales. I'll just make sure it's highlighted, click Okay. That's done. Next, add the…
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
-
-
-
-
Create worksheets and workbooks7m 12s
-
Navigate in worksheets and workbooks6m 8s
-
Format worksheets and workbooks5m 46s
-
Configure page setup and headers/footers5m 23s
-
Customize options and views for worksheets and workbooks7m 3s
-
Configure worksheets and workbooks for distribution7m 10s
-
Challenge: Create and manage workbooks and worksheets1m 56s
-
Solution: Create and manage workbooks and worksheets8m 46s
-
-
-
-
-
-
-