Media releases are provided as is by companies and have not been edited or checked for accuracy. Any queries should be directed to the company itself.

Is Your Spreadsheet Overweight?

  • 25 February, 2005 11:32

<p>10 signs that your spreadsheet is ready for a FileMaker database makeover</p>
<p>SYDNEY, Australia. – February 25, 2005 – The love affair between businesses and their spreadsheets is threatened by a weight problem. Excellent in their original use of managing financial and other numerical information, spreadsheets have become overweight as they are used for many tasks and business processes better suited for a database, such as customer information, schedule management, inventory tracking, order management and resource allocation.</p>
<p>To help Microsoft Excel users get the most from their data, FileMaker, Inc. offers a web-based version of a “data spa” at www.filemaker.com.au/technologies/excel.html, where users can go and find out when a spreadsheet is “carrying too much weight” and should be converted to a database solution.</p>
<p>The website provides a “Drag, Drop and Go” demo that shows how easily Excel users can convert spreadsheet information into a ready-to-use database by simply dragging a spreadsheet icon onto a FileMaker Pro icon. Trial copies of FileMaker Pro 7 are also available to download on the website. Users can then take Excel spreadsheet files and drag and drop them directly onto a FileMaker Pro icon. Also available is a free 16-page guide on using FileMaker Pro together with Excel, written by noted technology author Maria Langer. The web site features tips and techniques for exchanging data between Excel and FileMaker Pro applications, plus everything you need to know to easily transform Excel spreadsheets into rich, powerful solutions that can be customised.</p>
<p>“FileMaker Pro 7 provides overweight spreadsheets with a fast and painless data diet plan,” said Steve McManus, General Manager, Asia Pacific, FileMaker, Inc. “Spreadsheets can focus on crunching numbers and forecasting for individual users while the rest of a company’s data can get in competitive shape by taking advantage of a database’s capabilities to manage and share multiple types of information.”</p>
<p>“Excel spreadsheets continue to be great for financial information, but spreadsheets become overweight when they are used for handling non-numerical information that should be managed by a database,” said Maria Langer, who has authored several books on Microsoft Excel, FileMaker Pro and Quicken. “FileMaker is an excellent companion to Excel in data applications. In fact, many companies actually use a FileMaker Pro database to store and manage all their spreadsheets.”</p>
<p>10 Signs That Your Spreadsheet May Be Overweight
There are several indications when a spreadsheet is carrying too much of a data load and should be converted to a database, including:</p>
<p>1. When you are tracking your customers or managing a contact list and you would like to send them emails automatically or send letters using address labels from within the application
2. When data queries are important
3. When the data needs to be shared with others
4. When data integrity (the need to keep data protected from being changed) is critical
5. Searching and sorting data without changing the value or formula related to the data
6. Controlling access to files
7. Publishing data to the web
8. Organising data that has multiple relationships
9. Whenever more than one person is updating data
10. Organising large amounts of data</p>
<p>About FileMaker, Inc.
FileMaker Pro is used by millions of individuals and workgroups around the world to be more productive and efficient. Business, education and government customers rely on FileMaker to manage people, projects, images, assets and other information. In addition to being the number one-selling easy-to-use database software, the award-winning FileMaker product line also includes two software server applications, mobile database products, low-cost Applications that automate basic business tasks, ready-to-use Starter Solutions, and tools to create and share solutions from the desktop to the web. FileMaker, Inc. is a subsidiary of Apple Computer, Inc. (NASDAQ: AAPL).</p>
<p>###</p>
<p>Customer contact:
Australia 1800 028 316
New Zealand 0800 444 929
http://www.filemaker.com.au</p>
<p>Media contact:
Amanda Scott-Kiddie
+61 2 9976 6611
Amanda@kinetics.com.au</p>
<p>©2005 FileMaker, Inc. All rights reserved. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners.</p>

Most Popular

Cool Tech

Breitling Superocean Heritage Chronographe 44

Learn more >

SanDisk MicroSDXC™ for Nintendo® Switch™

Learn more >

Toys for Boys

Family Friendly

Panasonic 4K UHD Blu-Ray Player and Full HD Recorder with Netflix - UBT1GL-K

Learn more >

Stocking Stuffer

Razer DeathAdder Expert Ergonomic Gaming Mouse

Learn more >

Christmas Gift Guide

Click for more ›

Most Popular Reviews

Join the newsletter!

Error: Please check your email address.

Latest Articles

Resources

PCW Evaluation Team

Edwina Hargreaves

WD My Cloud Home

I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.

Walid Mikhael

Brother QL-820NWB Professional Label Printer

It’s easy to set up, it’s compact and quiet when printing and to top if off, the print quality is excellent. This is hands down the best printer I’ve used for printing labels.

Ben Ramsden

Sharp PN-40TC1 Huddle Board

Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

George Khoury

Sharp PN-40TC1 Huddle Board

The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic

Featured Content

Product Launch Showcase

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?