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





Desktop Applications Tutorials

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


 

MMult Function
Posted in MS Excel > Functions by tutorialgrub on Apr 25, 2011

The MMULT function in Excel is used for matrix multiplication. It takes as inputs two arrays or matrices and outputs the matrix product of the two
278 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

SUMPRODUCT
Posted in MS Excel > Functions by tutorialgrub on Apr 25, 2011

The SUMPRODUCT function in Excel is a useful tool when you are working with large datasets or multiple arrays.
44 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

DAVERAGE Function
Posted in MS Excel > Functions by tutorialgrub on Apr 25, 2011

The DAverage function in Excel is used to calculate the average of values in database based on entered criteria.
312 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

Sorting Worksheet Data
Posted in MS Excel > Formatting by tutorialgrub on Apr 24, 2011

This technique introduces you to the process of sorting worksheet data. It begins by covering the basic sorting of the records in a data list using one, two, or even three fields in the list.
67 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

Upper to Lower Case Function “=PROPER()”
Posted in MS Excel > Functions by tutorialgrub on Apr 23, 2011

The following formula easily tranforms a list of data from Upper to Lower case. This is has come in handy several times.
69 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

Creating presentations - Part Two {Tutorial for beginners}
Posted in MS PowerPoint > Effects and Presentation by tutorialgrub on Apr 22, 2011

This step by step tutorials explains how to place elements, like images and titles, in the slides. Later, you will know some tricks on alignment to have everything perfectly organized in PowerPoint 2007. Follow the link for more details....
45 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

Sending Workbooks Out for Review
Posted in MS Excel > Formatting by tutorialgrub on Apr 22, 2011

Excel makes it easy to send out spreadsheets for review by clients, coworkers, and managers who need to give you their input or approval after reviewing their contents.
53 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

Managing Worksheet Windows
Posted in MS Excel > Formatting by tutorialgrub on Apr 22, 2011

This tutorial covers ways you can use worksheet windows to compare data, copy and move it between different regions of the same (or different) worksheets, and even move it from one workbook file to another.
64 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

Excel VLOOKUP
Posted in MS Excel > Functions by tutorialgrub on Apr 21, 2011

VLOOKUP in excel stands for vertical lookup. This simple function is extremely useful if you have large lists of data. With this function, you can easily search through a list of data and match specific criteria. I
138 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial
 

Scatter Plot Graphs with Trendline
Posted in MS Excel > Charts and Graphs by tutorialgrub on Apr 21, 2011

Scatter plots are used to see the trend of the data set as a whole instead of the sequential pattern of the data.
62 Views | 0 Comments | 0 Votes | 0 FavesShareAdd To FavoritesReport Tutorial


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