I2xnhihq4wyctvaujd8e

Excel 2016 Advanced

Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more.'

Course Description

This course will teach students advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions such as HLOOKUP and VLOOOKP and MATCH and INDEX, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features, as well as how to import and export data to and from their workbooks.


Learning Outcomes

  • Use Advanced IF Statements
  • Use Advanced Lookup Functions
  • Use Complex Logical and Text Functions
  • Auditing Formulas
  • Working with What-If Analysis Tools
  • Protecting Worksheet and Workbook
  • Use Advanced PivotTables and PowerPivot Tools
  • Automate with Macros
  • Work with Form Controls
  • Ensure Data Integrity
  • Collaborate in Excel
  • Import and Export Data to a Text File


  • Pre-requisites

    Excel Introduction and Intermediate courses or equivalent experience.


    Who is this course intended for?

    Students who want to expand their Excel knowledge.



    Your Instructor


    Cathy James
    Cathy James

    Course Curriculum


      Introduction
    Available in days
    days after you enroll
      Importing and Exporting Data to a Text File
    Available in days
    days after you enroll
      Conclusion
    Available in days
    days after you enroll

    Frequently Asked Questions


    When does the course start and finish?
    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
    How long do I have access to the course?
    How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
    What if I am unhappy with the course?
    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

    Get started now!