Excel 2010 Business Math 26: Percent Conversions: By Hand and In Excel

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Girvin at Highline Community College.
In this video:
1. Conversions: Write A Decimal As A Percent
2. Conversions: Write A Percent As A Decimal
3. Conversions: Write A Fraction As A Percent
4. Conversions: Write A Percent As A Fraction
5. Conversions: Write A Fractional Percent As A Number

Category:

Education

Tags:

• Excel
• 2010
• Business
• Math
• Mathematics
• Mike
• excelisfun
• Girvin
• Highline
• Community
• College
• Slaying
• Dragons
• Percent
• Conversions:
• By
• Hand
• and
• In
• Decimal
• As
• Fraction

[richardkinzer]

Mike are you using a stylist of some sort (Wacom?) on your PwrPt or your mouse, to use the pen tool? I like the idea of turning the screen into a whiteboard.

I'm learning to teach as well as better Excel from you. That's a little more I'll have to put on my account that I owe you.

[ExcelIsFun]

@richardkinzer , the way the "account that I owe you" works is that it is not really an account; because at the moment that you help someone else, that is the payback. The act of helping makes the world a better place and that is the reward! Anytime you teach - you make the world a better place!

Yes, you can just turn on PowerPoint in Slide Show Mode, right-click and point to pointer: then draw. I also have a "Bamboo" stylist ("Bamboo" is the name and it is quite old...).

[brian4ca]

When I highlight my decimals & use CTRL+SHIFT+% then it changes the cells to a percentage format. Can I make this default to have 2 decimals though? If my cell is .025 then it'll change it to 3%. Instead, I need 2.50%. It'd just be nice to set that default somehow in Excel if possible.

[ExcelIsFun]

@brian4ca , I totally agree!! I never use that keyboard because it shows zero decimals. I wish there is a way to change that default. I do not know of a way. The only way I know is to record a Macro and then assign it to a button on the QAT. But I just use the Number Format drop-down in the Number group in the Home Ribbon tab and point to the Percent with Two Decimals.

[brian4ca]

Thanks.