Excel 2016: Macros and Advanced Queries

Description

• Create a macro in Microsoft Excel 2016.
• Record a simple macro in Microsoft Excel 2016.
• Run a custom macro from an interface element.
• Use the NOW and TODAY functions.
• Use the DATE function.
• Use the NETWORKDAYS function.
• Use TRANSPOSE to alter a worksheet.
• Look up data using the VLOOKUP and HLOOKUP functions.
• Look up data using the LOOKUP function use the IF function with other functions.
• Use SUMIFS, AVERAGEIFS, and COUNTIFS.