spreadsheet

Blog Post

Use Google Forms to create a survey

October 31, 2012 1:17pm PDT

A Google Form is a great way to gather information related to meetings or conferences. Andy Wolber explains how to make it work for you.

2 Latest comment by stevep457@...

Blog Post

Five small footprint productivity tools that pack a powerful punch

May 7, 2013 12:40pm PDT

With the right app you can get high performance without taking up a large amount of resources.

2 Latest comment by earlehartshorn@...

Articles

Convert an XML file into an Excel spreadsheet with this technique

March 1, 2007 4:39pm PST

One way to present XML information to a user is by converting it to a file format the user actually knows. Edmond Woychowsky walks you through his process, including all the necessary sample code,...

18 Latest comment by Cobynsoft

Blog Post

10 things to love and hate about Microsoft Office 2013

October 15, 2012 5:38am PDT

Office 2013 has just reached RTM, but Deb Shinder has been working with it for quite a while. Here's her rundown of the pros and cons.

102 Latest comment by Erwin.Craps@...

Blog Post

Quickly add a blank row between multiple rows of data in an Excel spreadsheet

October 2, 2009 12:00am PDT

Inserting a blank row between existing rows of data in an Excel spreadsheet can be a tedious task if you insert each row individually. Fortunately, if you know this trick, inserting rows between...

5 Latest comment by navyking

Blog Post

Use Google Forms to create a self-grading quiz

November 2, 2012 12:34pm PDT

Andy Wolber shows us how to use Google Forms to build an automated quiz using the survey tool.

6 Latest comment by vanessaelizebeth

Blog Post

Five Google Spreadsheet features to help kick your Excel addiction

September 14, 2012 8:38am PDT

Updates and added features have leveled the playing field, giving Google Spreadsheets capabilities that Excel may never have.

4 Latest comment by Atharton_CB

Articles

Download this spreadsheet for easy project management

November 13, 2001 8:00am PST

Excel is one of the most often-used desktop applications, so it's no surprise that it makes a great tool for managing projects. This sample spreadsheet can help consultants keep track of project...

18 Latest comment by euniq

Blog Post

Office suite alternatives for Android tablets

November 9, 2011 1:06pm PST

Donovan Colbert takes a close look at several Office suites for Android tablets, including Polaris Office, Documents To Go, OfficeSuite Pro 5, and Google Docs as a native app or via a web browser.

13 Latest comment by Brucie001

Blog Post

Collaborative budgeting with protected Google spreadsheets

May 8, 2013 7:53am PDT

A shared Google spreadsheet with protected areas may simplify collaboration for many tasks.

4 Latest comment by dogknees

Articles

Use Excel check boxes to create a list-totaling spreadsheet

November 20, 2001 8:00am PST

With a little creativity and Excel's check box feature, we show you how to total a selection of list items with ease. Use the techniques illustrated in this article to spice up your invoices,...

41 Latest comment by fowlesjohn@...

Blog Post

DIY: Add drop-down lists to LibreOffice spreadsheets

February 21, 2012 12:49pm PST

The addition of drop-down lists can make your LibreOffice Calc spreadsheets more flexible and powerful. Get instructions on adding them in Calc.

Blog Post

Add autonumbering to your Excel spreadsheet

October 16, 2007 12:00am PDT

Unlike Access, Excel does not have an autonumbering feature that increments a number each time you add a new row. With Excel 2003 and 2007, you can use the Row function to add your own...

16 Latest comment by noemir

Articles

Download this project-planning spreadsheet

January 11, 2002 8:00am PST

If your small to midsize projects don't warrant a full-scale plan in Microsoft Project, perhaps you'd fare better using this Excel project plan template sent to us by one of your fellow...

7 Latest comment by merlynn@...

Articles

Anatomy of Excel: Sorting and filtering

November 3, 2005 8:13pm PST

Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within...

3 Latest comment by robert.vas@...

Blog Post

Merge or share your LibreOffice Calc spreadsheets

May 7, 2013 10:36am PDT

The ability to easily share spreadsheets in LibreOffice has helped bring the office suite that much closer to being a worthy replacement for Microsoft Office.

Articles

Use dynamic ranges to make your Excel spreadsheets easier to understand

April 3, 2007 7:00am PDT

Give your numbers more distinct meanings in Excel with dynamic ranges. By using the OFFSET function and naming feature, you can give labels to your formulas, making them easier to find and reference.

9 Latest comment by sbach

Articles

Use error handling to enhance your Excel spreadsheets

April 2, 2001 7:00am PDT

If you're tired of seeing #N/A errors in your spreadsheets, we've got the solution for you. Find out how built-in Excel error-handling functions can hide these errors.

9 Latest comment by fhrosa

Articles

Adjust row heights to make Excel spreadsheets easier to read

October 17, 2006 7:00am PDT

Are all the rows in your Excel spreadsheet crunched together? Mary Ann Richardson explains how to adjust the height of your rows to allow your numbers some breathing room—and your eyes a bit of...

13 Latest comment by Quanta51

Articles

Download our invoice tracking spreadsheet

September 18, 2002 7:00am PDT

You may be a tech guru, but if you're an independent consultant who has trouble keeping track of invoices and accounts receivable, your IT skills are for naught. Our invoice tracking spreadsheet...

5 Latest comment by sandeep_G_G