Excel 2007 / Matthew MacDonald.
Material type: TextSeries: The missing manualPublication details: Beijing ; Farnham : Pogue/O'Reilly, 2006.Description: xxi, 831 p. : ill. ; 24 cmISBN:- 9780596527594 (pbk.) :
- 0596527594
- 005.54 MAC
- HF5548.4
Item type | Current library | Call number | Copy number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|---|
Long Loan | TUS: Midlands, Main Library Athlone General Lending | 005.54 MAC (Browse shelf(Opens below)) | 1 | Available | 202611 |
Includes index.
Part one: Worksheet basics -- 1.Creating and navigating worksheets -- 2.Adding information to worksheets -- 3.Moving data around a worksheept -- 4.Managing worksheets and workbooks -- 5.Formatting cells -- 6.Smart formatting tricks -- 7.Viewing and printing worksheets -- Part two: Formulas and functions -- 8.Building basic formulas -- 9.Math and statistical functions -- 10.Financial functions -- 11.Manipulating dates, times, and text -- 12.Lookup, reference, and information functions -- 13.Advanced formula writing and troubleshooting -- Part three: Organizing worksheets -- 14.Tables: list management made easy -- 15.Grouping and outlining data -- 16.Templates -- 17.Creating basic charts -- 18.Formatting and perfecting charts -- 19.Inserting graphics -- Part five: Advanced data analysis -- 20.Scenarios and goal seeking -- 21.Pivot tables -- Part six: Sharing data with the rest of the world -- 22.Protecting your workbooks -- 23.Worksheet collaboration -- 24.Querying databases and XML files -- 25.Exchanging data with other programs -- 26.Connecting worksheets to the web -- Part seven: Programming Excel -- 27.Automating tasks with macros -- 28.Programming spreadsheets with VBA.
Becoming an Excel jockey takes practice, dedication, and expert guidance. But despite its fairly steep learning curve, Excel is a rich program that enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. This resource is ideal for users of all levels.