It's easy to hide worksheets in Excel, but unhiding multiple worksheets within a given workbook can be a tedious exercise. Users who don't know otherwise are relegated to unhiding worksheets one at a time.
If two items on a list share the same value, MATCH/INDEX will return the same name for both items. Excel expert David Ringstrom describes how to use the COUNTIF function to create a tiebreaker in such situations.
Excel guru David Ringstrom explains how to rank a series of items within an Excel spreadsheet using the LARGE and SMALL functions.
High Impact Excel: Pivot Table Edition
Following up on the success of his popular High Impact Excel session, this time around David H. Ringstrom, CPA turns his attention to pivot tables. In one hour you'll learn how to whip unwieldy data into shape, and then quickly build meaningful reports by dragging and dropping with your mouse. David will also discuss techniques for improving pivot table data integrity. Detailed handouts with numbered steps will be provided for a variety of Excel versions.