عنوان

Microsoft Excel 2010 :

0735626944 (pbk.)

9780735626942 (pbk.)

dltt

Microsoft Excel 2010 :

[Book]

step by step /

Curtis Frye

xli, 436 pages :

illustrations ;

23 cm

Step by step

"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

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

2

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

Microsoft Excel (Computer file)

Business-- Computer programs

Electronic spreadsheets

Frye, Curtis,1968-

20141128135031.0

[Book]

Y