LibreOffice: Calc - Homepage
If you find these tutorials useful, Please consider making a donation.

TheFrugalComputerGuy.png
TheFrugalComputerLogo.png

Libre Office Calc
Video Tutorial
HomePage












Group 1 - Spreadsheet Basics


  • Video 1 - A first Look
    Shows a place where you can download LibreOffice, describes the title bar, menu bar, what is a cell, what is the active cell, and how to move around the screen
  • Video 2 - Fictitious Company
    Basic functionality of a spreadsheet with an example of a how we would calculate profits and sum totals for a Fictitious Company, undo/redo, cut/paste - cut/paste shortcuts
  • Video 3 - Formatting the Ficitious Company Basic formatting, borders, background color, center, currency, column align, column auto align, merge and center, delete cell vs. delete cell content
  • Video 4 - Saving your Spreadsheets
    Saving files, save vs. save as, file types .ods .xlxs
  • Video 5 - Printing your spreadsheets
    Printing - Print sheet order, Portrait, Landscape, Gridlines, Preview, Headers, Footers, Header footer info: font, page, number, date, path



Group 2 - Lemonade Stand





Group 3 - Lists Part 1





Group 4 - Lists Part 2





Group 5 - Lists Part 3








Group 6 - Conditional





Group 7 - Advanced Functions








Group 8 - Password protecting your spreadsheets





Group 9 - Working with Multiple Sheets





Group 10 - LibreOffice Charts


  • Video 34 - Pie Chart
    Create a simple pie chart, add title, change the colors of the slices of pie, change font in the legend.
    - Download file to accompany Video 34 :
  • Video 35 - Charts Data Series
    How to chart restaurant meals sold, by store. Explain what the data series is and how to use it and create chart on a separate sheet.
    - Download file to accompany Video 35 :
  • Video 36 - Charts Subgroup and rept()
    Create a chart with subgroups and create a bar graph without using the chart feature.
    - Download file to accompany Video 36 :



Group 11 - DataPilot a.k.a. Pivot Tables


  • Video 37 - DataPilot - Part 1
    Summerize, Subtotal, and Filter large amounts of data using DataPilot Also Known As Pivot Tables – Part 1
    - Download file to accompany Video 37 :
  • Video 38 - DataPilot - Part 2
    Summerize, Subtotal, and Filter large amounts of data using DataPilot Also Known As Pivot Tables – Part 2