Skip to main content

Books

 

          

 








Comments

Post a Comment

Popular posts from this blog

Change from Lower to Upper Case in Excel

  1. Insert a new blank column to the right of your data. 2. Use a formula such as  =UPPER(D2) . To convert to lower case, use  =LOWER() . To convert to Proper case, use  =PROPER() . 3. Copy the temporary formula down to all rows by double-clicking the fill handle. 4. The entire range of new formulas will be selected. Press  Ctrl+C  to copy. 5. Press the left arrow to move to the original data. Right-click and choose Paste Values. 6. You can now delete the temporary column D. Additional Details : I to bring up the “W” program again, but here is another place where Microsoft Word could make this easier. If you had an entire table that needs converting, select the whole table, paste to a blank word document, then use the Change Case dropdown in the Home tab. After the conversion is done, copy from Word and paste back to Excel. #upper #Uppercase
Post a Comment
Read more

How many types of the predefined freeze panes are there in Excel?

  Freeze Panes in Excel is used to fix any frame or row or section of the table to access the data located so down below so that the user can see the header’s name as well. There is 3 type of Freeze Panes option available in View menu tab under Window section, Freeze Panes, Freeze Top Row and Freeze First Column. Freeze Panes is used to freeze the worksheet from the point where we keep our cursor. This freezes both the row and column both. Then to freeze a Row and a Column, we have a separate option to freeze each of them. Once we do that, we will see some portion of the worksheet will not move until we unfreeze it.
Post a Comment
Read more

Up and Down Markers using Conditional Formatting

There is a super-obscure way to add up/down markers to a pivot table to indicate an increase or a decrease. Somewhere outside the pivot table, add columns to show increases or decreases. In the figure below, the difference between I6 and H6 is 3, but you just want to record this as a positive change. Use  SIGN(I6-H6)  to get either +1, 0, or -1. Select the two-column range showing the sign of the change and then select Home, Conditional Formatting, Icon Sets, 3 Triangles. (I have no idea why Microsoft called this option 3 Triangles, when it is clearly 2 Triangles and a Dash, as shown below.) With the same range selected, now select Home, Conditional Formatting, Manage Rules, Edit Rule. Check the Show Icon Only checkbox. With the same range selected, press  Ctrl+C  to copy. Select the first Tuesday cell in the pivot table. From the Home tab, open the Paste dropdown and choose Linked Picture. Excel pastes a live picture of the icons above the table. At this point, adju...
Post a Comment
Read more