Name:
[002] Ian Ozsvald
Member:
91 months
Authored:
181 videos
Description:
I am the co-founder of ShowMeDo (see http://showmedo.com/about), author of `The Screencasting Handbook <http://thescreencastinghandbook.com>`_ and the founder of the professional screencast production company `ProCasts <http://procasts.co.uk>`_:
.. image:: http://procasts.co.uk/media/procasts_sma ...
OpenOffice Calc 3.1 for Microsoft Excel users [ID:778]
a series of video-tutorials by Ian Ozsvald
This transition series will help you move from Microsoft Excel to OpenOffice Calc in a few easy steps. Topics covered include sharing .xls files between both programs, getting help and building a full spread-sheet from scratch in Calc.
Video Tutorials
1. Series Overview in 3 minutes (OpenOffice 3.1 for Excel users)
In this series we help you move from Microsoft Excel (2003 is our example) to OpenOffice 3.1. We show you how to use both Excel and Calc to edit the same document and how to do all the usual functions in OpenOffice, as well as where to go to get your questions answered.
Visit OpenOffice.org to get started and read more background at WikiPedia.
6 votes
2. Installing OpenOffice 3.1 on Windows XP
In just over 2 minutes we run you through the installation of OpenOffice 3.1 on Windows XP. We also show you how you can download a version of OpenOffice for Windows, Mac or Linux in different languages.
Visit OpenOffice.org to get started.
5 votes
3. Working with .xls Sheets in Calc
An early hurdle when switching to OpenOffice will be the question of whether you can still share documents with MS Office users. Of course you can! Here we edit a document in both MS Excel 2003 and OpenOffice 3.1 Calc to show that all formatting is preserved.
You can read a bit more about MS Office and OpenOffice.
2 votes
4. Saving as an ODF Spreadsheet (.ods) and PDF
Now let's look at a native document - OpenOffice works with .ods files (OpenDocument Spreadsheet).
2 votes
5. Where to get help
For help, the first place to start is TutorialsForOpenOffice. The official documentation is complete but a bit heavy.
OpenOffice's Support section gives many links which include free material, courses and books.
If you have questions the most active forum seems to be the independent OpenOffice Forum and although a little bit less active, the official forum should be your other port of call.
If y [...]
1 votes
6. Constructing a Sales-Forecast Sheet
Here we build a spreadsheet from scratch, the example used is a sales-forecast for an eBook.
We build a model, use headings and formulas, along with relative and absolute references.
1 votes
7. Formatting your Sheet
Now we want the sheet to look more pretty. We use formatting to add borders and show percent and currency symbols.
1 votes
8. Creating a Chart
Finally we want to add a chart to visually represent our calculated financials.
2 votes
9. Printing your Sheet
Printing on Windows is easy. We take a quick look at the Print Preview function and how to format a page to Landscape view.
Tutorials for OpenOffice has a short guide to printing. You might want this tip to turn off the printing of zeroes.
2 votes
10. Import and Export CSV files
Comma Separated Values are a common topic of the forums. Here I show you how to load a .csv file into both Excel and Calc.
I use example data from Yahoo!'s finance site.
1 votes
11. Re-associating .xls files with Excel after OpenOffice installation
Once you've installed OpenOffice you'll probably find that .xls files are now opened by OpenOffice Calc, not by Excel.
This video shows you how to re-associate .xls files with Excel. Alternative approaches are shown here.
1 votes
12. Light relief - Star Wars Easter Egg and others
Calc contains a few easter-eggs including Star Wars and OXOs. See this wiki page for details and this techrepublic page for examples.
3 votes
Thanks man