| Attend upcoming webinar and earn continuing education credits. | Designing Error-Proof Spreadsheets in Excel | | | | | | | | June | | | | 29 | | 1 pm - 2:40 pm ET | | | Presenter: David Ringstrom, an author and nationally recognized instructor | | | Credits: CPE (Credit Details) | | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | | | In this practical webinar, Excel expert, David Ringstrom, CPA, shares a variety of tricks and techniques you can employ to improve the integrity of your Excel spreadsheets. To help you design error-proof spreadsheets, David demonstrates how to implement a variety of Excel features and functions, preserve key formulas, perform dual lookups, and more. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation, as well as in his detailed handouts. You will also receive an Excel workbook that includes most of the examples used during the webinar. Who Should Attend: Practitioners who wish to learn how to improve the integrity of their Excel worksheets. You will learn how to: - Improve the integrity of spreadsheets with Excel's VLOOKUP function
- View two worksheets from within the same workbook at the same time
- Build resilience into spreadsheets by avoiding daisy-chained formulas
- Use range names to streamline formulas and bookmark key inputs within a workbook
- Sum disparate sections of a spreadsheet quickly with the SUBTOTAL function
- Switch between Custom Views by way of a hidden drop-down list you can enable on Excel's Quick Access Toolbar
- Use the SUMIF function to summarize data based on a single criterion
- Use Conditional Formatting to identify unlocked cells into which data can be entered
- Automatically use fallback positions in the event you need to see an earlier version of your spreadsheet
- Preserve key formulas using hide and protect features
- Perform dual lookups, which allow you to look across columns and down rows to cross-reference the data you need
- Use Excel's Custom Views feature to make a single set of data serve multiple purposes
Upon course completion, you will be able to: - Apply techniques and features that will improve the integrity of your Excel spreadsheets
- State how to hide and unhide multiple worksheets with a single command in Excel
- Apply Conditional Formatting to identify unlocked cells into which data can be entered
| | | | | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 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. | | | | | | | | | | | ● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 75 live webinars each month
● More than 1,500 on-demand courses | | | | | | |
No comments:
Post a Comment