Archive for April, 2011

Introduction to Spreadsheets in Google Docs

Monday, April 11th, 2011

Got Data? Then you need to be using Google Docs Spreadsheet! This tool allows you to collect and use data in interesting and helpful ways. The built in collaborative features of Google Docs allows multiple users to view and edit spreadsheets simultaneously.

Read more..

Tips on Microsoft Excel (Version 97 and Later)

Monday, April 11th, 2011

Microsoft Excel Tips – The classes that I teach most often are Microsoft Excel versions 2003 and 2007. I put together these tips for the Excel beginner. These tips will work for Excel ’97 or later.

Read more..

Top Ten Excel Tips For Beginners

Monday, April 11th, 2011

There are many tips for Excel. This article is for the beginners and covers the tips that I go over in the classes that I teach at local schools.

1. 80% of the most commonly used features, for beginners, in Excel can be done with two toolbars. A toolbar is the icons that are under the menus that are in text format (File, Edit, etc.). You should have the Standard toolbar and the Format toolbar on your screen.

Read more..

Excel Advisor Increasing the size of task bar in separate

Monday, April 11th, 2011

A vertical lookup is an extremely useful – but little-used – feature of Excel. It allows you to link data arranged in a table to data in your spreadsheet by matching a field contained in both the table and the spreadsheet

Read more..

Publishing Your Worksheet To Internet

Monday, April 11th, 2011

Publishing your worksheet on the Internet makes it readily available to anyone who has Internet access. By publishing it on a password protected Web site the Internet becomes a secure and timely method to distribute information.

Read more..

Publishing Your Worksheet To The Internet

Monday, April 11th, 2011

Publishing your worksheet on the Internet makes it readily available to anyone who has Internet access.

Read more..

MS Excel Tips – A Quick Tip You Can Use Today

Sunday, April 10th, 2011

Microsoft Excel is a great product. I use it every day at work to do a number of tasks. I love when I find a good Excel tip or find a trick that I didn’t know about. It makes the program even more useful and I become more productive as a result.

Read more..

Routing Files with e-Mail

Sunday, April 10th, 2011

You may have noticed that Excel has the ability to send a file as an e-mail or as an e-mail attachment directly from inside of the Excel worksheet.

Read more..