Request Inspection Copy

If you are an Academic or Teacher and wish to consider this book as a prescribed textbook for your course, you may be eligible for a complimentary inspection copy. Please complete this form, including information about your position, campus and course, before adding to cart.

* Required Fields

To complete your Inspection Copy Request you will need to click the Checkout button in the right margin and complete the checkout formalities. You can include Inspection Copies and purchased items in the same shopping cart, see our Inspection Copy terms for further information.

Any Questions? Please email our text Support Team on text@footprint.com.au

Submit

Email this to a friend

* ALL required Fields

Order Inspection Copy

An inspection copy has been added to your shopping cart

Data Visualization and Presentation with Microsoft Office

by Valerie M Sue and Matthew Griffin SAGE Publications, Inc
Pub Date:
01/2016
ISBN:
9781483365152
Format:
Pbk 360 pages
Price:
AU$95.00 NZ$97.39
Product Status: Available in Approx 7 days
add to your cart
Instructors
& Academics:
Available as eBook
AU$76.00 | NZ$85.13

Other Available Formats:

There are many Microsoft Office manuals on the market, a good number of graphic design texts, and a few excellent data visualization books. However, a single text that combines the technical and aesthetic elements to create accurate and visually appealing data displays using readily available software is lacking in the marketplace.

Data Visualization with Microsoft Office will cover the full range of tasks, from procuring data to presenting a report and provides step-by-step instructions for creating visual data displays. The focus is on turning raw, quantitative data into attractive, well-designed tables and charts that tell an accurate story about the underlying data. Valerie M. Sue and Matthew Griffin's approach is unique in that they discuss theory, for example, how perspective can be used to convey the relative importance of elements in a design, and then turn that into practice as they apply the principle to creating a chart. They use Microsoft Office programs (Excel, PowerPoint, Word, and Publisher) to illustrate and teach the principles, thus rendering the text accessible to a large audience.

Section I: Displaying Data1. Choosing Data Displays Learning Objectives Information and Audience Considerations Are You Preparing a Report or Presentation? Forms of Data Visualization Covered in This Text Summary2. Bar and Column Charts Learning Objectives Data Appropriate for Bar and Column Charts Best Practices for Creating Column and Bar Charts Choosing Between Bar and Column Charts Summary3. Line and Area Charts Learning Objectives Single-Series Line Charts Multi-Series Line Charts Area Charts Multi-Series Area Charts Stacked Area Charts Summary4. Pie Charts Learning Objectives The Trouble with Pie When to Use a Pie Chart Best Practices for Creating Pie Charts Alternatives to Pie Charts Summary5. Chart Formatting Learning Objectives Remove Unnecessary and Redundant Information Chart Titles Chart Legends Chart Axes Charts with Data Tables Labeling Individual Data Values Labeling the Y-Axis on a Bar Chart Formatting Numbers on Data Labels and Axes Formatting Dates Fonts Color Chart Templates Perspective SummarySection II: Preparing Data for Charting6. Preparing Data for Charting Learning Objectives Downloading Data Cleaning Data Summarizing Data Creating a Dynamic Summary Table Subtotal Summary7. Pivot Tables and Pivot Charts Learning Objectives Introduction to Pivot Tables Organizing Data for Pivot Tables Creating a Pivot Table Modify and Explore Pivot Table Filtering Data Changing Summary Data Values Nesting Variables Totals and Subtotals Refreshing Pivot Table Data Grouping Data Pivot Charts Summary8. Tables - When Charts Aren't Enough Learning Objectives Excel's Table Feature Table Formatting Best Practices Custom Table Styles SummarySection III: Presenting Data9. Reports Learning Objectives Report or Presentation? Moving Charts from Excel to Word Moving Tables from Excel to Word Word's Layout Options Professional Reports Posters Infographics Dashboards Summary10. Creating Presentations Learning Objectives Perspectives on Presentations Three Presentation Elements Designing Audience Slides Creating Speaker Notes Creating Handouts Summary11. Delivering Presentations Learning Objectives Preliminary Considerations Speaking of Data Addressing Audience Questions Working with the Physical Space Speaking Into a Microphone Using a Slide Remote Going Pro with Presenter View Delivering Presentations Remotely Summary12. Concluding Comments Collecting and Downloading Data Cleaning, Organizing, and Analyzing Data Creating Charts and Tables Creating Reports Designing Presentations and Creating Handouts Rehearsing and Delivering Presentations Mastering Data Visualization Skills Suggestions for Further Study

If you use Excel and Office to visualize and communicate data you will find this book invaluable. James Suleiman Data Visualization and Presentation with Microsoft Office is an excellent introduction to data visualization that will assist students and professionals with developing compelling, accurate, and beautiful charts and graphs. Robert N. Yale This text will introduce the MS Office neophyte to the wonders of creating charts while minimizing frustrations. Martin L. Levin
Valerie M. Sue is a senior manager at Kaiser Permanente (KP). She manages a range of projects for KPas Market Strategy and Sales Operations Department and provides data visualization consultation to KP executives and staff. Prior to joining KP, Sue was an associate professor of communication at California State University, East Bay. At CSU, East Bay she taught communication theory, research methods, survey research, statistics, and was the director of the Communication Departmentas graduate program. She has authored numerous journal articles, book chapters, and an online survey methods text. Sue earned a PhD in Communication from Stanford University. Matthew Griffin is a senior consultant at Kaiser Permanente (KP). He works in KPas Market Research department analyzing large quantities of web-related data and investigating the ways in which KP members use digital tools to manage their health. Griffin has been using Excel (and before that Lotus 1-2-3) for nearly 30 years. He has honed his expertise and passion for Excel while working in the healthcare, banking, and retail industries. He has provided Excel support and training to hundreds of colleagues over the years. Griffin has a B.S. in Business Administration: Concentration in Information Systems from San Francisco State University.