Microsoft® Excel® 2016 bible

The complete guide to Excel 2016, from Mr. Spreadsheet himself. Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features...

Full description

Saved in:
Bibliographic Details
Main Author Walkenbach, John (Author)
Format Electronic eBook
LanguageEnglish
Published Indianapolis, IN : John Wiley & Sons, Inc., [2016]
Subjects
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Business > Computer programs.
elektronické knihy
electronic books
Online AccessFull text
ISBN9781119067498
1119067499
9781119067504
1119067502
9781119067511
1119067510
Physical Description1 online resource

Cover

Table of 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.

Similar Items