How to do percentages in Excel

Today, I’m going to blaze through a few things you need to know about percentages in Excel. Of all topics, why percentages? Well, because whenever I review search data on Office.com, I frequently see search terms such as “percentages” and “percent increase” and “percent difference.”  Now, maybe you’re confused by how Excel handles number formatting. Or maybe you simply fell asleep in math class and need help creating the necessary formulas for calculating percentages. Or maybe I’m projecting. 🙂 Whatever the case, I hope this quick review helps.

Percentages 101

While Excel can do a lot of things, it can’t really teach you math. If you need a quick refresher on percentages, I recommend starting with a few excellent videos from The Khan Academy:

• Percent and decimals


• Solving percent problems


• Slightly harder percent problems

Displaying values as percentages

To show a number as a percent in Excel, you need to apply the percentage number format. To apply this format, select the cells that need formatting, and then click the Percent Style button in the Number group on the ribbon’s Home tab.



Of course, it’s even faster to use the keyboard shortcut for applying the format, which is Ctrl + Shift + %.

In Excel, the underlying value is always stored in decimal form. So, even if you’ve used number formatting to display something as a percentage (10%), that’s just what it is — formatting, or a symbolic representation of the underlying value. Excel always performs calculations on that underlying value, which is a decimal (0.1). To double-check the underlying value, select the cell, press Ctrl + 1, and look in the Sample box on the General category.



Percentage formatting can be (*ahem*) interesting. There’s a method to the madness, but you need to consider the following:

• Format existing values: When you apply percentage formatting to a cell that already has a number in it, Excel multiplies that number by 100 and adds the % sign at the end. This causes confusion, so let me explain what’s happening. Let’s say that you type 10 into cell A2, and you then apply the percentage number format. Because Excel multiples your number by 100 to show it as a percentage (remember that 1% is one part of one hundred), you’ll see 1000% displayed in the cell, not 10%. To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you ‘d expect. You can also just type the number in its decimal form directly into the cell — that is, type 0.1 and then apply percentage format.


• Format empty cells: Excel behaves differently when you pre-format empty cells with percentage formatting andthen enter numbers. Numbers equal to and larger than 1 are converted to percentages by default; numbers smaller than 1 that are not preceded with a zero are multiplied by 100 to convert them to percentages. For example, if you type 10 or .1 in a preformatted cell, you’ll see 10% appear in the cell. (Now, if you type 0.1 in the cell, something different happens. If you want details, see the More Information section in this KB article.)


• Format as you type: If you type 10% directly in the cell, Excel will automatically apply percentage formatting. This is useful when you want to type just a single percentage on your worksheet, such as a tax or commission rate.

If you’re still confused, I recommend that you watch Mike Girvin explain the percentage number format. Mike does a fine job describing the gotchas associated with this format.

Calculating percentages

As with any formula in Excel, you need to start by typing an equal sign (=) in the cell where you want your result, followed by the rest of the formula. So, I hear your next question in my head — which formula do I use to get the result I desire? Well, that depends. The basic formula for calculating a percentage is part/total = percentage, which might look something like this:



Now, let’s say that you want to reduce a particular amount by 25%, like when you’re trying to apply a discount. Here’s a formula that would get you that result. (Think of the 1 in the formula below as a stand-in for 100%.)



To increase the amount by 25%, replace the minus sign in the formula above with a plus sign.

The next example is slightly more complicated. Say the earnings for your department are $2,342 in November and $2,500 in December. What is the percentage change in earnings between these two months? To find the answer, divide the difference between December and November earnings ($158) by the value of the November earning ($2,342). Then, format the difference as a percentage with two decimal places.



You can find these and other examples in the Display numbers as percentages article on Office.com.

Need help with your formulas?

If you create formulas in Excel, you know that coming up with the right formula is often more art than science. The examples above are pretty simple. They’re meant to serve only as a jumping off point for creating your own formulas. If you need a more sophisticated formula for solving a percentage problem, or if you want troubleshooting advice, the best thing to do is ask a question in the Excel forum on the Microsoft Answers site.

You might also review the following videos, which cover common scenarios and formulas in more detail:

• Mike Girvin: Formulas for percent change / increase percentage / decrease percentage


