Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20

Excel 2013 in Depth

Paperback Engels 2013 9780789748577
Verwachte levertijd ongeveer 8 werkdagen

Samenvatting

Do more in less time!

Experience with Excel? Don't let Excel 2013 make you feel like a beginner again! This book is packed with intensely useful Excel 2013 knowledge you just won't find anywhere else. Packed with new tips and shortcuts, it's the fastest, best way to master Excel 2013's full power; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration!

Then, learn how to
- Supercharge your workbooks with new apps from the Excel App Store
- Leverage the improved Excel Web App to create highly interactive web pages and online surveys
- Build more spreadsheets that are trustworthy, error-resistant, flexible, extensible, intelligent, and understandable
- Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens
- Quickly apply attractive, consistent formats to any workbook or chart
- Return data from web services with new WEBSERVICE and FILTERXML functions
- Solve real-world business intelligence analysis problems with sorting, filtering, and pivot tables
- Take full advantage of What-if, Scenario Manager, goal Seek, and Solver
- Create amazing PowerPivot data mashups that integrate information from anywhere
- Use Power View to generate stunningly intuitive data visualizations, including maps and dashboards
- Share workbooks on the Web and social networks, inclusing Twitter and LinkedIn
- Automate repetitive functions using Excel macros

All In Depth offers:
- Comprehensive coverage with detailed solutions
- Troubleshooting help for tough problems you can't fix on your own
- Outstanding authors recognized worldwide for their expertise and teaching style

Specificaties

ISBN13:9780789748577
Taal:Engels
Bindwijze:paperback
Aantal pagina's:1218
Uitgever:Que
Druk:1
Verschijningsdatum:25-1-2013
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Geef uw waardering

Zeer goed Goed Voldoende Matig Slecht

Over Bill Jelen

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,200 episodes of his daily video podcast, "Learn Excel from MrExcel." He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, 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, and his sons, Josh and Zeke.

Andere boeken door Bill Jelen

Inhoudsopgave

Introduction

Part 1: Mastering the New User Interface
1. Staying Connected Using Excel 2013
2. Introducing Flash Fill and Analysis Lens
3. Using the Excel Interface
4. Customizing Excel
5. Extending Excel with Excel Apps and Add-Ins
6. Keyboard Shortcuts
7. The Big Grid and File Formats

Part 2: Calculating with Excel
8. Understanding Formulas
9. Controlling Formulas
10. Understanding Functions
11. Using Everyday Functions: Math, Date and Time, and Text
12. Using Powerful Functions: Logical, Lookup, Web, and Database Functions
13. Using Financial Functions
14. Using Statistical Functions
15. Using Trig, Matrix, and Engineering Functions
16. Connecting Worksheets, Workbooks, and External Data
17. Using Super Formulas in Excel
18. Using Names in Excel
19. Fabulous Table Intelligence

Part 3: Business Intelligence
20. Sorting Data
21. Removing Duplicates and Filtering
22. Using Automatic Subtotals
23. Using Pivot Tables to Analyze Data
24. Using Slicers and Filtering a Pivot Table
25. Mashing Up Data with PowerPivot
26. Creating Interactive Dashboards with Power View or GeoFlow
27. Using What-If, Scenario Manager, Goal Seek, and Solver
28. Automating Repetitive Functions Using VBA Macros
29. More Tips and Tricks for Excel 2013

Part 4: Visual Presentation
30. Formatting Worksheets
31. Using Data Visualizations and Conditional Formatting
32. Graphing Data Using Excel Charts
33. Using Sparklines
34. Using SmartArt, Shapes, WordArt, and Text Boxes
35. Using Pictures and Clip Art

Part 5: Sharing Information
36. Printing
37. Excel Web App and Other Ways to Share Workbooks
38. Saving Time Using the Easy-XL Program

Index

Managementboek Top 100

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Excel 2013 in Depth