Table of Contents

PC151-2016 - Intermediate Spreadsheets-1

Numeral | Section | Type | Sample |

1 | Introduction | Lesson | - |

2 | Filling Cells | Lesson | - |

3 | Ex-Filling Cells | Exercise | - |

4 | Moving & Copying Data Efficiently | Lesson | - |

5 | Ex-Moving & Copying Data Efficiently | Exercise | - |

6 | Inserting & Deleting Cells | Lesson | - |

7 | Ex-Inserting & Deleting Cells | Exercise | - |

8 | Inserting & Deleting Rows & Columns | Lesson | Sample |

9 | Ex-Inserting & Deleting Rows & Columns | Exercise | Sample |

10 | Data Fitting Errors | Lesson | - |

11 | Spelling Check | Lesson | - |

12 | Ex-Spelling Check | Exercise | - |

13 | Find & Replace | Lesson | - |

14 | Ex-Find & Replace | Exercise | - |

15 | Quiz 1 | Quiz | - |

16 | Formulas Containing Multiple Operators | Lesson | - |

17 | Ex-Formulas Containing Multiple Operators | Exercise | - |

18 | Commonly Used Functions | Lesson | - |

19 | Ex-Commonly Used Functions | Exercise | - |

20 | Inserting Functions in Formulas | Lesson | - |

21 | Ex-Inserting Functions in Formulas | Exercise | - |

22 | Modifying Formulas & Functions | Lesson | - |

23 | Ex-Modifying Formulas & Functions | Exercise | - |

24 | Copying Formulas & Functions | Lesson | - |

25 | Ex-Copying Formulas & Functions | Exercise | - |

26 | Formula & Function Errors | Lesson | - |

27 | Ex-Formula & Function Errors | Exercise | - |

28 | Organizing Worksheets | Lesson | - |

29 | Ex-Organizing Worksheets | Exercise | - |

30 | Templates | Lesson | - |

31 | Ex-Templates | Exercise | - |

32 | Time Saving Tips | Lesson | - |

33 | Ex-Time Saving Tips | Exercise | - |

34 | RS-Save Formats | Reading Supplement | - |

35 | Ex-Save Formats | Exercise | - |

36 | Quiz 2 | Quiz | - |

37 | End | Lesson | - |