Self Study Video: Computer Software & Apps
Computer Software & Apps Courses
Excel Dexterity Advanced Pivot Tables
COURSE DESCRIPTIONDiscover how to dig deeper into pivot tables in this comprehensive course. Excel expert David Ringstrom, CPA, demonstrates step-by-step how to manipulate your pivot table data faster and more efficiently. Youll learn how to extract data from Microsoft Access databases and other sources, minimize repetitive steps in Excel by creating keyboard shortcuts, and adapt simple macros that can be recorded. In addition, David discusses several helpful Excel features, including the Table feature, PivotTable feature, Slicer feature, Linked Picture feature, the PowerPivot feature, and others. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. Hell draw to your attention any differences in Excel 2013, 2010, or 2007 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. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Automating Financial Statements
COURSE DESCRIPTIONMany users pivot to Excel when a desired financial statement format cannot be created within the accounting software. However, this in turn often leads to techniques such as creating worksheets for every month of the year, which eventually can be cumbersome to revise and preserve data integrity. In this presentation Excel expert David Ringstrom, CPA, explains how to use Excel functions, including VLOOKUP, OFFSET, and SUM, to quickly create accounting reports that allow you to switch to any reporting period with only two mouse clicks from a single worksheet. You'll also get tips on exporting data from your accounting package, improving the integrity of your spreadsheets, and much more. Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Budget Spreadsheets
COURSE DESCRIPTIONIn this informative presentation, Excel expert David Ringstrom, CPA, shows you how to create resilient and easy-to-maintain budget spreadsheets. Among other techniques, David explains how to separate inputs from calculations, build out a separate calculation spreadsheet, create both an operating and a cash flow budget, transform filtering tasks, and preserve key formulas. 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Creating Interactive Spreadsheets
COURSE DESCRIPTIONIn this on-demand webcast, youll learn from Excel expert David Ringstrom, CPA, how to implement multiple techniques to create spreadsheets that are interactive, accurate, and user friendly. Step-by-step, David shows you how to 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 Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Custom Views
COURSE DESCRIPTIONIn this empowering presentation, Excel expert David Ringstrom, CPA, demonstrates multiple ways to automate your work in Excel by way of the Custom Views feature—one of the most underutilized features in Excel. David explains how to hide and unhide multiple worksheets at once, freeze or unfreeze worksheet panes on-demand, store multiple print ranges/settings for a given worksheet, gain control over long lists of data by filtering instead of sorting, 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Database Techniques
COURSE DESCRIPTIONThe process of culling data from text files or from databases, such as Access or SQL Server, can be intimidating to Excel users. In this comprehensive course, Excel expert David Ringstrom, CPA, shows you how to get the data you need into Excel where you then can work with it a variety of ways, including using worksheet functions to summarize data, querying text files and databases from within Excel, creating self-updating links to databases and other data sources, 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Deciphering Error Prompts
COURSE DESCRIPTIONIf youre often stopped in your tracks by error prompts you always get when youre performing seemingly simple actions in your spreadsheets, youll benefit from this broad-reaching course. Excel expert David Ringstrom, CPA, delves into the intricacies of Excel to explain why error prompts can be encountered, and he outlines in detail what actions to take when Excel appears to go away. Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Internal Control
COURSE DESCRIPTIONUser-proofing Excel spreadsheets don't have to be a tedious task, nor does it have to feel Draconian for spreadsheet users. In this presentation Excel expert David Ringstrom, CPA shares how to implement internal control features within your spreadsheets. Techniques covered include Data Validation, Conditional Formatting, hiding worksheets securely, as well as protecting worksheets and workbooks. You'll also see how to improve the integrity of your spreadsheets with VLOOKUP and SUMIF, as well as Excel's Table feature. 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Intro to Lookup Formulas
COURSE DESCRIPTIONIf you're not presently using look-up formulas such as VLOOKUP, HLOOKUP, SUMIF, and others in your work, then there's much about your experience in Excel that is more difficult than necessary. In this comprehensive presentation, Excel expert David Ringstrom, CPA, introduces several lookup functions and provides context on when youre likely to use them. He demonstrates troubleshooting techniques and prepares you to deal with nuances that can frustrate users new to lookup functions. 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Logic Functions
COURSE DESCRIPTIONIn this fast-paced presentation Excel expert David Ringstrom, CPA begins with a brief discussion of the IF function and then quickly moves beyond the basics. You'll see the pros and cons of nesting multiple IF functions together, along with that include IFS, CHOOSE, VLOOKUP, SUMIF, and several other worksheet functions. You'll also see techniques useful in confirming that complex formulas, such as nested IF functions, are working properly. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. Hell draw to your attention any differences in Excel 2013, 2010, or 2007 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. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Minimizing Errors
COURSE DESCRIPTIONUser-proofing Excel spreadsheets don't have to be a tedious task, nor does it have to feel Draconian for spreadsheet users. In this presentation Excel expert David Ringstrom, CPA shares how to implement internal control features within your spreadsheets. Techniques covered include Data Validation, Conditional Formatting, hiding worksheets securely, as well as protecting worksheets and workbooks. You'll also see how to improve the integrity of your spreadsheets with VLOOKUP and SUMIF, as well as Excel's Table feature. 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Office 365
COURSE DESCRIPTIONHistorically, each version of Excel has been identical for all users, but thats no longer the case. In this on-demand webcast, Excel expert David Ringstrom, CPA, explains how the Office 365 version of Excel 2016 differs from previous versions as well as perpetual licensed versions of Excel 2016. David discusses updated features and worksheet functions available in the Office 365 version of Excel 2016, and he shows you step-by-step how to use them. He also shares helpful keyboard shortcuts and tips. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel 2016. He draws your attention to any differences in the perpetual licensed versions of Excel 2016, 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. In addition, David provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Payroll Analysis
COURSE DESCRIPTIONExcel offers multiple features and functions payroll professionals can implement to improve the accuracy and efficiency of payroll production. In this comprehensive course, Excel expert David Ringstrom, CPA, demonstrates and explains: mathematics for employee timesheets, date and time formatting, and stamping, conditional formatting to highlight HR requirements, password protection for sensitive payroll files and worksheets, salary information formatting, and using pivot tables for HR reporting and analysis tasks. 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Pivot Tables Part I
COURSE DESCRIPTIONIn this session Excel expert David H. Ringstrom, CPA, introduces one of the most powerful, and yet overlooked features in Excel: pivot tables. Many users shy away from this feature, thinking that specialized knowledge is required. As you'll see in this presentation, pivot tables allow you to instantly summarize lists of data into meaningful reports with just a few actions with your mouse. As with many aspects of Excel, pivot tables have several nuances that Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Pivot Tables Part II
COURSE DESCRIPTIONIn this installment of the Pivot Table series Excel expert David Ringstrom, CPA takes you beyond the basics of pivot tables. You'll learn how pivot tables differ from worksheet formulas, the importance of the Refresh and Report David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity SUM SUMIF and More
COURSE DESCRIPTIONFollow along as Excel expert David Ringstrom, CPA explores several ways to sum data beyond the venerable SUM function. Expanding your knowledge of worksheet functions can markedly improve the resilience and integrity of your spreadsheets. Take summing to new levels with the SUBTOTAL and AGGREGATE functions, while you learn how to have SUMIF and SUMIFS add up values based upon up to 127 criteria. David also will discuss the SUMPRODUCT function. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. Hell draw to your attention any differences in Excel 2013, 2010, or 2007 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. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Table Feature
COURSE DESCRIPTIONIn this extensive presentation Excel expert David Ringstrom, CPA explores the Table feature. This feature offers a dazzling number of automation and data integrity opportunities. Start saving time immediately with pivot tables and formulas that automatically accommodate expanding lists of data. Sift through lists of data with ease, and eliminate the risk of forgetting to copy formulas both up and down a given column. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws to your attention any differences in Excel 2013, 2010, or 2007 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. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity What-If Analysis
COURSE DESCRIPTIONYoull discover how to implement Excels powerful What-If Analysis Tools in this course presented by Excel expert David Ringstrom, CPA. David outlines how and when to make use of Excels Scenario Manager as well as how to use the Data Table feature to compare calculation results based on two or three inputs. Youll also learn how to implement Excels Goal Seek feature to perform basic what-if analysis to solve for a single value. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. Hell draw to your attention any differences in Excel 2013, 2010, or 2007 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. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |
Excel Dexterity Workbook Links
COURSE DESCRIPTIONIn this comprehensive course, Excel expert David Ringstrom, CPA, explains the pros and cons of workbook links and takes you step-by-step through the process of creating and working with them. Workbook links are of great benefit, as they allow you to connect one Excel spreadsheet to other spreadsheets, Word documents, databases, and even web pages. David also covers how to dramatically improve the integrity of linked workbooks, copy links across rows or down columns, repair broken links, 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast. Topics include:
Learning Objectives:After reading the course material, you will be able to:
Who Should Attend:
Qualifies and Approved with all State Boards of Accountancy and the following sponsorships: |