CourseChapTopicID | CourseChapTopicName | |
131 | Managing the Worksheet Environment |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1452 | 131 | Navigate through a worksheet |
Learn
| | |
1453 | 131 | Print a worksheet or workbook |
Learn
| | |
1454 | 131 | Personalize environment by using Backstage |
Learn
| | |
|
132 | Creating Cell Data |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1455 | 132 | Construct cell data |
Learn
| | |
1456 | 132 | Apply AutoFill |
Learn
| | |
1457 | 132 | Apply and manipulate hyperlinks |
Learn
| | |
|
133 | Formatting Cells and Worksheets |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1458 | 133 | Apply and modify cell formats |
Learn
| | |
1459 | 133 | Merge or split cells |
Learn
| | |
1460 | 133 | Create row and column titles |
Learn
| | |
1461 | 133 | Hide and unhide rows and columns |
Learn
| | |
1462 | 133 | Manipulate Page Setup options for worksheets |
Learn
| | |
1463 | 133 | Create and apply cell styles |
Learn
| | |
|
134 | Managing Worksheets and Workbooks |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1464 | 134 | Create and format worksheets |
Learn
| | |
1465 | 134 | Manipulate window views |
Learn
| | |
1466 | 134 | Manipulate workbook views |
Learn
| | |
|
135 | Applying Formulas and Functions |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1467 | 135 | Create formulas |
Learn
| | |
1468 | 135 | Enforce precedence |
Learn
| | |
1469 | 135 | Apply cell references in formulas |
Learn
| | |
1470 | 135 | Apply conditional logic in a formula (<,>,=) |
Learn
| | |
1471 | 135 | Apply named ranges in formulas |
Learn
| | |
1472 | 135 | Apply cell ranges in formulas |
Learn
| | |
|
136 | Presenting Data Visually |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1473 | 136 | Create charts based on worksheet data |
Learn
| | |
1474 | 136 | Apply and manipulate illustrations |
Learn
| | |
1475 | 136 | Create and modify images by using the Image Editor |
Learn
| | |
1476 | 136 | Apply Sparklines |
Learn
| | |
|
137 | Sharing worksheet data with other users |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1477 | 137 | Share spreadsheets by using Backstage |
Learn
| | |
1478 | 137 | Manage comments |
Learn
| | |
|
138 | Analyzing and Organizing Data |
CourseChapTopicDetailsID | CourseChapTopicID | DetailTopicName | imgUrl | imgurl1 | iimgurl |
1479 | 138 | Filter data |
Learn
| | |
1480 | 138 | Sort data |
Learn
| | |
1481 | 138 | Apply conditional formatting |
Learn
| | |
|