Excel Skills: 14 CPE hours (Currently Unavailable)

Refresh your Excel skills with this package of Excel self-study courses in on-demand webcast format. Earn 14 CPE hours. Spreadsheet expert, David Ringstrom, CPA demonstrates powerful functions directly in Excel. View the recorded webcast as many times as you like. Includes practice Excel files.

Click on course titles below to view full descriptions of the programs included in this package.

In this on-demand course, Excel expert David H. Ringstrom, CPA shows you how to create dynamic accounting reports for any month of the year on a single worksheet. Many users set out to build a worksheet for each month of the year, which can be cumbersome to revise. Instead David will show you how to use functions like VLOOKUP, OFFSET and SUMIF together to quickly create accounting reports that toggle to any reporting period with just a couple of mouse clicks. The session also demonstrates effective ways to export data from your accounting package so that you can create a set-and-forget link to your accounting data in Excel.
David H. Ringstrom, CPA will present numerous techniques that he relies on to improve the integrity of spreadsheets that he builds for himself and others. This session will empower you with simple ways to avoid introducing errors into your own workbooks.
Many users rely on VLOOKUP for basic look-up functionality in spreadsheets, but are often unaware of ways to improve the integrity of this venerable function. In this session Excel expert David H. Ringstrom, CPA introduces the VLOOKUP function, and then quickly goes beyond the basics. Discover what can go awry with VLOOKUP, how to future-proof the function, and explore alternatives such as MATCH/INDEX, SUMIF, SUMIFS, SMALL/LARGE, MIN/MAX, and OFFSET.
Thanks to the success of our popular Excel Speed Tips presentation, Excel expert and CPA David H. Ringstrom has developed a follow-up session packed with even more ways to save time and effort in Excel. Remember, either you work Excel, or it works you!
Are there Excel tasks that are taking you way too long? This course will help you quickly accomplish certain tasks by teaching you ways to improve your efficiency, such as how to quickly filter data, streamline repetitive tasks, use keyboard shortcuts, and access folders and workbooks easily.
Total: 5 courses (14 CPE hours)

">
 Chat — Books Support