Home Archives for Interactive Webpages
June 28, 2011 2 Comments

How to Embed an Interactive Excel Workbook from a Sky Drive in Windows Office Live!

For the past two or three months, I have been uploading the Excel Workbooks that I use during my video tutorials to my Sky Drive at Windows Office Live! – www.office.live.com Just this past week, I learned that I can also “embed” those stored files here – in a blog post – on my website! So, here is my first attempt to share an “interactive Excel Workbook” with you.

Embedded Excel Workbook

This Excel worksheet is one of the basic data sets that I use when I demonstrate how to create Excel Pivot Tables. Scroll horizontally or vertically to see the Pivot Table. Notice that you can use the drop-down filters in the Pivot Table!

Click the Icon in the lower right corner of the Excel WebApps frame and you will be taken to my Sky Drive online where you can view or manipulate the worksheet in Full Screen More. Or, you can choose to download this file to your computer to work on it with the full range of Excel commands.

Download Excel Video Tutorial Recordings for $9.95

If you want to learn more about Pivot Tables, click on this link to gather information on my new series of Extended Length (one hour +) Excel Video Tutorials. You can download these videos to your computer for only US $9.95 from my WebEx by Cisco site – http://thecompanyrocks.webex.com – I store all of the Excel Workbooks that I use in the lessons on my Sky Drive online!

Watch This Video Tutorial in High Definition on YouTube

Follow this link to watch my step-by-step instructions to accomplish this task – in High Definition – on my YouTube Channel, DannyRocksExcels.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Download Files from Video Lessons, Excel Training, Interactive Webpages, Pivot Tables, WebEx Recordings & Webinars, YouTube Videos by Danny Rocks Tagged: , , , , , ,
October 25, 2010 Leave a Comment

How to Use the VLOOKUP Function in Excel

The VLOOKUP Function is one of the essential Excel functions that you need to understand in order to work with data tables, invoices and product listings. In response to numerous email requests, I created this video lesson to walk you through each step.

I share my best practices which include:

  • Use a “named cell range” for your “array.” The “array” is the table that contains the information that you are looking up.
  • Make sure that the “Leftmost” column in your array is sorted in ascending order and that this column contains the values that you are looking for.
  • Use “FALSE” as the optional fourth argument when you need to find an “exact” match in the Leftmost Column.

Work with Excel Workbook Used in This Lesson

Purchase DVD-ROM

You can learn more about essential Excel Functions on my DVD, “The 50 Best Tips for Excel 2007.” You can buy it now!

Learn how to “Master Excel in Minutes – Not Months!”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
How to Use the VLOOKUP Function in Excel [ 5:36 ] Play Now | Play in Popup | Download (1006)
Link to this post!
Filed Under: Excel Functions, Excel Training, Interactive Webpages, Lookup Functions in Excel, Podcast Tips & Timesavers Tagged: , , , , , ,
March 25, 2009 Leave a Comment

12 Excel Practice Files to Download

I want to thank the viewers who emailed me and responded to the Poll on this blog. I have now uploaded 12 Excel Practice files to this blog. Follow this link to navigate to the Download Excel Practice files page.

  • Click on the Practice file that you are interested in.
  • Right-click the Icon to determine how and where to open the practice file.
  • The Practice files are saved as “Interactive Web Pages.” From here, you can decide to work with the file over the Internet or to save it to disk as an Excel Workbook.

I will be adding additional Practice files – approximately three each week – so check back to locate the latest files that I have downloaded. If there is a particular file that you want to work with, email me your request – danny@thecompanyrocks.com and I will make it available as quickly as I can.

Thank you for your continuing support of The Company Rocks!

Sorry, there are no polls available at the moment.
Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Excel Training, Interactive Webpages Tagged: , ,
March 14, 2009 4 Comments

How to Publish an Excel Workbook as a Webpage

How good is your information – if you or your colleagues can not access it when you need it?

Not good enough!

I love USB Flash Drives for their portability. But, when I need – or I need to send an Excel Workbook – halfway around the world …? I need a better way to access that information.

I need to learn how to publish my Excel workbook as Web page – complete with Interactivity. Watch this short video lesson as I demonstrate how to:

  1. Save an Excel Workbook as a Web-page – be sure to enable Interactivity.
  2. Add, edit and delete data in the workbook while on-line.
  3. Send the Webpage version of the workbook back to Excel – to communicate my changes or to further analyze the data.

News! My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.

Related videos

Looking for the solution to an Excel problem? Search my Index of Excel Video Lessons.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Excel Training, Interactive Webpages Tagged: , ,
March 9, 2009 Leave a Comment

Do You Want Copies of My Excel Workbooks?

I have a question for you?

I just added an “interactive copy” of my Excel Workbook for my video lesson – “Rearrange Your Columns – Sort from Left to Right”

Here is the link to the workbook.

My question is: Should I go back and add links to the Excel Workbooks for earlier lessons? To make it easy for you to respond, I have included a quick poll to the right sidebar on this page (at the bottom of the sidebar).

Thanks in advance for your response!

Danny

Sorry, there are no polls available at the moment.

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Excel Training, Interactive Webpages, MS Excel Training Tagged: , ,