Home > Computer & Internet > Business applications > Spreadsheet software > Excel > Excel 2016 PivotTables And PowerPivot: Supports Excel 2010, 2013, And 2016
1%
Excel 2016 PivotTables And PowerPivot: Supports Excel 2010, 2013, And 2016

Excel 2016 PivotTables And PowerPivot: Supports Excel 2010, 2013, And 2016

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

This Step-By-Step Workbook will guide you through the PivotTable features including PowerPivot, PowerQuery, PowerView, and PowerMap Add-ins. It can be used by a beginner to understand PivotTables, and an advanced student to learn the PowerPivot capabilities of Excel. Included are over 140 Practice Exercises that demonstrate how to use Excel concepts. They can also be used as a reference guide to quickly look up specific topics.

What's is in the workbook? Click on the left side of the screen: Look Inside!
Enter one of the following keywords: PivotCharts, PivotTable, Add-In, PowerPivot, PowerView, PowerQuery, PowerMap, etc.
Take A Class: http: //www.elearnlogic.com/download/schedule18.pdf

The PivotTable chapter will answer the basic question "Why do you want to use a PivotTable?" Once you understand "why," you will have a deeper appreciation for its capabilities. PivotTables are very similar in all versions; however, new features have been added to Excel 2013 and 2016. The following topics will be covered:

  • Filtering - This will allow you to focus on required records and reduce the amount of data available.
  • Formatting - This will review many Excel formatting features as well as some custom PivotTable commands.
  • PivotCharts - This will allow you to chart information for better understanding.
  • Layout Adjustments - This will allow you to arrange and adjust fields in order to focus on the most valuable information.
  • Calculations - Calculations can be internal or external to the PivotTable.
The Business Intelligence tools include The PowerPivot, PowerView, PowerQuery and PowerMap. They are Add-In features in Excel 2010/2013 which means they must be downloaded from the Microsoft website, installed on your computer, and added using the Add-In feature in the Excel Options menu. In Excel 2016, they are a standard Add-In feature which means you do not need to download and install. All of these tools will provide the capabilities to analyze data and better understand information in an Excel workbook. The following topics will be covered:
  • PowerPivot - Students will need to understand PivotTables in order to use the PowerPivot features effectively. This is a technique used to create relationships between sheets similar to Access databases.
  • PowerView - This is a new way to generate reports from an Excel sheet.
  • PowerQuery - This is a tool used to extract and filter information from a data source prior to saving to an Excel sheet.
  • PowerMap - This is a technique used to build charts on a map of the world indicating population or revenue.
Design Strategy
This workbook is designed in conjunction with an Online-Instructor-Led course (for more information see: www.elearnlogic.com). There are many Step-By-Step Practice Exercises and more comprehensive Student Projects offered to help students better understand concepts. Furthermore, they will find that this workbook/guide can often be used as a reference to help them understand concepts quickly and thoroughly. An index is also provided on the last page to reference important topics as necessary. However, if more detail is needed for study, the Internet can be used, as well, to search a concept. Also, if student's skills are weak due to lack of implementation, they can refresh their knowledge quickly by visually scanning concepts of choice, and then testing them out using the application.
About the Author: Jeff Hutchinson is a computer instructor teaching a variety of classes around the country. He has a BS degree from BYU in Computer-Aided Engineering and has worked in the Information Technology field supporting and maintaining computers for many years. He also previously owned a computer training and consulting firm in San Francisco, California. After selling his business in 2001, he has continued to work as an independent computer instructor/consultant around the country. Jeff Hutchinson lives in Utah and also provides training for Utah Valley University Community Education system, offering valuable computer skills for the general knowledge of students, career development, and career advancement. Understanding the technology and the needs of students has been the basis for developing this material. Jeff Hutchinson can be contacted at jeffhutch@elearnlogic.com or (801) 376-6687.


Best Sellers



Product Details
  • ISBN-13: 9781975987220
  • Publisher: Createspace Independent Publishing Platform
  • Publisher Imprint: Createspace Independent Publishing Platform
  • Height: 280 mm
  • No of Pages: 136
  • Series Title: Excel 2016 Level 4
  • Weight: 331 gr
  • ISBN-10: 1975987225
  • Publisher Date: 31 Aug 2017
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Spine Width: 7 mm
  • Width: 216 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Excel 2016 PivotTables And PowerPivot: Supports Excel 2010, 2013, And 2016
Createspace Independent Publishing Platform -
Excel 2016 PivotTables And PowerPivot: Supports Excel 2010, 2013, And 2016
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Excel 2016 PivotTables And PowerPivot: Supports Excel 2010, 2013, And 2016

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals



    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!