In this valuable webcast, Excel expert David Ringstrom, CPA, shares a variety of tricks and techniques you can use to improve the accuracy of your ..
Excel spreadsheets. To help you create spreadsheets that are free of errors, David demonstrates how to implement Excel features and functions, such as the Hide and Protect feature, the Conditional Formatting feature, the VLOOKUP function, the SUBTOTAL function, and others. In addition, he discusses how to preserve key formulas, perform dual lookups, and sum discrepant sections of a spreadsheet. 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. 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.