eHow launches Android app: Get the best of eHow on the go.
How to Connect VB to Excel
How to Create an Excel Auto New Macro
How to Mail Merge in Excel
How to Make a Calendar Using Excel
How to Make a Form in Excel
How to Use Excel for Statistics
How to Write a Reset Macro for Excel
How to Write Macro Coding in MS Excel
Using Excel for Accounts
Using Excel for Project Management
Using Excel Macros
Using Excel Pivot Tables
Using Excel Templates
Using Excel Tutorials
Using Excel Visual Basic for Applications
Using Excel VLookup
What Is a Pull Handle in Excel?
Working Out Percentages in Excel
Summary: To work out percentages in Excel, simply enter a formula in the function box that divides one cell value by the other to achieve a percentage. Use a fill handle, or pull handle, to determine percentages in multiple cells with tips from an experienced Excel user in this free video on computer software.
Tonya Mason is an adjunct instructor and audio video equipment manager at a college in Cincinnati, Ohio. She has worked on various independent features, as well as, participated in...read more
"Microsoft Excel is a registered trademark of Microsoft Office Products and I am in no way, shape or form affiliated with Microsoft Office or Microsoft. What we want to do right now is go ahead and work with percentages in an Excel worksheet. As you can see I kind of put in a little bit of information here. I've got some phantom purchasers, I've got some phantom items, quantities ordered, and then quantities received. What I want to do is create how much of that shipment was actually received. So the easiest way to do that is to click up in the function box and type in equals D two which is our seventy-five items received divided by C two which is what we actually wanted to order. I've already form - right click on it and make sure that it's formatted to sell as a percentage. Click okay. Then next you want to go up to edit, fill, series, and then we're going to go by the column and the step value is going to be by one, and you click okay. You'd get your fill - auto fill handle, your pull down handle, and then it'll propagate the rest of the columns. And that is how you create percentages on an Excel worksheet."
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use † and Privacy Policy †. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License. † requires javascript
Comments
personalloanguy said
on 9/26/2009 Excel is the software that is used by students and professionals, with this tutorial video I can apply this to some of my business reports. Thanks a lot ma'm.