Webinars
Complete 2009 Schedule
Duration of each webinar: 50 minutesEach webinar will be followed by a live question and answer session at the end. Purchase a season pass for the low price of $499 to attend all webinars for this season, Click Here.
Excel Speed Tips - $79 or included with Season Pass
Learn numerous expert level tricks that will enable to you save significant time. This fast paced session is all about helping you using Excel faster.
Tuesday, April 28
Mastering Excel Pivot Tables - $79 or included with Season Pass
Learn how to prepare and then analyze data using one of Excel's most powerful features.
Tuesday, May 12
SQL for Excel Users - $79 or included with Season Pass
Learn how to use Microsoft Query and simple SQL statements
to filter and sort data that you extract from just about any source, including accounting software exports, Microsoft Access databases, and other sources.
Tuesday, May 19
Excel 2007: Filtering and Formatting Data - $79 or included with Season Pass
Get the lowdown on all of the new ways that Excel 2007 users can analyze data, including conditional formatting; data bars; color scales; icon sets, and tricks like using SUBTOTAL to create on the fly totals.
Tuesday, November 17
Also presented on Thursday, June 4
Easing the Transition to Excel 2007 - $79 or included with Season Pass
This session will help anyone currently using Excel 2003 or an earlier version get up and running quickly in the new Excel 2007 user interface. Existing Excel 2007 users will learn a few tricks they may have missed previously.
Thursday, June 11
Automating Excel-based Financial Statements - $79 or included with Season Pass
Use overlooked functions like OFFSET and INDIRECT to create financial statements dynamically compute YTD totals or summarize data from other worksheets without requiring tedious formulas.
Thursday, June 18
Beyond VLOOKUP: Mastering Advanced Excel Formulas - $79 or included with Season Pass
Look-up formulas are far superior to manually pointing to specific data elements in a spreadsheet. Many users rely on VLOOKUP to return data from other locations in a worksheet, but is that the most efficient approach? This session will explore alternatives like MATCH/INDEX, SUMIF, COUNTIF, as well as using SUMPRODUCT to look up values based on multiple criteria.
Thursday, June 25
Beyond QuickBooks Reports: 10 Simple Excel Strategies - $79 or included with Season Pass
Learn how to overcome limitations of QuickBooks internal reports, such as combining two reports into one, as well as creating pivot tables from QuickBooks data.
Thursday, July 9
Importing and Exporting Data from QuickBooks and Peachtree Accounting - $79 or included with Season Pass
Learn about tools and techniques that enable you to export data from these two accounting packages, and then analyze the data in Microsoft Excel or Access. Also learn the basics about importing lists and transactions into both programs.
Tuesday, August 11
Beyond Excel: A CPA’s Introduction to Access 2007 - $79 or included with Season Pass
This interactive webinar will provide an introduction to Access 2007 for CPAs that have mostly worked in Excel by way of building a simple timekeeping database from scratch.
Tuesday, August 18
Outlook Secrets for CPAs - $79 or included with Season Pass
You spend a large amount of your day in Outlook, so make sure that you know all of the tips and tricks to use it as efficiently as possible.
Tuesday, August 25
Word Secrets for CPAs - $79 or included with Season Pass
You've likely mastered Excel, and yet you muddle your way through word processing tasks mdash; learn techniques that enable you to use Word at the same high level as you use Excel.
Tuesday, September 15
Introduction to XML and XBRL - $79 or included with Season Pass
Learn why XML is shouldering its way to the top as the ideal data format, and how XBRL is becoming the defacto standard for accounting reports.
Tuesday, September 22
Introduction to Excel Macros - $79 or included with Season Pass
This session will provide help you get started with the most powerful feature in Excel by far, Visual Basic for Applications. Master the macro recorder, and then get a list of recommended resources to further your knowledge.
Tuesday, September 29
Creating Error Proof Spreadsheets - $79 or included with Season Pass
Learn ways to minimize errors in your spreadsheets.
Thursday, October 1
Previously presented on April 23, 2009
Excel Speed Tips - $79 or included with Season Pass
Learn numerous expert level tricks that will enable to you save significant time. This fast paced session is all about helping you using Excel faster.
Thursday, October 8
Also presented on April 28, 2009
