a Sift Media publication
Sift Media logo

Excel 2007: Filtering and Formatting data

Thursday, June 4, 1:00 Eastern

Excel 2007 introduced many powerful new data analysis features. This session will focus on techniques that you can use to quickly tame large sets of data.

In this exciting one-hour webinar Excel expert David Ringstrom, CPA shares dozens of the tricks that he uses to fly through Excel every day. Remember, either you work Excel, or it works you! 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
  • Explore new filtering capabilities, such as filtering by color
  • Discover advanced conditional formatting, such as data bars, color scales, and icon sets
  • Learn how to use the SUBTOTAL function to quickly analyze your data
  • Use pivot tables to summarize data
  • Discover the undocumented AutoFilter command
  • Discover how to sort data sideways
  • Use Custom Lists to sort your data in non-alphabetical order


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.