John Walkenbach [2013, PDF, ENG]

Книги и журналы » Компьютерная литература » Программы от Microsoft

John Walkenbach - Microsoft Excel 2013 Bible

Год: 2013
Автор: John Walkenbach / Джон Уокенбах
Издательство: Wiley
ISBN: 978-1-118-49036-5
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 1059
Описание:

Excel at Excel with the help of this bestselling spreadsheet guide

John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.

Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.

Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013
Provides essential coverage of all the newest features of Excel 2013
Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
Features a website that includes downloadable templates and worksheets from the book
Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!
[spoiler="Оглавление"]
[spoiler="Краткое оглавление"]
Part I: Getting Started with Excel

Chapter 1: Introducing Excel
Chapter 2: Entering and Editing Worksheet Data
Chapter 3: Essential Worksheet Operations
Chapter 4: Working with Cells and Ranges
Chapter 5: Introducing Tables
Chapter 6: Worksheet Formatting
Chapter 7: Understanding Excel Files
Chapter 8: Using and Creating Templates
Chapter 9: Printing Your Work

Part II: Working with Formulas and Functions

Chapter 10: Introducing Formulas and Functions
Chapter 11: Creating Formulas That Manipulate Text
Chapter 12: Working with Dates and Times
Chapter 13: Creating Formulas That Count and Sum
Chapter 14: Creating Formulas That Look Up Values
Chapter 15: Creating Formulas for Financial Applications
Chapter 16: Miscellaneous Calculations
Chapter 17: Introducing Array Formulas
Chapter 18: Performing Magic with Array Formulas

Part III: Creating Charts and Graphics

Chapter 19: Getting Started Making Charts
Chapter 20: Learning Advanced Charting
Chapter 21: Visualizing Data Using Conditional Formatting
Chapter 22: Creating Sparkline Graphics
Chapter 23: Enhancing Your Work with Pictures and Drawings

Part IV: Using Advanced Excel Features

Chapter 24: Customizing the Excel User Interface...571
Chapter 25: Using Custom Number Formats
Chapter 26: Using Data Validation
Chapter 27: Creating and Using Worksheet Outlines
Chapter 28: Linking and Consolidating Worksheets
Chapter 29: Excel and the Internet
Chapter 30: Protecting Your Work
Chapter 31: Making Your Worksheets Error Free

Part V: Analyzing Data with Excel

Chapter 32: Importing and Cleaning Data
Chapter 33: Introducing Pivot Tables
Chapter 34: Analyzing Data with Pivot Tables
Chapter 35: Performing Spreadsheet What-If Analysis
Chapter 36: Analyzing Data Using Goal Seeking and Solver
Chapter 37: Analyzing Data with the Analysis ToolPak

Part VI: Programming Excel with VBA

Chapter 38: Introducing Visual Basic for Applications
Chapter 39: Creating Custom Worksheet Functions
Chapter 40: Creating UserForms
Chapter 41: Using UserForm Controls in a Worksheet
Chapter 42: Working with Excel Events
Chapter 43: VBA Examples
Chapter 44: Creating Custom Excel Add-Ins

Part VII: Appendixes

Appendix A: Worksheet Function Reference
Appendix B: Excel Shortcut Keys
[/spoiler]
Подробное оглавление можно найти на сайте издательства (PDF).
[/spoiler]
[spoiler="Постскриптум"]
Эта книга была издана в России.
"Excel 2013. Библия пользователя.", Издательство "Диалектика", 2014 год.

Буду благодарен, если кто-нибудь опубликует качественные сканы на рутрекере.
Ищу в электронном, либо бумажном виде!
[/spoiler]
P.S. Дружище, не забудь сказать "Спасибо"!