Free MS-Office books

Free MS-Office books MS Excel Basics Inserting A Row Tutorial Likewise, we can also insert rows. View Rating

Free MS-Office books MS Excel Basics Inserting A Column Tutorial Sometimes we (all) make mistakes or things change. If you have a spreadsheet designed and you forgot to include some important information, you can insert a column into an existing spreadsheet. View Rating

Free MS-Office books MS Excel Formatting Column Width Tutorial A question that everyone (who has ever worked on a spreadsheet) has asked at one time or another is, 'Where did all my numbers go?' or same question, 'Where did all of those ####### come from and why are they in my spreadsheet?' View Rating

Free MS-Office books MS Excel Formatting Formatting Numbers Tutorial We often need to format the numbers to display the appropriate number of decimals, dollar signs, percentage, red (for negative dollars), etc. It is best to keep numbers describing similar items as uniform as possible. View Rating

Free MS-Office books MS Excel Formatting Formatting Text Tutorial Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the formatting of text. We can use : bold face, italics, underline, change the color, align (left, right, center), f View Rating

Free MS-Office books MS Excel Basics Copy Forumulas: Fill Right Tutorial We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu -- Fill and Right. View Rating

Free MS-Office books MS Excel Basics Copy Forumulas: Absolute Positioning Tutorial Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the Column letter or a $ before the Row number (or both). This is called Absolute Positioning. View Rating

Free MS-Office books MS Excel Basics Copy Forumulas: Fill Down Tutorial Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is called Fill Down. View Rating

Free MS-Office books MS Excel Functions Function Wizard Tutorial In Excel there is a help tool for functions called the Function Wizard. Learn how to easily use functions with the function wizard. View Rating

Free MS-Office books MS Excel Functions PMT (loan stuff) Function Tutorial The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used for the car purchase in the first example. There are a few things that we must know in order for this functio View Rating

Page:  [<<]   1   2   3   4   5   6   7   8   9   10   11     [>>]