In this episode I show you how to take a dull report, and make it more visually appealing by adding color. Color helps us take a complicated subject, and make it easy to understand at a glace. The tools that LibreOffice provides are very powerful and allow you a great deal of flexibility when formatting your reports. Used in conjunction with clipart, the techniques you learn in this episode will help you take your reports to the next level.

LibreOffice is a fork of the OpenOffice.org project, and is available for all major platforms including Mac OS X, Windows, and Linux. Like its predecessor, OpenOffice.org, LibreOffice is an open source office suite that emphasizes open document formats but is compatible with Microsoft Office. LibreOffice has received tremendous support from the community, and has seen widespread adoption by users of OpenOffice.org.

It becomes increasingly important to efficiently select the cells you are working with, in an OpenOffice.org Spreadsheet, as your spreadsheet gets bigger and bigger. Those of you who have worked with files that are thousands of rows long know what I mean. Learning a few simple keyboard shortcuts, will make your productivity increase tremendously! In this episode, we cover a few of the most useful shortcuts for selecting cells in an OpenOffice.org spreadsheet. Once you have the cells you want selected, you can use your selection to apply formatting to make your spreadsheet look nice, or use the values of your selection in calculating formulas.

Often when creating documents you will want to repeat a piece of text on each page you print out. Sometimes this means printing the title of the document on the top of each page, including the date a document was created on the bottom of each page, or printing the page number on each page individually so that they do not get accidentally placed out of order. OpenOffice.org makes creating such headers or footers a breeze. With a few simple clicks you will be able to include titles, dates, page numbers, or any other information in the headers or footers of all your documents.

Often you will find yourself in situations where you either need to open a Microsoft Office document that someone else has sent you, or save an OpenOffice.org document in a Microsoft Office compatible format so that someone else can open it. One of the most useful features of OpenOffice.org is that it is very compatible with Microsoft Office. It can be used to both open Microsoft Office documents, such as Word documents or Excel documents, and save documents in other formats as Microsoft Office documents.

In this episode of ilearnthings.com we continue to explore OpenOffice.org, by examening different ways of entering data into a spreadsheet.

In this video, the first of a series of episodes which will introduce you to OpenOffice.org, you will learn how to obtain and install OpenOffice.org which is a free alternative to Microsoft Office. OpenOffice.org comes with a number of programs that are analogous to the Microsoft Office programs.