Ctrl+shift+enter

Created for heavy-duty users who prefer a visual learning experience, this DVD-ROM is an all-encompassing video edition of Ctrl+Shift+Enter Mastering Excel Formulas . Users have the option of choosing a topic of interest from an assortment of videos featured on the menu, and once viewing the segment, they may click a link adjacent to the video to launch the Excel file featured in the segment. Compatible with Macs or PCs and narrated throughout, the DVD-ROM can function as a stand-alone educational tool or be used to enhance the understanding of the book's contents. With this tutorial, power users will learn to create formulas that solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Among the topics covered are the differences between array and standard Excel formulas, which functions are appropriate for their usage, and criteria for extracting data and lists.

Mike Girvin is the author of Slaying Excel Dragons and has more than 800 Excel how-to videos on YouTube. He teaches finance, accounting, and statistics using Excel at the community college level. He lives in Seattle.