Learn to import data from a database and sort and query the data. Summarize data using the database functions and the subtotals command. Create Pivot tables and Pivot charts. Students will need a copy of Excel. A 30-day trial is available.
In this course students will:
- Use the Sort and Filter features to change the view of their data.
- Use the Excel Form tool to view and modify their data.
- Use the subtotals feature and the Data function to summarize their data.
- Use pivot tables and pivot charts to summarize their data.
Prerequisites
Students should be comfortable working wtih Excel.
Requirements
Students will need a copy of Microsoft Excel. A 30-day trial is available.
Email this page