At the end of this workshop, you will be able to”

Apply functions in formulas

• Perform logical operations by using AND, OR and NOT functions
• Perform logical operations by using nested functions
• Perform statistical operations by using SUMIFS, AVERAGEIFS and COUNTIFS functions

Look up data using functions

• Look up data by using the VLOOKUP function
• Look up data by using the HLOOKUP function
• Look up data by using the MATCH function
• Look up data by using the INDEX function

Apply advanced date and time functions

• Reference the data and time by using the NOW and TODAY functions
• Import, transform, combine, display and connect to data
• Consolidate data
• Perform what-if analysis by using Goal Seek and Scenario Manager
• Use cube functions to get data out of the Excel data model
• Calculate data by using financial functions

Troubleshoot formulas

• Trace precedence and dependence
• Monitor cells and formulas using the Watch Window
• Validate formulas by using error checking rules
• Evaluate formulas

Define named ranges and objects

• Name cells
• Name data ranges
• Name tables
• Manage named ranges and objects