| |
| Excel Solver
Posted in MS Excel > Basics by tutorialgrub on Jul 14, 2011
Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems. |
| |
| Excel Tables
Posted in MS Excel > Basics by tutorialgrub on Jul 13, 2011
Excel tables allow you to analyze your data in Excel very easily. |
| |
| Excel Pivot Tables
Posted in MS Excel > Basics by tutorialgrub on Jun 16, 2011
Excel Pivot tables are very powerful when you need to extract the significance from a large, detailed data set. |
| |
| How To Zoom Into A Spreadsheet
Posted in MS Excel > Basics by tutorialgrub on May 21, 2011
This video tutorial shows how to change the zoom settings in a spreadsheet |
| |
| How To Copy And Paste In Excel
Posted in MS Excel > Basics by tutorialgrub on May 19, 2011
This video tutorial shows how to copy and paste in Excel. |
| |
| Delete a Custom Number or Date Format in Excel 2007
Posted in MS Excel > Basics by tutorialgrub on May 10, 2011
Previously created custom number, date or time formats can be quickly deleted in Excel 2007. |
| |
| 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. |
| |
| VBA: Color Reference For Colorindex
Posted in MS Excel > Basics by tutorialgrub on Apr 16, 2011
When using VBA to code the Colorindex (or background color) of a cell it is useful to know what integer will equal what color. Below is a reference picture which shows the color and lists it’s respective Colorindex. aka VBA Color Palette |
| |
| Edit Data in Excel 2007
Posted in MS Excel > Basics by tutorialgrub on Apr 14, 2011
Edit data in Excel 2007 by using options in the shortcut menu and your keyboard to make simple editing changes to existing data. |
| |
| Customize the Status Bar in Excel 2007
Posted in MS Excel > Basics by tutorialgrub on Apr 12, 2011
Customize the status bar in Excel 2007 and make the overlooked status bar keep you up to date on the status of certain items within your Excel spreadsheet. |
1 2 3 4 >> Next |
