1 option
Excel 2010 / Matthew MacDonald.
- Format:
- Book
- Author/Creator:
- MacDonald, Matthew.
- Series:
- Missing manual.
- The missing manual
- Language:
- English
- Subjects (All):
- Microsoft Excel (Computer file).
- Electronic spreadsheets.
- Physical Description:
- 1 online resource (896 p.)
- Edition:
- First edition.
- Place of Publication:
- Beijing ; Sebastopol, California : O'Reilly, 2010.
- Language Note:
- English
- System Details:
- text file
- Summary:
- 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 viewPerform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and moreO
- Contents:
- Part 1: Worksheet basics. Creating your first spreadsheet
- Adding information to worksheets
- Moving data
- Managing worksheets
- Formatting cells
- Smart formatting tricks
- Viewing and printing worksheets
- Part 2: Formulas and functions. Building basic formulas
- Math and statistical functions
- Financial functions
- Manipulating dates, times, and text
- Lookup, reference, and information functions
- Advanced formula writing and troubleshooting
- Part 3: Organizing worksheets. Tables: list management made easy
- Grouping and outlining data
- Templates
- Part 4: Charts and graphics. Creating basic charts
- Formatting and perfecting charts
- Inserting graphics
- Part 5: Advanced data analysis. Visualizing your data
- Scenarios and goal seeking
- Pivot tables
- Analyzing databases, XML, and web pages
- Part 6: Sharing data with the rest of the world. Protecting your workbooks
- Worksheet collaboration
- Using Excel on the web
- Exchanging data with other programs
- Part 7: Programming Excel. Automating tasks with macros
- Programming spreadsheets with VBA
- Part 8: Appendix. Customizing the ribbon.
- Notes:
- Includes index.
- Description based on online resource; title from PDF title page (ebrary, viewed October 16, 2013).
- ISBN:
- 9781449394196
- 1449394191
- 9781449394295
- 1449394299
- OCLC:
- 686710344
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.