Over Greg Harvey
Greg Harvey is directeur van Mind Over Media, auteur van talloze computerboeken en een ervaren docent.
Greg Harvey
Greg Harvey is directeur van Mind Over Media, auteur van talloze computerboeken en een ervaren docent.
Meer over Greg Harvey
Greg Harvey
Microsoft Excel 2010 All-in-One for Dummies
Paperback Engels 2010 1e druk 9780470489598Verwachte levertijd ongeveer 8 werkdagen
Samenvatting
Here's everything you need to know about using Excel - in one handy package!
Excel is such a powerhouse, it takes eight self-contained minibooks to cover all its features! Open this All-in-One and find just what you need to know, from how to use the Ribbon interface and Backstage View and how to set up your first spreadsheet to collaborating on a worksheet, presenting results with cool charts and graphs, and understanding formulas and functions.
- Welcome to 2010 - explore the new user experience, learn where to get help, and customize your Excel
- Workin' with worksheets - learn to build, format, edit, proof, manage, and print them
- Formula for success - find out what formulas and functions do and how to use them
- Share and collaborate - discover how to send workbooks out for review and incorporate input from multiple users
- Results that are pretty - find out which type of chart shows off your data to best advantage
- Keeping data in line - learn to maintain, sort, and filter data lists using Excel
- Analyze this - use Excel's computational ability to predict possible outcomes
- Making macros - use Visual Basic for Applications, record macros, edit VBA code, and make Excel do your bidding
Open the book and find:
- How to navigate the Ribbon and Backstage View
- Shortcuts for switching from older versions
- Tricks for eliminating Text to Speech errors
- All about functions and how they work in formulas
- How to secure data and still enable user edits
- How to use line charts, pie charts, and scatter charts
- Tips for creating macros and custom functions
- How to perform what-if analysis
Specificaties
ISBN13:9780470489598
Taal:Engels
Bindwijze:paperback
Aantal pagina's:763
Uitgever:John Wiley & Sons
Druk:1
Hoofdrubriek:IT-management / ICT
ISSN:
Serie:Dummies (Engelstalig)
Lezersrecensies
Wees de eerste die een lezersrecensie schrijft!
Inhoudsopgave
Introduction.
Book 1: Excel Basics.
1. The Excel 2010 User Experience.
2. Getting Help, Tips, and Updates.
3. Customizing Excel.
Book 2: Worksheet Design.
1. Building Worksheets.
2. Formatting Worksheets.
3. Editing and Proofi ng Worksheets.
4. Managing Worksheets.
5. Printing Worksheets.
Book 3: Formulas and Functions.
1. Building Basic Formulas.
2. Logical Functions and Error Trapping.
3. Date and Time Formulas.
4. Financial Formulas.
5. Math and Statistical Formulas.
6. Lookup, Information, and Text Formulas.
Book 4: Worksheet Collaboration and Review.
1. Protecting Workbooks and Worksheet Data.
2. Linking Workbooks with Hyperlinks.
3. Sending Workbooks Out for Review.
4. Sharing Worksheets and Worksheet Data.
Book 5: Charts and Graphics.
1. Charting Worksheet Data.
2. Adding Graphic Objects.
Book 6: Data Management.
1. Building and Maintaining Data Lists.
2. Filtering and Querying a Data List.
Book 7: Data Analysis.
1. Performing What-If Scenarios.
2. Generating Pivot Tables.
Book 8: Excel and VBA.
1. Building and Running Macros.
2. VBA Programming.
Appendix: Using XML File Formats.
Index.
Book 1: Excel Basics.
1. The Excel 2010 User Experience.
2. Getting Help, Tips, and Updates.
3. Customizing Excel.
Book 2: Worksheet Design.
1. Building Worksheets.
2. Formatting Worksheets.
3. Editing and Proofi ng Worksheets.
4. Managing Worksheets.
5. Printing Worksheets.
Book 3: Formulas and Functions.
1. Building Basic Formulas.
2. Logical Functions and Error Trapping.
3. Date and Time Formulas.
4. Financial Formulas.
5. Math and Statistical Formulas.
6. Lookup, Information, and Text Formulas.
Book 4: Worksheet Collaboration and Review.
1. Protecting Workbooks and Worksheet Data.
2. Linking Workbooks with Hyperlinks.
3. Sending Workbooks Out for Review.
4. Sharing Worksheets and Worksheet Data.
Book 5: Charts and Graphics.
1. Charting Worksheet Data.
2. Adding Graphic Objects.
Book 6: Data Management.
1. Building and Maintaining Data Lists.
2. Filtering and Querying a Data List.
Book 7: Data Analysis.
1. Performing What-If Scenarios.
2. Generating Pivot Tables.
Book 8: Excel and VBA.
1. Building and Running Macros.
2. VBA Programming.
Appendix: Using XML File Formats.
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
