| |
| Goalseeking in Excel
Posted in MS Excel > Functions by tutorialgrub on Apr 02, 2011
The Goalseek feature allows you to specify the result you require and which input can change. Then the computer will calculate the required number. Very useful for break even analysis. This clip also shows you how to perform a goalseek straight off a graph. |
| |
| Controlling When Certain Formats Are Used Controlling When Certain Formats Are Used
Posted in MS Excel > Formatting by tutorialgrub on Apr 02, 2011
This tutorial looks at ways you can use conditional formatting to alert yourself when certain key values change in your spreadsheet (for better or worse). |
| |
| Speeding Up Data Entry with AutoFill
Posted in MS Excel > Basics by tutorialgrub on Apr 02, 2011
With AutoFill, you can fill out a sequential series of entries (such as months of the year or days of the week) across a row or up or down a column simply by entering the first entry in the series and then dragging the cell pointer by its Fill handle. |
| |
| Multiple Scenarios
Posted in MS Excel > Functions by tutorialgrub on Apr 02, 2011
The scenario feature allows you to quickly change a number of input cells based on some predefined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios easily |
| |
| How to Create a Simple Macro in Excel
Posted in MS Excel > Macros by tutorialgrub on Apr 02, 2011
Learn to create a simple macro in Excel using step by step instructions with screenshots. |
| |
| How To Format A Number To A Decimal In Excel
Posted in MS Excel > Formatting by tutorialgrub on Mar 10, 2011
This video tuorial shows how to format numbers to decimals in Excel. |
| |
| How To Change The Axis Color In Excel
Posted in MS Excel > Charts and Graphs by tutorialgrub on Mar 10, 2011
This video tutorial shows how to change the color of the chart axis in Excel. |
| |
| How To Autofill Data In Excel
Posted in MS Excel > Basics by tutorialgrub on Mar 10, 2011
This video tutorial shows how to autofill identicle data in Excel. |
| |
| How To Change The Chart Legend Font In Excel
Posted in MS Excel > Charts and Graphs by tutorialgrub on Mar 10, 2011
This video tutorial shows how to change the font of the chart legend in Excel. |
| |
| Find/ Replace in Excel
Posted in MS Excel > Functions by tutorialgrub on Mar 09, 2011
The find replace tool is more commonly used in MS Word. However, it is extremely useful in Excel and can be used to quickly make changes to a spreadsheet. |
<< 1 2 3 4 5 6 7 8 9 10 11 12 13 >> Next |
