Excel 2013 Charts and Graphs (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
464
Utgivningsdatum
2013-03-06
Upplaga
1
Förlag
QUE
Illustratör/Fotograf
illustrations
Illustrationer
ill
Dimensioner
228 x 177 x 25 mm
Vikt
716 g
Antal komponenter
1
Komponenter
,
ISBN
9780789748621
Excel 2013 Charts and Graphs (häftad)

Excel 2013 Charts and Graphs

Häftad Engelska, 2013-03-06
409
Skickas inom 3-6 vardagar.
Fri frakt inom Sverige för privatpersoner.
Finns även som
Visa alla 1 format & utgåvor
Use Excel 2013s radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly so you drive your message home, and get the decisions and actions youre looking for!

 

This book reveals data visualization techniques you wont find anywhere else and shows you how to use Excel 2013 to create designer-quality charts and graphs that stand out from the crowd. It will help you make the most of new features ranging from Power View to Recommended Charts, and instantly share your insights with anyone, anywhereeven on the Web and social networks.

 

Learning advanced Excel techniques has never been easier. Youll find simple, step-by-step instructions, real-world
examples and case studies, and more than a dozen YouTube videos, straight from MrExcel!

 

   Create stunning data visualizations instantly with Excel 2013s new Recommended Charts

   Use charts to instantly reveal trends, differences, and relationships

   Map your data with Excel 2013, MapPoint, and the new GeoFlow add-in

   Quickly generate combo charts that once required complex, frustrating procedures

   Use sparklines to imbue worksheets with more context and insight

   Highlight and clarify the meaning of data with DataBars, color scales, icon sets, and other conditional formatting tools

   Post charts to Facebook, Twitter, or LinkedIn, directly from Excel

   Build stock charts that help you make smarter investments

   Solve non-standard problems such as noncontiguous data or custom data sequences

   Generate new charts automatically with Excel VBA

   Uncover visual tricks that people use to lie with Excel

 

About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks
and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these
books will:

 

   Dramatically increase your productivitysaving you 50 hours a year or more

   Present proven, creative strategies for solving real-world problems

   Show you how to get great results, no matter how much data you have

   Help you avoid critical mistakes that even experienced users make
Visa hela texten

Passar bra ihop

  1. Excel 2013 Charts and Graphs
  2. +
  3. Excel For Auditors

De som köpt den här boken har ofta också köpt Excel For Auditors av Bill Jelen, Dwayne K Dowell (häftad).

Köp båda 2 för 718 kr

Kundrecensioner

Har du läst boken? Sätt ditt betyg »

Bloggat om Excel 2013 Charts and Graphs

Övrig information

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,500 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 39 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. His Excel tips appear regularly in CFO Excel Pro Newsletter and CFO Magazine . Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches--working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen.

Innehållsförteckning

Introduction: Using Excel 2013 to Create Charts .................. 1

Choosing the Right Chart Type ...........................................1

Using Excel as Your Charting Canvas ...............................2

Topics Covered in This Book ........................................3

This Books Objectives ...............................4

 Versions of Excel ...................................................4

 Conventions Used in This Book ......................................4

 Special Elements in This Book .................................................4

Next Steps.................................................5

 

1 Introducing Charts in Excel 2013 ............................... 7

Whats New in Excel 2013 Charts ........................................................7

Choosing Among the Three Ways to Create a Chart ........................10

 Creating a Chart from the Quick Analysis Icon .........................................10

 Inserting a Recommended Chart .................................................................11

 Creating a Chart Using the Other Icons on the Insert Tab ......................14

 Creating a Chart Using Alt+F1 ............................................................15

Changing the Chart Title ................................................................16

 Editing a Title in the Formula Bar ...............................................16

 Why Cant Excel Pick Up the Title from the Worksheet? ...............17

 Assigning a Title from a Worksheet Cell ......................................18

Handling Special Situations ....................................................19

 Charting Noncontiguous Data .........................................................19

 Charting Nonsummarized Data ............................................22

 Charting Differing Orders of Magnitude Using a Custom Combo Chart .............23

 Reversing the Series and Categories in a Chart ...............................24

 Changing the Data Sequence by Using Select Data ........................25

Using the Charting Tools .................................................................26

 Introducing the Three Helper Icons ........................................26

 Introducing the Format Task Pane ..............................................27

 Using Commands on the Design Tab .....................................30

 Micromanaging Formatting Using the Format Tab .......................31

 Using Commands on the Home Tab ......................................31

 Changing the Theme on the Page Layout Tab ..............................32

Moving Charts ......................