Excel Interactive View 2: Sample Data

by Oz du Soleil | Oct 2, 2012 | Excel Geekdom, Spreadsheet Development | 12 comments

Live Data For Your Exploration of
Excel Interactive View

Hop in and Let’s Go!
The table below is random Data for 66 people whom I created with a Data Generator to display Excel Interactive View (click here for Excel Interactive View Part 1).

With Excel Interactive View you can stay on the web page and find:

Of the students counseled by Jones, how many have not paid their fees?
Which State has the most 21-year olds?
Which counselor has the most Mac students?
Who are the 23 and 24-yr olds with both Mac and Windows, in Indiana, Illinois and Wisconsin?

Go ahead. Click the button and see how you’re able to filter, sort, and look at different views.
Click the Excel icon and venture over to the Excel Web App for more power.

As Turtle Man, Ernie Brown says, “Getcha Some!”

(Please, if you do have questions, comments or requests, add them to the comments section below or, use the Contact page. I will respond.)

First Name	Last Name	State	Age	Fees Paid?	OS	Pass/Fail	Counselor
Charity	Booker	IL	21	Y	Win	P	Li
Kai	Wilder	WI	23	Y	Mac	P	Jones
Velma	Franks	OH	24	Y	Mac	P	de la Cruz
Xander	Duncan	OH	24	N	Mac	P	Li
Sonia	Bass	OH	24	Y	Win	F	Garrison
India	Carver	IL	23	Y	Both	P	Garrison
Raya	Santiago	TN	21	N	Both	P	Jones
Tyrone	Moore	WI	23	Y	Win	P	Cohen
Wyoming	Avila	PA	23	N	Mac	F	de la Cruz
Miranda	Bass	PA	21	Y	Mac	F	de la Cruz
Rhea	Abbott	IL	24	N	Both	P	Li
Colton	Forbes	WI	21	N	Both	P	Cohen
Gage	Knowles	PA	23	N	Win	P	Cohen
Alana	Bass	OH	21	N	Win	P	Cohen
Isaac	Day	IN	23	Y	Win	P	Li
Jenette	Moore	PA	21	Y	Both	P	Jones
Brandon	Carver	PA	23	Y	Mac	P	Li
Christine	Santiago	PA	24	Y	Mac	P	Li
Axel	Moore	IL	21	Y	Mac	P	de la Cruz
Charissa	Abbott	IN	24	Y	Both	P	Cohen
Jescie	Forbes	WI	24	N	Win	F	Li
Jackson	Knowles	PA	24	Y	Mac	P	Cohen
Bryar	Goodman	PA	22	N	Both	P	Garrison
Caleb	Hooper	IL	22	Y	Mac	P	Garrison
Wing	Mccarthy	WI	22	N	Both	P	Jones
Freya	Santana	PA	24	N	Win	F	Cohen
Charlotte	Foreman	OH	23	Y	Win	P	Li
Steven	Mckee	IN	23	Y	Win	P	Jones
Craig	Santos	PA	23	N	Mac	F	Li
Justin	Vazquez	PA	24	Y	Both	P	Li
Colorado	Wilson	PA	21	N	Mac	F	MacBrown
Kyra	Fitzpatrick	IL	22	Y	Both	P	Jones
Olympia	Shepard	IN	22	N	Both	P	Garrison
Clark	Fields	IN	22	N	Win	F	Li
Odette	Benjamin	PA	23	N	Win	F	Garrison
Malcolm	Pickett	PA	21	Y	Win	F	Jones
John	Rasmussen	PA	24	Y	Win	P	Garrison
Rudyard	Wilder	IL	23	N	Win	P	Jones
Elijah	Booker	IN	22	Y	Win	P	de la Cruz
Clinton	Booker	WI	22	N	Mac	P	Garrison
Juliet	Rasmussen	PA	21	Y	Both	P	MacBrown
Courtney	Randall	PA	24	Y	Mac	F	MacBrown
Kristen	Little	IL	23	N	Both	P	MacBrown
Ayanna	Padilla	WI	24	Y	Both	P	Garrison
Justine	Snow	PA	21	Y	Win	P	Garrison
Oscar	Bean	OH	23	N	Mac	P	Li
Alana	Neal	IN	22	Y	Both	P	Li
Duncan	Randolph	OH	21	N	Mac	P	de la Cruz
Lucy	Hardy	OH	22	N	Both	P	Jones
Meghan	Horton	OH	22	Y	Win	P	Cohen
Georgia	Buck	PA	21	Y	Win	P	Jones
Winifred	Cote	PA	23	Y	Win	P	Jones
Mauri	Ward	IL	22	Y	Mac	P	Garrison
Mo	Christensen	WI	24	Y	Both	P	Jones
Fredericka	Harding	IN	21	Y	Both	P	Li
Ryan	Conner	IN	23	N	Both	P	Garrison
Jillian	Doyle	IN	21	Y	Both	P	MacBrown
Georgia	Dudley	IN	24	Y	Win	F	de la Cruz
Brett	Cochran	IN	21	N	Mac	F	MacBrown
MacKensie	Woodard	TN	24	N	Both	P	Jones
Merrill	Sellers	PA	23	N	Mac	P	MacBrown
Rajah	Foley	OH	23	Y	Mac	P	MacBrown
Tim	Hayden	IL	22	Y	Both	P	de la Cruz
Debra	Gillespie	IL	21	Y	Both	P	Garrison
Christian	Hayden	IL	23	N	Both	P	Jones
Alix	Little	WI	23	N	Mac	P	Cohen

