3.1 Apply functions in formulasUsing nested functionsUsing the IF, AND, and OR functionsUsing the SUMIFS, AVERAGEIFS, and COUNTIFS functionsUsing financial functionsCalculating investmentsCalculating depreciationAnalyzing securities3.2 Look up data by using functionsUsing the VLOOKUP and HLOOKUP functionsUsing the LOOKUP functionUsing the TRANSPOSE function3.3 Apply advanced date and time functionsUsing the NOW and TODAY functionsUsing functions to serialize dates and timesUsing the YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND functionsUsing the DATEVALUE and TIMEVALUE functionsUsing the WEEKDAY, WORKDAY, and NETWORKDAYS functions3.4 Create scenariosUsing what-if analysis toolsUsing Goal SeekUsing SolverUsing the Scenario ManagerConsolidating dataConsolidating by positionConsolidating by categoryObjective review