19,154 tutorials online
20 tutorials pending review
763 dead links removed





Desktop Applications Tutorials

Subcategories:
MS Excel, MS PowerPoint, MS Word, QuarkXPress


 

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.
141 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
156 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
107 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
314 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
64 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
466 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
137 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
51 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
193 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

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.
133 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial


<<  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18    >>  Next