Numeral |
Section |
Type |
Sample |
B |
Introduction |
Lesson |
- |
B1 |
Unit 1 |
Lesson |
- |
B1.1 |
Spreadsheets Overview |
Lesson |
- |
B1.2 |
Getting Started |
Lesson |
- |
B1.3 |
Ribbon |
Lesson |
- |
B1.4 |
Entering Data |
Lesson |
- |
B1.5 |
Ex-Entering Data |
Exercise |
- |
B1.6 |
Editing Data |
Lesson |
- |
B1.7 |
Ex-Editing Data |
Exercise |
- |
B1.8 |
Formulas |
Lesson |
- |
B1.9 |
Ex-Formulas |
Exercise |
- |
B1.10 |
Functions |
Lesson |
- |
B1.11 |
Ex-Functions |
Exercise |
- |
B1.12 |
Saving Workbooks |
Lesson |
- |
B1.13 |
Ex-Saving Workbooks |
Exercise |
- |
B1.14 |
Creating a New Workbook |
Lesson |
- |
B1.15 |
Ex-Creating a New Workbook |
Exercise |
- |
B1.16 |
Opening Workbooks |
Lesson |
- |
B1.17 |
Ex-Opening Workbooks |
Exercise |
- |
B1.18 |
Quiz 1-1 |
Quiz |
- |
B1.19 |
Fonts |
Lesson |
- |
B1.20 |
Ex-Fonts |
Exercise |
- |
B1.21 |
Alignment |
Lesson |
- |
B1.22 |
Ex-Alignment |
Exercise |
- |
B1.23 |
Number Formats |
Lesson |
Sample |
B1.24 |
Ex-Number Formats |
Exercise |
Sample |
B1.25 |
Format Painter |
Lesson |
- |
B1.26 |
Ex-Format Painter |
Exercise |
- |
B1.27 |
Resizing Rows & Columns |
Lesson |
- |
B1.28 |
Ex-Resizing Rows & Columns |
Exercise |
- |
B1.29 |
Printing |
Lesson |
- |
B1.30 |
Ex-Printing |
Exercise |
- |
B1.31 |
Office Clipboard |
Lesson |
- |
B1.32 |
Ex-Office Clipboard |
Exercise |
- |
B1.33 |
Quiz 1-2 |
Quiz |
- |
B1.34 |
Unit 1 End |
Lesson |
- |
B2 |
Unit 2 |
Lesson |
- |
B2.1 |
Filling Cells |
Lesson |
- |
B2.2 |
Ex-Filling Cells |
Exercise |
- |
B2.3 |
Moving & Copying Data Efficiently |
Lesson |
- |
B2.4 |
Ex-Moving & Copying Data Efficiently |
Exercise |
- |
B2.5 |
Inserting & Deleting Cells |
Lesson |
- |
B2.6 |
Ex-Inserting & Deleting Cells |
Exercise |
- |
B2.7 |
Inserting & Deleting Rows & Columns |
Lesson |
- |
B2.8 |
Ex-Inserting & Deleting Rows & Columns |
Exercise |
- |
B2.9 |
Data Fitting Errors |
Lesson |
- |
B2.10 |
Spelling Check |
Lesson |
- |
B2.11 |
Ex-Spelling Check |
Exercise |
- |
B2.12 |
Find & Replace |
Lesson |
- |
B2.13 |
Ex-Find & Replace |
Exercise |
- |
B2.14 |
Quiz 2-1 |
Quiz |
- |
B2.15 |
Formulas Containing Multiple Operators |
Lesson |
- |
B2.16 |
Ex-Formulas Containing Multiple Operators |
Exercise |
- |
B2.17 |
Commonly Used Functions |
Lesson |
- |
B2.18 |
Ex-Commonly Used Functions |
Exercise |
- |
B2.19 |
Inserting Functions in Formulas |
Lesson |
- |
B2.20 |
Ex-Inserting Functions in Formulas |
Exercise |
- |
B2.21 |
Modifying Formulas & Functions |
Lesson |
- |
B2.22 |
Ex-Modifying Formulas & Functions |
Exercise |
- |
B2.23 |
Copying Formulas & Functions |
Lesson |
- |
B2.24 |
Ex-Copying Formulas & Functions |
Exercise |
- |
B2.25 |
Formula & Function Errors |
Lesson |
- |
B2.26 |
Ex-Formula & Function Errors |
Exercise |
- |
B2.27 |
Organizing Worksheets |
Lesson |
- |
B2.28 |
Ex-Organizing Worksheets |
Exercise |
- |
B2.29 |
RS-Copying Cells to Other Worksheets |
Reading Supplement |
- |
B2.30 |
Ex-Copying Cells to Other Worksheets |
Exercise |
- |
B2.31 |
Templates |
Lesson |
- |
B2.32 |
Ex-Templates |
Exercise |
- |
B2.33 |
Time Saving Tips |
Lesson |
- |
B2.34 |
Ex-Time Saving Tips |
Exercise |
- |
B2.35 |
RS-Save Formats |
Reading Supplement |
- |
B2.36 |
Ex-Save Formats |
Exercise |
- |
B2.37 |
RS-Protecting Workbooks |
Reading Supplement |
- |
B2.38 |
Ex-Protecting Workbooks |
Exercise |
- |
B2.39 |
Quiz 2-2 |
Quiz |
- |
B2.40 |
Unit 2 End |
Lesson |
- |
B3 |
Unit 3 |
Lesson |
- |
B3.1 |
Wrapping Text in a Cell |
Lesson |
- |
B3.2 |
Ex-Wrapping Text in a Cell |
Exercise |
- |
B3.3 |
Changing the Orientation of Data |
Lesson |
- |
B3.4 |
Ex-Changing the Orientation of Data |
Exercise |
- |
B3.5 |
Cell Borders |
Lesson |
- |
B3.6 |
Ex-Cell Borders |
Exercise |
- |
B3.7 |
Cell Shading |
Lesson |
- |
B3.8 |
Ex-Cell Shading |
Exercise |
- |
B3.9 |
Styles |
Lesson |
- |
B3.10 |
Ex-Styles |
Exercise |
- |
B3.11 |
RS-Formatting Cells as a Table |
Reading Supplement |
- |
B3.12 |
Ex-Formatting Cells as a Table |
Exercise |
- |
B3.13 |
Inserting Pictures |
Lesson |
- |
B3.14 |
Ex-Inserting pictures |
Exercise |
- |
B3.15 |
Ex-Resizing Pictures |
Exercise |
- |
B3.16 |
Adding Drawings |
Lesson |
- |
B3.17 |
Ex-Adding Drawings |
Exercise |
- |
B3.18 |
Modifying Drawings |
Lesson |
- |
B3.19 |
Ex-Modifying Drawings |
Exercise |
- |
B3.20 |
Quiz 3-1 |
Quiz |
- |
B3.21 |
Sorting Data |
Lesson |
- |
B3.22 |
Ex-Sorting Data |
Exercise |
- |
B3.23 |
Filtering Data |
Lesson |
- |
B3.24 |
Ex-Filtering Data |
Exercise |
- |
B3.25 |
Hiding Rows & Columns |
Lesson |
- |
B3.26 |
Ex-Hiding Rows & Columns |
Exercise |
- |
B3.27 |
Page Breaks |
Lesson |
- |
B3.28 |
Ex-Page Breaks |
Exercise |
- |
B3.29 |
Header & Footer |
Lesson |
- |
B3.30 |
Ex-Header & Footer |
Exercise |
- |
B3.31 |
Print Area |
Lesson |
- |
B3.32 |
Ex-Print Area |
Exercise |
- |
B3.33 |
Print Scaling |
Lesson |
- |
B3.34 |
Ex-Print Scaling |
Exercise |
- |
B3.35 |
Printing Titles & Gridlines |
Lesson |
- |
B3.36 |
Ex-Printing Titles & Gridlines |
Exercise |
- |
B3.37 |
Creating Charts |
Lesson |
- |
B3.38 |
Ex-Creating Charts |
Exercise |
- |
B3.39 |
Modifying Charts-1 |
Lesson |
- |
B3.40 |
Modifying Charts-2 |
Lesson |
- |
B3.41 |
Ex-Modifying Charts |
Exercise |
- |
B3.42 |
RS-Adding Chart Data Labels |
Reading Supplement |
- |
B3.43 |
Ex-Adding Chart Data Labels |
Exercise |
- |
B3.44 |
Interpreting Data & Charts |
Lesson |
- |
B3.45 |
RS-Guidelines for Creating Spreadsheets |
Reading Supplement |
- |
B3.46 |
Quiz 3-2 |
Quiz |
- |
B3.47 |
Unit 3 End |
Lesson |
- |