Microsoft Excel 2013 or 2016 - Level 3 - Advanced

Office Applications/Productivity
  • Retail Price: $395.00
  • Sale Price: $195.00 (Vendor Credits or Vouchers Accepted)
  • 1 Day
  • http://www.certiport.com
  • Office Applications/Productivity
Schedules
  08/23/17 - 9-5pm PST Glendale - CA
  09/07/17 - 9-5pm PST Glendale - CA
  09/20/17 - 9-5pm PST Glendale - CA
  10/04/17 - 9-5pm PST Glendale - CA
  10/18/17 - 9-5pm PST Glendale - CA
  11/01/17 - 9-5pm PST Glendale - CA
  11/15/17 - 9-5pm PST Glendale - CA
  11/29/17 - 9-5pm PST Glendale - CA
  12/13/17 - 9-5pm PST Glendale - CA
  12/28/17 - 9-5pm PST Glendale - CA
Delivery Type (Must Select One)
  Instructor-Led
  Online Live Instructor-Led
Version (Must Select One)
  2013
  2016
Optional
  Certiport Test with Proctor Fee ($126.00)
  Certiport Test with 1 Retake / Proctor Fee ($145.00)
  LearnITAnytime Online Subscription (1 Year Subscription - $195.00)
  IT Online Library (1 Year Subscription - $1595.00)
  Private Mentoring 3 Hours ($125)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

 

This hands-on class is suitable for Excel 2010, 2013 and 2016 users.

On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.

Live face-to-face instructor. No minimum class size - all classes guaranteed to run!

You should have completed our intermediate class or have the equivalent experience prior to attending this course.

 

Logical and Lookup Functions
  • The IF Function
  • Conditional Calculations
  • Using SUMIF
  • VLOOKUPS and HLOOKUPS
  • Range LOOKUPS

Advanced Formulas
  • Auditing and Error Trapping
  • Formula Options
  • Array Functions
  • Using TRANSPOSE

Special Functions
  • Date and Time Functions
    • TODAY
    • NOW
    • DATE
  • Date Calculations
  • Text Functions
    • Using CONCATENATE and TRIM
    • Using UPPER, LOWER and PROPER
    • Extracting Text
  • Statistical Functions
    • Using MIN and MAX
    • Using COUNT, COUNTA and COUNTBLANK
  • Financial Functions
    • Using FV
    • Using PMT

Importing and Exporting
  • The Power Pivot Data Model
  • Importing Data
  • Using Power Pivot
  • Exporting Data

Data Analysis
  • What-if Analysis
  • Scenarios
  • Using Goal Seek
  • The Analysis Toolpak

Macros and Forms
  • Recording Macros
  • Running Macros
  • Running Macros when Workbook is Open or Closed
  • Using Forms to Record Input



Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.


 

Certificate of Course Completion


 

This hands-on class is suitable for Excel 2010, 2013 and 2016 users.


 

You should have completed our intermediate class or have the equivalent experience prior to attending this course.


 

You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within 10 days will forfeit all fees paid.