Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries

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