Certification     Microsoft     Microsoft Office Specialist (MOS) on Microsoft Office 2016     77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation

---

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.

---

---

Objectives

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