Microsoft Excel - Tables Deep Dive
By Erin Olsen
Publisher: Infinite Skills
Final Release Date: December 2013
Run time: 3 hours 32 minutes

In this Microsoft Excel – Tables Deep Dive training course, expert author Erin Olsen takes you beyond the basics of Excel, diving deep into creating and using tables in this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.
You will start out by the learning the basics of Excel tables, such as how to prepare data for tables, creating and naming tables, and converting tables back to ranges. From there, you will move into working with table records, including how to add and delete records, use the data entry form, and sort and filter table records. Erin will teach you how to format tables and modify and create custom and default table styles. This video tutorial will also teach you table calculations, including how to create calculated columns, understand structured references, and work with table rows. Finally, you will learn how to work with table tools, such as moving tables, removing duplicates, and how to create charts from tables.
By the completion of this computer based training course, you will be fully capable of creating, using, modifying, and customizing tables in Excel. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents
Product Details
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMicrosoft Excel - Tables Deep Dive
 
3.0

(based on 1 review)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 1 customer

Displaying review 1

Back to top

 
3.0

Improve Excel Tables Knowledge

By Teeside

from Vancouver, BC

About Me Student

Verified Reviewer

Pros

  • Accurate
  • Easy to understand
  • Helpful examples

Cons

    Best Uses

    • Intermediate
    • Novice

    Comments about oreilly Microsoft Excel - Tables Deep Dive:

    Tables Dive Deep
    This video covers advanced use of Excel 2013 tables. The "deep dive" reference is used several times in the video, comparing swimming to learning Excel tables in depth, gaining a deeper knowledge. This video would be most useful to Excel users wanting to get up to speed with the 2013 version.
    The most useful segments of the video cover the new features affecting tables, such as slicers. Many tips for efficient styling and formatting of tables are shown. Some of the little-used but time-saving features, such as the data entry form are covered. Structured and absolute references, which can be tricky if you don't use them regularly, are clearly explained.
    The video covers a broad range of table tips and tricks, it's great if you want to improve productivity in working with tables.

    Displaying review 1

    Back to top

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Video: $24.95
    (Streaming, Downloadable)