Skip to main content

Excel 2019 Advanced - Online

ID : 33011   
« back to classes page
Master Microsoft Excel's most advanced features. Use data analysis tools to improve your decision making and practice generating accurate data more quickly. Gain advanced techniques to use when working with databases and PivotTables.

 

Prerequisite: Excel 2019 Intermediate (or equivalent experience)

Learning Objectives:

  • Learn how to format and work with tables using data forms and database techniques.
  • Employ data validation techniques to fix incorrect or missing data in a workbook.
  • Practice using custom controls to create standard and drop-down list boxes, check boxes, option buttons, and group boxes.
  • Learn how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, and more.
  • Efficiently summarize data from multiple sources using the consolidation function.
  • Use the Power Query tool and import external database to combine two database tables into a single import.
  • Work with Goal Seek, Scenario Manager, Solver, and PivotTables.
  • Update workbooks using the Analysis ToolPak, including Moving Average, Sampling tools, the View Side by Side tool, and the Watch Window.

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.

Class Details

12 Sessions
Online 24/7

Location
cpe.kennesaw.edu

Instructor
Online Instructor 

CEUs : 2.4

Fee: 

$159.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
12/9/2020 - 1/29/2021 Online 24/7 12:00 AM - 12:00 AM N/A - Online Online Instructor 

Other Class Offerings

ID: 33742

01/13/21 - 03/05/21
Online 24/7

ID: 33743

02/10/21 - 04/02/21
Online 24/7