| Attend upcoming webinar and earn continuing education credits. | Excel: Dynamic Array Functions | | | | | | | | September | | | | 17 | | 1 pm - 2:40 pm ET | | | Presenter: David Ringstrom, an author and nationally recognized instructor | | | Credits: CPE (Credit Details) | | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | | | Excel's recalculation engine has never been revamped since its inception — until now. In this practical webinar, Excel expert, David Ringstrom, CPA, will introduce you to a completely new class of worksheet functions—dynamic arrays. Available only to Office 365 subscribers, dynamic arrays recalculate traditional formulas faster. These functions eliminate the need to use menu commands to sort, filter, and/or remove duplicates from a list of data. With leading-edge dynamic array functions, you can also create formulas that resize themselves automatically, including an amortization table that expands into additional rows when a loan term increases, or contracts when a loan term is shortened. You will see every technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. David draws your attention to any differences in the older versions of Excel (2016, 2013, and earlier) during the presentation, as well as in his detailed handouts. You'll also discover some features only available in Office 365, but not in Excel 2019. You will also receive an Excel workbook that includes most of the examples used during the webcast. Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on. You will learn how to: - Use dynamic array formulas and resize an amortization table based on changing the loan term.
- Prevent dynamic arrays from resizing by using wrapper functions.
- Integrate the SEQUENCE function within SUMIF to create a dynamic running balance column for an amortization table.
- Contrast traditional static amortization tables with a dynamic amortization now possible in Office 365.
- Pair the EOMONTH and SEQUENCE functions together to create a dynamic column of period end dates.
- Create a dynamic list of sequential numbers with the SEQUENCE function in Office 365.
- Create self-updating lists data validation lists with dynamic array formulas.
- Utilize the PPMT and SEQUENCE functions together to return a dynamic column of principal paid amounts.
- Create an in-cell list by way of Excel's Data Validation feature.
- Display subsets of data dynamically by way of the new FILTER worksheet function.
- Nest dynamic array functions such as SORT and UNIQUE together.
- Describe the nuance of editing dynamic array–based formulas in Office 365.
Upon course completion, you will be able to: - Identify the arguments that correspond to the UNIQUE function
- Recall which ribbon tab or drop-down menu contains the Data Validation feature
- Select the arguments for the EOMONTH function in Excel
| | | | | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. | | | | | | | | | | | ● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 75 live webinars each month
● More than 1,500 on-demand courses | | | | | | |
No comments:
Post a Comment