Microsoft Excel 2016 bible / John Walkenbach.
Material type:![Text](/opac-tmpl/lib/famfamfam/BK.png)
- 9781119067511:
- 1119067510
- 005.54 23
- W34579 2015
- W344894 2015
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 |
Browsing Carlow Campus Library shelves, Shelving location: IN PROCESSING Close shelf browser (Hides shelf browser)
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.