+ Reply to Thread
Results 1 to 7 of 7

Instructional video on dashboards and pivot tables in Excel

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    2

    Instructional video on dashboards and pivot tables in Excel

    I'm creating a series of free instructional videos on Excel. I have published the first one at https://www.pjw.me/data-analysis-and...with-excel.htm and I'd like to know what the members of this forum think. Is it too fast-paced? Too slow? My target audience is people that already have a basic understanding of how spreadsheets work, but might not be familiar with pivot tables or slicers.

    The attached Excel file is the end result of the video lesson. It's an interactive dashboard based on flight data from the Bureau of Transportation Statistics. I look forward to hearing feedback from the community!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-06-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    46

    Re: Instructional video on dashboards and pivot tables in Excel

    I have just started with Pivot tables, but you really show what can be done ?

    John B

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Instructional video on dashboards and pivot tables in Excel

    Hi John,

    I have tried to make the video very accessible to people with no prior experience using pivot tables. If you have Excel 2010 or 2013, you should be able to follow along and reproduce the results (an interactive dashboard) in about half an hour or less. Please let me know if there are specific topics in the video that need further explanation. I want to do a few more of these videos when I get the time.

    -Peter

  4. #4
    Registered User
    Join Date
    06-12-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: Instructional video on dashboards and pivot tables in Excel

    Very well illustrated. Thanks for preparing such vedio and sharing.

  5. #5
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: Instructional video on dashboards and pivot tables in Excel

    Hello Mr Peter..I saw this video and the language is simple to understand. Well will you please try to make a video with linking data to drop down list in order to make a dashboard? i know its confusing but it would be highly appreciated if u help me with this.....ty

  6. #6
    Registered User
    Join Date
    09-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Instructional video on dashboards and pivot tables in Excel

    This is great, I hope you decide to show more examples of what is possible to do with Excel.

    Doug

  7. #7
    Registered User
    Join Date
    02-11-2018
    Location
    san antonio, texas
    MS-Off Ver
    2013 & 2016
    Posts
    32

    Re: Instructional video on dashboards and pivot tables in Excel

    i am unable to see the hyperlik.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Open a video file in a specific point of the video
    By anbe45 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2013, 04:03 PM
  2. Excel Dashboards
    By RobertG5 in forum Excel General
    Replies: 1
    Last Post: 12-31-2010, 01:17 PM
  3. Excel Dashboards
    By SCM Krishna in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-28-2006, 05:17 AM
  4. [SOLVED] How does the term 'pivot' apply to Excel's Pivot tables and Pivot.
    By stvermont in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1