Excel Agility: Mastering Advanced Formulas
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:
- Removing the Table feature from Excel spreadsheets once it’s no longer needed or simply erasing the alternate row shading.
- Understanding how the Table feature automates formula management within lists.
- Utilizing keyboard shortcuts to identify precedent and dependent worksheet cells.
- Transforming cell references into range names by way of the Apply Range Names to Formulas command.
- Overcoming the missing formula tip feature in Excel for Mac by accessing the Function Builder.
- Saving time writing formulas by choosing named ranges with the Use In Formula command.
- Creating bookmarks and nicknames for key inputs by way of the Create Names from Selection feature.
- Using the function arguments dialog box to deconstruct worksheet formulas.
- Adding a macro to Excel that adds the ability to display any formula in a cell comment.
- Displaying subsets of data dynamically by way of the new FILTER worksheet function.
- Making notes in the formula bar or preserving prior versions of formulas with the N function.
- 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
Aurora Training Advantage is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at 407-542-4317 or firstname.lastname@example.org.