• Courses
    • Professional Certificates & Courses
    • Corporate Learning
    • Online Courses
    • 50+ OLLI Program
    • Personal Enrichment Classes
    • Summer Camps
    • New Roam Galleria Location
    Our Catalog
    Catalog Oct-Dec 2019 Catalog Oct-Dec 2019
  • Events
    • Open House
    • Webinars
    • Graduation
    • Book an Event
  • Student Resources
    • Catalog
    • Career Networking
    • Financial Aid
    • Frequently Asked Questions
  • About
    • About Us
    • Blog
    • Contact
    • Instructor Application
    • Give to CPE
  • Login
    • Login to Register
    • Login for Students

College of Professional EducationCollege of Professional Education
  • Courses
    • Professional Certificates & Courses
    • Corporate Learning
    • Online Courses
    • 50+ OLLI Program
    • Personal Enrichment Classes
    • Summer Camps
    • New Roam Galleria Location
    Our Catalog
    Catalog Oct-Dec 2019 Catalog Oct-Dec 2019
  • Events
    • Open House
    • Webinars
    • Graduation
    • Book an Event
  • Student Resources
    • Catalog
    • Career Networking
    • Financial Aid
    • Frequently Asked Questions
  • About
    • About Us
    • Blog
    • Contact
    • Instructor Application
    • Give to CPE
  • Login
    • Login to Register
    • Login for Students
  • Professional

    • Home
    • All courses
    • Professional
    • Excel 2016 Advanced – Online

    Excel 2016 Advanced – Online

    Monthly Online
    $149
    More Info / Register
    • Overview
    • More Details

    Master advanced features and functions of Microsoft Excel 2016, including analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting. Learn to use validation to protect the integrity of your worksheets and solve common worksheet problems.

     


    Prerequisite:
    Excel 2016 Intermediate


    Learning Objectives:

    • Learn data analysis tools to improve decision making and streamline processes.
    • Create data forms that replace applying filters and formats separately.
    • Use conditional formatting to hide errors, highlight records based on multiple criteria, and more.
    • Use functions and create nested functions.
    • Learn one and two-variable data tables for analyzing potential outcomes.
    • Learn the functions available in the Analysis ToolPak.

    View full course syllabus

    For our online course refund policy, click here.

    Requirements: Internet access, e-mail, Firefox, Internet Explorer (9.0 or above), Google Chrome, or Safari web browser, and Microsoft Excel 2016. Software is not included in course fee. This course is not suitable for Macintosh users, users of older versions of Microsoft Excel, or “Starter Version” and “Web App” versions of Excel 2016.

    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.

    Financial Aid Options

    • Education Loans

    Course Details

    • Start Date 12/11/2019
    • End Date 01/31/2020
    • Delivery Online
    • Total Hours 24
    • Class Sessions 12
    • CEUs 2.4
    • Fee $149

    No extra information available at this moment.

    • Overview
    • More Details
    $149
    More Info / Register
    • Share:

    Related Courses

    Start Your Own Arts and Crafts Business – Online Read More
    Rodrigo

    Start Your Own Arts and Crafts Business - Online

    Monthly Online
    0
    0
    $149
    Forensic Computer Examiner Certificate – Online Read More
    Rodrigo

    Forensic Computer Examiner Certificate - Online

    Certificate Online Start-Anytime
    0
    0
    $3,095
    Construction Scheduling Read More
    Rodrigo

    Construction Scheduling

    0
    0
    $599
    Solving Classroom Discipline Problems – Online Read More
    Rodrigo

    Solving Classroom Discipline Problems - Online

    Monthly Online
    0
    0
    $159
    Gerontology Certificate Read More
    Rodrigo

    Gerontology Certificate

    Certificate
    0
    0
    $999
    Microsoft Outlook 2010 Introduction – Online Read More
    Rodrigo

    Microsoft Outlook 2010 Introduction - Online

    Monthly Online
    0
    0
    $149

    Categories

    • Professional
      • • Architecture & Construction
      • • 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

    • All Courses
    • Professional Certificates & Courses
    • Online Courses
    • Personal Enrichment Classes
    • 50+ OLLI Program
    • Summer University Camps

    For Students

    • Career Networking
    • Catalog
    • Financial Aid
    • Military Education Benefits

    Quick Links

    • Blog
    • Contact
    • Corporate Learning
    • Open House

    © 2019 Kennesaw State University College of Professional Education

    • Privacy
    • Policies
    • Sitemap
    • Text Only