Excel 2016 Essential Training
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.


  • Introduction
  • 1. Getting Started with Excel
  • 2. Entering Data
  • 3. Creating Formulas and Functions
  • 4. Formatting
  • 5. Adjusting Worksheet Layout and Data
  • 6. Printing
  • 7. Charts
  • 8. Adjusting Worksheet Views
  • 9. Multiple Worksheets and Workbooks
  • 10. IF, VLOOKUP, and Power Functions
  • 11. Security and Sharing
  • 12. Data Management Features
  • 13. Data Analysis Tools
  • 14. PivotTables
  • 15. Introduction to Macros
  • Conclusion


Information
Members of Guests cannot leave comments.




rss