Ch.19 for advanced Excel teaches you on using outline, group, subtotals and a bit of review on data validation. To create an outline in Excel go to data then group and outline. You have different options on what you want, such as you can auto outline the worksheet or you can group data as you wish. All you need to do is click on the types of groups or outlines you want. Subtotals are a rather easy feature on Excel. To use subtotals you highlight the data you wish to subtotal and go to data then subtotals. The subtotal feature allows you to subtotal by however you want according to your columns. You are able to find averages, counts and sums. This chapter also has a review on data validation. To use it you highlight what you wish to validate then go to data then validation. Just enter in what options you wish to have. You are able to circle already invalid data by opening the tools menu then formula auditing and then select show formula auditing toolbar.
The first project asks you to create an outline for an Auto Parts company number of parts sold. I did what you needed to do to create an outline and I chose auto outline and it looked good so I kept it. The second project asks you to make subtotals of the counts in each of the regions. Their way of subtotaling their data was not efficient enough so I changed the way to subtotal it. I eliminated all of the headings except for the top heading. I did add in the extra column to classify each item on what division it is a part of. Then I subtotaled it and it was more efficient and it looked better. The activity wants you to create a household inventory so I copied the inventory into Excel and used the sum feature on subtotal to create a subtotal for each category of household items.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment