If Statements in Excel

How To : Use nested IF statements in Microsoft Office 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 nested IF functions t ...more

How To : Use mixed cell references in formulas 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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

How To : Dominate the New York Times Crossword Puzzle

First off, don't be frustrated. YOU CAN DO IT! Contrary to the message in the image above, it's NOT over. It's just beginning. And when it comes to solving the New York Times crossword puzzle, the old cliche does apply: practice makes perfect. I've read quite a few books and ...more

How To : Calculate cash flow from assets in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 11th installment in ...more

How To : Check if a cell is empty using macros in Excel

Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Mac ...more

How To : Use the IF function with letter grades in Excel

This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is ...more

How To : Record and use macros in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52nd installment in his "Highline Exce ...more

How To : Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software ...more

How To : Bash (Shell) Scripting for Beginners

Bash (Shell) Scripting for Beginners Intro I am an occasional Linux user currently playing around in CrunchBang and loving it. Prior to this, I used to dual-boot Windows and xfce-buntu (or xubuntu) at work, and due to some unforeseen circumstances, my screen always went fuzz ...more

How To : Use the if Function in Excel

Video: . IF function This article describes the formula syntax and usage of the IFfunction in Microsoft Excel. Description The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. For example, the ...more

News : Excited About DeX? Here's a Reality Check

Samsung's new Galaxy S8 can turn into a PC with its DeX dock, but while that may sound like the future of mobile computing on the surface, there are definitely a few issues with the entire setup. The Samsung Desktop Experience (DeX) dock was debuted alongside the Galaxy S8 on ...more

News : Shadow Brokers Leak Reveals NSA Compromised SWIFT

The Shadow Brokers, a hacker group known for its dump of NSA hacking tools in 2016, has just leaked their remaining set of data which implies that the NSA compromised SWIFT, the global provider of secure financial services, to spy on banks in the Middle East. The hackers have ...more

How To : Break Bad News More Comfortably

Being the bearer of bad news is unpleasant; there's nothing more uncomfortable than offering up a spoonful of negativity. Whether you're a supervisor who spends a lot of time interviewing and rejecting candidates, or simply someone who has to say "no" to a friend, it's never f ...more

Next Page
Prev Page
  • Hot
  • Latest