Dennis Taylor – 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.
Topics include:
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros
Table of contents:
01. Introduction
02. Getting Started with Excel
03. Entering Data
04. Creating Formulas and Functions
05. Formatting
06. Adjusting Worksheet Layout and Data
07. Printing
08. Printing
09. Adjusting Worksheet Views
10. Multiple Worksheets and Workbooks
11. IF, VLOOKUP, and Power Functions
12. Security and Sharing
13. Data Management Features
14. Data Analysis Tools
15. PivotTables
16. Introduction to Macros
17. Conclusion
Get Download Dennis Taylor – Excel 2016 Essential Training at Offimc.com Now!
Delivery Information
- Upon ordering the product, a delivery email with download instructions will be sent immediately to you so that you may download your files. If you log in (or create an account) prior to purchase you will also be able to access your downloads from your account dashboard.
- It is a digital download, so please download the order items and save them to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link to you.
- If you don't receive the download link, please don’t worry about that. We will update and notify you as soon as possible from 8:00 AM – 8:00 PM (UTC+8).
- Please Contact Us if there are any further questions or concerns you may have. We are always happy to assist!
6 reviews for Excel 2016 Essential Training – Dennis Taylor
There are no reviews yet.