• Mike Girvin: Percentage change formula and chart


• Bill Jelen (MrExcel): Calculate a running percentage of total
  

A few last tips before we part…

• Decimal places: Press Ctrl + 1 to open the Format Cells dialog box, and then click Percentage. In the Decimal places box, enter the number of decimal places that you want to display. For example, if you want to see 10% instead of 10.00%, enter 0. You can also use the Increase Decimal and Decrease Decimal buttons in the Numbergroup (Home tab).


• Rounding issues: Note that sometimes what you see in a cell (e.g., 10%) doesn’t match the number you expected to see (e.g., 9.75%). To see the true percentage in the cell, rather than a rounded version, increase the decimal places. Again, Excel always uses the underlying value to perform calculations.


• Negative percentages: If you want negative percentages to be formatted differently — for example, to appear as red text or within parentheses — you can create a custom number format such as 0.00%;[Red]-0.00% or 0.00%_);(0.00%). This technique is outlined in the Display numbers as percentages article.

Do you have other tips or formulas to share? If so, leave a comment. We’d love to hear from you.

How to use PowerISO as ISO Mounter?

PowerISO has a built-in virtual drive, which can mount iso files and other CD / DVD image files. There is no need to install any other virtual drive software to mount ISO file. It is very convenient to mount an ISO file. You can mount it using the main program, using the shell context menu, or using the PowerISO virtual drive manager.

Click Here To Download it

Usage1: Mount  ISO file using the main program:

• 
  

  Click the "Mount" button on toolbar. PowerISO shows the iso mounter menu.

  
  


• 
  

  Click a virtual drive from the popup menu.

  
  


• 
  

  Choose the iso file you want to mount, then click "Open" to mount it.

  
  

Usage2: Mount ISO file using the shell context menu:

• 
  

  Open "My Computer" and select the iso file which you want to mount.

  
  

• 
  

  Right-click on the file selected, the shell context menu will popup.

  
  


• 
  

  Choose the menu "Mount Image to Drive[X:]".

  
  

Usage3: Mount ISO file using the shell context menu:

• 
  

  Open "My Computer" and select the virtual drive created by PowerISO.

  
  

• Right-click on the drive selected, the iso mounter shell context menu will popup.

• 
  

  Choose the menu "Mount Image to drive".

  
  


• 
  

  Choose the iso file you want to mount, then click "Open" to mount it.

  
  

Usage4: Mount ISO file using the PowerISO Virtual Drive Manager:

• 
  

  Right- click the PowerISO sys-tray icon, PowerISO Virtual Drive Manager shows a popup menu.

  
  

• 
  

  Click a virtual drive from the popup menu.

  
  


• 
  

  Choose the iso file you want to mount, then click "Open" to mount it.

  
  

The first Video Uploaded to youtube!!!!

The domain name "YouTube.com" was activated on February 14, 2005, and during the next few months the website was developed. It was opened for uploads on April 23, 2005. The first YouTube video uploaded on April 23, 2005 was titled Me at the zoo, and shows co-founder Jawed Karim at the San Diego Zoo.

https://youtu.be/jNQXAC9IVRw

Me at the zoo is the first-ever video that was uploaded to YouTube. It was uploaded at 8:27 p.m. on Saturday, April 23, 2005 by the site's cofounder Jawed Karim, with the username "jawed" and recorded by his high school friend Yakov Lapitsky.

He created an account on YouTube the same day

The nineteen-second video was shot by Yakov Lapitsky at the San Diego Zoo, featuring Karim in front of the elephants, professing his interest in their "really, really, really long trunks"

Comment below for any Question that you want to know.

Is Computer Hacking a Criminal Activity?

First of all, I would say “No,” because computer hacking is an act of manipulating a computer to do what you want it to do and it’s a very valuable skill in the Tech world. Actually, that’s not a criminal activity. You can sit in your home and hack your own computer legally.

The only situation when it becomes a crime is based on the intent or motive of the person sitting behind the computer.

Whenever most people hear someone is a Hacker, the first thing that comes to mind is the person is a criminal. He/She must be responsible for some of those malicious emails in their inbox. But, that’s a very wrong ideology in generalizing a Computer Hacker.

