Lynda - Excel 2016 Essential Training
Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.
Table of Contents
Introduction1. Getting Started with Excel2. Entering Data3. Creating Formulas and Functions4. Formatting5. Adjusting Worksheet Layout and Data6. Printing7. Charts8. Adjusting Worksheet Views9. Multiple Worksheets and Workbooks10. IF, VLOOKUP, and Power Functions11. Security and Sharing12. Data Management Features13. Data Analysis Tools14. PivotTables15. Introduction to MacrosConclusion