1. ExcelExposure.com

    This video explains how you can name cells and/or ranges for use within functions/formulas.

    I've found it incredibly useful throughout Excel, and it eliminates the worry that you're pulling information from the wrong area.

    # vimeo.com/30348580 Uploaded 84.1K Plays 0 Comments
  2. Video lesson from ExcelExposure.com on Advanced Filtering in Microsoft Excel.

    Using auto-filters in Excel provides a useful way to drill down and extract data from spreadsheets.

    This video lesson explains multiple ways you can use filters in Excel.

    Make sure to download the most recent Master Excel Workbook so that you can follow along at ExcelExposure.com

    # vimeo.com/38803911 Uploaded 71.9K Plays 0 Comments
  3. ExcelExposure.com

    Pivot Tables are an extremely useful way of analyzing large sets of data quickly and easily.

    This video provides a beginner's introduction to Pivot Tables.

    # vimeo.com/39800964 Uploaded 145K Plays 0 Comments
  4. Pivot Tables are extremely useful in Excel. This video lesson is a follow-up to the Introduction to Pivot Tables and covers the first round of advanced topics.

    The lesson goes over some additional Pivot Table options and features including:

    - Drill-down functionality which creates a summary sheet of any Pivot Table amount selected.

    - Pivot Table Options including show/hide totals, error/empty cell display options, and refresh when opening workbook (and more).

    - Value calculation options including sum/count/average, % of grand total, and % of parent row / parent column total.

    - Formatting / display options including row/column label layout, sorting labels, and other formatting.

    As always, download the latest version of the Master Workbook to follow along at home here: excelexposure.com/workbook/

    # vimeo.com/48967704 Uploaded 95.1K Plays 0 Comments
  5. This lesson picks up right where the last Pivot Table lesson left off.

    In this tutorial, you will learn:

    - How to use multiple levels of data within row or column labels.
    - Expand / collapse all functionality through right-click (Expand / collapse entire field)
    - Advanced filtering options including: right-click, row label, column label, and report filters. Includes multiple simultaneous filters, and using search/filter functionality within each data level.
    - ‘Defer Layout Update’ option which allows for changing fields without pivot table automatically updating.
    - Fields Section / Areas Section Stacked vs. Other Pivot Field List Formats.

    Make sure to download the Advanced Pivot Tables – Round 2 workbook to follow along with the lesson:

    # vimeo.com/57257055 Uploaded 132K Plays 2 Comments


King James

Browse This Channel

Shout Box

Heads up: the shoutbox will be retiring soon. It’s tired of working, and can’t wait to relax. You can still send a message to the channel owner, though!

Channels are a simple, beautiful way to showcase and watch videos. Browse more Channels.