Learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts and graphs, building links, and custom toolbar buttons. You will also be introduced Excel 2019’s powerful charting capabilities and features like Quick Analysis and Flash Fill.

Learning Objectives:

• Develop a solid understanding of the Excel interface.
• Discover five simple steps to ensure that your worksheets are well-planned, well-constructed, and beautifully formatted.
• Differentiate between relative, absolute, mixed, and circular references.
• Develop skills in subtotalling, sorting, and filtering.
• Create, adjust, and format your chart types, labels, titles, and colors.
• Employ statistical, financial, and if Functions.

This course is part of the Microsoft Office Certificate.

View full course syllabus

For our online course refund policy, click here.

Requirements: Internet access (Chrome, Firefox, or Edge), e-mail, and Microsoft Excel 2019. 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. 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 at online@kennesaw.edu.