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.

Tags: Calc, Lessons, DataPilot

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.

Tags: Calc, Lessons, Formatting

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.

Tags: Lessons, Calc, =LEN()

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.

Tags: Lessons, Calc, =IF()

Just added another part to the Q&A-section, regarding Pivottable and Datapilot.

Click here for the RSS feed.

Tags: Calc, Q & A

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.

Tags: Calc, Q & A

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.

Tags: Lessons, Calc, =MID()

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.

Tags: Lessons, Calc, =RIGHT()

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.

Tags: Lessons, Calc, =SUMIF()

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.

Tags: =TRUNC(), Lessons, Calc

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.

Tags: =ROUND(), Lessons, Calc

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.

Tags: Lessons, Calc, =RAND()

We are working on multiple lessons for Calc at the moment, and we expect to start publishing the first ones at the beginning of September!

This includes both more formula lessons, but also tips and tricks.

Tags: Lessons, Calc

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.

Tags: Calc, formulas, =VLOOKUP()