Explores the functions, commands, and techniques in Excel that quickly restructure data, remove unwanted characters, convert date data into the desired format, and prepare data for efficient analysis.
Spells out the design considerations and tools needed for creating a database in Excel.
“When a director at work asked for an Excel spreadsheet, and said "just use pivot tables, it's easier,” I hid my ignorance, went immediately to lynda.com, and voilá! I now use pivot tables extensively.” —Cathy N.
more from our members »