OK. I'm going to run with Excel & subtotals. This could get a bit harem
scarem but stick with it and I'm sure we'll get there
Step 1: set up your spreadsheet
1. Create 3 columns called 'Category', 'Name' and 'Features' - be sure to
format these differently than the rest of the cells e.g. larger font. Trust
me, it will stop Excel whinging on later.
2. Add your info to the rows - all columns 3 must be used. So row 2 = Hotel
: Hyatt Regency : Feature 1 and row 3 = Hotel : Hyatt Regency : Feature 2
etc. Autofill should make filling columns 1 and 2 a quick job.
3. Ensure data is sorted by 'Category' and then 'Name' (which will probably
happen by default as you fill in your info)
Step 1.5: set background colour
1. Make sure your corporate colour is available in the workbook by adding it
to Tools -> Options -> Colour -> select any box -> modify -> custom -> add
rgb values
2. Select all cells (ctrl+a) -> format -> cells -> patterns -> select your
colour
Step 2: subtotal twice
1. Click any cell in your data and Data -> Subtotal
2. Select 'Category' from the 'at each change in' drop down, 'Count' from
the 'use function' drop down and tick 'Features' in 'add subtotal to' box
3. Click OK - we know have our first level
4. With the selection still selected again go to Data -> Subtotal
5. Select 'Name' from the 'at each change in' drop down and untick 'replace
current subtotals'
6. Click OK. Now we're cooking with gas
7. Click the '2' in the outline pane thingo (if you can't see it go to
Tools -> Options -> View -> tick 'Outline symbols' in the 'Windows options'
group
8. Click the pluses and minuses to your heart's content
Step 3: get rid of 'Count' written everywhere
1. Go to Edit -> Replace (ctrl+h)
2. In 'Find what' type Count and leave 'Replace with' blank then click
'Replace all'
Step 4: make it look less like Excel (optional)
1. Select row below the last row of data -> ctrl+shift+down arrow -> ctrl+9
2. Select column to the right of last column of data -> ctrl+shift+right
arrow -> ctrl+0
3. Go to Tools -> Options -> View and untick all the stuff you don't need
(like headers, grid lines & scroll bars)
What do you think?
Lucy
--
Lucy Thomson
PowerPoint MVP
MOS Master Instructor
www.aneasiertomorrow.com.au