Excel for the Small Business Owner

Name: Excel for the Small Business Owner
Brand: Holy Macro! Books
Price: 12.99 EUR
Availability: OnlineOnly

P. K. Hari(Autor*in)

Holy Macro! Books (Verlag)

Erschienen am 1. Juli 2008

368 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-1-932802-61-0 (ISBN)

12,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Person

Inhalt

Front Cover
Table of Contents
Dedications
Acknowledgements
About the Author
Starting off on the Right Foot
Basic Terminology
Title Bar
Menu Bar
Active Cell
Toolbar Collections
Help Bar
Minimize / Maximize and Close Buttons
Task Pane / Task Selector
Rows and Columns
Formula Bar
Name Box
Scroll Bars
Tab Scrollers
Status Bar
Creating, Saving, Opening, and Closing Workbooks and Worksheets
Creating Workbooks
Saving Workbooks
Opening Workbooks
Closing Workbooks
Navigating in Excel - Within a Worksheet and Between Workbooks
Selecting Cells, Rows and Columns, Non-adjacent Cells
Other Keys in Used Navigation
Editing, Updating, and Deleting Data - Ways Available
Copying Data
Moving Data
Updating and Deleting Data
Formatting Cells
Sheet Background, Name, Hiding, and Unhiding
Entering Functions in Excel
Entering Formulas in Excel
Creating Charts - the Basics
Excel-lent Tips
Activating the Menus
Accessing the Toolbars with the Keyboard
Basic and Common Shortcut Keys
Shortcuts with the Ctrl Key Combination
Ctrl Key with Number Keys
Ctrl Key with Alphabet Keys
Ctrl Key with Special Keys
Ctrl Key with Function Keys
Shortcuts Using the Shift Key
Shift Key with Numeric Pad Keys
Shift Key with Function Keys and Other Keys
Shortcuts Using the Alt Key
Alt Key with Numeric Keys
Alt Key with Alphabet keys
Alt Key with Function Keys
Special Shortcut Keys
Shortcuts Using the Function Keys
Twenty Terrific Excel Tips
Links for More Tips
Best Keyboard Shortcuts for Selecting Data
Best Keyboard Shortcuts for Moving in a Workbook
Best Keyboard Shortcuts to Use with Functions and Formulas
Formulas, Functions, and More.
What Is a Formula and How Does It Work?
The Operator Precedence Rules
Relative vs. Absolute Referencing
Introducing Array Formulas
Common Error Messages in Formulas
How are Functions Different from Formulas?
What are the Categories and Components of Functions?
Financial Functions
Depreciation-related Functions
Annuity-/Investment-related Functions
Functions for Interest Computation
Examples
Depreciation Functions
Other Financial Functions
Date and Time Functions
Examples of Time-related Functions
Examples of Date-related Functions
Math, Trig, and Statistical Functions
Math and Trig functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Examples of Text Functions
Logical Functions
Practical Application of Logical Functions
Information Functions
Practical Application of Information Functions
Nesting Functions
Example of Multi-level Nesting
Troubleshooting and Evaluating Formulas and Functions
Conclusion
Data Management in Excel
Database Management - the Basics
Data Management Functions Available in Excel
Creating a Database
Manual Data Capture
Data Capture Using a Form
Sorting a Database
Steps in Data Sorting
Filtering Data - AutoFilter and Advanced Filter
AutoFilter
Advanced Filter
Scenario 1 - Filtering Data Based on One Condition
Scenario 2 - Filtering Data Based on Two Conditions
Scenario 3 - Filtering Data Based on Three Conditions
Scenario 4 - Filtering Data Based on Four Conditions
Subtotals, Grouping and Outlining
Grouping and Outlining
To outline the data automatically:
To outline the data manually:
Data Validation Feature
Converting Text to Columns / Importing Text Data
Sound Interesting?
Advanced Data Management in Excel
Database Functions - the Concept
Detailed Listing of Database Functions
Using Database Functions
DSUM Function
DSUM Based on a Single Criterion
DSUM Based on Multiple Conditions under the Same Field
DSUM Based on Conditions under Different Fields
DCOUNT Function
DCOUNT Based on a Single Criterion
DCOUNT Based on Multiple Conditions under Same Field
DCOUNT Based on Conditions under Different Fields
Other Functions
Working with Data Tables
Data Table Based on Two Variables
Creating and Managing Lists
Advantages of Using a List
Step-by-Step Process of Creating a List
Consolidation of Data
Consolidation Using 3D Formulas
Importing External Data
Handling XML data
More Terrific Links
PivotTables, PivotCharts, and Reporting
Introducing PivotTables
When Should You Use a PivotTable?
Creating a PivotTable
Filtering and Modifying Fields within a PivotTable
Sorting Data and Listing Specific PivotTable Items
Listing the Top / Bottom Items
Drill Down Facilities
Grouping and Ungrouping
Using Calculated Fields
Adding and Modifying Calculated Fields
Modifying and Deleting Calculated Fields
PivotTable Report Formatting Options
PivotTable Field Settings
Things You Should Know When Using PivotTables
Refreshing Data
Changing the Range of Source Data
Table Options
Show Pages
Creating a PivotChart
Links for More Information
Auditing Tools
Introducing Auditing Tools
Formula Auditing Toolbar
Error Checking Feature
The Rules and What They Check for
Other Buttons in the Error Checking Dialog Box
Tracing Precedents
Tracing Dependents
Removing Tracing Arrows
Trace Error Option
New Comment / Edit Comment Option
Circling Invalid Data
Clearing Validation Circles
Showing Watch Window
Evaluate Formula Option
Tips for Using Formula Evaluator
Tracking Changes Made to a Workbook
Viewing and Printing Formulas in Any Sheet
Example Using the Formulas Checkbox
Viewing and Printing Comments and Errors
Controlling the Printing of Comments
Controlling the Printing of Cell Errors
Related Links
Formatting and Printing Reports
Print Preview Options and Zooming
Controlling Print Selection, Page, Cells, and Copies
Selecting Pages to Print
Controlling Print Copies
Printing to a File
Setting, Removing Page Breaks
Page Break Preview
Print Area - Setting, Clearing
Page Control - Orientation, Size, Scaling, Quality
Alignment Control - Margins, Centering Report
Headers and Footers, First Page Numbers
Controlling Sheet Properties During Printing
Printing Charts
Four More Topics
Massive Printing of Blank Pages
Pages per Sheet Option
Printing to PDF
Copying Page Setup Options Between Different Sheets
For Further Study
Adding Interactivity and Publishing Reports on the Web
Saving as a Web Page
Publishing an Entire Workbook on a Web Page
Publishing One Worksheet / Range / Other Items
Publishing a Chart on a Web page
Publishing a PivotTable Report on a Web Page
Further Information(
An Introduction to VBA
What Is a Macro and What Is It Used for?
Recording a Macro - the Toolkit
Writing a Macro - the VBE Window
Running a Macro
Other Advanced Topics and Links
Case Studies
Peter F. Drucker's Advice to CEOs
Duties of the CEO
Key Decision Making Points
OK, But Where Does Excel Come in?
Reviewing Projects and Their Profitability
Checking Delivery Schedules Using Gantt Charts
Comparing Excel Worksheets/Workbooks
Comparison Process
Financial Analysis Models - Creation and Automation
Having Your Own Menu Bar
Control Reports Using PivotTables
Step-by-Step Construction of the Control PivotTable
Using Conditional Statements for Reporting
Controlling Entry of Dates - the Dating Problem!
Some Interesting Examples
Using Word Count in Excel
Showing Formulas in Different Color
Deleting Empty Worksheets
Sorting All Sheets by Name
Forcing Caps on Entry
Deleting Every nth Row
Merging Data of Multiple Columns into One Column
Merging the Selection into One Cell
Inserting a Blank Row Between Every Row of Data
Coloring Alternate Rows with a Distinct Shade
Using VBA to Print Your File to PDF
Goal Seek and Scenario Builder
Using Goal Seek
Using Scenario Builder
Other New Techniques and Developments
Dashboard Charting Techniques
New Techniques with PivotTables
New Techniques with Charting
Resources and Examples for the Finance People
Other Interesting Developments
One Journey Ends - Another Begins
A Word of Conclusion
Appendix A - Finding and Launching Excel
Where to Find Excel
Appendix B - Excel's Roots
How Did It All Start - Weaving the Excel Magic
Index
Back Cover

Systemvoraussetzungen

Als PDF speichern Als Link merken