Percentage of a Number in Excel

How To : Generate random numbers (with decimals) in Excel

This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=ra ...more

How To : Calculate and add running percentages in Excel

In this tutorial, we learn how to calculate and add running percentages in Excel. First, write out your value and percentage into the different columns. Next, write the formula in the cell where you want the answer to appear. To have the answer appear, highlight the box and dr ...more

How To : Control percentages with a scroll bar in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 46th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more

How To : Find the number given its percent

This video will provide you with insight into how to find a number given its percent. In the example provided, you needed to find the number which 33 is 60% of. This was achieved by simply taking the number which is a percentage of another number, in this case 33, and divide i ...more

How To : Solve basic percentages

In this video tutorial, viewers learn how to work out basic percentages. The key is to always find 10% of the number first. To find 10%, divide the number by 10. It's very simple because you simply move one decimal to the left. Once you have found the 10%, you can simply find ...more

How To : Calculate total savings in Excel

This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches f ...more

How To : Convert decimals to percents in math

This video is about the mathematical calculation to convert decimal to percentages. In this video, step by step calculations are shown. Let us take an example of a number; say 0.345, and we want to convert this decimal number to a percentage. Then we have to shift the decimal ...more

How To : Find percentages using a standard calculator

Want to find a percentage of one number relative to another? With a calculator, it's easy. And this free video math lesson will show you how to go about it. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have ...more

How To : Increase or decrease by a percentage

In this video, we learn how to increase or decrease by a percentage. First, to increase you will need to find what the percent of the number is. To do this, you will find 10%, which should be very easy. As soon as you've found this, you can add or subtract to find the percent ...more

How To : Convert percents to decimals

Math Problem Generator shows us how to convert the percentage into decimals in a simple and in a very effective manner. To convert the numbers from the percentage mode to a decimal mode you need to know how to shift the decimals. take any number which is in percentage mode, he ...more

How To : Use COUNTIF in Microsoft Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about Using COUNTIF function to c ...more

How To : Format dates & calculations in Excel

This is an Excel magic trick video in which the instructor shows how is time represented in Excel and how it is formatted before displaying it to us. He talks about the decimal representation of the time. He says that if O hour is mapped to the number zero and 24th hour of a d ...more

How To : Sort & find duplicates in Excel

This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another. In the column next to the sorted column it shows whether the (cell 1 is equal or not equal to the cell 2 directly undern ...more

How To : Solve for rate of change in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 29th installment i ...more

How To : Solve markup & markdown math problems in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 32nd installment i ...more

How To : Merge & unmerge cells in Excel

In this software video tutorial you will learn how to merge and unmerge cells in Excel. A cell in an Excel spread sheet is assigned a row and a column number. You will mostly need to merge cells when you are trying to create headers that span across two or more cells. For this ...more

How To : Understand car battery basics

For most automotive applications a battery needs to supply a lot of current for a short period of time to turn over the engine and get the car started. With the engine running, the car's alternator produces all the power the car needs. Thin plates inside a starting battery inc ...more

How To : Calculate weighted atomic mass

This video is about Level 2 atomic concepts, specifically the Pennium Lab. This helps you understand how atomic masses are derived for the periodic table. This teacher demonstrates how to do the calculation. He first reviews the Isotopes as they are different masses of the sam ...more

How To : Evaluate successive percentage changes

The concept of percentages may be a bit difficult to grasp for some beginner level learners. This video attempts to explain the concept of percentages in an easy to understand way. The concept of percentages is explained by using 10 percentage as a base - which of course has ...more

How To : Find the Percent Given Two Numbers

Whether you're shopping for deals, need help with a little math, or any number of other occasions, it's a valuable skill to know how to quickly figure out a percentage given two numbers. Let's say you're shopping and you come across a pair of shoes that are normally $45, but ...more

How To : Format decimals & fractions as inches in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

How To : Count Mondays between 2 dates in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more

How To : Conditionally format dates & weekends in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply c ...more

How To : Use OR, ISNUMBER and ISTEXT in Excel

ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a num ...more

How To : Win playing slot machines

In order to win at playing slot machines, you need to keep a few things in mind. Slot machines are not random. They are programmed to pay out at certain times, in certain amounts, and at certain intervals. Most states have laws stating the number of times or the amount of mon ...more

How To : Convert between fractions, decimals, and percents

In this tutorial the author explains of how to find out percentages of a given number. He explains that x percent of some number y is x multiplied by y and divided by 100. He goes on and explains this concept with numerous examples. He suggests a short cut to move the decimal ...more

How To : Calculate percentages by example

In this tutorial the author explains of how to find percentages using examples. He explains that x percent of some number y is x multiplied by y and divided by 100. He goes on and explains this concept with numerous examples. He suggests a short cut to movie the decimal point ...more

How To : Use YEARFRAC, INT, and DATEDIF in Excel

In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to ex ...more

How To : Group quantitative data into classes in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's Excel ...more

How To : Create a dynamic weekly chart in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 262nd installment in their series of Excel magic tricks, you'll see how to create a Weekly Chart that can sh ...more

How To : Convert decimals into fractions and percents

Decimal numbers, fractions and percents are pretty much three versions of the exact same value. In this tutorial, learn how to work with all three and convert them within each other. This video will walk you through the steps to convert a decimal into a fraction or a percentag ...more

How To : Find dates with Microsoft Excel's WORKDAY function

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 372nd installment in their series of digital spreadsheet magic tricks, you'll learn how to find th ...more

How To : Extrapolate given daily fixed costs in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 325th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

  • Hot
  • Latest