Intermediate Microsoft Excel 2016

In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel’s data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.

Duration: 3 Months

  • Details
    • Master charting, PivotTables, Slicers, Sparklines, and other advance features of Microsoft Excel 2016
    • Learn to create useful and eye-catching charts
    • Discover how to manipulate data with the push of a button
    • Add the time-saving functions of advanced Excel users to your repertoire
  • Course Outline

    Excel Charts and Graphs
    More Excel Charts
    AutoFilter and Sorting
    Goal Seeking
    PivotTables
    Advanced PivotTables
    Solver
    Sparklines
    Macros
    Introduction to Functions
    Math/Trig Functions
    VLOOKUP, INDEX, and MATCH Functions

  • Requirements

    Prerequisites:

    There are no prerequisites to take this course.

    Requirements:

    Hardware Requirements:

    • This course must be taken on a PC. It is not suitable for Mac users.

    Software Requirements:

    • Windows 7 or later.
    • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
    • Microsoft Office Home and Student 2016 or Microsoft Office 365 (not included in enrollment).
    • Note that the “Starter Version” and “Web App” versions of Microsoft Excel will not work with the full version of Excel taught in this course.
    • Adobe Flash Player. Click here to download the Flash Player.
    • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
    • Software must be installed and fully operational before the course begins.

    Other:

    • Email capabilities and access to a personal email account.

Course Fee: USD 120Now available at Afghanistan, Bangladesh, Bhutan, India, Maldives, Nepal, Pakstan and Sri Lanka

Post An Inquiry Register Now