Monday, May 13, 2013

HOW TO MAKE SYMBOLS WITH KEYBOARD


I would to share few important symbols using Keyboard.


Alt + 0153..... ™... trademark symbol

Alt + 0169.... ©.... copyright symbol

Alt + 0174..... ®....registered ­ trademark symbol

Alt + 0176 ...°......degre ­e symbol

Alt + 0177 ...±....plus-or ­-minus sign

Alt + 2 ...........bla­ck smiley face

Alt + 15..........su­n

Alt + 12...........female sign

Alt + 11...........m­ale sign

Alt + 6............spade

Alt + 5............. ­Club

Alt + 3.............. ­Heart

Alt + 4............. ­Diamond

Alt + 13...........e­ighth note

Alt + 14............ ­beamed eighth note

Alt + 8721.... ∑.... N-ary summation (auto sum)

Alt + 251.....√.....s­quare root check mark

Alt + 8236.....∞..... ­infinity

Alt + 24............ ­up arrow

Alt + 25............ ­down arrow

Alt + 26..........ri­ght arrow

Alt + 27...........l­eft arrow

Alt + 18...........u­p/down arrow

Alt + 29.........left right arrow


Wednesday, March 27, 2013

Excel Percentage Formula

Percentages


 There are no specific functions for calculating percentages.
 You have to use the skills you were taught in your maths class at school!
Finding a percentage of a value

    





Example 1
A company is about to give its staff a pay rise.




The wages department need to calculate the increases.



Staff on different grades get different pay rises.











Finding a percentage increase 
     
















Example 2







A company is about to give its staff a pay rise.




The wages department need to calculate the new salary including the % increase.


Staff on different grades get different pay rises.












Finding one value as percentage of another











You will need to format the result as % by using the % button



on the toolbar.
Example 3







An manager has been asked to submit budget requirements for next year.


The manger needs to specify what will be required each quarter.



The manager knows what has been spent by each region in the previous year.


By analysing the past years spending, the manager hopes to predict


what will need to be spent in the next year.








Finding an original value after an increase has been applied









Example 4







An employ has to submit an expenses claim for travelling and accommodation.


The claim needs to show the VAT tax portion of each receipt.



Unfortunately the receipts held by the employee only show the total amount.


The employee needs to split this total to show the original value and the VAT amount.











Twitter Bird Gadget