Microsoft Excel 2016: (C) Advanced Calculations - EOD

Back to List

Course: 2112889 - Microsoft Excel 2016: (C) Advanced Calculations - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn more advanced features of Microsoft Excel and spreadsheets. Find out how to use logical, statistical, financial, and date functions. You will also build lookup functions, validate data, and troubleshoot errors. Discover how to create sparklines and scenarios, consolidate data, link cells in workbooks, and create outlines.

Prerequisites

Course Outline

  • Using Text Functions (LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER, CONCATENATE and TRANSPOSE)
  • Using Logical Functions and Operators (AND, OR, and IF)
  • Using Lookup Functions (LOOKUP, VLOOKUP, and HLOOKUP)
  • Using Date Functions (TODAY and NOW)
  • Serializing Dates and Times with Functions
  • Using Financial Functions (IPMT, PPMT, NPV, and FV)
  • Applying Conditional Formatting
  • Adding Data Validation Criteria
  • Tracing Cells
  • Troubleshooting Invalid Data and Formula Errors
  • Watching and Evaluating Formulas
  • Creating a Data List Outline
  • Creating Sparklines
  • Creating Scenarios
  • Performing a What-If Analysis
  • Consolidating Data
  • Linking Cells in Different Workbooks
  • Merging Workbooks
Course Type: In Classroom
CEU: 0.60
Sections:
Section#: 4598
Section Meeting Dates and Times:
11/27/2017: 1:30 PM - 4:30 PM
11/30/2017: 1:30 PM - 4:30 PM

Location:
Suite 2201 - Lab 2202
General Services Complex (GSC)
750 Agronomy Rd.
Description: Day 1 of the class is on Monday, November 27th at 1:30 PM. Day 2 of the Class is on Thursday, November 30th at 1:30 PM.

Category: Technology Training - Spreadsheets

Register and View Schedule

Add to Course Waitlist