| |
| 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 |
| |
| 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. |
| |
| 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. |
| |
| 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. |
| |
| 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. |
| |
| 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.... |
| |
| 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. |
| |
| 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. |
| |
| 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 |
| |
| 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. |
<< 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 >> Next |