Asking if Computer hacking is a criminal activity is like asking: “Is it a crime for a Policeman to hold a gun?”

It only becomes a crime when the Policeman starts  killing innocent  people with that gun on street like his Playing Call Of Duty. And, that policeman will face justice for sure, right? But, if the police uses that same gun to kill an armed robber who’s a threat on the street, it’s not a crime because the police has the authority to do so.

The same analogy can be applied to Computer Hacking. If prior rights and authority have been given by the owner of a computer infrastructure to hack and find security Vulnerabilities/Weakness, there’s no crime because you’ve been giving prior authority to do so.

So, who are the Criminals?

The cyber criminals are those hackers who have not been given any rights and authority to hack a computer infrastructure. There aim is to find security Vulnerabilities/Weakness in computer infrastructure and human behavior, then exploit/hack them for different aims, objectives and goals.

And, that’s what brings about different classifications of computer hackers based on their skills and intent.

• White Hat Hacker: White Hat Hackers are professional hackers who have been given prior authority and they use their Professional skills to try to Penetrate or Hack a computer infrastructure so as to patch any Vulnerabilities/Weakness before other hacker with different motive try to exploit them.

• Black Hat Hacker:  Black Hat Hackers are professional hackers(The Bad Guys) who have not given prior authority to hack a Computer infrastructure. They find security Vulnerabilities/Weakness in computer infrastructure, exploit them for Personal gain, motive and intent.  They perform random mass attacks, like sending spam emails. They also perform targeted attacks, like attacking corporate bodies/organizations for financial gain.

• Gray Hat Hacker: Gray Hat Hackers are professional hackers, too, but they use their computer skills for both white hat hacking and black hat hacking.

• Script Kiddies: Script Kiddies are hackers that do a lot of harm to computer infrastructures, including DDOS attacks, Defacing Websites, etc.. They use borrowed tools from Professional hackers they found on the internet. They have no prior knowledge of Cyber Security or even Computer programming. Once they see a script and knows what it does, they just take it and run it against the network without knowing what the script is doing. Maybe it’s even a script that will destroy their own computer but they don’t know.

• Hacktivists: These are hackers who are motivated by Political and Religious causes, like the famous “Anonymous Hacktivist group.”

I may have changed some of your ideologies about computer Hackers after reading this post to the end. So, now you know all hackers are not Cyber criminals.

 

Hope you have enjoyed this post. If you have recommendations or questions, you can drop them in the comment section below

Apple Online Store Now Offering Refurbished 12.9-Inch iPad Pro

For anyone that has been waiting to get their hands on the 12.9-inch iPad Pro, specifically for when Apple offers refurbished models, the wait is finally over.

As initially discovered by iPhone in Canada, the 12.9-inch iPad Pro is now available in the Apple Online Store, via the dedicated section for refurbished products. However, as noted in the original report, there isn’t a dedicated sub-section just for the iPad Pro lineup just yet. However, the tablet can be found in the iPad area, and scrolling to the bottom of the page.

Each of the models available are tagged with a 14 to 15 percent discount from the standard retail pricing. For instance, the iPad Pro with Wi-Fi and Cellular, with 128GB of built-in storage, will set a buyer back $919.00 — which saves the buyer $160.00.

Both the Wi-Fi and Wi-Fi + Cellular options are available, in a variety of storage options, so there should be a good match for anyone looking to pick up the 10 month old tablet.

Do you plan on buying a refurbished model?

A-Z Kali Linux: Useful Commands Everyone Should Know

a
apropos Search Help manual pages (man -k)
apt-get Search for and install software packages (Debian)
aptitude Search for and install software packages (Debian)
aspell Spell Checker
awk Find and Replace text, database sort/validate/index

b
basename Strip directory and suffix from filenames
bash GNU Bourne-Again SHell
bc Arbitrary precision calculator language
bg Send to background
break Exit from a loop
builtin Run a shell builtin
bzip2 Compress or decompress named file(s)

