| |
| GoTo Special in Excel
Posted in MS Excel > Functions by tutorialgrub on May 22, 2011
Due to the size of spreadsheets it would sometimes be useful to quickly highlight all cells exhibiting the same criteria. This features allows you to highlight cells that contain comments, constants or formula, blanks, Objects (pictures, buttons, etc), cells in rows or columns that are different from their neighbors, precedents and dependents, last cell in a sheet, and cells with conditional formatting or data validation. |
| |
| GROUP and UNGROUP in Excel
Posted in MS Excel > Functions by tutorialgrub on May 21, 2011
Learn how to group and ungroup rows and columns so that you can easily hide or unhide the rows and columns you are interested in. |
| |
| Data AutoFilter in Excel
Posted in MS Excel > Functions by tutorialgrub on May 20, 2011
The Data Autofilter allows you to investigate large quantities of information and filter out unnecessary rows. Extremely useful if you work with large quantities of data. |
| |
| How To Use The Square Root Function
Posted in MS Excel > Functions by tutorialgrub on May 20, 2011
This video tutorial shows how to use the square root function in Excel. |
| |
| External Links in Excel
Posted in MS Excel > Functions by tutorialgrub on May 20, 2011
Excel is often used to link multiple spreadsheets. However, the risks associated with handling these links is often misunderstood. This will show you a feature in Excel which allows you to identify your external links, change the source if necessary and break links. |
| |
| LEFT, RIGHT and MID in Excel
Posted in MS Excel > Functions by tutorialgrub on May 19, 2011
These text functions give you the ability to to extract certain segments of a cell (normally text). Useful if only part of a cell's text contains the information you want.. |
| |
| How To Use The Log Function
Posted in MS Excel > Functions by tutorialgrub on May 18, 2011
This video tutorial shows how to use the logarithm function in Excel. |
| |
| DAYS360 Function
Posted in MS Excel > Functions by tutorialgrub on May 13, 2011
The DAYS360 function is used to calculate the number of days between two dates. It is based on a 360 day calendar. |
| |
| VLOOKUP Errors
Posted in MS Excel > Functions by tutorialgrub on May 13, 2011
As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for. |
| |
| 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. |
1 2 3 4 >> Next |
