Courses > Course Outline

Excel 2013 Formulas & Charts

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

Excel 2013 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 2013.

 

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 2013 Formulas & Charts

    €375
    Course Length : 0.5 Day
     

    1. Choose a Date | 2. Click Enroll Now [G2R=Guaranteed to Run]

     PDF Outline With Dates     PDF Outline

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