Table of Contents

PCIC3B2-GS5-2016 - Key Applications-Excel

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 | - |