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

Learn Excel 2011 for Mac

Master data management, analysis, and automation with Excel 2011 for Mac

Paperback Engels 2011 9781430235217
Verwachte levertijd ongeveer 9 werkdagen

Samenvatting

It's easy to get started with Microsoft Excel 2011 for Mac, but to make the most of Excel, you need to dig deep into it. 'Learn Excel 2011 for Mac' provides a practical, hands-on approach to learning how to get your work done quickly and efficiently with Excel 2011. From using formulas and functions to creating databases, and from analyzing data to automating tasks, you'll learn everything you need to know to make this powerful application perform whatever kind of business tasks you require.

You'll discover how to master and exploit the secrets of the Excel:Mac interface, customize Excel to work your way, and harness the power of Excel's hundreds of built-in functions. You'll be able to turn your raw data into powerful and persuasieve charts, and you'll even explore the ability to share workbooks with you Windows colleagues.

You'll learn how to:
- Create workbooks and templates that save you and your colleague time and effort
- Format worksheets quickly and consistently
- Make your worksheets pop with SmartArt, pictures, and more
- Solve business problems quickly with what-if analysis, Goals Seek, and the Solver
- Store and filter data with tables, and analyze data with pivot tables
- Streamline your work by automating tasks with VBA

Specificaties

ISBN13:9781430235217
Taal:Engels
Bindwijze:paperback
Aantal pagina's:465
Uitgever:Apress
Druk:1
Verschijningsdatum:27-6-2011
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Inhoudsopgave

About the author
About the technical reviewer
Acknowledgments
Introduction

1. Learning the Secrets of the Excel:Mac Interface
2. Configuring Excel:Mac to Suit the Way You Work
3. Creating Effective Workbooks and Templates
4. Formatting Your Worksheets Quickly and Efficiently
5. Performing Custom Calculations with Formulas
6. Using Excel's Built-In Functions
7. Creating Clear and Persuasive Charts
8. Using Data Bars, Color Scales, Icon Sets, and Sparklines
9. Illustrating Your Worksheets with SmartArt, Pictures, and More
10. Creating Databases Using Tables
11. Solving Business Questions with What-If Analysis, Goal Seek, and Solver
12. Analyzing Data with PivotTables
13. Collaborating and Sharing with Macs and Windows
14. Automating Tasks with Macros and VBA

Index

Managementboek Top 100

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Learn Excel 2011 for Mac