Boot Camp for QuickBooks

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Boot Camp for QuickBooks January   26 1 pm - 2:40 pm ET Presenter: Mario Nowogrodzki, Founder and Principal of Mendelson Consulting 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 Course Reviews: View Testimonials Can't wait? View previously recorded version now Learn More Register Today Course Description   In this webinar, you'll learn how to maximize your use of QuickBooks and save time. You'll learn about key QuickBooks features and learn answers to your QuickBooks dilemmas. Upon completion of this course, you'll be able to: Recognize which edition you need to use Know when to utilize QuickBooks Add-Ons Create and work with lists Use essential QuickBooks features Customize QuickBooks Identify practical tips for working with QuickBooks Course Reviews from Past Attendees 100% of attendees said they would recommend this course to others. "It was very informative in a relatively short period of time." Learn More Register Today About The Presenter   Mario Nowogrodzki, CPA/CITP, is an information systems consultant and instructor. He is also the founder and principal of Mendelson Consulting, which specializes in QuickBooks and information technology consulting services. Mr. Nowogrodzki is a frequent author and instructor of QuickBooks and technology topics and a contributing author and speaker for Intuit, The Sleeter Group, and The Woodard Group. Mr. Nowogrodzki was named to the 'Top 10 ProAdvisor' list, an exclusive list of prominent consultants honored for their accomplishments and leadership in the field of QuickBooks, and was named Top Integrations ProAdvisor out of a field of over 150,000 ProAdvisors worldwide. 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 850 on-demand courses Learn More Upcoming Webinars International Tax and Reporting for Cross-Border Transactions January 9 at 3 pm ET Learn More New and Enhanced FBAR and FATCA Reporting Requirements January 10 at 1 pm ET Learn More 10 Ways to Improve Excel Workbooks January 11 at 3 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 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.

Excel Lookup Formula Basics

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Excel Lookup Formula Basics January   25 1 pm - 2:40 pm ET Presenter: David Ringstrom, CPA, Owner and Founder of Accounting Advisors, Inc. 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 Course Reviews: View Testimonials Can't wait? View previously recorded version now Learn More Register Today Course Description   Lookup functions enable you to work more efficiently in Excel and quickly find the information you're looking for, rather than manually linking to specific cells. In this webinar, you'll learn how and when to use the VLOOKUP and HLOOKUP functions in Excel as well as troubleshooting techniques to ensure your lookup formulas are working properly. You'll improve the integrity of your spreadsheets, perform dual lookups, scan a column for # sign errors, identify differences between two lists, and much more. Upon completion of this course, you'll be able to: Apply the VLOOKUP and HLOOKUP functions Manage subtle issues that can prevent lookup functions from working properly Use wildcards and multiple criteria within lookup formulas Identify the risks of linked workbooks, determine if a workbook contains links, and see how links can hide within Excel features Perform dual lookups, which allow you to look across columns and down rows to cross-reference the data you need Recognize when you might wish to use ISERROR or ISNA instead of IFERROR Utilize other excel functions, including: Excel's Filter feature to quickly scan a column for # sign errors Excel's TRIM function to eliminate extraneous spaces that can compromise lookup functions The IFERROR function to display something other than an #N/A error value when VLOOKUP can't find a match The MATCH worksheet function to identify differences between two different lists Course Reviews from Past Attendees 100% of attendees said they would recommend this course to others. "New tricks I was not aware of!" "Everything is written and spelled out - with slides for reference." Learn More Register Today 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 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 850 on-demand courses Learn More Upcoming Webinars The 1099 & W-9 Annual Update Course January 3 at 3 pm ET Learn More Nexus and Drop Shipments and Sales and Use Tax January 4 at 3 pm ET Learn More Detecting & Preventing Payroll Fraud January 5 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 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.