Home 2008 Archives for July 2008

Archives for July 2008

July 31, 2008 1 Comment

How to reveal the formulas in all cells

Here are the steps to follow for this lesson:

  1. To reveal the formula in a single cell, double-click the cell or press the F2 key.
  2. To reveal all of the formulas in the worksheet use Ctrl + Tilde (Ctrl+˜) – This is a “toggle.”
  3. There are 4 ways to write a formula to show the discounted price:
    1. If the cell containing the discount % is a negative (-20%) number =B5+(B5*$D$2)
    2. If the cell containing the discount % is a positive (20%) number =B5-(B5*$G$2)
    3. If the cell containing the discount % is a negative (-20%) number =B5*(1+$D$2)
    4. If the cell containing the discount % is a positive (20%) number =B5*(1-$G$2)

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Videos

Link to this post!
Filed Under: Everyday Calculations in Excel, Excel Training, Tips and Time Savers Tagged: , , ,
July 28, 2008 1 Comment

How to calculate the percentage of discount received

Here are the steps to follow in this lesson:

  1. To calculate the % of discount received: =”Savings”/”Original Price.”
  2. Excel follows an “Order of Precedence” when performing calculations: It performs multiplication and division before performing operations involving addition and subtraction.
  3. Enclose portions of your formula inside () in order to control the order of your calculations.
  4. To determine the “Original Price” when you know the “Sale Price” and the “% of Discount”: =”Sale Price”/ (1-“% of Discount”)

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Everyday Calculations in Excel, Excel Training, Most Viewed Excel Videos Tagged: , ,
July 27, 2008 4 Comments

Keyboard Shortcuts – Part 1

Here are the steps to follow in this lesson:

  1. All shortcuts in this lesson require you to hold down the “CTRL” key while you press a single Letter.
  2. Ctrl+A will select either all of the cells in the current worksheet or just the range of cells where you are working.
  3. Ctrl+B (Bold), Ctrl+I (Italic) and Ctrl+U (Underline) will “toggle” the formatting on or off.
  4. Ctrl+D (Fill Down) and Ctrl+R (Fill Right) require you to select a range of cells beforehand.
  5. The “Office Clipboard” allows you to retain 24 items in memory. You can use them in all of the applications across the MS Office Suite. (Ctrl+F1 brings up the Task Pane for the Clipboard)
  6. Ctrl+Z (Undo) and Ctrl+Y (Redo) apply to the last 16 actions (provided you have not “saved” the workbook.)

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, Most Viewed Excel Videos, Tips and Time Savers Tagged: , , ,
July 27, 2008 Leave a Comment

I have added an Index of topics taught

Now, it is is easy to locate the video lesson that you are looking for. I have added an Index to the front page of this blog – Index of Topics Taught.

Just click on the topic and you will go directly to the video lesson.

As each new video lesson is added to my site, I will update the Index to add the link.

This suggestion came from one of my colleagues who reviewed this website. I welcome your feedback.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, MS Excel Training Tagged: , ,
July 26, 2008 Leave a Comment

Learn how to convert text in a cell into multiple columns

Here are the steps to follow in this lesson:

  1. Highlight the cells containing the text that you wish to extract.
  2. From the Data menu, choose “Text to Columns” and follow the Wizard.
  3. Choose the correct “Delimiter,” e.g. “Space” or “Tab.”
  4. Preview the result and click Finish.
  5. Cut and paste as needed.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Videos

Link to this post!
Filed Under: Excel Training, Text Functions Tagged: , ,
July 25, 2008 Leave a Comment

Learn to extract information from a text string

Here are the steps to follow in this lesson:

  1. Use the =LEFT() Function to extract characters at the beginning of a text string.
  2. Use the =RIGHT() Function to extract characters at the end of a text string.
  3. Be sure to distinguish “stored cell” entries from “formatted” or “displayed” cell values.
  4. Before you use the =MID() Function to extract characters in the middle of a text string, be sure to locate the starting location.
  5. The =MID() Function requires 3 arguments.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, Text Functions Tagged: , ,
July 25, 2008 Leave a Comment

Use the proper text function to change the case

Here are the steps to follow in this lesson:

  1. Use the =PROPER() function to convert your text string.
  2. Look out for names like “Mckinley” – You will need to edit these cells manually by:
  3. Changing the cells from Formulas to Values using Copy, Paste Special, Values. Then edit each cell.
  4. Before deleting a column of data, be sure to change the cells from Formulas to Values.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, Text Functions Tagged: , , ,
July 23, 2008 Leave a Comment

Use the =TRIM() Function to eliminate unnecessary space inside a cell

Here are the steps to follow in this lesson:

  1. When we wrote the formula =B4&” “&C4&” “&D4)  we found an unnecessary blank space between “First Name” and “Last Name” when the cell reference for “Middle Name” was blank.
  2. Edit that formula by using the =TRIM() Function to remove the extra space in the resulting cell.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Functions, Excel Training, Text Functions Tagged: , ,
July 22, 2008 2 Comments

Learn 2 ways to combine text from multiple cells into 1 cell

Here are the steps to follow in this lesson:

  1. Method #1 – Use the =CONCATENATE() Function Wizard.
  2. Text1 will be the cell reference for “First Name.”
  3. Text2 will indicate a SPACE between the 2 names. Type ” ” into the text2 indicator.
  4. Text3 will be the cell reference for “Last Name.”
  5. Method # 2 – Use the Ampersand (&) symbol in your formula e.g. =B4&” “&C4.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

Link to this post!
Filed Under: Excel Training, MS Excel Training, Text Functions Tagged: , ,
July 22, 2008 Leave a Comment

Responding to a customer complaint

Recently, I invited a colleague to visit my blog and to offer his suggestions.

I had to work hard to get my friend to even consider reading my blog (he told me that he avoided “blogs” as a matter of principle – he is a journalist by way of explanation.) 

He did visit this blog and then he (attempted) to offer me his comments. Unfortunately, I had made it too difficult for him to add his comments. I had required readers to “register” on my site before they could add a comment.

No longer!

I have opened the doors. Anyone can now contribute comments on any of my blogs – without having to register!

I need to thank my friend for bringing this customer irritation to my attention. I just wonder how many other readers I needlessly irritated.

I heard the complaint and I responded – I made the change. It made perfect sense to do so!

 

Link to this post!
Filed Under: Business Communications, Customer Service Tagged:
Next Page »