LibreOffice Calc - Overview

Group 1 - Spreadsheet Basics

• Video 1 - A first Look
  Please, only download libreoffice from www.libreoffice.org. This video also 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
  borders, background color, center, currency, column align, column auto align, merge and center, delete cell vs. delete cell content
  

• Video 4 - Saving your Spreadsheets
  This video tutorial shows some ways to save 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

• Video 6 - Sally's Lemonade Stand - Arithmetic
  Calculates cost per cup, income and expenses and profit, Spreadsheet arithmetic (PEMDAS) explained here
  

• Video 7 - Sally's Lemonade - Fill Handle, Anchoring
  Fill Handle (drag lower right corner of the cell), Anchoring (copy a cell, but have pasted cell refer to same cell reference)
  - Download file(s) to accompany Video 7
  
  Click here to Download: ods07-SallysLemonadeStand.ods
  

• Video 8 - Sally's Lemonade - Define Name
  Give selling price a name instead of anchoring the cell (and how to remove name)
  

• Video 9 - Sally's Lemonade - 2 rows in 1 cell - Formatting
  Formatting 2 rows in 1 cell, 45 degree angle title (top or bottom).
  

Group 3 - Lists Part 1

• Video 10 - Format phone number - sort button
  This video tutorial will show how to format for a U.S. Phone Number and zip code.
  - Download file(s) to accompany Video 10
  
  Click here to Download: ods10a-StartOfVid-Unformatted.ods
  
  Click here to Download: ods10b-EndOfVid-Formatted-phone-zip.ods
  

• Video 11 - MultiColumn Sort / Random Order
  This video tutorial will show how to sort multiple using columns and how to sort in a random order
  - Download file(s) to accompany Video 11
  
  Click here to Download: ods11-Sort-Random-Order.ods
  

• Video 12 - Freeze, Filter, and Split
  This video tutorial will show how how to use Freeze, Filter, and Split
  

Group 4 - Lists Part 2

• Video 13 - Forms
  This video tutorial will show page break view, how to turn on off tool bars, and List Forms.
  

• Video 14 - Drop Down Box
  This video tutorial will show how to validate with a drop down down list
  

• Video 15 - Input Help / Validate Input
  This video tutorial will show how to display a cell input message and validate data into a cell
  

Group 5 - Lists Part 3

• Video 16 - Dates Function
  This video tutorial will show how the date function works.
  - Download file(s) to accompany Video 16
  
  Click here to Download: ods16-Date-Time-Function.ods
  

• Video 17 - Add a Birthdate
  This video tutorial will show how to create some random birthdays for our contact list.
  - Download file(s) to accompany Video 17
  
  Click here to Download: ods17-Add-Birthdays.ods
  

• Video 18 - Subtotals
  This video tutorial will show how subtotals work on a list of cells with numerical values (like Salaries)
  - Download file(s) to accompany Video 18
  
  Click here to Download: ods18-SubTotal.ods
  

• Video 19 - 1 column into 2 Back to 1
  This video tutorial will show how concatenate 2 columns into 1 column then separate them back into 2 columns
  - Download file(s) to accompany Video 19
  
  Click here to Download: ods19b-Make-2-colums-Into-1-column.ods
  
  Click here to Download: ods19a-Make-1-column-Into-2-columns.ods
  

Group 6 - Conditional

• Video 20 - CountIf CountBlank
  See how the CountIf and CountBlank functions work!
  - Download file(s) to accompany Video 20
  
  Click here to Download: ods20-CountIF.ods
  

• Video 21 - Conditional If And Or functions
  See the basics of "If" "And" and "or" functions as used in a spreadsheet program.
  - Download file(s) to accompany Video 21
  
  Click here to Download: ods21-Condtional-IFAndOrFunctions.ods
  

• Video 22 - Advanced Formatting
  An in depth view of the style and formatting as used by LibreOffice and OpenOffice
  - Download file(s) to accompany Video 22
  
  Click here to Download: ods22-AdvancedFormatting.ods
  

• Video 23 - Conditional Formatting
  An in depth view of the style and formatting as used by LibreOffice and OpenOffice
  
  Learn how to add conditional formatting to your spreadsheets.
  - Download file(s) to accompany Video 23
  
  Click here to Download: ods23-ConditionalFormatting.ods
  

Group 7 - Advanced Functions

• Video 24 - Weekday()
  What the Weekday Function is – And how to use it.
  - Download file(s) to accompany Video 24
  
  Click here to Download: ods24-Weekday.ods
  

• Video 25 - VLookup part 1
  VLookup() - Part 1
  - Download file(s) to accompany Video 25
  
  Click here to Download: ods25-VLookup-mode1.ods
  

• Video 26 - VLookup part 2
  Using VLookup with exact match (Mode 0) {Also revisits Drop-down box, and Range Names}
  - Download file(s) to accompany Video 26
  
  Click here to Download: ods26-VLookup-mode0.ods
  

Group 8 - Password Protecting Your Spreadsheets

• Video 27 - Password Protect and Read Only
  Password protect your spreadsheet file and give "Read Only" password protection to your spreadsheet files
  

• Video 28 - Protecting a Sheet in a Spreadsheet File
  Password protect a single sheet or tab in a spreadsheet file.
  

• Video 29 - Protect sheet Allow Calculations
  Password protect a single sheet, but allow users to update specific cells and see results to calculations.
  - Download file(s) to accompany Video 29
  
  Click here to Download: ods29a-TempConversion-ProtectSheet-NoSelect.ods
  
  Click here to Download: ods29b-TempConversion-ProtectSheet-SelectOK.ods
  

Group 9 - Working with Multiple Sheets

• Video 30 - Show/use cells from another worksheet tab
  View/use information on your worksheet created in a different worksheet tab.
  - Download file(s) to accompany Video 30
  
  Click here to Download: ods30-LinkToSheet2.ods
  

• Video 31 - Tab Colors - Create multiple Sheets (pt. 1)
  Change tab colors, tab names, add/remove sheets/tabs, create multiple identical sheets at the same time.
  

• Video 32 - Summarize multiple Sheets (pt. 2)
  This video will add a sheet using Move/Copy and finish the summary sheet started in Video 31.
  

• Video 33 - Add Hyperlink Index page
  The video will show you how to create an index page with hyperlinks to the tabs in that file ; and how to move/copy a sheet to another document.
  

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(s) to accompany Video 34
  
  Click here to Download: ods34-PieCharts.ods
  

• 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(s) to accompany Video 35
  
  Click here to Download: ods35-Chart-DataSeries.ods
  

• Video 36 - Charts Subgroup and rept()
  Create a chart with subgroups and create a bar graph without using the chart feature.
  - Download file(s) to accompany Video 36
  
  Click here to Download: ods36-SubgroupsAndRept.ods
  

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(s) to accompany Video 37
  
  Click here to Download: ods37-DataPilot.ods
  

• Video 38 - DataPilot - Part 2
  Summerize, Subtotal, and Filter large amounts of data using DataPilot Also Known As Pivot Tables – Part 2