c
cal Display a calendar
case Conditionally perform a command
cat Concatenate and print (display) the content of files
cd Change Directory
cfdisk Partition table manipulator for Linux
chgrp Change group ownership
chmod Change access permissions
chown Change file owner and group
chroot Run a command with a different root directory
chkconfig System services (runlevel)
cksum Print CRC checksum and byte counts
clear Clear terminal screen
cmp Compare two files
comm Compare two sorted files line by line
command Run a command – ignoring shell functions
continue Resume the next iteration of a loop
cp Copy one or more files to another location
cron Daemon to execute scheduled commands
crontab Schedule a command to run at a later time
csplit Split a file into context-determined pieces
cut Divide a file into several parts

d
date Display or change the date & time
dc Desk Calculator
dd Convert and copy a file, write disk headers, boot records
ddrescue Data recovery tool
declare Declare variables and give them attributes
df Display free disk space
diff Display the differences between two files
diff3 Show differences among three files
dig DNS lookup
dir Briefly list directory contents
dircolors Colour setup for `ls’
dirname Convert a full pathname to just a path
dirs Display list of remembered directories
dmesg Print kernel & driver messages
du Estimate file space usage

e
echo Display message on screen
egrep Search file(s) for lines that match an extended expression
eject Eject removable media
enable Enable and disable builtin shell commands
env Environment variables
ethtool Ethernet card settings
eval Evaluate several commands/arguments
exec Execute a command
exit Exit the shell
expect Automate arbitrary applications accessed over a terminal
expand Convert tabs to spaces
export Set an environment variable
expr Evaluate expressions

f
false Do nothing, unsuccessfully
fdformat Low-level format a floppy disk
fdisk Partition table manipulator for Linux
fg Send job to foreground
fgrep Search file(s) for lines that match a fixed string
file Determine file type
find Search for files that meet a desired criteria
fmt Reformat paragraph text
fold Wrap text to fit a specified width.
for Expand words, and execute commands
format Format disks or tapes
free Display memory usage
fsck File system consistency check and repair
ftp File Transfer Protocol
function Define Function Macros
fuser Identify/kill the process that is accessing a file

g
gawk Find and Replace text within file(s)
getopts Parse positional parameters
grep Search file(s) for lines that match a given pattern
groupadd Add a user security group
groupdel Delete a group
groupmod Modify a group
groups Print group names a user is in
gzip Compress or decompress named file(s)

h
hash Remember the full pathname of a name argument
head Output the first part of file(s)
help Display help for a built-in command
history Command History
hostname Print or set system name

i
iconv Convert the character set of a file
id Print user and group id’s
if Conditionally perform a command
ifconfig Configure a network interface
ifdown Stop a network interface
ifup Start a network interface up
import Capture an X server screen and save the image to file
install Copy files and set attributes

j
jobs List active jobs
join Join lines on a common field

k
kill Stop a process from running
killall Kill processes by name

l
less Display output one screen at a time
let Perform arithmetic on shell variables
ln Create a symbolic link to a file
local Create variables
locate Find files
logname Print current login name
logout Exit a login shell
look Display lines beginning with a given string
lpc Line printer control program
lpr Off line print
lprint Print a file
lprintd Abort a print job
lprintq List the print queue
lprm Remove jobs from the print queue
ls List information about file(s)
lsof List open files

m
make Recompile a group of programs
man Help manual
mkdir Create new folder(s)
mkfifo Make FIFOs (named pipes)
mkisofs Create an hybrid ISO9660/JOLIET/HFS filesystem
mknod Make block or character special files
more Display output one screen at a time
mount Mount a file system
mtools Manipulate MS-DOS files
mtr Network diagnostics (traceroute/ping)
mv Move or rename files or directories
mmv Mass Move and rename (files)

n
netstat Networking information
nice Set the priority of a command or job
nl Number lines and write files
nohup Run a command immune to hangups
notify-send Send desktop notifications
nslookup Query Internet name servers interactively

o
open Open a file in its default application
op Operator access

p
passwd Modify a user password
paste Merge lines of files
pathchk Check file name portability
ping Test a network connection
pkill Stop processes from running
popd Restore the previous value of the current directory
pr Prepare files for printing
printcap Printer capability database
printenv Print environment variables
printf Format and print data
ps Process status
pushd Save and then change the current directory
pwd Print Working Directory

q
quota Display disk usage and limits
quotacheck Scan a file system for disk usage
quotactl Set disk quotas

r
ram ram disk device
rcp Copy files between two machines
read Read a line from standard input
readarray Read from stdin into an array variable
readonly Mark variables/functions as readonly
reboot Reboot the system
rename Rename files
renice Alter priority of running processes
remsync Synchronize remote files via email
return Exit a shell function
rev Reverse lines of a file
rm Remove files
rmdir Remove folder(s)
rsync Remote file copy (Synchronize file trees)

s
screen Multiplex terminal, run remote shells via ssh
scp Secure copy (remote file copy)
sdiff Merge two files interactively
sed Stream Editor
select Accept keyboard input
seq Print numeric sequences
set Manipulate shell variables and functions
sftp Secure File Transfer Program
shift Shift positional parameters
shopt Shell Options
shutdown Shutdown or restart linux
sleep Delay for a specified time
slocate Find files
sort Sort text files
source Run commands from a file `.’
split Split a file into fixed-size pieces
ssh Secure Shell client (remote login program)
strace Trace system calls and signals
su Substitute user identity
sudo Execute a command as another user
sum Print a checksum for a file
suspend Suspend execution of this shell
symlink Make a new name for a file
sync Synchronize data on disk with memory

