Live Educational Webinar
Excel Efficiency: Dynamic Arrays
Price: FREE
Jan. 10, 2019 Thursday
11:00 AM - 12:00 PM (Pacific)
1 Hour
shutterstock_699113008.jpg

Free Live Webinar

  • Free CPE
  • Non-sponsored webinars mean you never listen to a 3rd party sales pitch – it’s all just great education
  • Expert-instructor-led learning with live Q&A
  • Based on a great course on Illumeo
David Ringstrom President and CPA, Accounting Advisors Inc
Excel’s calculation engine is being revamped for the first time since its inception. As Excel expert David Ringstrom, CPA, will explain, this functionality will be available only to Office 365 subscribers. Not only will traditional formulas recalculate faster, there will be an entire new class of worksheet functions known as dynamic arrays. Among other things, you’ll no longer have to use menu commands to sort, filter, and/or remove duplicates from a list of data. You’ll also be able to create formulas that resize themselves automatically, such as an amortization table that expands into additional rows when a loan term increases or contracts when a loan term is shortened.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses 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.

REGISTER

Learning Objectives

After attending this event you will be able to:
Recognize the color that dynamic array functions are displayed in within Excel’s formula bar in all cells except the cell where the formulas were entered.
Recall the menu in Excel where the Table feature resides.
State the location of the Convert to Range command within Excel’s menu structure.

Speakers

David RingstromPresident and CPA, Accounting Advisors Inc
David Ringstrom
President and CPA, Accounting Advisors Inc
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.
Moderated by Jennifer RobbinsIllumeo Webinar Manager
Moderated by Jennifer Robbins
Illumeo Webinar Manager
Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 400 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.

Continuing Education Information

Certified Public Accountant

Continuing Ed Credit: 1 CPE Credits
Field of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online

International Continuing Professional Development IES 7

Continuing Ed Credit: 1 Hours
Field of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online

Certified Management Accountant

Continuing Ed Credit: 1 CPE Credits
Field of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Internal Auditor

Continuing Ed Credit: 1 CPE Credits
Field of Study: Computer science
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certification in Risk Management Assurance

Continuing Ed Credit: 1 CPE Credits
Field of Study:
Other activities contributing to professional competence
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Register for this Event

Price: FREE
By submitting this form, you agree to the terms of Illumeo’s User Agreement and to receive email marketing from Illumeo. Consent can be withdrawn at any time.