عنوان

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