About

Ian Ozsvald picture

This is Ian Ozsvald's blog (@IanOzsvald), I'm an entrepreneurial geek, a Data Science/ML/NLP/AI consultant, author of O'Reilly's High Performance Python book, co-organiser of PyDataLondon, a Pythonista, co-founder of ShowMeDo and also a Londoner. Here's a little more about me.

High Performance Python book with O'Reilly

View Ian Ozsvald's profile on LinkedIn

ModelInsight Data Science Consultancy London Protecting your bits. Open Rights Group

30 June 2009 - 18:46New ShowMeDo series – OpenOffice Calc transition series for Excel users

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.

  1. Series Overview in 3 minutes (OpenOffice 3.1 for Excel users) (Free)
  2. Installing OpenOffice 3.1 on Windows XP (Free)
  3. Working with .xls Sheets in Calc
  4. Saving as an ODF Spreadsheet (.ods) and PDF
  5. Where to get help
  6. Constructing a Sales-Forecast Sheet
  7. Formatting your Sheet
  8. Creating a Chart
  9. Printing your Sheet
  10. Import and Export CSV files
  11. Re-associating .xls files with Excel after OpenOffice installation
  12. Light relief – Star Wars Easter Egg and others

Ian applies Data Science as an AI/Data Scientist for companies in ModelInsight, sign-up for Data Science tutorials in London. Historically Ian ran Mor Consulting. He also founded the image and text annotation API Annotate.io, co-authored SocialTies, programs Python, authored The Screencasting Handbook, lives in London and is a consumer of fine coffees.

No Comments | Tags: ProCasts, Screencasting, ShowMeDo

Comments are closed.