Excel 2007 Advanced - Online

ID : 13241   
« back to classes page
Maximize your investment in Microsoft Excel 2007 by mastering advanced Excel features that most users don't even know exist. In this practical, hands-on course, you'll discover how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover a variety of advanced techniques for PivotTables, like creating calculated fields and calculated items, as well as how to restore the "Classic PivotTable Style" drag-and-drop functionality. You'll become adept at consolidating and importing data from other sources, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.

 

Prerequisite: Excel 2007 Intermediate

Learning Objectives:

  • Practice using data validation to control cell input more effectively.
  • Use formula conditional formatting to analyze data or track trends.
  • Import data from multiple sources.
  • Learn to use Goal Seek, Scenario Manager, and Solver.
  • Master the use of PivotTables and PivotCharts.

View a course demo

For our online course refund policy, click here.

Requirements: Internet access, e-mail, Firefox or Internet Explorer web browser, and Microsoft Excel 2007. Software is not included in course fee.This course is not suitable for Macintosh users.

You will need to create a login for your online classroom. Go to www.ed2go.com/ksuconed. Find your course by browsing the catalog or using the search bar. Click the 'Add to Cart' button (this site does not accept payments - you will not be charged here). Select your start date and then create a Username and Password. You must make an 80 or higher on the final exam (online) to successfully complete the course. You may only take the exam once.

If you have questions about this course, please contact the online coordinator at 470-578-3355 or online@kennesaw.edu.

Class Details

38 Sessions
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor 

CEUs : 2.4

Fee: 

$179.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
4/12/2017 - 5/19/2017 Weekly -Sun, Mon, Tue, Wed, Thu, Fri, Sat 12:00 AM - 11:59 PM TBD Online Instructor 

Other Class Offerings

Excel 2007 Advanced - Online
ID: 13242

05/17/17 - 06/23/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor

Excel 2007 Advanced - Online
ID: 13243

06/14/17 - 07/21/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor