• Courses
    • Graduate College
    • Professional Certificates & Courses
    • Corporate Learning
    • Executive Education
    • Online Courses
    • 50+ OLLI Program
    • Personal Enrichment Classes
    • Summer Camps
    • Atlanta Galleria Center
    • Intensive English Program
    Our Catalog
    OLLI Catalog Winter 2020
  • Events
    • Open House
    • Webinars
    • Graduation
    • Book an Event
  • Student Resources
    • Catalog
    • Career Development Resources
    • Financial Aid
    • KSU Discounts
    • Scholarships
    • Frequently Asked Questions
  • 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
    • Graduate College
    • Professional Certificates & Courses
    • Corporate Learning
    • Executive Education
    • Online Courses
    • 50+ OLLI Program
    • Personal Enrichment Classes
    • Summer Camps
    • Atlanta Galleria Center
    • Intensive English Program
    Our Catalog
    OLLI Catalog Winter 2020
  • Events
    • Open House
    • Webinars
    • Graduation
    • Book an Event
  • Student Resources
    • Catalog
    • Career Development Resources
    • Financial Aid
    • KSU Discounts
    • Scholarships
    • Frequently Asked Questions
  • About
    • About Us
    • Blog
    • Contact
    • Instructor Application
    • Give to CPE
  • Login
    • Login to Register
    • Login to Moodle
  • Professional

    • Home
    • All courses
    • Professional
    • Microsoft Excel 2016 Advanced – Online (Self Paced)

    Microsoft Excel 2016 Advanced – Online (Self Paced)

    Online Self-Paced
    $159
    More Info / Register
    • Overview
    • More Details

    Master advanced features and functions of Microsoft Excel 2016, including data analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting.

    Prerequisite: Excel 2016 Intermediate

    Learning Objectives:

    • Discover 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 about different methods of importing external data.
    • Discover how to use PivotTables and PivotCharts.
    • Learn the functions available in the Analysis ToolPak.

    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 for the ‘Self-Paced’ class. This site does not accept payments – you will not be charged here. Create a Username and Password. Once you pay and add your class at the classroom site, you will be verified to access your class after 5PM on Wednesday. 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.

    Financial Aid Options

    • No options available at this moment.

    Course Details

    • Delivery Online
    • Total Hours 24
    • Class Sessions 0
    • CEUs 2.4
    • Fee $159

    No extra information available at this moment.

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

    Related Courses

    Energy Medicine Certificate – Online Read More
    Rodrigo

    Energy Medicine Certificate - Online

    Certificate Monthly Online
    0
    0
    $79
    Creating Web Pages (HTML) – Online Read More
    Rodrigo

    Creating Web Pages (HTML) - Online

    Monthly Online
    0
    0
    $159
    Paralegal Certificate – Online Read More
    Rodrigo

    Paralegal Certificate - Online

    Certificate Online Start-Anytime
    0
    0
    $2,995
    Marketing Your Business on the Internet – Online Read More
    Rodrigo

    Marketing Your Business on the Internet - Online

    Monthly Online
    0
    0
    $159
    Purchasing Fundamentals – Online (Self Paced) Read More
    Rodrigo

    Purchasing Fundamentals - Online (Self Paced)

    Online Self-Paced
    0
    0
    $159
    Digital Marketer: Google Ads & Analytics, Hubspot Marketing, & Digital Channels Read More
    Rodrigo

    Digital Marketer: Google Ads & Analytics, Hubspot Marketing, & Digital Channels

    0
    0
    $1,500

    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

    • 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

    © 2020 Kennesaw State University College of Professional Education

    • Privacy
    • Policies
    • Sitemap
    • Text Only