Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
Using macros in Excel 2016 lets you save time when performing repetitive tasks. This course covers the options available when you are running macros, and also how to create your own custom macros. You will also learn about advanced functions that allow you to perform calculations using date and time, how to look up data, and how to perform advanced conditional queries.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Prerequisites
None

Expected Duration (hours)
1.2

Lesson Objectives

Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries

  • start the course
  • configure macro security settings in Microsoft Excel 2016
  • run a macro in Microsoft Excel 2016
  • record a simple macro in Microsoft Excel 2016
  • run a custom macro from an interface element in Microsoft Excel 2016
  • create a macro in Microsoft Excel 2016
  • use the NOW and TODAY functions in Microsoft Excel 2016
  • use the DATE function in Microsoft Excel 2016
  • use the NETWORKDAYS function in Microsoft Excel 2016
  • use TRANSPOSE to alter a worksheet in Microsoft Excel 2016
  • look up data using the VLOOKUP and HLOOKUP functions in Microsoft Excel 2016
  • look up data using the LOOKUP function in Microsoft Excel 2016
  • use the IF function with other functions in Microsoft Excel 2016
  • use SUMIFS, AVERAGEIFS, and COUNTIFS in Microsoft Excel 2016
  • perform advanced queries in Microsoft Excel 2016

    • Course Number:
    mo_inel_a04_dt_enus

    Expertise Level
    Intermediate