I spent the weekend cracking through the creation of a new 12-part tutorial series for ShowMeDo, the result is OpenOffice Calc 3.1 for Microsoft Excel users. The overview is embedded below, links to all the episodes are further down. This series was created whilst wearing my screencast production hat for ProCasts.
The goal is to take the hand of an Excel user and easily and quickly move them over to using Calc with the minimum of fuss.
Common topics like sharing .xls files, using .ods native files, printing, .csv files and PDF export are covered. I also spend three episodes (just over 20 minutes) going through the creation of a sheet to model a mythical eBook’s sales covering formulas, formatting and charting. Finally I finish with a look at some of Calc’s easter eggs including Star Wars (heck, I didn’t even know there were any games in OOo!).
Note that this series is a part of ShowMeDo’s Club so you need to be a paying member or contributing author to get access to all the episodes. I’ve also updated the OpenOffice Learning Path which collates all of ShowMeDo’s OpenOffice videos.
- Series Overview in 3 minutes (OpenOffice 3.1 for Excel users) (Free)
- Installing OpenOffice 3.1 on Windows XP (Free)
- Working with .xls Sheets in Calc
- Saving as an ODF Spreadsheet (.ods) and PDF
- Where to get help
- Constructing a Sales-Forecast Sheet
- Formatting your Sheet
- Creating a Chart
- Printing your Sheet
- Import and Export CSV files
- Re-associating .xls files with Excel after OpenOffice installation
- Light relief – Star Wars Easter Egg and others
Ian is a Chief Interim Data Scientist via his Mor Consulting. Sign-up for Data Science tutorials in London and to hear about his data science thoughts and jobs. He lives in London, is walked by his high energy Springer Spaniel and is a consumer of fine coffees.