->
Excel 2016 Essential Training
Categories: Tutorials

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


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Coktum   |  

Information
Members of Guests cannot leave comments.


Categories Sitemap



rss