Learn Excel 2011 for Mac
Master data management, analysis, and automation with Excel 2011 for Mac
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
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
Anderen die dit boek kochten, kochten ook
Net verschenen
Rubrieken
- aanbestedingsrecht
- aansprakelijkheids- en verzekeringsrecht
- accountancy
- algemeen juridisch
- arbeidsrecht
- bank- en effectenrecht
- bestuursrecht
- bouwrecht
- burgerlijk recht en procesrecht
- europees-internationaal recht
- fiscaal recht
- gezondheidsrecht
- insolventierecht
- intellectuele eigendom en ict-recht
- management
- mens en maatschappij
- milieu- en omgevingsrecht
- notarieel recht
- ondernemingsrecht
- pensioenrecht
- personen- en familierecht
- sociale zekerheidsrecht
- staatsrecht
- strafrecht en criminologie
- vastgoed- en huurrecht
- vreemdelingenrecht