OpenOffice.org is an
incredible collection of applications, such as a
word processor, spreadsheet, presentation, database
and so on. OpenOffice is free,
and so is OpenOfficeSchool!
You can "attend" our "classes" at any time, you don’t send us any papers, you don’t have to register and you don‘t pay for anything as a "student"!
How about businesses, how much do they have to pay to follow our classes? Nothing. Nada. Zero.
You can find all the lessons here, which, for now, cover the spreadsheet Calc.
But how about Microsoft Office users? If you are a Microsoft Office user, then you´re in luck, because just about every lessons here at OpenOfficeSchool will also apply to Microsoft Office! This is because the principles are the same, and the user interface are very, very similar.
We’ve made a forum for OpenOfficeSchool.org, that we hope you will find useful! We encourage everybody to contribute, either with questions, answers or tips!
I have to admit that we’ve been quite busy trying to cope with questions that we receive, and hope this forum will be able to lighten the work load a bit. But still; feel free to send questions.
Regards,
Roar Malmin
Editor
You can "attend" our "classes" at any time, you don’t send us any papers, you don’t have to register and you don‘t pay for anything as a "student"!
How about businesses, how much do they have to pay to follow our classes? Nothing. Nada. Zero.
You can find all the lessons here, which, for now, cover the spreadsheet Calc.
But how about Microsoft Office users? If you are a Microsoft Office user, then you´re in luck, because just about every lessons here at OpenOfficeSchool will also apply to Microsoft Office! This is because the principles are the same, and the user interface are very, very similar.
We’ve made a forum for OpenOfficeSchool.org, that we hope you will find useful! We encourage everybody to contribute, either with questions, answers or tips!
I have to admit that we’ve been quite busy trying to cope with questions that we receive, and hope this forum will be able to lighten the work load a bit. But still; feel free to send questions.
Regards,
Roar Malmin
Editor
Latest update:
7th of May 2008
Please check the Blogg for more
news or for searching on topics!
Added a lesson on how to create and modify DataPilot -- recommended!
04/05/08 22:13 Filed in: Calc
Just added a lesson on DataPilot
that shows how to master large amounts of
data with DataPilot. This is one of the
really, really big strengths of Calc, and
is highly recommended reading!
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
|
Added a lesson on formatting of text and cells
20/03/08 20:35 Filed in: Calc
Just added a lesson on
formatting that shows how easy it is
to change the appearance of a spreadsheet
in no-time. Sometimes changing the look of
a sheet can enhance how the information is
received by the end user, either it is
yourself or, perhaps even more
importantly, others.
This is just a quick dip into the water, but it covers the most used features.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
This is just a quick dip into the water, but it covers the most used features.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Added a lesson with =LEN() -- how to count the number of characters in a cell or string
13/03/08 13:27 Filed in: Calc
Just added a lesson with =LEN()
which can be used for counting the number
of characters in a cell or text string. On
its own it obviously doesn’t do very
much, but with combined with other
formulas new opportunities are uncovered.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Transition of lessons to one common format is completed
27/02/08 23:12 Filed in: Calc
| OpenOfficeSchool
The transition to one, single format for all
lessons has now been completed, and I hope it
will benefit us all. It has taken some time,
but now it’s done 
I will start focusing on new lessons for Calc, and on improving the lessons in other ways, but more on that at a later stage...
Regards,
Roar Malmin
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
I will start focusing on new lessons for Calc, and on improving the lessons in other ways, but more on that at a later stage...
Regards,
Roar Malmin
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Changes in lessons already made
24/02/08 20:54 Filed in: Calc
| OpenOfficeSchool
We are now in the process of changing some of
the lessons from one format to another.
There are two reasons for this; the first is that we have now gone through the different formats, and came to the conclusion that the format used in lessons like =SUM() and =NOW() (and most other by now) is the most effective one, both for learning and for producing. The second reason is that Microsoft’s Internet Explorer 6 and older are very non-compliant, and messes up the other formats, in varying degrees.
As soon as all lessons have been changed to the chosen format, we will start making new lessons again.
The two formats that will be removed, are the ones where you click to get to the next step. Both of them has the advantage that they provide as little information as possible for each step, which is possibly less confusing, but I truly believe the chosen format will fully usable.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
There are two reasons for this; the first is that we have now gone through the different formats, and came to the conclusion that the format used in lessons like =SUM() and =NOW() (and most other by now) is the most effective one, both for learning and for producing. The second reason is that Microsoft’s Internet Explorer 6 and older are very non-compliant, and messes up the other formats, in varying degrees.
As soon as all lessons have been changed to the chosen format, we will start making new lessons again.
The two formats that will be removed, are the ones where you click to get to the next step. Both of them has the advantage that they provide as little information as possible for each step, which is possibly less confusing, but I truly believe the chosen format will fully usable.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Some problems with Internet Explorer 6
15/01/08 20:40 Filed in: Calc
| OpenOfficeSchool
As some of you might have noticed, some of the
lessons does not like Internet Explorer 6 very
much. This is related to the "step"-effect used
on some of the lessons, where each step is
listed on the left hand side.
For now there are no workaround if you have Internet Explorer 6, but this will be fixed. Please note that all lessons work well inn Internet Explorer 7 and any other web browser, such as Opera, FireFox and Safari (to mention a few). These are all free of charge.
I apologize for inconvenience, and hope to fix this in a few weeks.
Regards,
Roar Malmin
For now there are no workaround if you have Internet Explorer 6, but this will be fixed. Please note that all lessons work well inn Internet Explorer 7 and any other web browser, such as Opera, FireFox and Safari (to mention a few). These are all free of charge.
I apologize for inconvenience, and hope to fix this in a few weeks.
Regards,
Roar Malmin
Added a lesson with =IF() -- how to ad conditions to Calc
06/01/08 21:39 Filed in: Calc
Just added a lesson with the powerful
formula =IF(), which can
be used for performing different actions,
depending on the conditions.
In its simplest form it is very easy, but you can develop to be as complex as you like to match your task.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
In its simplest form it is very easy, but you can develop to be as complex as you like to match your task.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
The Norwegian government insist on ODF-support
20/12/07 12:38 Filed in: OpenOffice
| ODT
Several Norwegian newspapers has the recent
days been reporting that the Norwegian
government will insist on all public offices to
use one of the following document types:
1 - HTML as the primary format for information publication
2 - PDF for all documents not meant to be edited
3 - ODF for all documents where the end user will be able to edit the documents (forms to be filled out etc.)
The changes will be effective January 1st 2009. The pressrelease has not been translated into English yet.
ODF (Open Document Format) is the default fileformat for OpenOffice.
Norway is just one of several countries endorsing ODF as the format of choice, which, in my opinion, is very good for all of us, as all software developers have full access to every aspect of the format needed to implement it in their software. This includes Microsoft.
Roar
1 - HTML as the primary format for information publication
2 - PDF for all documents not meant to be edited
3 - ODF for all documents where the end user will be able to edit the documents (forms to be filled out etc.)
The changes will be effective January 1st 2009. The pressrelease has not been translated into English yet.
ODF (Open Document Format) is the default fileformat for OpenOffice.
Norway is just one of several countries endorsing ODF as the format of choice, which, in my opinion, is very good for all of us, as all software developers have full access to every aspect of the format needed to implement it in their software. This includes Microsoft.
Roar
Added to the Q&A
16/12/07 23:29 Filed in: Calc
Just added another part to the Q&A-section,
regarding Pivottable and
Datapilot.
Click here for the RSS feed.
Click here for the RSS feed.
Added an Q & A section
05/12/07 22:18 Filed in: Calc
In addition to the new forum, we’ve also
added a Q & A section.
We will NOT be able to answer all the questions that we get, I realize that now, but we’re trying the best we can to answer as many questions as possible. From now on some selected questions will be added to the Q & A section, and we hope it can be a good help to others as well.
Click here for the RSS feed.
We will NOT be able to answer all the questions that we get, I realize that now, but we’re trying the best we can to answer as many questions as possible. From now on some selected questions will be added to the Q & A section, and we hope it can be a good help to others as well.
Click here for the RSS feed.
Most recently from the blog:
