Question: I installed Picasa and now every picture or fax that I open, opens in Picasa. How do I change my settings so that Picasa is not the default picture viewer?
In Picasa go to Tools > Configure Photo Viewer and ‘check’ the button at the bottom that says “Don’t Use Photo Viewer”. Then press OK.
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?
To make this work, you need to be in the Classic Pivot Table view see this blog post for instructions on how to convert to the classic pivot table view: http://businesstoolsblog.com/2011/05/display-pivot-tables-with-the-row-labels-side-by-side-instead-of-in-one-column/
In a standard pivot table the row labels after the first row label are blank, like this:
If you want the row labels to appear on each row of your pivot table, so it looks like this:
Right click on the pivot table and select “Field Settings”
Then select the “Layout and Print” tab; check the box next to “Repeat item labels” and click “OK”
Your pivot table will now look like this:
Formatting this way is great if you need to use the data in the pivot tables for additional analysis.
Drew Moldane came up with this trick to automate adding manual labels to PowerPoint graphs/charts. This is great for displaying related data in a straight line on any chart. It also displays words that can’t otherwise be graphed. He won the high five Buddha … since this is a huge time-saver!
Please see below for the step-by-step walkthrough on how to convert manually added labels to linked labels. Please let me know if any of the steps don’t make sense or if you’re following along and I’ve missed something and I’ll correct. As I’m sure you know with these things, what might make perfect sense to me may come across confusing to the reader, so let me know if that is the case …hope this is helpful!
Step-by-Step:
1. Click anywhere within the chart
2. Click “Select Data” from the Design tab
3. Click “Add” in the Legend Entries (Series) box
4. Select the data that you want to appear as labels (this data may need to be manually added to the PPT chart excel sheet and then linked to your earnings supplement)
5. Edit the Horizontal (Category) Axis Labels
6. Select the numeric data for the Axis label range. Traditionally this data would be the dates
7. The “Select Data” box should look like the below screenshot, with CV added as a new Legend Entries and the CV values ($64, $61, etc) as the Horizontal Axis Labels
8. Return to the PPT and click anywhere within the chart
9. From the Layout tab “Current Selection” drop-down box, select the newly created Series and click “Format Selection”
10. In the new Format Data Series box, plot the series on the Secondary axis. Click OK and ignore the effects on the chart
11. From the Layout tab, click AxesSecondary Horizontal AxisShow Left to Right Axis and ignore the effects on the chart
12. From the Layout tab “Current Selection” drop-down box, select Secondary Horizontal (Category) Axis and click “Format Selection”
13. Format Axis Window:
a. Axis Options: select Major/Minor tick mark type: None, and leave the Axis labels: Next to Axis
b. Number: enter the custom Format Code below (this will create the M in the $xxM),uncheck Linked to source and click Add. There are various format codes for %, +/-, etc
c. Fill: No fill
d. Line Color: No line
14. Click Close. With the same Secondary Horizontal (Category) Axis selected, click the Home tab and format the Font Face/Size/Color/Bold to match the current format (most used color scheme settings below)
15. From the Layout tab “Current Selection” drop-down box, select Secondary Vertical (Value) Axis and click “Format Selection”
16. Format Axis Window:
a. Axis Options as shown below. Where the horizontal axis crosses should be the ONLY recurring manual step. This value will have to be updated depending on how the numbers shift. Pay attention to the Min/Max/Major unit on this page, as it will tell you about where the axis will cross and where it will show up on your chart
b. Fill: No fill
c. Line Color: No line
d. Click Close
17. Delete the current data labels / text boxes and voila! You now have labels that update automatically with the rest of your charts. No more nudging to get them to line up properly / remembering to update them! You still need to keep the “Contract Value = “ data label in place
18. Note: there are slight variations that have to be made for different chart types (%ages, etc), but the basic steps are the same
Why would excel default to Euros when you are sitting in Colorado, USA?
The setting for Microsoft Office default currency, dates, times, currency values, and numbers is controlled by in the Regional and Language Options section of your Control Panel.
To open the Regional and Language Options tool:
Click Start, and then click Control Panel.
Click Date, Time, Language, and Regional Options, and then click Regional and Language Options.
To change one or more of the individual settings, click Customize.
If you are sitting in Colorado, select “United States”, then click “OK”.
Question:
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.
Yes -
I broke this out into 5 steps and am including a one formula solution in the picture below.
Step 1: Count the characters using the LEN formula and subtract 5. This will tell you the number of characters that will be shown to the left of the decimal. =LEN(A3)-5 In the example below, there are a total of 12 characters. 12-5=7
Step 2: Use the LEFT formula to display the 7 characters that will be on the left of the decimal =LEFT(A3,Step 1)
Step 3: Use the RIGHT formula to display the 5 characters that will display to the right of the decimal =RIGHT(A3,5)
Step 4: Concatenate the LEFT and RIGHT results of Step 2 and 3 with a decimal in between =Step2&”.”&Step3
Step 5: Change the concatenated cell to a value using VALUE formula =VALUE(Step4)
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 table looks something like this:
And you want them to look like this, with the Labels in separate columns:
Just right click on the pivot table and select “PivotTable Options”
Then check the box next to “Classic Pivot Table layout” and click “OK”
Your Pivot Table now looks like this:
In Excel 2010, Microsoft added a friendly visual interface for pivot tables. Excellsfun has a great video that shows how to use THE SLICER.
Did you ever try to use numbers in an excel spreadsheet to populate a Word document using mail merge? If you have then you probably noticed that MS Word loads any number in general format. Number formatting problems in a mail merge occur when the cells that contain the numbers in the Excel worksheet are formatted as Number, Currency, Date, Percentage, etc.
Example, $1,000.00 in Excel will load as 1000 into a mail merge document.
One way to make the number look like currency in your Mail Merge is to create a new column in excel that converts the number $1,000.00 into Text. Use the following formula: =TEXT(A1,”$#,##0.0″)
Before you use the mail merge, hard code the column with the =TEXT(A1,”$#,##0.00″) formula. When you import the new column into your mail merge document it will appear as currency.
Rachelle Haid is a an Excel wiz and came across this snazzy feature that finds the number of years, months, or days between two dates.
If you want to know the number of days between 2 dates, just type: =DATEDIF(CELL1,CELL2,”d”).
If you want to know the number of months between 2 dates, just type: =DATEDIF(CELL1,CELL2,”m”).
If you want to know the number of years between 2 dates, just type: =DATEDIF(CELL1,CELL2,”y”).
“What should we give to say thanks to our loyal customers and employees?
© 2007 Business Tools Blog. Powered by Wordpress wearing MyJournal Hypereal by 
BlogoSquare
There are currently 641 posts extending over categories with loads upto 580 comments with valid XHTML and CSS.
