Author: Debra Dalgleish

Remove Excel Pivot Fields With Macros 7

Remove Excel Pivot Fields With Macros

If you’re rearranging a complex pivot table, it can take a while to manually remove each field. To make the job easier, you can remove Excel pivot fields with macros. There’s a sample macro...

How to Organize Your Excel Files http://blog.contextures.com/ 2

How to Organize Your Excel Files

Are your Excel files carefully organized, so you can find what you need in a few seconds? Or, are things messy, and it takes a miracle to find anything later? If that’s the case,...

how to make a marimekko chart 0

How to Make a Marimekko Chart in Excel

In a Marimekko chart, the column widths show one set of percentages, and the column stacks show another set of percentages. For example, show the size of market segments for computer sales, and company...

Excel COUNTIF Challenge http://blog.contextures.com/ 18

Take the Excel COUNTIF Challenge

Last week, in my Contextures Newsletter, I posted an Excel COUNTIF challenge. There were 100 codes on a worksheet, but when counted, the occurrences for each letter only added up to 99. What was...

Interactive Excel Chart 0

Create an Interactive Excel Chart

If you add a chart to a dashboard, it’s helpful to let people choose what they’d like to see in the chart. In this example, you’ll choose a date range, and select other criteria,...