column News and Other Resources

Blog Post

Build a simple timesheet in Excel

May 3, 2013 12:43am PDT

Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.

12 Latest comment by emma0123

Blog Post

10 tips for working with Word columns

May 1, 2013 6:17am PDT

One of the simplest ways to make a page more attractive and easy to read is to place the text in columns.

Blog Post

Mac sharing Part 2: File-sharing scenarios

April 23, 2013 11:52am PDT

Sharing files between Macs is easy and convenient. Here are tips for various file-sharing scenarios, including AirDrop and User and Guest account sharing.

Blog Post

Three tips for using Excel's conditional formatting more efficiently

April 8, 2013 8:06am PDT

These three tips will help you work more efficiently when using Excel's conditional formatting feature.

2 Latest comment by ssharkins@...

Blog Post

Determine the remaining number of days in the same year

March 18, 2013 8:20am PDT

Susan Harkins explains two ways to calculate in Excel the remaining number of days from a specific date to the end of the same year.

7 Latest comment by lee_dimambro@...

Blog Post

FooTable jQuery plugin tames tabular data in responsive web designs

March 12, 2013 6:00am PDT

Ryan Boudreaux demonstrates a jQuery plugin that will allow you to create responsive web designs, when tabular data must be presented on screens of all sizes.

2 Latest comment by Jason.Friend

Blog Post

How to find duplicates in Excel

March 5, 2013 10:56am PST

You'll need more than one trick up your sleeve to find duplicates in Excel.

7 Latest comment by ssharkins@...

Blog Post

Excel's Auto Outline quickly hides data details to simplify viewing

February 28, 2013 7:49am PST

Excel's Auto Outline feature quickly hides detail noise so you can view just a summary of your data.

Blog Post

10+ tips for working with Word tables

February 12, 2013 11:14am PST

Word's table tools are fairly straightforward, but there are a few tricks to using them efficiently.

1

Blog Post

10+ tips for working with Excel's Subtotal feature

January 14, 2013 7:46am PST

Excel's Subtotal feature can save you tons of time, especially if you know a few efficiency tricks.

3 Latest comment by jbenton@...

Blog Post

An easy technique for creating a floating column chart in Excel

November 27, 2012 11:23am PST

This quick Excel technique turns an otherwise complicated charting requirement into a simple task.

11 Latest comment by gobrannan@...

Blog Post

Using Excel's Text To Columns feature to clean up foreign data

November 20, 2012 7:24am PST

Work smart when cleaning up foreign data. Text To Columns can divide data and get rid of delimiters.

11 Latest comment by ssharkins@...

Blog Post

How to create and destroy an HP cloud server

November 7, 2012 6:00am PST

Nick Hardiman gives you the step-by-step procedure for creating and then destroying a cloud server from your HP Cloud account.

2 Latest comment by Nick Hardiman

Blog Post

10 steps to a multi-column search in Excel

July 5, 2012 7:22am PDT

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting.

1

Blog Post

A clever trick for filtering odd and even rows in Excel

April 26, 2012 8:12am PDT

If you want to see only odd or even rows in an Excel worksheet, use this quick filtering trick.

11 Latest comment by sanjyn

Blog Post

How to find the latest (or earliest) date and a corresponding value

April 24, 2012 7:25am PDT

Use this combination of Excel functions to find the latest date and return a corresponding value.

2 Latest comment by DBlayney

Blog Post

Two ways to build dynamic charts in Excel

April 19, 2012 11:48am PDT

Users will appreciate a chart that updates right before their eyes. In Excel 2007 and 2010 it's as easy as creating a table. In earlier versions, you'll need the formula method.

13 Latest comment by chip_long@...

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