December 23, 2011 – 12:52 am
How to build a stacked bar chart with positive and negative numbers
Question: When I build a pivot able, and have 2 or more sets of row labels, the label to the left only shows once. How do I fill the data in columns in a pivot table?
April 12, 2011 – 12:47 pm
automate adding manual labels to PowerPoint graphs/charts
Is there a way in Microsoft Excel to insert a decimal place 5 places from the right side (i.e. the last 5 digits are decimals and everything left of that is a whole number) of a series of numbers with different lengths? I need to figure out how to insert the decimal so I can sum the totals for a check figure.
January 12, 2011 – 2:42 pm
Question: How do I change the pivot table so that if I have 2 or more row labels, they can be displayed side by side, in different columns vs. stacked in one column? In other words, please make my Pivot Table look like it did when I used Excel 2003.
My guess is that your pivot […]
September 14, 2010 – 10:58 am
In Excel 2010, Microsoft added a friendly visual interface for pivot tables
September 2, 2010 – 12:44 am
How to Convert Numbers to Currency Text for Mail Merge
August 19, 2010 – 2:09 pm
Calculate the number of Years, Months, Days between two dates
Microsoft Excel - Round numbers in the same cell without a formula
Micorsoft Excel has a neat feature called Precision As Displayed. Using this function automatically rounds all of the numbers in the spreadsheet to equal the number displayed. You can round without using the “=Round(number,round to number of digits)” formula.
For example, the number in cell C1 […]
Thanks to Rachelle for helping me figure this one out. In Excel 2007, pivot tables have a lot of new options, but some of the old functions seem to be missing.
For example, In the below table … I wanted to change the format so that the MRR and Term Values are stacked in the Pivot […]
Category Archives: 
BlogoSquare