Microsoft Excel - Data Management Features

Hours: 8 / Access Length: 3 Weeks / Delivery: Monthly, Mentor Supported
Retail Price: $210.00

Course Overview:

Learn to manage data using Excel! Student will import data from a database and sort and query the data. Student will summarize data using the database functions and the subtotals command. Students will create Pivot tables and Pivot charts. Students will need a copy of Excel. A 60-day trial is available.

Course Outline:

• Students will use the Sort and Filter features to change the view of their data.
• Students will use the Excel Form tool to view and modify their data.
• Students will use the subtotals feature and the Data function to summarize their data.
• Students will use pivot tables and pivot charts to summarize their data. Students will import data into Excel from a database.

All necessary materials are included.

System Requirements:

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is denoted in the above course outline.