t
tail Output the last part of file
tar Tape ARchiver
tee Redirect output to multiple files
test Evaluate a conditional expression
time Measure Program running time
times User and system times
touch Change file timestamps
top List processes running on the system
traceroute Trace Route to Host
trap Run a command when a signal is set(bourne)
tr Translate, squeeze, and/or delete characters
true Do nothing, successfully
tsort Topological sort
tty Print filename of terminal on stdin
type Describe a command

u
ulimit Limit user resources
umask Users file creation mask
umount Unmount a device
unalias Remove an alias
uname Print system information
unexpand Convert spaces to tabs
uniq Uniquify files
units Convert units from one scale to another
unset Remove variable or function names
unshar Unpack shell archive scripts
until Execute commands (until error)
uptime Show uptime
useradd Create new user account
userdel Delete a user account
usermod Modify user account
users List users currently logged in
uuencode Encode a binary file
uudecode Decode a file created by uuencode

v
v Verbosely list directory contents (`ls -l -b’)
vdir Verbosely list directory contents (`ls -l -b’)
vi Text Editor
vmstat Report virtual memory statistics

w
wait Wait for a process to complete
watch Execute/display a program periodically
wc Print byte, word, and line counts
whereis Search the user’s $path, man pages and source files for a program
which Search the user’s $path for a program file
while Execute commands
who Print all usernames currently logged in
whoami Print the current user id and name (`id -un’)
wget Retrieve web pages or files via HTTP, HTTPS or FTP
write Send a message to another user

x
xargs Execute utility, passing constructed argument list(s)
xdg-open Open a file or URL in the user’s preferred application.

y
yes Print a string until interrupted

After Kickass Torrents, Torrentz.eu Shuts Down

Weeks after torrents site Kickass Torrents was shut down following the arrest of alleged founder Artem Vaulin in Poland, another major player Torrentz.eu appears to have shut its portals on Friday, a media report said.

Torrentz.eu, considered the largest torrent meta-search engine, announced "farewell" to its millions of users.

Founded in 2003, Torrentz.eu had millions of visitors per day the site grew out to become one of the most visited torrent sites.

After more than 13 years of service, the popular site announced its farewell just a few hours ago, that too without any warning, Torrent Freak reported.

While the homepage is still active, Torrentz has completely disabled its search functionality and has similarly removed all torrent links. Torrent Freak claims it was contacted by the owner of Torrentz.eu, who "prefers not to comment at the moment."

"Torrentz was a free, fast and powerful meta-search engine combining results from dozens of search engines," a text read while searching for content.

The site's users are no longer able to login either. Instead, they see the following message: "Torrentz will always love you. Farewell."

Two weeks ago, Artem Vaulin, the alleged 30-year-old Ukrainian owner of Kickass Torrents, was detained in Poland after being charged with a four-count US criminal indictment which was followed by shutdown of the search engine.

Vaulin was charged with money laundering and violations of several copyright laws.