Domain 1 Lesson 1: Introduction

(Introduction lesson...no skills to be learned)
​

Domain 1 Lesson 2: Import Data & Navigate Workbooks

1 Importing from a Text File

Open the 111-instructors.txt file from the GMetrixTemplates folder. Indicate that the data has headers. Tabs are the delimiters.

1. Click the File tab
2. Ensure the Open tab is selected
3. Browse to the GMetrixTemplates folder
4. Click the File type drop-down arrow
5. Click All Files
6. Click the 111-instructors.txt file
7. Click the Open button
8. Ensure that the My data has headers check box is selected
9. Click the Next button
10. Ensure that the Tab check box is the only delimiter check box selected
11. Click the Next button
12. Click the Finish button

2 Importing from a .csv File

Import the 112-class schedule.csv file from the GMetrixTemplates folder as a table to the current worksheet.

1. Click the Data tab
2. In the Get & Transform Data group, click From Text/CSV
3. Browse to the GMetrixTemplates folder
4. Click the 112-class schedule.csv file
5. Click the Import button
6. In the preview window, click the Load dropdown and select Load To...
7. Ensure that Table is selected under Select how you want to view this data in your workbook.
8. Under Where do you want to put the data?, select Existing worksheet
9. Click OK

3 Search for Data

Find all instances of the word, Yoga, on the class schedule worksheet. Then, change the first instance of the word, Yoga, to Hot Yoga.

1. In the Home tab, Editing group, click the Find & Select drop-down arrow
2. Click Find
3. Type: yoga
4. Click the Find All button
5. Click the first instance of the word, Yoga (it will take you to cell A3)
6. Change the contents of cell A3 to the words, Hot Yoga
7. Press the Enter key

4 Workbook Navigation

​Navigate to the Instructor4 named range. Then, change the contents of the cell to Charles.

1. In the Home tab, Editing group, click the Find & Select drop-down arrow
2. Click Go To
3. Click Instructor4
4. Click the OK button
5. Click into cell A5
6. Change the instructor name in cell A5 to Charles
7. Press the Enter key​​

Domain 1 Lesson 3: Format Worksheets & Workbook

5 Page Setup

For this worksheet, set the page margins to wide and the orientation to landscape.

1. Click the Page Layout tab
2. In the Page Setup group, click the Margins drop-down arrow
3. Click Wide
4. In the Page Setup group, click the Orientation drop-down arrow
5. Click Landscape

6 Row Height and Column Width

On the current worksheet, set the row height for row 2 to 30 and the width of columns F and G to 12.

1. Click the number 2 in the rows to select the entire row
2. Click the Home tab (if necessary)
3. In the Cells group, click the Format drop-down arrow
4. In the Cell Size section, click Row Height
5. Type: 30
6. Click the OK button
7. Click and drag over the letters F and G to select columns F and G
8. In the Cells group, click the Format drop-down arrow
9. In the Cell Size section, click Column Width
10. Type: 12
11. Click the OK button

7 Headers and Footers

​Add the file name as a header to the current worksheet. Then, add the current date to the left side of the footer.

1. Click the Page Layout tab
2. Click the Page Setup dialog box launcher
3. Click the Header/Footer tab
4. Click the Header drop-down arrow
5. Click the file name (133-classes by month.xlsx)
6. Click the Custom Footer button
7. Ensure the cursor is in the Left section
8. Click the Date icon
9. Click the OK button twice

Domain 1 Lesson 4: Customize Options & Views

8 Quick Access Toolbar
Add the Fill Color icon to the Quick Access Toolbar.

1. In the Home tab, Font group, right-click the Fill Color button
2. Click Add to Quick Access Toolbar

9 Workbook Views
View the current worksheet in Page Layout view. While in Page Layout view, add the sheet name to the right-side header.

1. Click the View tab
2. In the Workbook Views group, click the Page Layout button
3. Click in the right side of the header
4. Click the Design tab under Header & Footer Tools (if necessary)
5. In the Header & Footer Elements group, click the Sheet Name button
6. Click anywhere on the worksheet

10 Freezing Panes
Freeze the top two rows of the current worksheet.

1. Select row 3
2. Click the View tab
3. In the Window group, click the Freeze Panes drop-down arrow
4. Click Freeze Panes

11 Window Views
Split the worksheet into two sections between rows 11 and 12.

1. Select row 12
2. Click the View tab
3. In the Window group, click Split

12 Workbook Properties
Add "fitness; classes; location" as tags to the current workbook. Then, add Uptown Athletic Club as the company for this workbook.

1. Click the File tab
2. Click Add a tag
3. Type: fitness; classes; location
4. Click Show All Properties
5. Click Specify the company
6. Type: Uptown Athletic Club
7. Press the Enter key

13 Display Formulas
​Display all of the formulas on the current worksheet.

1. Click the Formulas tab
2. In the Formula Auditing group, click Show Formulas

Domain 1 Lesson 5: Configure Content For Collaboration

14 Set a Print Area
Set the cells A1 through M17 to be the print area for this worksheet.

1. Select cells A1 through M17
2. Click the Page Layout tab
3. In the Page Setup group, click the Print Area drop-down arrow
4. Click Set Print Area

15 Save in Alternative File Formats
Save the current file as a PDF to the GMetrixTemplates folder. Accept the default options for the file name and settings.

1. Click the File tab
2. Click Save As
3. Click Browse
4. If necessary, navigate to the GMetrixTemplates folder
5. Click the Save as type drop-down arrow
6. Click PDF
7. Click the Save button

16 Print Settings
Set the current worksheet to repeat the top two rows and the first column to repeat on every page when the worksheet is being printed.

1. Click the Page Layout tab
2. In the Page Setup group, click Print Titles
3. Click in the Rows to repeat at top field
4. In the worksheet select rows 1 and 2
5. Click in the Columns to repeat at left field
6. In the worksheet select column A
7. Click the OK button

17 Inspect Workbooks
​Perform an accessibility check on the current workbook. Rename the first warning instance to January and the second to Forecasting.

1. Click the File tab
2. Click the Check for Issues drop-down button
3. Click Check Accessibility
4. In the Accessibility Checker panel expand the Default Sheet Names warning
5. Select Sheet1 and then the Sheet1 dropdown
6. Under Recommended Actions select Rename Sheet
7. Type: January
8. Press the Enter key
9. Back in the Accessibility Checker panel select Sheet2 and then the Sheet2 dropdown
10. Under Recommended Actions select Rename Sheet
11. Type: Forecasting
12. Press the Enter key