Spreadsheets - Excel / Open Office

Topic outline

• Topic 1
  

  Topic 1

  • Introduction Topics
  • Introduction to the Main Screens File
  • Icons explained - Standard Icons File
  • Icons explained - Formating Icons File
  • Working with Cells
  • Selecting Cells File
  • Finding and Replacing File
  • Freezing Titles File
  • Sorting Columns File
  • Inserting Columns and Rows File
  • Hiding Columns and Rows File
  • Naming Ranges File
  • Cut Copy Paste and Move Information File
  • Editing and Deleting Cell Contents File
  • Formating Cells
  • Basic Formating File
  • Applying Colours File
  • Applying Borders File
  • Alignment Formating File
  • Resizing Columns and Rows File
  • Formulas and Functions
  • Working with Formulas and Functions File
  • Advanced Functions and Formulas File
  • Changing a Formula Result to a Value File
  • Absolute References File
  • Charts and Graphs
  • Creating Charts and Graphs in Excel File
  • Creating Charts and Graphs in Open Office CALC File
  • Other Instructions
  • Linking a Spreadsheet to a Document File
  • Printing Spreadsheets File
  • Opening a Text File - CSV
  • Saving in CSV text Format File
  • Mail Merge URL