Search Contextures Sites
Excel Weekly News from Contextures Feb 27, 2012It'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 firstname.lastname@example.org
Keep Track of Time in ExcelWhile 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 SheetsThere 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 PowerPivotIn 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 FieldOn 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 HumourOnce 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
Contextures Inc., Copyright ©2017
All rights reserved.