content here
Customer Service 800-328-1452

Educator's Site

SocialTwist Tell-a-Friend

Advanced Microsoft Excel 2016

Availability: Out of stock

Format Product Name
No options of this product are available.

Click on image to zoom

Pages: 864 | Copyright: 2018

Author(s): Jan Davidson, Lambton College; and Jan Marrelli

Overview

Designed for advanced spreadsheet courses, Advanced Microsoft Excel 2016 focuses on data analysis, problem solving, business, finance, and information systems. In each chapter, students have the opportunity to apply their new knowledge as they acquire it while working through a job-based project and video tutorial.

Available December 2017

Table of Contents
  1. Preparing an Excel Workbook
  2. Inserting Formulas and Functions
  3. Applying Formatting to Text and Data
  4. Inserting Visual Elements and Modifying Page Setup
  5. Managing Workbooks
  6. Inserting and Formatting Charts
  7. Creating and Managing Tables
  8. Creating PivotTables and PivotCharts
  9. Inserting Advanced Formulas and Formatting
  10. Using Financial Functions and Analysis Features
  11. Applying Advanced Formatting
  12. Calculating and Analyzing Business Data
  13. Importing and Exporting Data
  14. Sharing a Workbook
  15. Automating Repetitive Tasks and Customizing Excel