Excel tutorial
Not what you're looking for?
Please see attached.
In column F you will find some cells and data exhibiting many of the skills you need to learn.
It is assumed you can copy and paste data.
This part describes how cells F6 through F10 were prepared.
To get the dark bold outline (from the top of row 5 to the bottom of row 10) you should use the outline/border icon on the formatting toolbar (in Excel 2007, find this on the formatting ribbon). Highlight all rows from 5 to 10. Then click the drop-down arrow beside the outline/border icon. Select the broad border icon.
You can then highlight row 9 and repeat and select the narrow bottom border.
The $ mark is achieved through two steps. First, highlight the cells (5 through 10) and click the $ mark format icon. Then highlight again and click twice on the fewer decimal point icon to remove the decimals.
To put the total in row 10, click on the cell F10, then type =subtotal(9,F5:F9)
Try this yourself for rows 14-16. Put the total in cell F17. You should get a total of $1,399.
The other skills you need can be practiced with cells H4 through J7.
First, you need column I to be wider. To achieve this, place your cursor in the space between columns I and J on the label row and quickly click twice (double click).
Next you need the total from cell F17 in cell J6. Place your cursor in J6, press the "=" key, then point to cell F17, then hit enter. (This process will also work across separate tabs.)
Third, in cell J7, type =subtotal(9,J5:J6)
This produces a total just like in cell F10, when you make another "subtotal" that crosses over this cell, the subtotal will be ignored.
Now make an appropriate label for row H through J7.
Finally, practice your formatting skills.
Purchase this Solution
Solution Summary
The solution provides an Excel tutorial on budget tools.
Purchase this Solution
Free BrainMass Quizzes
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.