Mastering Lookup Formulas and High Powered Alternative Techniques
Excel expert David Ringstrom, CPA, shows you various ways to make sense of complicated Excel formulas in this insightful presentation. Sometimes your formulas can grow out of control, or, more likely, you’ve inherited spreadsheets from others that you’re to take ownership of. You’ll have many tricks at your disposal to quickly decipher even the most complex Excel formulas after attending this webcast.
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.
Topics Typically Covered:
• Adding a macro to Excel that adds the ability to display any formula in a cell comment.
• Utilizing the New Window and Arrange Windows commands to view two different worksheets simultaneously.
• Utilizing the FORMULATEXT function in Excel 2013 and later to display a formula from one cell in another cell.
• Understanding the purpose and nuances of Excel’s Personal Macro Workbook.
• Making notes in the formula bar or preserving prior versions of formulas with the N function.
• Utilizing the Error Checking command to locate cells that contain errors within a worksheet.
• Creating bookmarks and nicknames for key inputs by way of the Create Names from Selection feature.
• Identifying the various # sign errors Excel formulas can return.
• Shortening worksheet names, even temporarily, to make formulas easier to comprehend.
• Leveraging Excel’s color coding to detect cells related to a formula, especially in Excel 2013 and later.
• List the benefits of using range names.
• Apply the Trace Precedents and Trace Error features to identify linked cells.
• Apply the SUMIF function to summarize data and the SUMIFS function to sum values.
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 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. To learn more about David, you can view his LinkedIn profile and follow him on ... View Full Profile