Subject: Designing Error-Proof Spreadsheets in Excel
From: "Michael Tobin, Clear Law Institute" <[email-masked]>
To: Zachary Allen <[email-masked]>
Date: Thu, 3 Dec 2015 09:30:41 -0800

View this email in your Browser:
(http://marketing.cllearn.com/acton/rif/9643/s-0da0-1512/-/l-018e:1baaef/q-0318/showPreparedMessage)

**Designing Error-Proof Spreadsheets in Excel**
--------------------------------------------------------------

December 4
1 pm - 2:40 pm ET
Presenter: David Ringstrom, Owner and Founder of Accounting Advisors
Credits: CPE, IRS EA
Viewing Options: Live and/or recording for 6 months on your computer, tablet, or smartphone

Learn More and Register Today:
http://cllearn.com/cllearn/designing-error-proof-spreadsheets-in-excel/?utm_source=Shared%20IP&utm_medium=Email&utm_campaign=12%2F3%20-%20Designing%20Error-Proof%20Spreadsheets%20in%20Excel

**Course Description**
--------------------------------------------------------------
In this practical webinar, you'll learn how to minimize data integrity
risks within your Excel spreadsheets. You'll build resilience into your
spreadsheets that reduce your errors and save time. Upon successful
completion of this course, you will be able to:
Protect the master copies of your spreadsheets by saving them as Excel
templates
Use Data Validation to input rules or drop-down lists within Excel
worksheets
Utilize Excel's Custom Views feature to make one worksheet serve
multiple purposes
Compare and contrast IFNA, IFERROR, and ISERROR
Identify free, prebuilt templates in Excel to get a jump start on
spreadsheet projects
Recognize how range names minimize errors, save time in Excel, serve as
navigation aids, and can store information in a hidden location
Prevent users from circumventing data validation, and easily identify
when they attempt to do so
Minimize ongoing spreadsheet maintenance with Excel's Table feature
Protect key formulas by using the Hidden and Protect features
Arrange two worksheets from within the same workbook onscreen at the
same time
Use Conditional Formatting to color code your data, identify duplicates,
and apply icons

**About The Presenter**
--------------------------------------------------------------
David H. Ringstrom, CPA, is the owner and founder of Accounting
Advisors, Inc., a spreadsheet consulting firm. Mr. Ringstrom provides
Microsoft Excel training and consulting services nationwide. He
frequently presents on Microsoft Excel at webinars and conferences,
regularly publishes articles about spreadsheets, and has edited dozens
of books on accounting software.

**All-Access Membership**
--------------------------------------------------------------
View hundreds of live and On-Demand courses for one flat fee
Earn continuing education credit for no additional fee
Access courses on your computer, tablet, or smartphone

Learn More about the membership:
http://cllearn.com/cllearn/all-access-memberships/?utm_source=Shared%20IP&utm_medium=Email&utm_campaign=12%2F3%20-%20Designing%20Error-Proof%20Spreadsheets%20in%20Excel

--------------------------------------------------------------
Our Mailing Address:
Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA |
22201

Remove me from future emails:
http://marketing.cllearn.com/acton/rif/9643/s-0da0-1512/-/l-018e:1baaef/q-0318/zout?sid=mqNY7CgU8