Learn how to use the data validation tools in Excel 2016 to control how users input data into workbooks and ensure data is entered consistently and accurately.
Save time by automating repetitive tasks with Excel macros. Learn how to record, edit, and run simple macros, and program more complex macros with VBA.
Learn easy-to-use commands, features, and functions for managing and analyzing large amounts of data in Excel 2016.
Master Excel formulas and functions—once and for all. Get tips for using the most challenging of the 450+ functions in Excel for Mac 2016.
“lynda.com has made it possible and affordable to retool and get back to work after raising my kids. I can't imagine working without this resource now.” —Maureen C.
more from our members »