Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.
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.
Shares easy-to-use database commands and methods for maintaining an Excel database.
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 »