MS Excel
-
So You Think You Can Use Microsoft Excel? A General Knowledge Quiz
Are you a newbie to Microsoft Excel? Can you whip a simple spreadsheet together without using help files? Sharpen your thinking cap and test your knowledge with this quick quiz.By October 14, 2011
-
Top Spreadsheet Functions in Excel
Microsoft Excel features a vast selection of functions and formulas that you can use to manipulate data to give you the results you're looking for.By September 26, 2011
-
Excel Worksheet Tab Tips and Tricks
Have you ever made changes to a tab in a Microsoft Excel workbook? If so, perhaps you would like to make changes to multiple tabs at once. There are a few ways you can make changes to multiple Excel tabs and this saves you time from having to edit...By September 13, 2011
-
-
Excel 2007: Check Multiple Conditions With Nested IF Functions
With the 2007 version of Microsoft Excel, nested IF functions became a lot more powerful. We’ll explain more about this type of function and give a specific case when one can be used when assigning letter grades.By August 10, 2011
-
Be a Power Excel User with Formula Tutorials
Formulas in Microsoft Excel are empowering. They allow you to create everything from charts to sales forecasts, with stops by apps as diverse as data tracking and financial software. Formulas are built with functions, and so we start with Excel function...By August 10, 2011
-
When and How to Use VLOOKUP and HLOOKUP
The VLOOKUP and HLOOKUP functions in Microsoft Excel are powerful tools that can be used to query a lookup table, but many get confused when it comes to actually constructing formulas containing these functions. In this article, we'll explain how...By August 6, 2011
-
-
Let Excel Calculate Your Age: What Functions to Use
There are many ways to create a formula that will calculate a person’s age in Microsoft Excel. In this tutorial, we’ll take a look at one of the most basic methods using the YEARFRAC function.By August 5, 2011
-
Biostatistics Calculations in Microsoft Excel – An Introduction
Do you have a lot of biostatistical data (or any other statistical data) and you don't know what to do with it? Let us help you, by showing you how you can derive some useful information from it, using MS Excel. Read this article for details...By July 7, 2011
-
The Best Free Online Excel Tutorials
Learn Excel from any of this list of the Top 5 free online tutorials. All of the 5 tutorial sites listed in this article are free for anyone to use. Why pay for books or lessons when you can learn Excel for free from these online resources?By June 9, 2011
-
The Ultimate Guide to Excel Tips & Tricks
MS Excel offers much more than anyone can expect. This article on Excel tips and tricks exposes the secrets of the spreadsheet to help you get more out of the application.By June 1, 2011