excel

Blog Post

Use this Excel quick fill handle trick to insert partial rows and columns

June 10, 2013 7:20am PDT

Learn the many ways to insert entire and partial rows and columns in Excel, including a fill handle method.

1

Blog Post

Use SUMIFS() to sum by multiple conditions in Excel

May 30, 2013 12:30am PDT

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

5 Latest comment by DonG43

Blog Post

Build dynamic charts in Excel

May 28, 2013 1:22am PDT

Users will appreciate an Excel chart that updates right before their eyes.

3 Latest comment by GraemeLeggett

Blog Post

Use EDATE() and relative addressing to create a quick date matrix in Excel

May 28, 2013 12:26am PDT

With a little planning, you can create an easy-to-implement date matrix in Microsoft Excel.

7 Latest comment by jshewsbury@...

Blog Post

10 things that are hard to find (or gone altogether) in Office 2013

May 23, 2013 6:20am PDT

Is Office 2013 hiding the tools and options you rely on? Here are some features that have been reshuffled -- or removed.

82 Latest comment by ssharkins@...

Blog Post

A couple of time-saving autofill shortcuts for Excel

May 13, 2013 11:13am PDT

Learn these autofill tricks to work more efficiently with recurring data in Excel.

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

Excel 2013 Flash Fill anticipates needs on the fly

April 29, 2013 8:23am PDT

Put aside earlier list features and let Excel 2013's Flash Fill interpret your needs and complete the task.

4 Latest comment by Slayer_

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

Find the hidden talent in your organization

April 2, 2013 4:39am PDT

Hidden talent is the ultimate organizational resource. It's already present in your organization, doesn't require any procurement, and can be exploited without incurring any significant cost increase.

5 Latest comment by kwickset@...

Blog Post

Transposing Excel data via the fixed and live methods

April 1, 2013 1:32pm PDT

Excel provides two methods for transposing data. Whether you need a live link might be the condition that helps you choose the right one.

1

Blog Post

Three easy ways to use color in an Excel worksheet

March 11, 2013 10:44am PDT

These simple color tips for Excel can help you add a bit of color to designate purpose or task.

6 Latest comment by marj@...

Blog Post

10 advanced formatting tricks for Excel users

March 7, 2013 12:28pm PST

Your worksheets will be more polished and easy to read if you learn a few sophisticated formatting techniques.

16 Latest comment by hdas2012

Blog Post

Three ways to guide users through an Excel input range

March 7, 2013 8:20am PST

Susan Harkins describes three ways to ease the data input process in Excel.

3 Latest comment by Marshwiggle

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.

8 Latest comment by thanhonap

Blog Post

10 underused Office features

February 28, 2013 1:56pm PST

Microsoft Office is so feature-packed, most users barely scratch the surface of its functionality. See if you're using Office apps to their full potential.

64 Latest comment by NickNielsen

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 steps to creating a custom list for sorting in Excel

February 6, 2013 1:18pm PST

When you need to implement a special sort order that Excel can't accommodate, use this trick to set up a custom sort.

5 Latest comment by ssharkins@...

Blog Post

Highlight Excel list values when they change

February 4, 2013 11:04am PST

If your Excel lists repeats values and you need help finding changes, try this easy conditional format.

23 Latest comment by ssharkins@...

Blog Post

Display multiple subtotaling functions in Excel

January 21, 2013 12:05am PST

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

2 Latest comment by sparent