Courses > Course Outline

Excel 2016 Formulas & Charts

In this course, students will create, edit, and enhance spreadsheet formulas and charts using Microsoft Office Excel 2016.

Excel 2016 Formulas & Charts

Skip to Available Dates

Learning Objectives

Upon successful completion of this course, students will be able to create formulas and charts using Microsoft Office Excel 2016.

 

Course Details

Course Outline

1 - Basic Formulas
  • SUM, AVERAGE, MAX, MIN
    • 2 - Absolute References
    • 3 - Calculating Data with Advanced Formulas
  • 3D Formulas
  • Range Names
  • Special Functions VLOOKUP, IF, CONCATENATE, TODAY, PROPER, SUMIF, COUNTIF, RIGHT
    • 4 - Presenting Data using Charts
  • Create, Modify and format charts
  • Line, Pie and Column Charts
  • Create Sparklines
  • Create line, column and win/loss Sparklines

    • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    This course is intended for individuals who want to gain knowledge of working on Excel using formulas and charts.

    Excel 2016 Formulas & Charts

    Call
    Course Length : 0.5 Day

    There are currently no scheduled dates for this course. Please contact us for more information.

     PDF Outline With Dates     PDF Outline

    Need Help Picking the Right Course? Give us a call! 01 8898700