office suites News and Other Resources

Blog Post

Two ways to add checkbox controls to a Word document

February 22, 2012 8:16am PST

Use a customized bulleted list or a content control to insert checkboxes into a Word document, depending on how you are going to use it.

2 Latest comment by ian@...

Blog Post

Transpose Excel data from rows to columns, or vice versa

June 23, 2009 12:00am PDT

When you need to flip-flop data in an Excel worksheet, don't waste time doing it manually. Excel offers a handy Transpose option that will quickly take care of the task.

33 Latest comment by excelinexcel

Blog Post

10 ways to reference Excel workbooks and sheets using VBA

August 25, 2009 9:08am PDT

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

5 Latest comment by johnywhy@...

Blog Post

Use SUMIFS() to sum by multiple conditions in Excel

November 14, 2011 11:25am PST

Excel's SUMIF() lets you sum values, conditionally. It's new sibling, SUMIFS() lets you sum values by multiple conditions.

7 Latest comment by david.hanshumaker@...

Blog Post

10 cool ways to use Excel's conditional formatting feature

April 11, 2012 2:06pm PDT

Excel's conditional formatting feature can do a whole lot more than many people realize. Susan Harkins runs through 10 practical ways to put this tool to work.

23 Latest comment by EleanorSugden

Blog Post

How to use Excel 2010's new conditional formatting with references

August 30, 2010 8:40am PDT

Excel 2010's new referencing option makes conditional formatting more powerful than ever before!

10 Latest comment by manishdhir

Blog Post

10+ ways to recover a corrupted Word document

August 17, 2009 2:55pm PDT

Few computer experiences are worse than having a Word document blow up on you. But before you resign yourself to losing the document contents, check out these techniques for salvaging your text.

39 Latest comment by techrepublic2013

Blog Post

Add horizontal lines to a Word document

September 29, 2010 12:00am PDT

Susan Harkins shows you two easy ways to insert a horizontal line into a Word document.

8 Latest comment by Shrike49

Blog Post

Four ways to insert an em dash in a Word document

March 1, 2010 12:00am PST

When you need an em dash, you can let Word enter it for you the easy way. If that approach doesn't suit your needs, try one of three manual methods.

30 Latest comment by Marshwiggle

Blog Post

Three Outlook Calendar defaults you can have your way

May 6, 2013 7:51am PDT

Don't work harder than you need to. Change Outlook Calendar's defaults to suit your working habits.

6 Latest comment by jonathan_armstrong@...

Blog Post

The first nine things I do to default settings in Word 2013

December 6, 2012 12:22pm PST

Some of the default settings in Word 2013 just don't work for him, so before he does anything else Mark Kaelin changes them.

30 Latest comment by nuwan-d2d92

Articles

Concatenate date cells with text cells in Excel

December 12, 2006 8:00am PST

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

7 Latest comment by tali.tv

Blog Post

Google Apps v. Office 365: Head-to-head comparison of features

April 2, 2013 12:30pm PDT

Ian Hardenburgh compares the core features of Microsoft Office 365 and Google Apps to see which one comes out on top and includes a downloadable chart for at-a-glance comparison.

52 Latest comment by maikr

Blog Post

Five top alternatives to Microsoft Outlook

November 14, 2011 5:49am PST

If you're looking for an email client to replace Outlook, you're in luck: Many solid alternatives are available. Jack Wallen lists five top contenders.

195 Latest comment by ag691234

Blog Post

Use Word's Vertical Alignment settings to center a page

July 28, 2010 6:30pm PDT

Centering text vertically isn't difficult; you just have to know where to look!

Blog Post

10 steps to setting up page numbering in Word sections

September 23, 2010 9:41am PDT

If you've ever been outfoxed by Word's page numbering options in a multiple-section document, here's good news: Controlling how the pages in each section are numbered is actually pretty easy....

3 Latest comment by Vigs