Take your Excel skills to the next level! In these hands-on lessons, you’ll master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2010. You’ll learn how to harness the power of Excel’s data analysis and filtering tools and see how easy it is to create macros that eliminate repetitive tasks. You’ll also set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel’s other time-saving functions to your repertoire. So get ready for six fun, action-packed weeks that will make you an Excel expert!

Prerequisite: Excel 2010 Introduction (or equivalent experience)

Learning Objectives:

• Learn to create the right chart for the right job.
• Discover why Goal Seek eliminates formula guesswork.
• Find out how to use the Excel PivotTable to create a quick, easy-to-read summary of data in an otherwise unwieldy spreadsheet.
• Become proficient at using the PivotTable to filter, group, and chart data.
• Understand how macros can help you work more efficiently by automating tasks you find time-consuming or repetitive.

This course is part of the Microsoft Office Certificate.

View full course syllabus

For our online course refund policy, click here.

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

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. 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-6693 or online@kennesaw.edu.