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

Microsoft Excel 2010: Organizing Worksheet and Table Data

Preview video
Preview Video
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
Downloadable Resources
A screenshot of someone using Excel A screenshot of a database on Excel A screenshot of someone using a formula on Excel
Overview

Microsoft Excel 2010: Organizing Worksheet and Table Data

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 30 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.