In-Depth Series: LibreOffice
- Number of episodes: 72
- Open/closed: open
- Date of earliest show: 2012-09-12
- Date of latest show: 2020-08-19
- Series RSS feeds: ogg, spx, mp3
hpr3143 :: LibreOffice 7.0 Released! hosted by Ahuka
LibreOffice releases a new major update, LibreOffice 7.0
I try to explain how to use the COUNTIF function in LibreOffice to generate reports
Impress tables and how to format them
Creating charts from inside Impress
Using Calc modules and data in a presentation
Using Audio and Video files in Impress
Text formatting options are explored
The use of Text Boxes from the Drawing Toolbar is explored
LibreOffice Impress Slide Layouts and components are explored
LibreOffice Clip Art Gallery and Theme collections
Using and formatting pictures, and creating a photo album
Creating a sample template illustrates these concepts
A workaround to create horizontal ordered lists in LibreOffice and run LO headless to convert files
Drawing Object Styles and their use in LibreOffice Impress
Presentation Styles and their use in LibreOffice Impress
Using and acquiring Templates in Impress
The mechanics of creating a presentation in Impress
Learning to start with the content and not the eye candy.
Introduction to the Impress application screen layout.
Introduction to making Presentations, with some good advice.
hpr1735 :: Free tutorials for teachers hosted by Ahuka
Professor Bernard Poole makes free tutorials available aimed at teachers
We create Template (recording Billable Time) using Styles to illustrate the usage.
How to use Cell Styles to control the appearance of your cells.
How to control the overall appearance of a worksheet using Page Styles and Page Settings.
Ubderstanding the Object Model and how Templates work.
How the concepts of Styles and Templates can be useful in Spreadsheets
When you have a pivot table, what are some of the things you can do with it to analyze your data?
How to create a Pivot Table
hpr1645 :: 42 - LibreOffice Calc - Data Manipulation 2: Standard and Advanced Filters hosted by Ahuka
A look at the more advanced filtering options for manipulating data in Calc.
A look at the most simple ways of manipulating data in Calc.
A quick look at some miscellaneous functions in Calc.
Inferential statistics is how we draw conclusions from data and make predictions.
Descriptive statistics is how we make basic measurements about a population
A look at financial functions and constructing a mortgage repayment schedule
Financial Functions in LibreOffice Calc
Introduction to working with functions in LibreOffice Calc
Editing charts, Calc
Creating Charts with LibreOffice Calc
LibreOffice, Calc, Spreadsheet, chart, graph
Editing and navigating sheets, rows and columns in LibreOffice Calc
LibreOffice, Calc, Spreadsheet, models, what-if analysis, savings
This episode looks at building models and doing "What-If?" Analysis.
This episode looks at the filling rows and columns using click-and-drag.
This episode looks at the creating and using formulas in spreadsheets.
hpr1485 :: 26 - LibreOffice Calc Cells hosted by Ahuka
This episode looks at the fundamental unit of a spreadsheet, the cell, and introduces addressing and
The origins and history of the spreadsheet
This concludes our look at page layout by showing these techniques at use in creating a Tri-fold bro
This continues our look at page layout by looking at ways to do this other than by using frames.
This continues our look at frames by looking at frame styles for things other than text.
The second of two programs about Frame properties in LibreOffice Writer
This episode introduces the discussion of Frames in LibreOffice Writer
Using page styles in LibreOffice Writer
An introduction to page styles in LibreOffice Writer
Controlling page layout in LibreOffice Writer
Controlling nested lists with styles in LibreOffice Writer
Introducing nested lists in LibreOffice Writer
How to define a numbered list style in LibreOffice Writer
How to define a bullet list style in LibreOffice Writer
Introducing list styles in LibreOffice Writer
Character styles in LibreOffice Writer
Using paragraph styles in templates in LibreOffice Writer
Details of paragraph-level styles in LibreOffice Writer
Tab styles in LibreOffice Writer
Heading styles in LibreOffice Writer
Creating a Paragraph Style in LibreOffice
Style properties in LibreOffice Writer, part 2
Style properties in LibreOffice Writer, part 1
Using styles to control the appearance of documents in LibreOffice Writer
The default template in LibreOffice Writer
Introduction to Office Software
A continuation of the topic of presentation versus content
An introduction to the concept of presentation versus content