Record Display for the EPA National Library Catalog


OLS Field Name OLS Field Data
Main Title Excel® 2013 bible /
Author Walkenbach, John.
Publisher John Wiley & Sons,
Year Published 2013
OCLC Number 819520141
ISBN 9781118490365; 1118490363
Subjects Electronic spreadsheets--Computer programs. ; Business--Computer programs. ; EXCEL 2013
Internet Access
Description Access URL
Library Call Number Additional Info Location Last
EJAM  HF5548.4.M523W344894 2013 Region 3 Library/Philadelphia, PA 11/12/2014 STATUS
EKBM  HF5548.4.M523W344894 2013 Research Triangle Park Library/RTP, NC 06/30/2014
ESAR  HF5548.4.M523W34 2013 Region 10 Library/Seattle,WA 09/26/2013
Collation xli, 1012 pages : illustrations ; 24 cm
"The comprehensive tutorial resource"--Cover. Includes index.
Contents Notes
Details Excel's updated features, and explains how to use the software to import and analyze data, build pivot tables, create macros, identify data trends and patterns, and generate charts and diagrams. Getting started with Excel. Introducing Excel ; Entering and editing worksheet data ; Essential worksheet operations ; Working with cells and ranges ; Introducing tables ; Worksheet formatting ; Understanding Excel files ; Using and creating templates ; Printing your work -- 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 ; Miscellaneous calculations ; Introducing array formulas ; Performing magic with array formulas -- 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 -- Using advanced Excel features. Customizing the Excel user interface ; Using custom number formulas ; Using data validation ; Creating and using worksheet outlines ; Linking and consolidating worksheets ; Excel and the internet ; Protecting your work ; Making your worksheets error free -- Analyzing data with Excel. Importing and cleaning data ; 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 -- 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.