spreadsheet News and Other Resources

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

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@...

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.

Blog Post

Track projects and employees' hours with eHour

January 11, 2013 9:54am PST

Jack Wallen calls eHours one of the best systems for small businesses that need to track time. Learn how to install and configure eHours, which has distributions for Linux, Windows, and Mac.

6 Latest comment by kshitiz_vyas

Blog Post

Recover data from a damaged Office file with the help of 7-Zip

November 21, 2012 3:32pm PST

Jack Wallen walks you through how to recover data using 7-Zip. He notes this data recovery solution isn't ideal, but it could put you back in business.

1

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

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

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

Use formatting, autoformatting, and themes in LibreOffice Calc

September 27, 2012 3:40pm PDT

Formatting, autoformatting, and themes will make your LibreOffice Calc documents easier to read, prettier, and more efficient to create and use.

1

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

Blog Post

Feature update: Protected ranges in a Google Doc spreadsheet

August 21, 2012 12:49pm PDT

Google has made it possible to designate a named range in a spreadsheet as a protected range.

1

Blog Post

Tech skills: The problem's not the staff, it's the bozos in charge

July 17, 2012 7:29am PDT

Evidence is mounting that technologically illiterate managers are causing more damage to corporate productivity than a shortage of IT skills among staff.

35 Latest comment by lebotse@...

Blog Post

Modernize group brainstorming with Google Apps

May 24, 2012 11:28am PDT

Use a shared Google spreadsheet to facilitate the success of your next brainstorming session.

3 Latest comment by rdux

Blog Post

DIY: Conditional formatting in LibreOffice Calc

February 29, 2012 12:54pm PST

Jack Wallen describes how to create conditional formatting in LibreOffice's Calc spreadsheet application.

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

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

10 ways to screw up your spreadsheet design

June 23, 2011 8:25am PDT

How you set up a spreadsheet determines its efficiency, usability, and reliability. Avoiding these pitfalls during the design phase will save you a million headaches.

81 Latest comment by margswarnabhoomi

Blog Post

Five tips for collaborating in LibreOffice

June 11, 2011 10:56am PDT

Collaboration tools are essential for all sorts of business documents and writing projects. Jack Wallen collaborates extensively on his technical content and fiction writing -- and he uses...