عنوان

Excel 2010 bible /

شابک

0470474874

شابک

9780470474877 (pbk.)

شماره

dltt

عنوان اصلي

Excel 2010 bible /

نام عام مواد

[Book]

نام نخستين پديدآور

John Walkenbach.

نام خاص و کميت اثر

xliv, 1006 pages :

ساير جزييات

illustrations ;

ابعاد

24 cm +

مواد همراه اثر

1 CD-ROM (4 3/4 in.)

متن يادداشت

Includes index.

متن يادداشت

pt. 1: Getting started with Excel. Introducing Excel -- Entering and editing worksheet data -- Essential worksheet operations -- Working with cells and ranges -- Introducing tables -- Worksheet formating -- Understanding Excel files -- Using and creating templates -- Printing your work -- pt. 2: Working with formulas and functions. Introducing formulas and functions -- Creating formulas that manipulate text -- Working with dates and times -- Creating formulas that count and sum -- Creating formulas that look up values -- Creating formulas for financial applications -- Introducing array formulas -- Performing magic with array formulas -- pt. 3: Creating charts and graphics. Getting started making charts -- Learning advanced charting -- Visualizing data using conditional formatting -- Creating sparkline graphics -- Enhancing your work with pictures and drawings -- pt. 4: Using advanced Excel features. Customizing the Excel user interface -- Using custom number formats -- Using data validation -- Creating and using worksheet outlines -- Linking and consolidating worksheets -- Excel and the internet -- Sharing data with other office applications -- Using Excel in a workgroup -- Protecting your work -- Making your worksheets error-free -- pt. 5: Analyzing data with Excel. Getting data from external database files -- Introducing pivot tables -- Analyzing data with pivot tables -- Performing spreadsheet what-if analysis -- Analyzing data using goal seeking and solver -- Analyzing data with the analysis toolpak -- pt. 6: Programming Excel with VBA. Introducing Visual Basic for Applications -- Creating custom worksheet functions -- Creating userforms -- Using userform controls in a worksheet -- Working with Excel events -- VBA examples -- Creating custom Excel add-ins.

بدون عنوان

0

متن يادداشت

Surveys the tools, features, and capabilities of Excel 2010, explaining the user interface and covering such topics as spreadsheet design, creating charts and diagrams, developing formulas, analyzing data, PivotTables, XML and data reporting, Internet applications, and VBA.

عنوان روي جلد

Microsoft Excel 2010 bible

موضوع مستند نشده

Microsoft Excel (Computer file)

موضوع مستند نشده

Business-- Computer programs.

موضوع مستند نشده

Electronic spreadsheets.

شماره

ويراست

شماره رده

نشانه اثر

مستند نام اشخاص تاييد نشده

Walkenbach, John.

تاريخ عمليات

20110922145800.0

قواعد فهرست نويسي ( بخش توصيفي )

rda

نام الکترونيکي

نوع ماده

[Book]

تكميل شده

Y