Use Multiple Functions for One Cell in Excel

How To : Remember the parts of the cell

Are you much for science? Cytoplasm. Nucleus. Endoplasmic reticulum. Organelle. These words might sound alien, but breaking down the parts of a cell and their functions will help you remember. This is one of the best ways for cell identification, and it's perfect for science c ...more

How To : Enter Excel data into cells with drop down menus

In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window o ...more

How To : Use functions and formulas 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 2nd installment in his "Highline Excel Clas ...more

How To : Deliver the sheet tab name to a cell in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 39th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the RIGHT, LEN, FIND & REPLACE ...more

How To : Sum dollar amounts from a column in Micrsoft 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 553rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

How To : Calculate commissions with Excel's IF & VLOOKUP

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 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

Use MS Excel cell references : relative & absolute

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 8th in ...more

How To : Use the UPPER & EXACT functions in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to ...more

How To : Create Double Exposures with Your Cell Phone

In photography, creating a double or multiple exposure photo involves combining two different images to make one single image. This technique has been used in film photography by exposing a piece of film twice to two different images. The second image becomes superimposed onto ...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 : Create a daily Gantt 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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart usi ...more

How To : Merge a range of cells in Microsoft Excel 2000

Using the Merge feature in Microsoft Office Excel 2007, you can quickly turn that worksheet into an easy-to-scan, appealing report. When you merge cells, you join several adjacent cells into one larger cell. Check out this tutorial and learn how to adjust the position of the c ...more

Altruistic Hacking : The Rise of the DIY Radiation Detector

Understandably, the tragedy in Japan has substantially risen the level of worldwide radiation-related hysteria. So much so, as an alternative to stampeding health food stores for iodine tablets, crafty individuals and organizations are hacking together personal radiation detec ...more

How To : Clear data & cell contents in Excel using a macro

In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number ...more

How To : Use a Verizon LG Fathom Windows Mobile smartphone

Whether you're the proud owner of a Verizon LG Fathom Windows Mobile smartphone or perhaps just considering picking one up, you're sure to benefit from this free video tutorial, which presents a complete overview of the phone's various features and functions. For more informat ...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 : Make Excel Work for You with This Training Bundle

Microsoft Excel is one of the most widely used tools in the professional sphere. It's also one that's difficult to master beyond a superficial understanding of how to input data. The All-In-One Microsoft Excel Certification Training Bundle can teach you how to make this multif ...more

How To : Here's the Ultimate Guide to Becoming a Data Ninja

Data analytics is crucial to the operations of every modern business. This trend is going to continue: in three years, 71% of global enterprises predict a rapid increase in data analytics. Experienced professionals that can project manage data initiatives are in high demand. ...more

News : 44 Cool New Features & Changes in Android 9.0 Pie

Even though most phones don't have Oreo yet, Google has released Android 9.0 Pie. It's available on Google's own Pixel devices, and updates should soon be available to partnered devices from Essential, Nokia, Oppo, Sony, Vivo, and Xiaomi. We're already digging into it to highl ...more

How To : Assemble a Survival Kit

I am writing this quick post in response to the recent earthquakes and tsunamis that are affecting Japan. As soon as the news broke, and we began to hear of tsunami warning for our area, I immediately realized how under prepared I was for a natural disaster. The thing that dro ...more

How To : Create a Tangent Line with Excel

Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for S ...more

How To : Calculate future value for an annuity 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 60th installment i ...more

How To : Calculate present value for an annuity 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 61st installment i ...more

How To : Solve KenKen puzzles with Will Shortz

Toss aside that Sudoku. Take a stab at the new craze to hit the Times: KenKen. New York Times puzzle editor Will Shortz introduces KenKen and gives a brief play-by-play demonstration of this new puzzle craze. In this video, Will Shortz speaks about how he found out about and ...more

Pygame : All You Need to Start Making Games in Python

Pygame! And what you can accomplish with it. Another python article... (Blame Alex for getting me hooked on yet another coding language...) This little article will cover "Pygame", the set of modules that were designed with game developers in mind. Specifically ones who code ...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 : A Simple Guide to Using Redstone in Minecraft

Welcome to Minecraft World! Check out our advanced tutorials and come play on our free server. As we all know, redstone can be a very useful tool for make basic things in Minecraft more complex and intricate. For beginners to redstone, today's article will give you a basic un ...more

  • Hot
  • Latest