• Courses
    • Professional Certificates & Courses
    • Corporate Learning
    • Online Courses
    • Executive Education
    • 50+ OLLI Program
    • Personal Enrichment Classes
    • Summer Camps
    • Atlanta Galleria Center
    • Intensive English Program
    Our Community Catalog
    OLLI Catalog Winter 2022
  • Events
    • Open House
    • Webinars
    • Graduation
    • Book an Event
  • Student Resources
    • Career Development Resources
    • Catalog
    • Financial Aid
    • Frequently Asked Questions
    • KSU Discounts
    • Military Education Benefits
    • Scholarships
  • About
    • About Us
    • Blog
    • Contact
    • Instructor Application
    • Give to CPE
  • Login
    • Login to Register
    • Login to Moodle

College of Professional EducationCollege of Professional Education
  • Courses
    • Professional Certificates & Courses
    • Corporate Learning
    • Online Courses
    • Executive Education
    • 50+ OLLI Program
    • Personal Enrichment Classes
    • Summer Camps
    • Atlanta Galleria Center
    • Intensive English Program
    Our Community Catalog
    OLLI Catalog Winter 2022
  • Events
    • Open House
    • Webinars
    • Graduation
    • Book an Event
  • Student Resources
    • Career Development Resources
    • Catalog
    • Financial Aid
    • Frequently Asked Questions
    • KSU Discounts
    • Military Education Benefits
    • Scholarships
  • About
    • About Us
    • Blog
    • Contact
    • Instructor Application
    • Give to CPE
  • Login
    • Login to Register
    • Login to Moodle
  • Professional

    • Home
    • All courses
    • Professional
    • Excel 2019 Advanced – Online
    Excel 2019 Advanced – Online
    Monthly Online
    Technology
    $159
    More Info & Contact Enroll Now
    • Share:
    • Overview
    • Offerings & Schedules
    • Instructor
    • Financial Aid
    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.

    Add To Cart »Send to Friend »Request More Info »

    Online Instructor

    Online Instructor

    #1: Excel 2019 Advanced - Online


    Start/End: 07/13/2022 to 08/19/2022
    Fee: $159
    Delivery: Online
    Location: n/a
    Class ID 39511
    Start Date July 13, 2022
    End Date August 19, 2022
    Delivery Online
    Location n/a
    Total Hours 24.0
    CEUs 2.4
    ENROLL IN THIS OFFERING

    #2: Excel 2019 Advanced - Online


    Start/End: 08/17/2022 to 09/23/2022
    Fee: $159
    Delivery: Online
    Location: n/a
    Class ID 39512
    Start Date August 17, 2022
    End Date September 23, 2022
    Delivery Online
    Location n/a
    Total Hours 24.0
    CEUs 2.4
    ENROLL IN THIS OFFERING

    #3: Excel 2019 Advanced - Online


    Start/End: 09/14/2022 to 10/21/2022
    Fee: $159
    Delivery: Online
    Location: n/a
    Class ID 39513
    Start Date September 14, 2022
    End Date October 21, 2022
    Delivery Online
    Location n/a
    Total Hours 24.0
    CEUs 2.4
    ENROLL IN THIS OFFERING

    Financial Aid Options

    • No options available at this moment.
    • But you can click here for more information about Financial Aid

    More Info / Contact Us

    If you would like to receive more information about this program or speak with the program lead, submit your information below:

    • Overview
    • More Details
    • Offerings & Schedules
    • Instructor
    • Financial Aid
    $159
    More Info & Contact Enroll Now
    • Share:

    Related Courses

    Business

    Workers’ Compensation – Online (Self Paced)

    Online Self-Paced
    Price$
    $159
    Start Date
    N/A
    Location
    N/A
    Educators

    Instant Italian – Online

    Monthly Online
    Price$
    $159
    Start Date
    08/18/2021
    Location
    N/A
    Technology

    PowerPoint 2019 Introduction – Online (Self Paced)

    Online Self-Paced
    Price$
    $159
    Start Date
    N/A
    Location
    N/A
    Professional

    Introduction to Chemistry – Online (Self Paced)

    Online Self-Paced
    Price$
    Free
    Start Date
    N/A
    Location
    N/A
    Technology

    Social Media Marketing Certificate – Galleria Center

    Certificate
    Price$
    $1,349
    Start Date
    08/17/2020
    Location
    Galleria Center
    Technology

    Web Design Introduction Certificate

    Certificate Monthly Online
    Price$
    Free
    Start Date
    N/A
    Location
    N/A

    Categories

    • Professional
      • • Computer-Aided Design (CAD)
      • • Business
      • • Culinary & Hospitality
      • • Educators
      • • Entrepreneurship
      • • Finance
      • • Healthcare
      • • Languages & Translation
      • • Legal
      • • Real Estate
      • • Technology
      • • Test Prep
    • Personal Enrichment
      • • Art
      • • Cooking
      • • Finance & Investment
      • • Health & Fitness
      • • Languages
      • • Lifestyle
      • • Photography
      • • Writing
    • 50+ OLLI
      • • Art & Music
      • • Events & Travel
      • • Health & Wellness
      • • History
      • • Languages & Writing
      • • Leisure
      • • OLLI Scholar Computer Certificate
      • • OLLI Scholar Spanish Certificate
      • • Personal Finance
      • • Technology & Computers
    CPE Logo

    Kennesaw - KSU Center

    3333 Busbee Drive, #3301
    Kennesaw, Georgia 30144

    (470) 578-6765

    • Facebook
    • Twitter
    • Instagram
    • Linkedin
    • YouTube
    • Blog

    Courses

    • Graduate College
    • All Courses
    • Professional Certificates & Courses
    • Online Courses
    • Personal Enrichment Classes

    For Students

    • Career Development Resources
    • Catalog
    • Financial Aid
    • Military Education Benefits

    Quick Links

    • Blog
    • Contact
    • Corporate Learning
    • Open House

    © 2022 Kennesaw State University - College of Professional Education

    • Privacy
    • Policies
    • Sitemap
    • Text Only