Description
Learn how to create, analyze, and manage data.In this topic Excel Expert David H. Ringstrom, CPA shows you how to leverage one of the most powerful aspects of Microsoft Excel using your spreadsheet as a database. You’ll see how organizing your data into discrete lists streamlines spreadsheet management and empowers you to take advantage of powerful features such as Power Query for linking and managing data, and PivotTables for creating selfupdating reports. He will take you even farther by illustrating dynamic array formulas in Microsoft 365 to create reports that update themselves in real time. Once you start using Excel as a database, you won’t see spreadsheets the same way again.David demonstrates every technique at least twice first, on a PowerPoint slide with numbered steps, and second, in the subscriptionbased Microsoft 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 program.Microsoft 365 is a subscriptionbased product that provides newfeature 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.
Date: 2020-10-14 Start Time: End Time:
Learning Objectives