Thursday, August 04, 2005

Stop The Cheats!

Stop The Cheats!

M.R. wrote to Telegraph.Connected - "I'm preparing some exercises and tests in Excel for students. Can anyone suggest a way of preventing students from copying and passing the exercises and answers to each other?"

The suggested answers are quite creative and useful. From hidden white code on white cell background indexed to each student to use of the RANDOM number function to generate data for the studnet to work with and indexing this to the students. You can read more here


Saturday, July 30, 2005

Which Is Better Excel or Access?

This age old question inevitably comes up for users of Excel. Whats the answer??? Well a good link is Daily Dose of Excel: "Wrench vs Screwdriver" and follow the through link to Microsoft for what I think is a very clear and useful explination of the differances and really gives you the answer you need.

In a nutshell, if your focus is calculation and detailed analysis then use Excel, if your focus is on management of relational data then Access. It may not be that simple some of the time but read the article and make up your own mind and experiment!


Google Maps In Excel

Google Maps In Excel: "Google Maps In Excel
Here's my first attempt at using google maps in excel (download below). Currently I can input an address and have a google map of the address displayed in Excel, with most of the cool google functionality."

A very cool tool from Mark at How ever you do need up to date hardware and software.


Do Often Need To Compare Excel Worksheets?

Comparing Excel Files Made Easy: "4TOPS just released the 4TOPS Compare Excel Files program. This software utility helps users find differences between worksheets or Microsoft� Excel files by creating clear reports in HTML. The broad use of Excel in virtually any business explains the need for such a specialized comparison program. As an example it is used for identifying changes in versions trading sheets before they are being sent out to trade partners. Another example is reviewing new versions of project plans which have been made in Excel."

I thougt this could be useful for some. Find out more here.


New Excel For School Students?

"In many households, homework is a big problem. Teachers often load up students with far more of it than I recall from my own prehistoric school career. And parents, squeezed for time by dual careers and rusty because of rapidly changing curricula, find it is hard to help.

Taking note of this daily homework battle, Microsoft has decided to help - or at least to see whether it can make some money by addressing the problem. The software colossus has just introduced Microsoft Student 2006, designed to make it easier for middle-school and high-school students to attack homework efficiently by gathering homework resources in one place on the computer." by Walter S. Mossberg, The Wall Street Journal.

Well there are mixed reviews on this new product from Microsoft. It cops a pasting in the article above and a positively lukewarm reception at

To me its seems like a thin veneer over existing programs such as Excel, Word etc. It dosen't make sense that you'd buy this program, if all the information was already easily availble on the net, mostly for free, or more than likely on already owned software on your home computer. So no its not a new Excel for School Students, its just some templates which might come in handy. Teach your kids to do it themselves I say!


Wednesday, July 27, 2005

Finding Spreadsheets With Google

From Research Buzz Finding Spreadsheets With Google: "remember that XLS isn't the only kind of spreadsheet; ever thought of searching for filetype:csv? Or ( filetype:csv | filetype:xls ) ? "
This article and the one at Automate Excel (click here) show some really cool search methods to dig up excel spradsheet and much more through clever use of search syntax on Google.


Save Time - Use Shortcuts

Andrew's Excel Tips: "Keyboard shorcuts save a lot of time. Here are some of the more common ones (they can also be used in a lot of other software other than Excel)

Push both keys at the same time -

Ctrl A Select All

Ctrl C Copy

Ctrl X Cut

Ctrl V Paste

Ctrl B Toggle Bold Font

Ctrl I Toggle Italic Font

Ctrl U Toggle Underline"

If your new to shortcuts, try these and see what a differance they make. Those in the know couldn't live wit out them.


Especially For Excel Info Junkies

Specious Argument: Daily Dose of Excel: "If you work with Microsoft Excel and you want to improve your skills, one blog I highly recommend you read is Daily Dose of Excel. Dick Kusleika along with his terrific authors provide a wealth of information and knowledge. "

A gem from Kevin at Specious Argument!


Programs For Serious Excel Masters

Specious Argument: Speaking of Microsoft Excel: "If you do serious Excel Spreadsheet work, this software package is an absolute must. Fast Excel also contains a superb program called The Name Manager."

These sound like excellent tools, check out the article here. Can't wait to try them out. I will psot when I have, and let you know how they went.


Need Some Cheat Sheets For Excel?

Rover of Windsor - ???: Our Favorite Cheat Sheets: "You never know when a good cheat sheet will come in handy -- bookmark this page to keep our treasure trove of useful information at your fingertips! "

Here is an excellent list of cheats sheets! One to bookmark.


A Mathematical Theory To Prove The Brits Waste Sunlight! � Blog Archive � Altitude of the Sun and Moon: "full astronomical twilight is never quite reached in the Summer months in the UK."

This is a really Lunatical use of Excel, and the theory explained proves that the Brits can't be utilising all the sunlight at their disposal if they are so lilly white and tanless. Maybe it always cloudy and raining? And all on an excel spreadsheet!


Monday, July 25, 2005

Excel To PDF for FREE!

Graphic Exchange News: "New version of activePDF free PDF creation software for Windows
Jul 22, 05 | 10:09 am
activePDF has announced the release of PrimoPDF 2.0, a free PDF creation tool for Windows only that creates PDFs from virtually any printable file type.
New features in PrimoPDF 2.0 include the ability to generate secure PDFs with 40-/128-bit encryption and the option to add document information (e.g. title, author, subject, keywords). PrimoPDF can convert files in Word, Excel, PowerPoint, and other popular applications. To download PrimoPDF, visit"

I will be trying this one out for sure! Anyone else? Would appreciate any feedback.


Cheat Via Google For Spreadsheet Formats

Searching for Spreadsheets with Google: "Is there anything that Google can't do? This via, I found out that by using various syntaxes you can find spreadsheets, in all sorts of formats, with Google.
Here's how it works:
filetype:xls is the search string for finding any kind of Excel spreadsheet. For instance, you could type in planning filetype:xls and this is what you would come up with.
ResearchBuzz came up with a few more special ways to mix up the syntax, including this little gem: intitle:gantt filetype:xls site:edu.
Finding spreadsheets is not really my idea of a good time on the Web, but I'll contribute a search query: filetype:xls inurl:budget. My results are predictably full of budgety goodness. "

Well how about that! Why reinvent the wheel?


Welcome To Super Spreadsheets

Hi Fellow Excel Users,

we hope to be bringing you the latest information on Microsoft's Excel® spreadhseet software from around the world. We'd love to get to know you so we would love to hear from you. Just hit the comment button below and let us know what you think.