Muutke küpsiste eelistusi

E-raamat: Data Visualization & Presentation With Microsoft Office

  • Formaat: PDF+DRM
  • Ilmumisaeg: 09-Oct-2015
  • Kirjastus: SAGE Publications Inc
  • Keel: eng
  • ISBN-13: 9781483365145
  • Formaat - PDF+DRM
  • Hind: 70,40 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Formaat: PDF+DRM
  • Ilmumisaeg: 09-Oct-2015
  • Kirjastus: SAGE Publications Inc
  • Keel: eng
  • ISBN-13: 9781483365145

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

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, and Word) to illustrate and teach the principles, thus rendering the text accessible to a large audience.

Arvustused

If you use Excel and Office to visualize and communicate data youll find this book invaluable. -- James Suleiman Data Visualization & 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

Preface xii
Acknowledgments xvii
About the Authors xviii
Section I: Displaying Data 1(118)
Chapter 1 Choosing Data Displays
3(10)
Information and Audience Considerations
3(1)
How Much Information?
3(1)
Who Is the Audience for Your Data?
3(1)
What Does the Audience Know?
4(1)
What Will the Audience Do With the Information?
4(1)
Are You Preparing a Report or Presentation?
4(1)
Reports
5(1)
Presentations
5(1)
Forms of Data Visualization Covered in This Text
5(6)
Charts
6(4)
Column and Bar Charts
6(2)
Line Charts
8(1)
Area Charts
9(1)
Pie Charts
10(1)
Tables
10(1)
Which Form of Data Visualization to Use
11(1)
Summary
11(2)
Chapter 2 Bar and Column Charts
13(30)
Data Appropriate for Bar and Column Charts
14(6)
Stacked Column Charts
20(2)
100% Stacked Column Charts
22(5)
Best Practices for Creating Column and Bar Charts
27(12)
Axes
28(2)
Chart Categories
30(2)
Gap Width
32(1)
Series Overlap
32(5)
Data Labels
37(2)
Choosing Between Bar and Column Charts
39(1)
Summary
40(1)
Chapter Bonus
41(2)
Chapter 3 Line and Area Charts
43(18)
Single-Series Line Charts
44(3)
Multiseries Line Charts
47(4)
Transposing Data
50(1)
Area Charts
51(3)
Multiseries Area Charts
54(2)
Stacked Area Charts
56(3)
Summary
59(1)
Chapter Bonus
59(2)
Chapter 4 Pie Charts
61(16)
The Trouble With Pie Charts
62(1)
When to Use a Pie Chart
63(3)
Best Practices for Creating Pie Charts
66(6)
Alternatives to Pie Charts
72(2)
Summary
74(3)
Chapter 5 Chart Formatting
77(42)
Remove Unnecessary and Redundant Information
78(3)
Chart Titles
81(3)
Chart Legends
84(5)
Legend Position
85(4)
Chart Axes
89(9)
Labeling Axes
90(2)
Axes and Individual Data Labels
92(2)
Units of the Y-Axis
94(3)
Position of the X-Axis
97(1)
Charts With Data Tables
98(1)
Labeling Individual Data Values
99(1)
Labeling the Y-Axis on a Bar Chart
100(2)
Formatting Numbers on Data Labels and Axes
102(3)
Use the Thousands Separator on Data Labels and Axes
103(1)
Shorten Long Numbers
103(1)
Only Use as Many Decimals as Necessary
104(1)
Formatting Dates
105(4)
Fonts
109(2)
Font Size
110(1)
Font Styles
110(1)
Color
111(2)
Color of the Bars, Lines, and Slices of Pie
111(2)
Chart Templates
113(2)
Perspective
115(2)
Summary
117(2)
Section II: Preparing Data For Charting 119(88)
Chapter 6 Preparing Data for Charting
121(32)
Sources of Free Data
121(1)
Downloading Data
122(1)
Cleaning Data
123(4)
Relabel the Variables
123(1)
Examine the Data
124(3)
Summarize the Data
127(19)
Creating a Simple Summary Table
127(1)
Creating a Complex Summary Table
128(4)
Computing Summary Statistics
132(14)
Creating a Dynamic Summary Table
146(2)
Subtotal
148(3)
Summary
151(2)
Chapter 7 Pivot Tables and Pivot Charts
153(24)
Introduction to Pivot Tables
153(2)
Organizing Data for Pivot Tables
155(7)
Creating a Pivot Table
159(3)
Modifying and Exploring a Pivot Table
162(1)
Transposing Rows and Columns
162(1)
Filtering Data
163(2)
Changing Summary Data Values
165(1)
Nesting Variables
166(1)
Totals and Subtotals
167(3)
Refreshing Pivot Table Data
170(1)
Grouping Data
170(2)
Pivot Charts
172(4)
Summary
176(1)
Chapter 8 Tables: When Charts Aren't Enough
177(30)
Excel's Table Feature
177(7)
Easy Sorting and Filtering
179(2)
Quickly Add a Total
181(1)
Perpetually Visible Headers
182(1)
Dynamic Charts
183(1)
Table Formatting Best Practices
184(15)
Creating an Excel Table Using Format as Table
186(2)
Borders, Rules, and Grids
188(1)
Row and Column Formatting
189(4)
Text Alignment
193(3)
Number Formatting
196(2)
Fonts
198(1)
Colors
199(1)
Custom Table Styles
199(4)
Summary
203(1)
Chapter Bonus
204(3)
Section III: Presenting Data 207(108)
Chapter 9 Creating Reports
209(46)
Report or Presentation?
209(4)
Choosing a Report Format
210(1)
Report Types
210(3)
Moving Charts From Excel to Word
213(4)
Moving Tables From Excel to Word
217(3)
Word's Layout Options
220(3)
Position
220(2)
Text Wrap
222(1)
Professional Reports
223(16)
Creating Professional Reports in PowerPoint
223(16)
Posters
239(1)
Infographics
240(5)
Creating Posters and Infographics With PowerPoint
242(1)
Guidelines for Creating Posters
243(2)
Dashboards
245(8)
Designing a Dashboard in Excel
246(7)
Summary
253(2)
Chapter 10 Creating Presentations
255(34)
Perspectives on Presentations
256(4)
Guy Kawasaki
256(1)
Lawrence Lessig
257(1)
Seth Godin
258(1)
Garr Reynolds
258(1)
Nancy Duarte
259(1)
Michael Alley
259(1)
Three Presentation Elements
260(1)
Designing Audience Slides
260(22)
Eliminate Slide Junk
261(1)
Minimize Text, Maximize Images
262(5)
Think Visually
267(2)
Be Transparent
269(2)
Add Images on Nondata Slides
271(3)
Create Readable Slides
274(1)
Use Animations and Transitions to Maintain Attention
275(7)
Creating Speaker Notes
282(2)
Creating Handouts
284(3)
Summary
287(2)
Chapter 11 Delivering Presentations
289(18)
Preliminary Considerations
289(1)
Speaking of Data
290(4)
Open Strongly
290(1)
Maintain Momentum
291(2)
Conclude Memorably
293(1)
Addressing Audience Questions
294(1)
Working With the Physical Space
294(2)
Speaking Into a Microphone
296(1)
Using a Slide Remote
297(2)
Going Pro With Presenter View
299(3)
Delivering Presentations Remotely
302(4)
Learn the Technology
304(1)
Get Help
304(1)
Plan Ahead
305(1)
Prepare a Webinar Version of PowerPoint Slides
305(1)
Rehearse
305(1)
Delivering the Presentation
305(1)
Summary
306(1)
Chapter 12 Concluding Comments
307(8)
Collecting or Downloading Data
308(1)
Cleaning, Organizing, and Analyzing Data
308(1)
Creating Charts and Tables
308(1)
Creating Reports
309(1)
Designing Presentations and Creating Handouts
309(1)
Rehearsing and Delivering Presentations
309(1)
Mastering Data Visualization Skills
310(2)
Suggestions for Further Study
312(3)
The Visual Display of Quantitative Information
312(1)
Show Me the Numbers
313(1)
Visualize This
313(1)
Visual Thinking for Design
313(1)
Microsoft Excel 2013 Bible
313(1)
Pivot Table Data Crunching: Microsoft Excel 2013 (MrExcel Library)
314(1)
Slideology: The Art and Science of Creating Great Presentations
314(1)
Presentation Zen
314(1)
Appendix A: Excel Basics 315(14)
Appendix B: Configuring Microsoft Word for APA-Style Reports 329(5)
Index 334
Valerie M. Sue is a senior manager at Kaiser Permanente (KP). She manages a range of projects for KPs 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 Departments 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 T. Griffin is a senior consultant at Kaiser Permanente (KP). He works in KPs 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 with a concentration in information systems from San Francisco State University.