Skip to main content
E-Help
  • You are currently using guest access (Log in)

Spreadsheets - Excel / Open Office

  1. Home
  2. Courses
  3. SPREADSHEETS

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
Skip Navigation
Navigation
  • Home

    • Site pages

      • Tags

      • Calendar

    • Courses

      • SPREADSHEETS

        • Participants

        • Topic 1

Skip Workshop Files
Workshop Files
Link to the files needed for this workshop.

Data File to be downloaded to your computer for the workshop is: Data

Instruction Sheets for the workshop...download and open: Practise Worksheet
Skip ONLINE VIDEO CLIPS
ONLINE VIDEO CLIPS
  • Using "Paste Special"
  • Using Text to Columns
  • Tips on Filtering With "AutoFiltering"
  • About Conditional Formating
  • Basics of Protecting a Worksheet
  • Basics of Using Subtotals
  • Using the Subtotals Function
  • Basics of Print Setup Options
  • Formating Tricks
  • Grouping Tabs to Save Time
  • Formating Charts (Graphs)
  • Formatting Data Points
  • VLookup Formulas
  • Cell Information Functions
  • Text and String Functions
  • Using And(IF) and And(OR)
  • Using the Countif() to Find Duplicates
  • Setting Duplication Warning with Data Validation
  • Basics of Nested Formulas
  • Conditional Formating with 4 Conditions


You are currently using guest access (Log in)
Home
Data retention summary