Wiley Excel 2013 Power Programming with VBA (2013).pdf
(
30073 KB
)
Pobierz
Excel
®
2013 Power Programming
with VBA
Table of Contents
Introduction
Topics Covered
What You Need to Know
What You Need to Have
Conventions in This Book
Excel commands
Visual Basic Editor commands
Keyboard conventions
Mouse conventions
What the Icons Mean
How This Book Is Organized
Part I: Some Essential Background
Part II: Understanding Visual Basic for Applications
Part III: Working with UserForms
Part IV: Advanced Programming Techniques
Part V: Developing Applications
Part VI: Other Topics
Part VII: Appendixes
About This Book's Website
About the Power Utility Pak Offer
How to Use This Book
Part I: Some Essential Background
Chapter 1: Excel in a Nutshell
About Excel
Thinking in Terms of Objects
Workbooks
Worksheets
Chart sheets
XLM macro sheets
Excel 5 and 95 dialog sheets
Excel's User Interface
About the Ribbon
Shortcut menus and the Mini toolbar
Dialog boxes
Task pane
Keyboard shortcuts
Data Entry
Formulas, Functions, and Names
Selecting Objects
Formatting
Protection Options
Protecting formulas from being overwritten
Protecting a workbook's structure
Applying password protection to a workbook
Protecting VBA code with a password
Charts
Shapes and SmartArt
Database Access
Worksheet databases
External databases
Internet Features
Analysis Tools
Add-Ins
Macros and Programming
File Format
Excel's Help System
Chapter 2: Formula Tricks and Techniques
About Formulas
Calculating Formulas
Cell and Range References
Why use references that aren't relative?
About R1C1 notation
Referencing other sheets or workbooks
Using Names
Naming cells and ranges
Applying names to existing references
Intersecting names
Naming columns and rows
Scoping names
Naming constants
Naming formulas
Naming objects
Formula Errors
Excel Auditing Tools
Identifying cells of a particular type
Viewing formulas
Tracing cell relationships
Tracing error values
Fixing circular reference errors
Using the background error-checking feature
Using Excel's Formula Evaluator
Array Formulas
An array formula example
An array formula calendar
Array formula pros and cons
Counting and Summing Techniques
Counting formula examples
Summing formula examples
Plik z chomika:
Ryjufka
Inne pliki z tego folderu:
VBA for Excel Made Simple(1).pdf
(6196 KB)
Wiley Excel 2013 Power Programming with VBA (2013)(1).pdf
(30073 KB)
VBA for Excel Made Simple.pdf
(6196 KB)
Wiley Excel 2013 Power Programming with VBA (2013).pdf
(30073 KB)
Inne foldery tego chomika:
C++
JAVA
PL SQL
Zgłoś jeśli
naruszono regulamin