http://www.brighthub.com/search/searchresults.aspx?u=1708&o=DateDescending&a=275Posts by Mr Excelen-UShttp://www.brighthub.com/office/home/articles/1984.aspxWed, 18 Jun 2008 19:56:31 GMTb133e95a-c263-4882-8f2a-b24547eff78e:1984mrexcelDid you know you can set up a simulator and play craps in Excel? Follow these simple steps and you can be throwing virtual dice ... and look like you are working on a spreadsheet while doing it. Creating a Craps Simulator in Microsoft Excel Strategy: Craps is a game played with two dice. On your first roll, if you roll a 7 or 11, you win. If yo...http://www.brighthub.com/computing/windows-platform/articles/1650.aspxThu, 05 Jun 2008 19:15:44 GMTb133e95a-c263-4882-8f2a-b24547eff78e:1650mrexcelProblem: You rarely use half of the icons in the Standard or Formatting toolbar. Why not create a Steve-O toolbar with just your favorites?
 See all Microsoft Excel tips Strategy: 1) Choose View – Toolbars – Customize. From the Toolbars tab, select New…, as shown in Fig. 119 2) Give the new toolbar a name, as shown in Fig. 120. You...http://www.brighthub.com/office/home/articles/2003.aspxThu, 19 Jun 2008 04:21:18 GMTb133e95a-c263-4882-8f2a-b24547eff78e:2003mrexcelProblem: You run an ice cream stand. After 10 days of sales, you discover that you either make a lot of money or nearly go broke. As you analyze sales, you feel that temperature and rain might be two important determining factors. On rainy or cool days, fewer people buy ice cream. See all Microsoft Excel tips As shown in Fig. 399, you set up th...http://www.brighthub.com/office/home/articles/7969.aspxFri, 01 Aug 2008 17:21:41 GMTb133e95a-c263-4882-8f2a-b24547eff78e:7969mrexcelIn his book, Success Made Easy, retail guru Ron Martin suggests using a daily chart to track your progress towards a goal. His chart shows progress towards the goal as well as where you need to be to remain on track. In the image, the straight line is the track. See all Microsoft Excel tips As shown in Fig. 1098, I can see from the chart that I am ...http://www.brighthub.com/office/home/articles/2023.aspxThu, 19 Jun 2008 21:31:09 GMTb133e95a-c263-4882-8f2a-b24547eff78e:2023mrexcelProblem: You have a large formula. You would like to visually see how the cell is calculated. See all Microsoft Excel tips Strategy: There are a few options. Option 1: Select the cell. Hit F2 to edit the cell, as shown in Fig. 490. As shown in Fig. 490, all of the references in the formula bar will light up with different colors. If the precede...http://www.brighthub.com/computing/windows-platform/articles/1654.aspxThu, 05 Jun 2008 19:47:53 GMTb133e95a-c263-4882-8f2a-b24547eff78e:1654mrexcelProblem: Every time you type the name of your WYA Division, as shown in Fig. 147, Excel changes “WYA” to “WAY”, as shown in Fig. 148. It is impossible to type WYA without entering it as a formula: =”W”&”Y”&”A. See all Microsoft Excel tips Strategy: There is a large list of words that are automatically replaced as you type. Excel added this feature ...http://www.brighthub.com/computing/windows-platform/articles/2766.aspxThu, 17 Jul 2008 21:05:28 GMTb133e95a-c263-4882-8f2a-b24547eff78e:2766mrexcelProblem: You want to buy a car. You want to compare eight price points and four loan terms to calculate the monthly payment amount. See all Microsoft Excel tips   Strategy: There are two methods. The cool method is to use a data table. As shown in Fig. 764, set up the worksheet as follows: 1) Enter one price in cell B2. 2) Enter one term i...http://www.brighthub.com/computing/windows-platform/articles/1656.aspxThu, 05 Jun 2008 20:18:05 GMTb133e95a-c263-4882-8f2a-b24547eff78e:1656mrexcelProblem: You have twelve monthly worksheets in a workbook. You’ve made changes to January and now need to copy the changes to the other eleven worksheets. See all Microsoft Excel tips Strategy: After you’ve successfully made changes to January, follow these steps: 1) Select the January worksheet. While holding down the Shift key, select t...http://www.brighthub.com/computing/windows-platform/articles/1659.aspxThu, 05 Jun 2008 20:37:51 GMTb133e95a-c263-4882-8f2a-b24547eff78e:1659mrexcelProblem: You suspect that there are cells in your data with text numbers instead of numbers. There is no easy way to visually locate these cells in versions before Excel 2002. In Excel 2002, these text cells, as well as a variety of other potential errors, are noted by a dark green triangle in the upper left corner of the cell. As shown in Fig....http://www.brighthub.com/office/home/articles/4838.aspxThu, 31 Jul 2008 18:29:50 GMTb133e95a-c263-4882-8f2a-b24547eff78e:4838mrexcelProblem: You created a chart with the F11 key. You need this chart to be an embedded chart. How can you change the location of the chart? See all Microsoft Excel tips Strategy:1) Right-click the chart. Choose Location, as shown in Fig. 1067. 2) As shown in Fig. 1068, in the Chart Location dialog, choose a new location. Gotcha: When you move...