Library Home Page
Login
My List - 0
Help
Home
Search
My Account
Basic
Advanced
History
Search:
WORD(s) anywhere
TITLE begins with ...
TITLE word(s)
AUTHOR (last name first)
AUTHOR word(s)
SUBJECT begins with ...
SUBJECT word(s)
VIDEO TITLE word(s)
Bib No.
Refine Search
> You're searching:
St Clair County Community College
Item Information
Holdings
Author Notes & Sketches
Summary
More Content
More by this author
Walkenbach, John, [author]
Subjects
Microsoft Excel (Computer file)
Electronic spreadsheets -- Computer programs.
Browse Catalog
by author:
Walkenbach, John, [author]
by title:
Microsoft® Excel® 20...
MARC Display
Microsoft® Excel® 2016 bible / John Walkenbach.
by
Walkenbach, John, [author]
Subjects
Microsoft Excel (Computer file)
Electronic spreadsheets -- Computer programs.
ISBN:
1119067510
9781119067511
Description:
xlv, 1106 pages : illustrations ; 23 cm
Contents:
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 formats ; 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 tookpak ; Working with get & transform -- 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 -- Appendixes. Worksheet function reference ; Excel shortcut keys.
Copy/Holding information
Call No.
Collection
Status
Location
HF5548.4.M523 W344896 2016
Circulating Books
Checked In
St. Clair County Community College Library
Add Copy to MyList
Format:
HTML
Plain text
Delimited
Subject:
Email to:
Horizon Information Portal 3.0
© 2001-2013
SirsiDynix
All rights reserved.