a Sift Media publication
Sift Media logo

SQL For Excel Users

Tuesday, May 19, 1:00 Eastern

In this exciting one-hour webinar Excel expert David Ringstrom, CPA shares data analysis tricks that he uses to query text files and databases from within Excel. At the end of the presentation you can ask any Excel questions you have of the speaker, even if they're not specifically related to the presentation.

See Full List of Webinar Offerings
Click Here to Purchase

Program Content

Level: intermediate to advanced
Delivery Method: Group Internet-Based
Field of Study: Specialized Knowledge and Applications
  • Learn how to link your spreadsheets directly to text files that you download from other sources
  • Use Microsoft Query to access data from a variety of sources, including text files, databases, and even other Excel spreadsheets
  • Craft analysis formulas that expand to additional rows as needed
  • Learn basis SQL statements that you can use to query your data
  • Get an overview of how to use pivot tables to analyze the resulting data
  • Summarize data by using SUMIF, COUNTIF, and SUMPRODUCT


Program Prerequisites

  • none

Advance Preparation

  • None, but we'll provide a copy of the handout for you to review prior to the session.

Recommended CPE Credits

  • one hour

Registration Instructions

Refund/Cancellation Policy

Please direct questions, complaints, cancellations, or refund requests to Rob Nance, Publisher, at AccountingWEB at publisher@accountingweb.com or 1.866.688.1678 ext. 16. We will do our best to ensure that every attendee is completely satisfied.

Complaint Resolution Policy

AccountingWEB, Inc. will address any and all complaints, after each event, with dissatisfied customers.


Accountingweb, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Web site: www.nasbatools.com.