Long Kept Secret For Generating Free Electricity – How would you like to create a generator which creates Free Electric Energy? Using our easy-to-follow guide, … Posted in California, Home improvements of free classifieds via Free Electricity for Home – – Free classifieds in California, Home improvements.
Author Archive
Free Electricity for Home – - Free classifieds in California, Home improvements Leave a comment
Wrapping Text in Excel Leave a comment
Wrapping Text For multiple line entries of labels, comments, notes, or descriptions in Microsoft Excel, select the cells (or an entire row or column), choose Format > Cells, pick the Alignment Tab, and check the option for Wrap Text, finish with OK. The column width will determine how many lines are needed to display the [...]
No Formula, Please Leave a comment
Formulas entered in Excel are relative to the cells they are entered in. Now you want copy the “result” of a formula to another cell. So you go ahead and copy the cell where the result is and “paste” it it into the new cell. Whoops! What hapened? The reult is not the same as what [...]
Entering Phone #’s – What a Pain! Leave a comment
These days to make a call you have to dial the 10 digit number…which means dialing the area code as well as the local phone #. Formating the # for each entry is a PAIN! For example to enter my phone number you would have to type “(613) 347-9893″. Thats a total of 14 keystrokes. [...]
Smart Data Entry Leave a comment
Here’s the scenario: You are maintaining a customer list in Excel. Your column names and widths are as follows: Note: To set column widths Select Format from the top menu then choose Column and select Width. Enter the names and widths shown below. Last Name = Lname [...]
Excel Can Find It! Leave a comment
Geez! I have a big file of customers with all their information including phone #’s & addresses . I want to talk to Jim Smith but I can’t find him in my Excel spreadsheet. I also know that I have a lot of “Jim”s in my spreadsheet. So let’s find the one I want. Go [...]
The Power of “Find” Leave a comment
The Power of the “Find” function in Word’s Edit menu will lower your frustration level. Place your cursor (Insertion Point) at the very top of your document… now let’s get started. Scenario: You have a form letter that you have addressed to a customer and you want to call the customer but you’re not sure [...]
Doesn’t Look Like a Fraction! 1 comment
Go to a blank cell in a worksheet. Enter the fraction 3/4. Hey! Wait a minute! I didn’t say March 4th …. I entered three quarters. Simple… I’ll just format the cell as a number or fraction (Format Menu/Cells) the result is 39145. Where did my fraction go? Here’s the answer. Excel automatically interprets your [...]
The Zero Dilema Leave a comment
Often you want enter a number that begins with a Zero (Invoices, Zip codes). How frustrating it can be when you want the preceding zero(s) to appear in the cell. In an Excel cell enter 0012345 and press enter. OOPS! No Zeros! – only 12345 appears. Go back to the cell and check the edit [...]
Separate Pages When Printing – Page Breaks Leave a comment
You can spend a lot of time inserting and deleting rows in your worksheet so that when you print it your information stops and restarts on the next page where you want it to. This can be very frustrating and cost you a lot of ink and paper when testing each adjustment. Help is on [...]
Page Borders in Word Leave a comment
Page Borders often present a problem that is easily solved, but is frustrating until you know about one small adjustment. The problem is that when you print your masterpiece, the page you have worked on so carefully, the bottom of the border does not print. The border looks fine, it is exactly as you wanted [...]
Does It Read Smoothly? Leave a comment
Sometimes you want to move a paragraph or two around in your document. For instance, you might want to move a paragraph from its current location to before the preceding paragraph. You can quickly move paragraphs by following these steps: Position the insertion point in the paragraph you want to move. While holding down the [...]
Getting around Your Document Leave a comment
I was working on a document with a student one day when we noticed a change needed to be made at the beginning of the line. I mentioned it and the student immediately held down the left arrow key to get to the error and fix it. I became impatient… using the arrow key takes [...]
Word Formatting Tip Leave a comment
Suppose your writing a multi-paragraph document but you would like to separate each with a formatted line. Try this … it will give your document a more professional look. Enter some text in a new Word document… don’t waste time typing… just copy any junk from an existing document. At the end of the text, [...]
What Day of the Week Is It? Leave a comment
When Did I do This? What if you’re using Excel to track the hours you are working for a customer. Naturally, you will use Excel’s date formatting in column A , # of hours worked column, a rate/hour column, a formula to calculate that day’s billing amount and a total billing to date column. Hey! [...]