Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Feb 27, 2012

It's Leap Year, so you'll have an extra day to work on Excel this month. That should give you enough time to read some of these Excel articles from the past week.

 -  Debra ddalgleish@contextures.com
 

Keep Track of Time in Excel

While working on projects, you can use keyboard shortcuts to enter start and stop times in Excel. Then, use formulas to calculate the total time that you spent on each task. 

Read the details on the Contextures blog article: Keep Track of Time in Excel

Filter Excel Data Onto Multiple Sheets

There is sample file on the Contextures website takes a list of sales orders, and filter them onto a separate worksheet for each sales rep.

When you click the worksheet button, a macro runs. It sets up a list of sales rep names, then loops through that list, creating a worksheet for each name.

This article on the Contextures Blog explains how it works, and gives you a link to the sample file: Filter Excel Data Onto Multiple Sheets

Unique Count in Excel Pivot Table With PowerPivot

In Excel, this is no built-in summary function that calculates a distinct count or unique count. As a workaround, you can add a column to the pivot table source data, and use a formula to calculate one or zero in each row.unique count workaround

If you are using Excel 2010, you can calculate a unique count by using the PowerPivot add-in.

Easy Two-Panel Line Chart in Excel

On the PeltierTech blog, Jon Peltier gives us step-by-step instructions for creating a two-panel line chart.

For an even easier solution, you can invest in Jon's Panel Chart utility, which does all the hard work for you.

Percent of True Items in a Pivot Table Field

On his YourSumBuddy blog, Doug Glancy shows us how to calculate the percentage of "Yes" items in a pivot table.
 
Doug adds an extra column in the source data, and shows the average of that column in the pivot table.

Excel Humour

Once again, I read the Excel tweets, so you don't have to! Here are a few favourites from this week. You can read the rest of the tweet collection here.
 
  • Building an Excel spreadsheet. You would think it would take me 10 minutes. It's taking forever.
  • Told her I was a great problem solver, quick thinker & proficient on excel. So I should just start with googling excel tutorials, right?
  • Ah, treacherous pivot table. You work for me yesterday but today you stab me in the eye...

Recommended Excel Tools

/td>

__

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.