Create and Manage an Excel® Database is brought to you by Lorman
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 self-updating 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 subscription-based 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 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.
See more content from Lorman by clicking here.