12 Comments

MrExcel on Wednesday 03-Oct-12 at 05:33 pm PDT

Oz – the Excel button is *awesome*! Every website manager should use it to bring their static pages to life.Here is one I set up: http://www.mrexcel.com/exceleverywhere.html
Reply
- OzData on Wednesday 03-Oct-12 at 07:23 pm PDT
  
  MrExcel Thanks for commenting and thanks for the link for more exposure of not only Excel Interactive View, but also the Excel knowledge that you share at MrExcel.comThis button is awesome indeed! The surprise of Excel Web App makes it all more awesome. We’ve gotta keep getting the word out to help encourage website managers to include the button on their data tables.Have you seen any unique uses for Excel Interactive view? I can see using Interactive View to do an initial review of data before bringing into Excel to then comb over it and discover it doesn’t have what we were looking for.This button is a big big deal.
  Reply
  - MrExcel on Wednesday 03-Oct-12 at 07:38 pm PDT
    
    OzData MrExcel I think any long list of items in a web page could benefit from it. Like the products listed in my example, you can filter to just Excel 2010 books aimed at beginners, then chart the results.I just finished updating Excel 2013 In Depth and the chapter on the Excel web app wins the prize for most improvements in the last 3 years. The other one I love is the Survey feature. Build a survey in Excel web app, publish the link. People get a form that they fill out, but the results are written directly into your Excel workbook! This is from the same team at Microsoft.
    Reply
    - OzData on Wednesday 03-Oct-12 at 11:23 pm PDT
      
      MrExcel OzData Survey feature? Straight into the workbook? I’ll have to dig into that.When is Excel 2013 In Depth expected to be available? I want to check it out because Excel 2013 is beautiful.The Flash Fill is already a feature I’ve benefitted from. But the internet integration features in Apps for Office are most intriguing and I see this area benefitting my clients in a big way as they ask for more data-retrieval and applications that touch the internet in some way.The web-integration celebrations describe Apps for Office integration with Python, HTML, PHP, etc but I haven’t seen many examples.Do you cover this in Excel 2013 In Depth?
      Reply
    - MrExcel on Thursday 04-Oct-12 at 04:53 am PDT
      
      OzData MrExcel Excel 2013 In Depth does not include any macros or programming examples, so nothing on creating Apps for Office. I am working on another book, VBA & Macros for Excel 2013 and my co-author will include one example of creating an app using javascript. But it won’t be the definitive book on creating apps. There are/were two Microsoft events to teach app creation – in Seattle earlier this week and in London soon and I could not attend either. Excel 2013 In Depth should publish in November. The VBA book and Pivot Table Data Crunching follow in December.
      Reply
    - OzData on Friday 05-Oct-12 at 01:54 am PDT
      
      MrExcel OzData
      Excel 2013 is reaching beyond a better version of Excel, it’s reaching deeper into the cloud. So, we’ll be on the lookout for the books in November and December.
      Reply
DaliaTendziagolskyte on Sunday 29-Sep-13 at 09:31 pm PDT

I would
like to ask, if it is possibility to add some more additional attributes in
Excel Interactive View button command list. I would like to have some kind of a
table like this one

Indicator Year

2009 2010 2011 2012

Population
Male

Female

Mortality

and make
filter just for “Year”, I mean, that it would be a possibility to choose year:
just 2010 or 2012 or all of its. Now Interactive View button make all columns
like filters (Year1, Year2, …) and let me pick particular value of year. I don’t
need to choose value in filtered year, I just need to select specific year. Is
it possibility to do with this Interactive View Button? At first I found this
Button I was surprised and happy, but when trying to do I really need,
something went wrong… Maybe it is some other possibility to do like this? I
would appreciate for You help! (mydestinyq@gmail.com)
Reply
MrExcel on Monday 30-Sep-13 at 01:32 am PDT

DaliaTendziagolskyte If I understand your question, you want the button to show/hide various columns of data based on the year that you select? I do not believe that is possible with this version 1.0 of the Excel Interactive View.
Instead, I would consider creating a pivot table in Excel with years going across. Add Year as a slicer. Publish the workbook to the SkyDrive and share the link (this is considerably easier in Excel 2013 than previous versions). The steps are fairly convoluted, so I used this topic as my podcast today: Learn Excel 1796 – http://youtu.be/8oLovrZ66zs
Reply
OzData on Monday 30-Sep-13 at 03:58 am PDT

MrExcel DaliaTendziagolskyte Dalia, thanks for the question. Mr Excel, thanks for jumping in and responding. Dalia didn’t have to wait for me to wake up and eat brreakfast. 🙂
Reply
DaliaTendziagolskyte on Thursday 03-Oct-13 at 10:18 am PDT

OzData MrExcel DaliaTendziagolskyte Thank You! It was very usefull!
Reply
OzData on Thursday 03-Oct-13 at 11:11 am PDT

DaliaTendziagolskyte OzData MrExcel No problem Dalia!
Keep in touch and let us know if we can be of help again.
Question: how do you use Excel? What’s your role?
Reply
DaliaTendziagolskyte on Thursday 03-Oct-13 at 07:17 pm PDT

MrExcel DaliaTendziagolskyte

I have another question. How I should create and modify Pivot
Table for making slicer as You recommended, if I have a table like this
one and want to add slicers not only for year, but also for columns of
group and indicator and so on.
Group Indicator Year
2010 2011 2012
Population Total
Population Male
Population Female
Mortality Total
Mortality Male
Mortality Female
I am just statistician and use Excel for my work.
Reply