Posts Tagged: spreadsheet


6
Mar 08

Zoho Sheet – Video Tip

Last week, I gave you a short video tour of Zoho.com’s Writer word processing application. This week the tour continues with the Sheet program (spreadsheet) from Zoho. Like the word processor program, Sheet offers all of the features that 90% of spreadsheet users need or use, including:

  • Mulitple sheets (workbooks)
  • Charting
  • Advanced calculations
  • Auto formatting
  • Link external data
  • Online collaboration
  • and much more.

Watch the short video below to see how far online applications from Zoho.com can take you.


8
Nov 07

Microsoft Excel tip that will change your life – Video Tip

If this tip doesn’t change your life, it can change your cube mates life or someone’s life who uses Excel a lot.

This short (4 minute) video demonstrates the power of knowing how to quickly navigate around a spreadsheet without using the vertical or horizontal scroll bars.

Even if you don’t use Excel, watch the video…it is like a magic show you might see in Las Vegas.


8
Nov 06

Open Office 2.0 — FREE Alternative to Microsoft Office

In today's meetings, we downloaded, installed, and worked with Open Office. The FREE altnernative to Microsoft Office. To read why the software is free, read this information from their web site .

OpenOffice programs are completely compatible with Microsoft Office programs and allows you to read, edit, and create Office documents without owning the Microsoft Office suite. Here is a list of the programs and their functions in Open Office:

Open Office icons

First, you need to download the product by clicking here . You will be asked if you want to donate to the project…this is completely voluntary, and you can simply click "Continue to Download" if you don't want to donate. After the download finishes (less than 15 minutes for cable users, about 30-40 minutes for DSL users, and more than 5 hours for dial-up users), you will see the following icon on your Desktop or wherever you chose to save the file:

Open Office icon

  1. Double-click on the file you just downloaded, wait for the installation to start then:
  2. Click Next
  3. Click Unpack
  4. Wait a few moments
  5. Click Next
  6. Click the "I accept" button
  7. Click Next
  8. Type your name in the "Name" box
  9. Click Next
  10. Click Next if you want to install ALL programs (OR click Custom, then Next if you want to choose which programs to install)
  11. On the screen presented below, check all the boxes IF you don't currently have Microsoft Office installed OR you want to make OpenOffice your default word processor, spreadsheet and presentation manager.
    open office install screen
  12. Click Next
  13. Click Install
  14. Wait a few moments
  15. Click Finish

The install is finished, the first time you open any of the OpenOffice.org programs, you will need to answer a few more questions…again, this is one time only:

  1. When the Welcome screen appears, click Next
  2. Scroll down to the bottom of the license agreement to make the Next button clickable, then click Accept
  3. Type your Name and Initials if they don't appear already
  4. Click Next
  5. Choose whether or not you want to register (it's not necessary)
  6. Click Finish

You are now ready to start using Open Office!!

One quick tip for the Word Processor and Spreadsheet programs, when you open them the first time Click Tools —> Options from the menus, then:

  1. Click the the "+" next to Load/Save
  2. Click the "Always Save As" box and choose the "Microsoft Word 97/2000/XP " option
  3. Click OK (these settings are illustrated below)

Default Save options

Setting this option allows you to save all your documents as Microsoft Word documents so that it is easier to share them. Do the same thing in the OpenOffice Spreadsheet (Calc) and change the save option to Excel.

One other tip we pointed out in the group today is that OpenOffice has a built-in function to create an Adobe Acrobat (PDF) file out of any document you create in OpenOffice.

 

 


21
Sep 06

OpenOffice – Revisited

I wanted to give a quick update on a product that we started talking about on the show about four years ago. It's called OpenOffice . OpenOffice is considered an open source project which means that no one entity owns it (although Sun Microsystems pushed it hard in the early going), and anyone can use it for free. OpenOffice, as the name implies, is a productivity software. It contains a Microsoft Office compatible word processor, spreadsheet, presentation manager and database. I installed it for my kids almost a year ago and have been rolling it out for more and more clients. I can honestly say that I'm impressed with the product.

OpenOffice opens and edits any of the Microsoft products and can save in the Microsoft format. Therefore compatibility is nearly seamless. Some smaller government jurisdictions are giving the expensive licensing fees attached to Microsoft Office in favor of the free OpenOffice. If you are looking for an alternative to Microsoft Office products, take another look at OpenOffice . I think you will be pleasantly surprised.