Friday, March 31, 2017

Taxing Policies and Rules for Sales and Use Tax

Attend upcoming webinar and earn continuing education credits.
Live Webinars   |   On-Demand   |   All-Access Plan
Manage Preferences    |    View in Browser
Visit Clear Law Institute
Taxing Policies and Rules for Sales and Use Tax
April
 
17
3 pm - 4:40 pm ET
Presenter: Jim Frazier, CPA, President of Take Charge Seminars
Credits: CPE, IRS EA, CLE in all states (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
Learn More
Register Today
Course Description
 
Sales tax rules are complicated and vary by state. Several states are taking an aggressive approach on taxing out of state vendors, thereby creating a formula for an audit disaster. This webinar will cover most taxability issues and will address complications involved in sales tax calculation. Among other things, you'll learn about the following:
  • How specific industries are taxed; including construction and manufacturing
  • Myths about taxing purchases by non-profits and government agencies
  • How specific products and services are taxed including repairs, leases, and containers
  • How states deal with technology, including software, multiple points of use, data processing services, digital products, and data centers
  • How to unravel the mysteries of taxing freight and shipping charges
  • How to find the specific rules for the states where you do business
  • How to immediately avoid unnecessary taxes and minimize future assessments and penalties
Learn More
Register Today
The Presenter
About The Presenter
 
Jim Frazier, CPA, is president of Take Charge Seminars, a training company specializing in seminars, webinars and publishing on sales and use. Mr. Frazier started The Sales Tax Guy in 2005, one of the only sales tax blogs in the world at the time. Previously, Mr. Frazier served in accounting and financial management positions for a wide variety of industries. He frequently presents on issues in taxes and accounting. Mr. Frazier is a graduate of DePaul University.
Learn More
Register Today
All-Access Membership
 
● 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,000 on-demand courses
Learn More
Upcoming Webinars
Using Relevant Ratios as the Basis for Key Business Decisions
April 4 at 1 pm ET
Learn More
Proactively Managing Cash Flow
April 5 at 3 pm ET
Learn More
Creating an Effective and Efficient Travel and Entertainment Expense Reimbursement Policy
April 6 at 1 pm ET
Learn More
Questions?
Please call us at 703-372-0550

Our Mailing Address:
Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203
Remove me from future emails.

Manage email preferences.

This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.
 

Thursday, March 30, 2017

Tomorrow: Excel Logic Formulas: IF, AND, OR, and More

Attend upcoming webinar and earn continuing education credits.
Live Webinars   |   On-Demand   |   All-Access Plan
Manage Preferences    |    View in Browser
Visit Clear Law Institute
Excel Logic Formulas: IF, AND, OR, and More
March
 
31
1 pm - 2:40 pm ET
Presenter: David Ringstrom, author and nationally recognized Excel 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
Learn More
Register Today
Course Description
 
While many Excel users rely on the IF function, they're often unaware of ways to improve the integrity of decision-making formulas. In this practical webinar, you will learn how to apply the IF function and its powerful alternatives such as IFS, CHOOSE, VLOOKUP, and SUMIF functions. Upon completion of this course, you will be able to:
  • Transform SUM, MIN, and MAX into multi-criteria array formulas
  • Define the pros, cons, and limitations of nesting IF functions
  • Use the SUMIF function to summarize data based on a single criterion
  • Compare IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions
  • Compare the MIN, SMALL, MAX, and LARGE functions
  • Use the SUMIFS function to sum values based on multiple criteria
  • Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can't find a match
  • Identify the range of IS functions that can be used within IF statements to test for various conditions within a worksheet
  • Use the COUNTIF function to determine the number of times an item appears on a list
  • Apply the MINIFS function in Excel 2016
  • Use the IF function to compare two cells directly to return TRUE or FALSE values
  • Avoid the complexity of nested IF statements with Excel's CHOOSE function
Learn More
Register Today
The Presenter
About The Presenter
 
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 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.
Learn More
Register Today
All-Access Membership
 
● 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,000 on-demand courses
Learn More
Upcoming Webinars
Using Relevant Ratios as the Basis for Key Business Decisions
April 4 at 1 pm ET
Learn More
Proactively Managing Cash Flow
April 5 at 3 pm ET
Learn More
Creating an Effective and Efficient Travel and Entertainment Expense Reimbursement Policy
April 6 at 1 pm ET
Learn More
Questions?
Please call us at 703-372-0550

Our Mailing Address:
Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203
Remove me from future emails.

Manage email preferences.

This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.