Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET.

Meer over Matthew MacDonald

Matthew MacDonald

Excel 2010: The Missing Manual

Name: Excel 2010: The Missing Manual
Price: 46.85 EUR
Availability: InStock
Author: Matthew MacDonald

Paperback Engels 2010 1e druk 9781449382353

€ 46,85

In winkelwagen

Levertijd ± 16 werkdagen

Gratis verzonden

Samenvatting

Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master - especially from online help pages. This 'Missing Manual' clearly explains how everything works with a unique and witty style to help you learn quickly.

- Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
- Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
- Organize your data. Search, sort, and filter huge amounts of information
- Illustrate trends. Bring your data to life with charts and graphics - including miniature charts called Sparklines
- Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
- Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
- Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save

Specificaties

ISBN13:9781449382353

Trefwoorden:financiële rapportage, financiële verslaglegging, Microsoft Excel, Spreadsheets, kantoorapplicaties, Excel 2010, Office 2010

Taal:Engels

Bindwijze:paperback

Aantal pagina's:871

Uitgever:O'Reilly

Druk:1

Hoofdrubriek:IT-management / ICT

Serie:Missing Manual (OReilly)

Thema:

UFC Spreadsheetsoftware

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Uw waardering

?

Log in om uw waardering te geven

Klik om uw waardering te geven

Over Matthew MacDonald

Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). He has also written Excel 2007:The Missing Manual, Excel 2007 for Starters: The Missing Manual, Access 2007:The Missing Manual, and Access 2007 for Starters: The Missing Manual, all from O'Reilly.

Andere boeken door Matthew MacDonald

Meer over Matthew MacDonald

Inhoudsopgave

The Missing Credits
Introduction

Part 1: Worksheet Basics
1. Creating Your First Spreadsheet
-Creating a Basic Worksheet
-Moving Around the Grid
-A Tour of the Excel Window
-Saving Files
-Opening Files

2. Adding Information to Worksheets
-Adding Different Types of Data
-Handy Timesavers
-Dealing with Change: Undo, Redo, and AutoRecover
-Spell Check
-Adding Hyperlinks

3. Moving Data
-Selecting Cells
-Making Continuous Range Selections
-Making Noncontiguous Selections
-Automatically Selecting Your Data
-Making Selections with the Keyboard
-Moving Cells Around
-A Simple Cut-and-Paste or Copy-and-Paste
-A Quicker Cut-and-Paste or Copy-and-Paste
-Fancy Pasting Tricks
-Paste Special
-Copying Multiple Items with the Clipboard
-Adding and Moving Columns or Rows
-Inserting Columns and Rows
-Inserting Rows
-Inserting Copied or Cut Cells
-Deleting Columns and Rows

4. Managing Worksheets
-Worksheets and Workbooks
-Find and Replace

5. Formatting Cells
-Formatting Cell Values
-Formatting Cell Appearance

6. Smart Formatting Tricks
-The Format Painter
-Styles and Themes
-Conditional Formatting

7. Viewing and Printing Worksheets
-Controlling Your View
-Printing
-Controlling Pagination

Part 2: Formulas and Functions
8. Building Basic Formulas
-Creating a Basic Formula
-Functions
-Formula Errors
-Logical Operators
-Formula Shortcuts
-Copying Formulas

9. Math and Statistical Functions
-Rounding Numbers
-Groups of Numbers
-General Math Functions
-Trigonometry and Advanced Math
-Advanced Statistics

10. Financial Functions
-The World of Finance
-Financial Functions
-Depreciation
-Other Financial Functions

11. Manipulating Dates, Times, and Text
-Manipulating Text
-Manipulating Dates and Times
-Math with Dates and Times
-Date and Time Functions

12. Lookup, Reference, and Information Functions
-The Basic Lookup
-Advanced Lookups
-Information Functions
-Tutorial: Generating Invoices from a Product Catalog

13. Advanced Formula Writing and Troubleshooting
-Conditions in Formulas
-Descriptive Names for Cell References
-Variable Data Tables
-Controlling Recalculation
-Solving Formula Errors

Part 3: Organizing Worksheets
14. Tables: List Management Made Easy
-The Basics of Tables
-Sorting and Filtering a Table
-Dealing with Duplicate Rows
-Performing Table Calculations

15. Grouping and Outlining Data
-Basic Data Grouping
-Grouping Timesavers

16. Templates
-Understanding Templates
-Creating a New Workbook from a Template
-Creating Templates

Part 4: Charts and Graphics
17. Creating Basic Charts
-Charting 101
-Basic Tasks with Charts
-Practical Charting
-Chart Types

18. Formatting and Perfecting Charts
-Chart Styles and Layouts
-Adding Chart Elements
-Selecting Chart Elements
-Formatting Chart Elements
-Improving Your Charts
-Advanced Charting

19. Inserting Graphics
-Adding Pictures to a Worksheet
-Excel's Clip Art Library
-Drawing Shapes

Part 5: Advanced Data Analysis
20. Visualizing Your Data
-Data Bars
-Color Scales
-Icon Sets
-Sparklines

21. Scenarios and Goal Seeking
-Using Scenarios
-Using Goal Seek
-Solver

22. Pivot Tables
-Summary Tables Revisited
-Building Pivot Tables
-Multi-Layered Pivot Tables
-Fine-Tuning Pivot Table Calculations
-Filtering a Pivot Table
-Pivot Charts

23. Analyzing Databases, XML, and Web Pages
-Excel and Databases
-Understanding XML
-Excel and XML
-Web Queries

Part 6: Sharing Data with the Rest of the World
24. Protecting Your Workbooks
-Understanding Excel's Safeguards
-Data Validation
-Locked and Hidden Cells

25. Worksheet Collaboration
-Your Excel Identity
-Preparing Your Workbook
-Distributing a Document
-Adding Comments
-Tracking Changes
-Sharing Your Workbook

26. Using Excel on the Web
-Putting Your Files Online
-Using the Excel Web App

27. Exchanging Data with Other Programs
-Sharing Information in Windows
-Embedding and Linking Objects
-Transferring Data
-Programming Excel

28. Automating Tasks with Macros
-Macros 101
-The Macro Recorder
-Macro Security
-Creating Practical Macros

29. Programming Spreadsheets with VBA
-The Visual Basic Editor
-Understanding Macro Code
-Exploring the VBA Language

Part 8: Appendix
Appendix A: Customizing the Ribbon
-Adding Your Favorites to the QAT
-Personalizing the Ribbon

Index

Afgekapt op 62 regels

Managementboek Top 100

Bekijk de volledige Managementboek Top 100

Uw winkelwagen

Excel 2010: The Missing Manual

Samenvatting

Specificaties

Lezersrecensies

Over Matthew MacDonald

Andere boeken door Matthew MacDonald

Inhoudsopgave

Managementboek Top 100

Rubrieken

Producten

Auteurs

Trefwoorden

Artikelen