High Impact Excel: Error Prompt Edition

View the Webinar

Follow this link to register or access the recording. After this seminar has passed, the recording will still be available.

CPE CREDIT WILL BE AVAILABLE TO LIVE ATTENDEES ONLY.

Event Date: November 18, 2014, 2 pm ET
 
In this session Excel expert David Ringstrom, CPA tackles what to do when bad things happen to good spreadsheets. Users often get stopped in their tracks by disabled features, inscrutable error prompts, or just quirky behavior in Excel. David will decipher a number of common error prompts in Excel, show you how to diagnose disabled features, and close with a series of troubleshooting steps.
 
David will teach from Excel 2010, but will include instructions for Excel 2007, 2010, and 2013 were applicable. In addition to the one-hour presentation, David offers a one-hour "ask the expert" session where you can ask any questions you have about Excel, even if not specifically related to error prompts in Excel.
 
Who Should Attend:
Practitioners seeking to use Microsoft Excel more effectively
 
Topics Covered:
  • Save time when saving workbooks as .XLS files by dispatching the Compatibility Checker
  • Learn why you can't assign the name History to a worksheet tab.
  • Discover the Sparklines feature in Excel 2010 and 2013, and how to replicate it in Excel 2007 and earlier.
  • Make sense of why Excel is complaining about circular references.
  • Compare and contrast IFNA, IFERROR, and ISERROR, and see which versions of Excel support each of these worksheet functions.
  • Master the nuances--and power--of Excel's Transpose feature.
  • Decipher and manage Excel's macro security prompts.
  • See steps to take if you can't open a damaged workbook.
  • Learn how to launch Excel in Safe Mode to troubleshoot Excel issues.
  • Remove memory hogging add-ins that can compromise Excel.
Learning Objectives:
  • Understand frequently encountered error prompts in in Excel.
  • Save time by disabling repetitive prompts that you don't need to see again.
  • Develop a checklist of what to do when Excel exhibits unexpected behaviors.
 
Presenter:
David Ringstrom
Owner
Accounting Advisors, Inc.
 
David H. Ringstrom, CPA  is the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. He teaches dozens of webinars each year and speaks at conferences on Excel, along with writing freelance articles about spreadsheets that appear internationally. Webinar attendees are often amazed by how much ground David can cover in a short period of time.
 
Program Levelintermediate
Prerequisitesnone
Field of StudySpecialized Knowledge and Apps
Advance Preparation Needednone
Delivery MethodGroup-Internet Based
Recommended CPE Credit1 credit per 50-minute session*
Registration Instructionsregister online
Costfree
Complaint Resolutionpublisher@accountingweb.com
Refund policy/Cancellation policyDue to this program being offered free of charge, there will be no refunds issued

 

Sift Media is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing 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.learningmarket.org.


* To obtain CPE credit, the live session must be attended.  THE RECORDING DOES NOT QUALIFY FOR CPE CREDIT.