March 4, 2008

Newsletter Archives

Unsubscribe

MSCPA Home

> Introducing…the MSCPA Career Center! Just launched late last week, this new Missouri-CPA centric online career center is expected to become a popular and highly sought-after recruiting resource. Free for job seekers; employers, enjoy 50 percent off during the month of March. Enter INTRO in the promotional code box! http://careers.mocpa.org/ ______________________________________________________________ > Congratulations to LEAP Challenge Preliminary Round Winners! Seventeen teams of accounting students competed in the LEAP Challenge preliminary rounds held throughout Missouri during February. The following teams won their preliminary rounds and will now advance to the LEAP Challenge Championship held at the 2008 Annual Members Convention on Friday, May 30! Northwest Missouri State University Missouri Western State University University of Central Missouri Truman State University Drury University Southeast Missouri State University Missouri Baptist University ______________________________________________________________ > Small Firm Practitioners – Sign Up Now! Come see why so many small firm practitioners keep coming back to the MSCPA Small Firm Networking Roundtables!  Meet other practitioners from across the state and expand your knowledge network while discussing the issues that matter to you most.  Date: Wednesday, May 7, 2008 Location: Marriott Country Club Plaza in Kansas City, MO Time: 8:30 a.m. to 1:30 p.m. Cost: $75 (breakfast and lunch included) CPE: 3 hours Register now! Sign up today to join this very energetic group and to take away best practices you can immediately apply to your business!  http://www.mocpa.org/Content/21056.aspx ______________________________________________________________ > LAST CHANCE! 2008 Annual MSCPA Awards Do you know someone who has made a unique contribution to the accounting profession?  Nominate that person for the 2008 Annual MSCPA Awards! Each year, the MSCPA recognizes CPAs who have served their profession and/or community above and beyond their responsibility. Nominations are accepted in five categories: Outstanding Educator Award Outstanding CPA in Government Innovative User of Technology Public Service Award Outstanding CPA in Business & Industry Nominations are due March 14, 2008. http://www.mocpa.org/Content/awards.aspx ______________________________________________________________ > Newly Revised Form 4136 The IRS has announced that agricultural industry taxpayers, farmers and fishermen, who electronically file Form 1040 returns with Form 4136, Credit for Federal Tax Paid on Fuels, must wait until March 3 to e-file the newly-revised Form 4136, which can be accessed below: http://www.irs.gov/pub/irs-pdf/f4136.pdf ______________________________________________________________ > Economic Stimulus Payments Information Center The IRS has published a page on its website that provides comprehensive information about the 2008 Economic Stimulus Act. http://www.irs.gov/irs/article/0,,id=177937,00.html ______________________________________________________________ > 2008 Economic Stimulus Act: Incentives For New Construction Great news for taxpayers who are embarking on a new construction project or are adding leasehold improvements in 2008 - the Economic Stimulus Act of 2008 was officially signed into law on February 13, 2008, and with it, 50% bonus depreciation is back for a limited time. http://www.mocpa.org/content/files/pdfs/econstimulus.pdf ______________________________________________________________ Sponsored By: Information, Inc. Information Inc.'s handcrafted business intelligence services provide up-to-the-minute information on critical issues. Decision-makers in more than 2,000 major corporations, associations and government agencies worldwide have relied on our comprehensive news services for the past 22 years. To learn how our timely, targeted, custom services can help you compete in the 21st century, go to: http://www.infoinc.com/s tatecpa/contact.html Technology & Productivity Weekly is a membership benefit and is intended for your personal use only. This Week's Headlines Tech to Boost Teamwork 10 Ways to Trim Your IT Budget Demystifying a Wireless Network Before the Storm Rewind Your Network Woes Can E-Mail Authentication Kill Spam? Portals: Gateways to Data Company Email on Employee-Owned Cell Phones Open Source Applications for Small Business Speeding Toward Convergence: Changes to Come Rapidly for Accounting Profession Camera-Ready

CPE 2008 For CPAs in Public Practice Be on the lookout in April for the 2008-2009 CPE Catalog! 2008 MSCPA Conferences Announced _______________________________ Technology Tip of the Week Provided by the MSCPA Information Technology Committee In Excel, Counting Unique Numeric Values or Unique Data in a List Problem:  Counting the number of unique numeric values or unique data in List1, disregarding blank cells. Solution1: To count the number of unique values use the SUM, IF, and FREQUENCY functions as shown in the following formula: = SUM(IF(FREQUENCY (A2:A13,A2:A13)>0,1)) Solution 2: To count the number of unique data use the SUMPRODUCT and COUNTIF functions as shown the following formula: =SUMPRODUCT((A2:A13<>"") /COUNTIF(A2:A13,A2:A13&"")) More To view recently archived issues of “Technology Tip of the Week,” go to: http://www.mocpa.org/Content/22269.aspx ________________________________ Contact Us For comments or questions, contact: Dawn Martin - dmartin@mocpa.org To view online: http://www.mocpa.org/Content/files/ newsletters/2008/news030408pp.html For technical assistance, contact: Christy Aven -caven@mocpa.org To update your e-mail address: Please include your old e-mail address, new e-mail address and MSCPA member ID (if known) and send it to member@mocpa.org. Please note: This newsletter may contain commercial material. Missouri Society of CPAs 540 Maryville Centre Drive, Suite 200 St. Louis, MO 63141 © 2008 Missouri Society of Certified Public Accountants - All Rights Reserved