gogo
Amazon cover image
Image from Amazon.com

Microsoft Excel 2016 bible / John Walkenbach.

By: Material type: TextTextPublication details: Indianapolis, IN : Wiley, [2015]Description: xlv, 1106 pages : illustrations (black and white) ; 24 cmISBN:
  • 9781119067511:
  • 1119067510
Subject(s): DDC classification:
  • 005.54 23
LOC classification:
  • W34579 2015
  • W344894 2015
Online resources:
Contents:
[Part 1: 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.
[Part 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 -- Miscellaneous calculations -- Introducing array formulas -- Performing magic with array formulas.
[Part 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.
[Part 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 -- Protecting your work -- Making your worksheets error free.
[Part 5: 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.
[Part 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 -- Appendixes. Worksheet function reference -- Excel shortcut keys.
Holdings
Item type Current library Call number Status Date due Barcode
General Lending Carlow Campus Library General Lending 005.54 (Browse shelf(Opens below)) Available 84513
General Lending Carlow Campus Library IN PROCESSING 005.54 (Browse shelf(Opens below)) Available 84514

Includes index

At head of title: Microsoft 41.22 CW908

[Part 1: 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.

[Part 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 -- Miscellaneous calculations -- Introducing array formulas -- Performing magic with array formulas.

[Part 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.

[Part 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 -- Protecting your work -- Making your worksheets error free.

[Part 5: 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.

[Part 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 -- Appendixes. Worksheet function reference -- Excel shortcut keys.

Powered by Koha