Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Useful Excel Functions: Date, Text, and Logical Aggregators

Description

Besides the essential functions for analysis, there are dozens of useful functions that help us build dynamic reports. In this session, we’ll discuss Boolean-driven summary functions, date and time functions, and text manipulation functions.

Topics include:

  • Building useful summaries with SUMIFS, COUNTIFS, and others
  • Dealing with dates effectively
  • Calculating date differences and deadlines
  • Manipulating text with functions

Prerequisites

Absolute and relative references and experience creating Excel functions

Introduction to formulas and functions (linkedin.com)