Excel Level 1 | |||

Getting Started | Time | ||

Excel-Intro To the Desktop | This video introduces you to the technical terms of the Excel Desktop. | 7:12 | |

Creating a Workbook | How to enter information into an Excel spreadsheet. | 4:30 | |

Entering Data | How to add data into a spreadsheet, using autocomplete, pick from drop down list or duplicating an entry. | 4:23 | |

Opening a File | How to open an existing file through the Excel interface. | 2:19 | |

Editing a Workbook | Time | ||

Editing Content | How to edit cell content in a spreadsheet. | 1:58 | |

Saving a File | Saving a file, saving a file with another name or location, or saving as a different file type. | 4:50 | |

Using the Microsoft Clipboard | Using the clipboard to copy information from one document to another between Microsoft applications. | 4:16 | |

Formulas | Time | ||

Basic Formuals | How to use basic formulas in a spreadsheet. Add, Subtract, multiple, Divide. | 7:19 | |

Order of Precedence | How Excel calculates a formula. | 4:29 | |

Functions | Time | ||

AutoSum | Using the AutoSum feature to Add up a column or row of numbers. | 3:08 | |

Average | Calculate the Average for a group of numbers. | 1:56 | |

Max & Min | How to find the highest or lowest number in a group. | 2:20 | |

Auto Fill (Copying Formulas) | How to use auto fill to copy a formula to another cell or group of cells. | 4:15 | |

Moving a Formula | How Excel handles moving a cell with a formula or the cells in the formula. | 4:00 | |

Absolute Formulas | Time | ||

Absolute Formula Part I | How to copy a cell where a cell reference can not change. | 3:41 | |

Absolute Formula Part 2 | How to copy a cell where a row or column reference can not change. | 5:14 | |

Formatting | Time | ||

Formatting Text in a spreadsheet | How to format text in a spreadsheet, Align, Center Across Selection, and Indent. | 4:30 | |

AutoFill | How to use Auto Fill to create a series of numbers, create a list. | 4:15 | |

Formatting | How to format cells, numbers. | 5:15 | |

Printing | Time | ||

Basic Printing | How to print a basic worksheet. | 3:59 | |

Printing Large Documents | How to print a large Documents. | 2:45 | |

Print Titles | How to add column or row titles to each page. | 3:07 | |

Printing Headers and Footers | How to print headers and footers on pages. | 4:07 | |

Basic Charts | Time | ||

Pie Chart (Basic) | How to create a basic pie chart | 4:09 | |

Column Chart (Basics) | How to create a basic column chart | 4:04 | |

Formatting | Time | ||

Hiding Colums, Rows & Tabs | How to hide columns, rows or Tabs. | 2:32 | |

Paste Special | How to paste numbers from one area and add them to existing numbers. | 3:19 | |

... |

126 Lakedale Drive, Lawrenceville, NJ 08648 USA - 1 609 695 1125

© 2012 - 2017 Princeton Design Collaborative