Online Training | 800‑258‑3837
Back to Course List

Microsoft Excel 2010: Organizing Worksheet and Table Data

Preview video
Preview Video
Course Format
Video on Demand  Video On Demand
Product ID
sonieowt_vod
Training Time ?
77 to 82 minutes
Language(s)
English
Video Format
High Definition
Required Plugins
None
Number of Lessons
10
Quiz Questions
5
Question Feedback
Wrong Answer Remediation
Lesson Bookmarking
Interactive Producer
Mastery Training Content Network
Original Content Producer
Sonic Performance Support GmbH
Course screen Course screen Course screen
Overview

This online training video demonstrates how to create tables within Microsoft Excel 2010 worksheets. Using video tutorials, this course demonstrates how to modify and format the tables, organize the data, and do calculations.

In the section on database functions viewers learn Microsoft Excel 2010 has specialized functions to work with a database. These can be found in the insert function wizard, under the database category. The video walks viewers through a database analysis, explains AND and OR conditions for calculations using multiple criteria, and how to create subtotals.

Learn how to create tables within Microsoft Excel 2010 and become more proficient in manipulating table data in worksheets by watching this training video.

Video on Demand   This course is in the Video On Demand format, to read about Video On Demand features click here.

  • Install on any SCORM LMS
  • Full-screen video presentation
  • Print certificate and wallet card
  • You have 60 days to complete the course
Audience

Everyone who uses Microsoft Excel 2010

Topics
The course presents the following topical areas:
  • Organizing Worksheet and Table Data
  • Creating Tables
  • Modifying Tables
  • Formatting Tables
  • Sorting
  • Filtering
  • Special Filter
  • Database Functions
  • AND and OR Conditions
  • Subtotals

© Mastery Technologies, Inc.