|
" Microsoft Excel 2010 : "
Curtis Frye
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
659189
|
| Doc. No
|
:
|
dltt
|
| Main Entry
|
:
|
Frye, Curtis,1968-
|
| Title & Author
|
:
|
Microsoft Excel 2010 : : step by step /\ Curtis Frye
|
| Series Statement
|
:
|
Step by step
|
| Page. NO
|
:
|
xli, 436 pages :: illustrations ;; 23 cm
|
| ISBN
|
:
|
9780735626942 (pbk.)
|
|
|
:
|
: 0735626944 (pbk.)
|
| Notes
|
:
|
"Write formulas, calculate values, and organize results; visualize data with graphics, charts, and diagrams; use filters to zero in on the most-relevant data; analyze data dynamically with PivotTables; exchange data with other Microsoft Office applications; create templates and macros to save time"--P. [4] of cover
|
|
|
:
|
Includes index
|
| Contents
|
:
|
Introducing Microsoft Excel 2010 -- Modifying the display of the ribbon -- Features and conventions -- Using the practice files -- Getting help -- 1. Setting up a workbook : Creating workbooks ; Modifying workbooks ; Modifying worksheets ; Customizing the Excel 2010 program window -- 2. Working with data and Excel tables : Entering and revising data ; Moving data within a workbook ; Finding and replacing data ; Correcting and expanding upon worksheet data ; Defining Excel tables -- 3. Performing calculations on data : Naming groups of data ; Creating formulas to calculate values ; Summarizing data that meets specific conditions ; Finding and correcting errors in calculations -- 4. Changing workbook appearance : Formatting cells ; Defining styles ; Applying workbook themes and Excel table styles ; Making numbers easier to read ; Changing the appearance of data based on its value ; Adding images to worksheets -- 5. Focusing on specific data by using filters : Limiting data that appears on your screen ; Manipulating worksheet data ; Defining valid sets of values for ranges of cells -- 6. Reordering and summarizing data : Sorting worksheet data ; Organizing data into levels ; Looking up information in a worksheet -- 7. Combining data from multiple sources : Using workbooks as templates for other workbooks ; Linking to data in other worksheets and workbooks ; Consolidating multiple sets of data into a single workbook ; Grouping multiple sets of data -- 8. Analyzing alternative data sets : Defining an alternative data set ; Defining multiple alternative data sets ; Varying your data to get a desired result by using Goal Seek ; Finding optimal solutions by using Solver ; Analyzing data by using descriptive statistics -- 9. Creating dynamic worksheets by using PivotTables : Analyzing data dynamically by using PivotTables ; Filtering, showing, and hiding PivotTable data ; Editing PivotTables ; Formatting PivotTables ; Creating PivotTables from external data -- 10. Creating charts and graphics : Creating charts ; Customizing the appearance of charts ; Finding trends in your data ; Summarizing your data by using Sparklines ; Creating dynamic charts by using PivotCharts ; Creating diagrams by using SmartArt ; Creating shapes and mathematical equations -- 11. Printing : Adding headers and footers to printed pages ; Preparing worksheets for printing ; Printing worksheets ; Printing parts of worksheets ; Printing charts -- 12. Automating repetitive tasks by using macros : Enabling and examining macros ; Creating and modifying macros ; Running macros when a button is clicked ; Running macros when a workbook is opened -- 13. Working with other Microsoft Office programs : Including Office documents in workbooks ; Storing workbooks as parts of other Office documents ; Creating hyperlinks ; Pasting charts into other documents -- 14. Collaborating with colleagues : Sharing workbooks ; Managing comments ; Tracking and managing colleagues' changes ; Protecting workbooks and worksheets ; Authenticating workbooks ; Saving workbooks for the web -- Keyboard shortcuts
|
| Abstract
|
:
|
Screenshots and step-by-step instructions explain how to use Microsoft Excel 2010 to manage, analyze, and present data, covering graphics, charts, diagrams, filters, PivotTables, templates, macros, and more
|
| Subject
|
:
|
Business-- Computer programs
|
| Subject
|
:
|
Electronic spreadsheets
|
| Subject
|
:
|
Microsoft Excel (Computer file)
|
| Dewey Classification
|
:
|
005.54
|
| LC Classification
|
:
|
HF5548.4.M523F7873 2010
|
| |