Advanced Filter Scenarios In Excel, pt 2

In which we make a named criteria range grow and shrink, in order to incorporate it into our solution of the Scenario manager and Advanced Filtering. We take care NOT to name this range Criteria, but rather some other name, so that it is not replaced when the Advanced Filtering happens.

To understand this, you probably want to view the preceding post first.

Advanced Filter Scenarios In Excel

This makes use of things covered during class, but puts them together nicely.
Part 1 of X

Excel Final Review

Here is a review of the Microsoft Excel final, explaining in detail what I was looking for.

Question 1:


Question 2:


Question 3:



Question 4:



Question 5:


Question 6, 7:


Question 8:


Question 9:


Question 10:


Question 11:


Question 12:


Question 13:

More Excel Videos

I lieu of class this Thursday, here are a bunch more excel videos to watch:

7) Circular References In Excel, part 4


8) Circular References In Excel, part 5


9) Circular References In Excel, part 6


10) Circular References In Excel, part 7


11) Custom Formatting in Excel, part 1 (runtime: 43 minutes)


See you next Tuesday!

Some Excel Videos

Here are a few videos on Excel, instead of class this Thursday:

1: PivotTable and PivotChart. Runtime: 31 mins


2: How to open up Excel Spreadsheets with macros in them.


3: Circular References in Excel part 1:


4: Circular References in Excel part 2:


5: Circular References in Excel part 3:


More on circular references later.

6: How to make a Gantt chart in Excel:

nothing here yet