Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries

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

Prerequisite
None

Expected Duration
71 minutes

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.

Objective

Macros

  • 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

Practice: Working with Macros

  • create a macro in Microsoft Excel 2016

Date and Time Functions

  • 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

Transposing and Looking Up Data

  • 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

Functions in Formulas

  • use the IF function with other functions in Microsoft Excel 2016
  • use SUMIFS, AVERAGEIFS, and COUNTIFS in Microsoft Excel 2016

Practice: Advanced Functions

  • perform advanced queries in Microsoft Excel 2016

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.