1. 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
  2. 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.2K Plays 0 Comments
  3. One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works. I've created this lesson in an attempt to introduce the most basic information about what Excel is and go over some examples of what it could be used for.

    Throughout the lesson, I explain the following information and questions in great detail:

    Disclaimer: If you're pretty familiar with Excel, this video may be extremely boring. You have been warned!

    - What am I looking at when I open Excel for the first time?

    - Explanation of Column / Rows and how referencing works.

    - Navigating Excel, knowing where you are in the spreadsheet, and the 'name box'.

    - Overview of sheets including adding, deleting, and renaming.

    - Explanation of hard-coded values vs. formulas/functions, and Excel default cell formats.

    - Formatting options including bold/underline, alignment (e.g. centering), and creating borders.

    - Information about the formula bar, and how to use the 'Insert Function' feature.

    - Example of creating a simple personal finance tracker and how to input information into Excel.

    - Introduction to the Master Workbook, including the function listing and previews of examples from other lessons.

    Feel free to show this lesson to anyone who wants to learn Excel but doesn't know the first thing about getting started!

    # vimeo.com/52821278 Uploaded 507K Plays 3 Comments
  4. Error Checking and Data Monitoring in Excel

    Download the Error and Data Checking workbook to follow along with the video lesson:
    excelexposure.files.wordpress.com/2013/04/error-and-data-checking.xlsx

    In the following Excel video tutorial, I go over the following topics in detail:

    - Explanation and example of major errors in Excel:

    #DIV/0 -- #VALUE! -- #REF! -- #NAME? -- #NUM! -- #N/A -- #NULL!

    - Overview of Excel's built-in error checking options and functionality.

    - How to use Go To Special... -> Errors to find errors easily.

    - Copy / paste large data areas for data monitoring.

    - Using direct comparison, and SUM/COUNT functions to compare data changes.

    - Use of Conditional Formatting for emphasis when comparing ranges.

    # vimeo.com/65126195 Uploaded 35.4K Plays 0 Comments

Data Input, Output and Manipulation

Excel Exposure Plus

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.