Excel 2016 - Formulas and Charts (FocusChoice)

In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.

Excel 2016 - Formulas and Charts (FocusChoice)

Skip to Available Dates

Learning Objectives

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

 

Course Details

Course Outline

1 - Performing Calculations
  • Formulas
  • Functions: SUM, AVERAGE, MAX, & MIN
  • Absolute Reference
  • 2 - Working with Functions
  • Named Ranges
  • Logical Functions: IF, SUMIF, $ COUNTIF
  • 3 - Using Lookup Functions
  • Lookup Functions: MATCH, INDEX, & VLOOKUP
  • HLOOKUP
  • 4 - Visualizing Data with Charts
  • Creating Charts
  • Modifying Charts
  • 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 basic knowledge of working on Excel.

    Excel 2016 - Formulas and Charts (FocusChoice)

    $195
    Course Length : 1 Day (4 Hours)
     

    1. Choose a Date | 2. Click Enroll Now

    Search All Dates

    Next 4 available dates:

    ... More Dates
    Need Help Picking the Right Course? Give us a call! 503-506-2937