Overview

This is learning made easy. Students will get productive fast with Excel 2016 and jump in wherever they need answers--brisk lessons and colourful screen shots show them exactly what to do, step by step. The quick way to learn Microsoft Excel 2016! Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Filter, sort, summarise, and combine data Analyse data by using PivotTables, PivotCharts, scenarios, data tables, and Solver Visualise data with charts and graphs, including new sunbursts, waterfalls, and treemaps Build data models and use them in business intelligence analyses Create timelines, forecasts, and visualisations, including KPIs and PowerMap data maps Look up just the tasks and lessons you need

Full Product Details

Author:   Curtis Frye
Publisher:   Microsoft Press,U.S.
Imprint:   Microsoft Press,U.S.
Dimensions:   Width: 19.00cm , Height: 2.00cm , Length: 23.00cm
Weight:   0.800kg
ISBN:  

9780735698802

ISBN 10:   0735698805
Pages:   544
Publication Date:   29 October 2015
Audience:   College/higher education ,  Tertiary & Higher Education
Replaced By:   9781509307678
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Part 1: Create and format workbooks Chapter 1: Set up a workbook Chapter 2: Work with data and Excel tables Chapter 3: Perform calculations on data Chapter 4: Change workbook appearance Part 2: Analyze and present data Chapter 5: Manage worksheet data Chapter 6: Reorder and summarize data Chapter 7: Combine data from multiple sources Chapter 8: Analyze alternative data sets Chapter 9: Create charts and graphics Chapter 10: Create dynamic worksheets by using PivotTables Part 3: Collaborate and share in Excel Chapter 11: Print worksheets and charts Chapter 12: Automate repetitive tasks by using macros Chapter 13: Work with other Microsoft Office apps Chapter 14: Collaborate with colleagues Part 4: Perform advanced analysis Chapter 15: Perform business intelligence analysis Chapter 16: Create forecasts and visualizations Keyboard shortcuts Glossary Index About the author

Reviews

Author Information

Curtis Frye is the author of more than 30 books, including  Microsoft Excel 2013 Step by Step for Microsoft Press and  Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for lynda.com, including  Excel for Mac 2016 Essential Training and  Excel 2013: PivotTables in Depth. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions