Microsoft Excel 2016 bible /
Walkenbach, John
Microsoft Excel 2016 bible / John Walkenbach. - Indianapolis, IN : Wiley, [2015] - xlv, 1106 pages : illustrations (black and white) ; 24 cm
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.
9781119067511: £33.99 No price No price 1119067510
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs
Computers and IT.
Spreadsheet software
/ W34579 2015 / W344894 2015
005.54
Microsoft Excel 2016 bible / John Walkenbach. - Indianapolis, IN : Wiley, [2015] - xlv, 1106 pages : illustrations (black and white) ; 24 cm
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.
9781119067511: £33.99 No price No price 1119067510
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs
Computers and IT.
Spreadsheet software
/ W34579 2015 / W344894 2015
005.54