An easier way of copying cells
13/08/11 22:56
This is one of those tips that make your everyday life with OpenOffice.org Calc juuust a little bit easier… Nothing major, but it should speed up some of the copying of cells that you do.
The point here is to reduce the amount of work when copying cells downwards. Of course, you can do it by using one of the numerous ways of copying and pasting involving right-clicking and selecting from the menu, using the Edit menu or using the short cuts.
Usually I advise people to avoid using the mouse when possible; this is an exception. Read More...
The point here is to reduce the amount of work when copying cells downwards. Of course, you can do it by using one of the numerous ways of copying and pasting involving right-clicking and selecting from the menu, using the Edit menu or using the short cuts.
Usually I advise people to avoid using the mouse when possible; this is an exception. Read More...
|
Changing the colour of text in Calc, not background
08/06/09 19:49
Question:
As I post accounting I am used to turning those cells in the Cheque Register blue so that I know I have posted those items. I try to change the font colors in the Calc spreadsheets, and no matter how many times I do it, the font remains stubbornly black, even though the background color will change.
Read More...
As I post accounting I am used to turning those cells in the Cheque Register blue so that I know I have posted those items. I try to change the font colors in the Calc spreadsheets, and no matter how many times I do it, the font remains stubbornly black, even though the background color will change.
Read More...
Added a lesson on how to create filters easily with AutoFilter
28/01/09 21:31
This lesson will show you how to filter potentially large amounts of data with AutoFilter. The really fun part is how easy it actually is to create!
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 how to create charts
11/09/08 16:59
We have just created a lesson on charts, which is due to a suggestion on the forums. This lesson will show you how to create simple charts and edit them to suit your purpose.
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 how to create and modify DataPilot -- recommended!
04/05/08 22:13
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
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
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
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
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
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
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.
Added to the Q&A
16/12/07 23:29
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
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.
Added a lesson with =MID() -- how to extract characters, counting from the pointyou specify
02/12/07 22:45
Just added a lesson with the formula =MID(), which is used for extracting any given number characters from a cell or other text, starting from where you specify.
This is as easy formula, but it’s still very powerful, probably more powerful than both =LEFT() and =RIGHT().
There have been some activity on the forum, but remember; the more the merrier Don’t be afraid to post there, and it will probably get you answers faster, and more answers, than mailing us!
Click here for the RSS feed.
This is as easy formula, but it’s still very powerful, probably more powerful than both =LEFT() and =RIGHT().
There have been some activity on the forum, but remember; the more the merrier
Don’t be afraid to post there, and it will probably get you answers faster, and more answers, than mailing us!Click here for the RSS feed.
Added a lesson with =RIGHT() -- how to extract characters, counting from the right
25/11/07 19:45
Just added a lesson with the formula =RIGHT(), which is used for extracting any given number characters from a cell or other text, counted from right
This is as easy formula, but it’s still very powerful.
We have also added a Links-page, to help you find useful resources on the net.
Click here for the RSS feed.
This is as easy formula, but it’s still very powerful.
We have also added a Links-page, to help you find useful resources on the net.
Click here for the RSS feed.
Added a lesson with =SUMIF() -- how to sum only lines meeting certain criterias
14/10/07 19:51
Just added a lesson with the formula =SUMIF(), which is used for summing lines meeting the criteria you specify. This works kinda like =SUM(), but with a powerful twist.
This is a medium difficult formula, but is very powerful.
Click here for the RSS feed.
This is a medium difficult formula, but is very powerful.
Click here for the RSS feed.
Added a lesson with =TRUNC() -- how to cut off decimals
10/10/07 19:59
Just added a lesson with the formula =TRUNC(), which is used for cutting off decimals.
And, further good news; this is also one of the easier formulas
Click here for the RSS feed.
And, further good news; this is also one of the easier formulas
Click here for the RSS feed.
Added a lesson with =ROUND() -- how to round values
07/10/07 20:26
Just added a lesson with the formula =ROUND(), which is used for rounding values.
This is also one of the easier values.
Click here for the RSS feed.
This is also one of the easier values.
Click here for the RSS feed.
Added a lesson with =RAND() -- how to create random numbers, more to come!
12/09/07 21:27
Just added a lesson with the formula =RAND(), which is used for creating random numbers.
This one is both relatively easy and, if used creatively, quite powerful.
From now on there will be more frequent updates on this site, still focusing on Calc. There is another lesson ready to be published early next week. And there are a lot more in the pipeline already!
Click here for the RSS feed.
This one is both relatively easy and, if used creatively, quite powerful.
From now on there will be more frequent updates on this site, still focusing on Calc. There is another lesson ready to be published early next week. And there are a lot more in the pipeline already!
Click here for the RSS feed.
More lessons comming starting primo September
24/08/07 00:09
Added a lesson with =VLOOKUP()
23/05/07 21:25
Now we have finally added a lesson with one of the more advanced formulas, =VLOOKUP(), and more lessons will follow, so please continue to visit us.
Click here for the RSS feed.
Click here for the RSS feed.
Added two more formulas
25/06/06 22:57
Next formula ready...
05/06/06 20:08
Now we've finished the next lesson, which teaches you how to use the =average() formula, which is very similar to the =sum() formula explained in the previous lesson.
The first formula
21/05/06 23:19
New lesson out
14/05/06 22:31
We’ve added a new lesson to the Calc repository, where we’re starting to deal with formulas.
We’ve also removed those highly unfinished Writer and Impress pages -- these will be back as soon as we start developing lessons for them.
You can expect another lesson next week, as usual.
We’ve also removed those highly unfinished Writer and Impress pages -- these will be back as soon as we start developing lessons for them.
You can expect another lesson next week, as usual.
New lesson next week
04/05/06 22:06