Excel 2016: Macros and Advanced Queries

Intermediate Level - Free Course

Description

Featured on: Jul 8, 2018

  • 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.
  • Comments

    Not Available

    SUBMITED BY: