| |
| Excel Vlookup
Posted in MS Excel > Functions by tutorialgrub on Apr 28, 2011
The Vlookup function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column of the table. |
| |
| Quickly Finding the Workbook
Posted in MS Excel > Formatting by tutorialgrub on Apr 28, 2011
This technique covers ways to quickly and easily find the workbook file you want. |
| |
| Excel Ranges
Posted in MS Excel > Basics by tutorialgrub on Apr 27, 2011
A range in Excel is a collection of two or more cells. Learn how to work with Ranges. |
| |
| Using the IF statement
Posted in MS Excel > Functions by tutorialgrub on Apr 27, 2011
The IF statement is excel is very useful, but can become a little complicated. The following explanation will explain how to easily and properly use this function. |
| |
| COUNTIF Function - Cell Counting Tips
Posted in MS Excel > Functions by tutorialgrub on Apr 27, 2011
There are various methods used to count cells in Excel. We will be utilizing the COUNT function. |
| |
| Create a Thermometer Chart in Excel
Posted in MS Excel > Charts and Graphs by tutorialgrub on Apr 26, 2011
Thermometer charts in Excel are great for comparing actual figures against a target. This article looks at how to create a thermometer chart. |
| |
| Using Sparklines in Excel 2010
Posted in MS Excel > Charts and Graphs by tutorialgrub on Apr 26, 2011
Use Sparklines in Excel 2010 as a visualisation tool to see data trends at a glance. Sparklines are mini charts inserted inside cells of Excel 2010. |
| |
| VBA: Yes or No Message Box
Posted in MS Excel > Macros by tutorialgrub on Apr 26, 2011
Here is code to present the user with a Yes/No Message box. |
| |
| Find Payments Due this Week
Posted in MS Excel > Formatting by tutorialgrub on Apr 26, 2011
Use Excel to find payments due this week. Use an Excel formula in Conditional Formatting to alert you to payments due this week and next week. |
| |
| Lookup in a Column to the Left in Excel
Posted in MS Excel > Functions by tutorialgrub on Apr 26, 2011
Lookup data in a column to the left in Excel. The Vlookup function cannot look to the left in Excel. Index and Match can be used to lookup data from any column. |
<< 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 >> Next |
