Learn your way! Get started

Microsoft Excel 2016 Data Analysis, Part 1: Functions and Formulas

with expert Sondra Nelson


Watch trailer

Microsoft Excel 2016 Data Analysis, Part 1: Functions and Formulas Trailer

Course at a glance

Included in these subscriptions:

  • Creative Design Power Pack
  • Power Pack Plus

Release date Release date 6/16/2017
Level Level Intermediate
Runtime Runtime 1h 0m
Published eBooks Published eBooks N/A
Hands-on labs Hands-on labs N/A
Sample files Sample files Included
Exams Exams Included


Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More



Course description

Understanding when and how to use advanced functions and arrays is an important step in mastering data analyzation in Excel. Discover the importance of multiple functions including logical and conditional functions, financial and statistical functions, and DateTime functions, as well as examine Arrays, in this overview of advanced functions and formulas.

Prerequisites

This course is designed for students with a base knowledge of Excel and want to learn higher-level skills to display data and perform functions. Students should know how to perform calculations, modify worksheets, format worksheets, print workbooks and manage workbooks.

Meet the expert

Sondra Nelson Sondra Nelson is a Microsoft Certified Trainer and has been teaching Microsoft Office for over 15 years. She has teaching and consulting experience with high school students, college students and corporate employees.


Course outline



Functions and Formulas

Logical and Conditional Functions (27:35)
  • Introduction (00:24)
  • Logical Functions (00:55)
  • IF and AND Functions Demo (03:31)
  • Demo: IF and AND (04:43)
  • Demo: Using IF and AND Together (03:34)
  • Conditional Functions (01:00)
  • SUMIF Demo (02:30)
  • Demo: SUMIF and SUMIFS (05:50)
  • Logical Functions Continued (00:33)
  • ISBLANK and EXACT Demo (04:09)
  • Summary (00:21)
Financial and Statistical Functions (19:29)
  • Introduction (00:23)
  • Financial Functions (02:05)
  • Financial Functions Continued (01:47)
  • PMT and IPMT Demo (01:48)
  • Demo: PMT (03:19)
  • Demo: IPMT (03:06)
  • Statistical Functions (00:48)
  • AVERAGE, MEDIAN, and MODE.SNGL Functions Demo (01:34)
  • Demo: Mean, Median, and Mode (04:18)
  • Summary (00:16)
Date/Time and Arrays (13:11)
  • Introduction (00:29)
  • Date and Time Functions (01:13)
  • Date and Time Functions Continued (00:32)
  • Time Functions Demo (01:34)
  • Demo: Date and Time Functions (03:01)
  • Array Formulas (01:45)
  • Array Formulas Continued (00:38)
  • Array Demo (00:57)
  • Demo: Array Formulas (02:37)
  • Summary (00:21)