microsoft excel

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.

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.

15 Latest comment by cmenkiti@...

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

Blog Post

Two dynamic chart enhancements using Excel

January 14, 2013 8:23am PST

These two Excel chart enhancements are easy to implement and will improve readability.

2 Latest comment by ssharkins@...

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

Four things I learned from readers in 2012

January 7, 2013 11:40am PST

Susan Sales Harkins shares a few Microsoft Office tricks she learned from TechRepublic readers during 2012.

1

Blog Post

Create an Excel data table to compare multiple results

December 28, 2012 12:57am PST

Suppose you want to view multiple possibilities within an Excel calculation. The answer is to create a data table.

4 Latest comment by tufte@...

Blog Post

The ten most popular Office tips of 2012

December 20, 2012 12:20pm PST

Susan Harkins lists ten of 2012's most popular Office tips published in the Windows and Office Blog, and the now inactive Office Blog.

12 Latest comment by skbinok