Learn Excel 2011 for Mac
Master data management, analysis, and automation with Excel 2011 for Mac
Paperback Engels 2011 9781430235217Samenvatting
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
Lezersrecensies
Inhoudsopgave
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
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan