|
" MBA's guide to Microsoft Excel 2000 : "
Stephen L. Nelson.
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
949075
|
| Doc. No
|
:
|
b703445
|
| Main Entry
|
:
|
Nelson, Stephen L.,1959-
|
| Title & Author
|
:
|
MBA's guide to Microsoft Excel 2000 : : the essential Excel reference for business professionals /\ Stephen L. Nelson.
|
| Publication Statement
|
:
|
Redmond, WA :: Redmond Technology Press,, ©1999.
|
| Page. NO
|
:
|
xxv, 463 pages :: illustrations ;; 24 cm ++ 1 computer optical disc (4 3/4 in.)
|
| ISBN
|
:
|
0967298105
|
|
|
:
|
: 9780967298108
|
| Notes
|
:
|
Disc containers starter and sample workbooks.
|
|
|
:
|
Includes index.
|
| Contents
|
:
|
Amortization Inputs -- Fixed Interest Rate, Annuity Due Amortization Schedule -- Balloon Payment Schedule -- Understanding the Variable Rate, Ordinary Annuity Amortization Starter Workbook -- Variable Interest Rate Amortization Inputs -- Variable Interest Rate Amortization Schedule -- Balloon Payment Schedule -- Understanding the Variable Rate, Annuity Due Amortization Starter Workbook -- Variable Interest Rate, Annuity Due Amortization Inputs -- Variable Interest Rate, Annuity Due Amortization Schedule -- Balloon Payment Schedule -- Customizing the Debt Amortization Starter Workbooks -- Changing the Number of Periods -- Removing the Balloon Payment Schedule -- Adding Data Values -- Building Asset Depreciation Schedules -- EasyRefresher: Asset Depreciation -- Using the Asset Depreciation Starter Workbooks -- Understanding the Straight-Line Depreciation Starter Workbook -- Straight-Line Depreciation Calculation Inputs -- Straight-Line Depreciation Schedule -- Understanding the Declining Balance Depreciation Starter Workbook -- Declining Balance Depreciation Calculation Inputs -- Declining Balance Depreciation Schedule -- Understanding the Sum-of-the-Years'-Digits Depreciation Starter Workbook -- Sum-of-the-Years'-Digits Calculation Inputs -- Sum-of-the-Years'-Digits Depreciation Schedule -- Straight-Line Depreciation Schedule -- Excess Accelerated Depreciation Schedule -- Understanding the Annuity or Sinking Fund Depreciation Starter Workbook.
|
|
|
:
|
QuickPrimers -- QuickPrimer on Using Excel -- Starting Excel -- Working with the Excel Windows -- Creating a Simple Workbook -- Saving and Opening Workbooks -- Using File Properties -- Exiting the Program -- Using Formulas and Functions -- Entering Formulas -- Using Functions -- Naming Cells and Ranges -- Editing Workbook Data -- Erasing Cell Contents -- Undoing Mistakes -- Copying, Cutting, and Pasting -- Inserting and Deleting Cells, Rows, Columns, and Worksheets -- Using Find and Replace -- Checking Your Spelling -- Formating Workbooks -- Using a Predesigned Format -- Formatting Manually -- Printing Workbooks -- QuickPrimer on Charting -- Understanding Excel's Charting Terms -- How Excel Sees Chart Data -- Components of Excel Charts -- Presenting Data with Charts -- Using the Chart Wizard -- Choosing the Right Chart Type -- Customizing Your Charts -- Mapping Geographic Data -- Adding the Map Button to the Toolbar -- Creating a Data Map -- Customizing Your Data Maps -- Using Excel in Business -- Statistical Analysis -- EasyRefresher: Basic Business Statistics -- Statistical Formulas -- Average Absolute Deviation from the Mean (AVEDEV) -- Beta Probability Density -- Binomial Probability Distribution -- Chi-Square Distribution -- Confidence Intervals for Population Means (CONFIDENCE) -- Correlation -- Counting Cells -- Covariance (COVAR) -- Exponential Probability Distribution (EXPONDIST) -- Exponential Regression -- F Probability Distribution -- Fisher Transformation -- Frequency (FREQUENCY) -- Gamma Probability Distribution -- Geometric Mean (GEOMEAN) -- Harmonic Mean (HARMEAN) -- Hypergeometric Distribution (HYPGEOMDIST) -- Kurtosis (KURT) -- Linear Regression -- Lognormal Distribution Function -- Maximums and Minimums -- Mean -- Median (MEDIAN) -- Mode (MODE) -- Normal Probability Distribution -- Permutations (PERMUT) -- Poisson Random Variables (POISSON) -- Probability That Values Are Between Upper and Lower Limits (PROB) -- Rank and Percentile -- Skewness (SKEW) -- Standard Normal Probability Distribution -- Sum of Squares of Deviations from Mean (DEVSQ) -- Standard Deviation -- t Distribution -- Trimming to the Mean (TRIMMEAN) -- Variance -- Weibull Distribution (WEIBULL) -- Z-Test (ZTEST) -- Data Analysis Tools -- Analysis of Variance (ANOVA) -- Correlation -- Covariance -- Descriptive Statistics -- Exponential Smoothing -- F-Test -- Fourier Analysis -- Histogram -- Moving Averages -- Random Number Generation -- Rank and Percentile -- Regression -- Sampling -- T-Test -- Z-Test -- Financial Calculations -- EasyRefresher: Applying Time Value of Money Concepts -- Analyzing Borrowing -- Analyzing Investments -- Dealing with Inflation -- Using the Standard Financial Functions -- Using the Depreciation Functions -- Using the Payment Functions -- Using the Present Value, Future Value, and Interest Rate Functions -- Using the Add-In Financial Functions -- Using the Accrued Interest Add-In Functions -- Using the Bond Duration Add-In Functions -- Using the Capital Budgeting Add-In Functions -- Using the Coupon Dates Add-In Functions -- Using the Cumulative Interest and Principal Add-In Functions -- Using the Dollar Pricing Add-In Functions -- Using the French Depreciation Add-In Functions -- Using the Future Value Add-In Functions -- Using the Interest Rate Add-In Functions -- Using the Price and Yield Add-In Functions -- Using the Treasury Bill Add-In Functions -- Business Modeling -- What-If Analysis with Data Tables -- Working with One-Variable Data Tables -- Working with Two-Variable Data Tables -- What-If Analysis with Scenario Manager -- Creating a Scenario -- Using a Scenario -- Editing a Scenario -- Summarizing Scenarios -- Merging Scenarios from Other Workbooks -- Simple Modeling with Goal Seek -- Optimization Modeling with Solver -- EasyRefresher: How Optimization Modeling Works -- Solving an Optimization Problem -- Reviewing Solver Reports -- Customizing Solver's Operation -- Save Model and Load Model -- Understanding Solver Error Messages -- Sharing Workbooks -- Using OLE with Excel -- How OLE Works -- Creating an Embedded OLE Object -- Creating a Linked OLE Object -- Editing OLE Objects -- Inserting OLE Objects in Excel Workbooks -- Sharing Workbook Files -- Sharing Excel Workbooks with Other Programs -- Sharing Excel Workbooks Over a Network -- Sharing Excel Workbooks with E-Mail -- Workbook Sharing with E-Mail -- Using E-Mail Routing Slips -- Receiving a Routed Workbook -- Sharing Excel Data Over the Web -- Creating a Web Page Version of an Excel Workbook -- Creating an Interactive Spreadsheet Component -- Retrieving External Data with Excel -- Importing Textual Data into Excel -- Using the Get External Data Commands -- PivotTables and PivotCharts -- Using the PivotTable Wizard -- Specifying PivotTable Layout -- Editing PivotTables -- Pivoting -- Filtering Items in a Field -- Separating Data Between Pages -- Grouping PivotTable Data -- Creating PivotCharts -- Creating a PivotChart from an Existing PivotTable -- Creating a PivotChart Directly from a Database -- Small Business Financial Manager -- Installing and Starting the Small Business Financial Manager -- Importing Financial Data -- Importing Data for the First Time -- Working with the Report Wizard -- Reviewing the Report Wizard Reports -- Using the Report Wizard -- Using the Report Wizard's Reports -- Working with the Financial Analysis Tools -- Using the Business Comparison Report Tool -- Using the Buy Vs. Lease Tool -- Using the Create Projection Wizard Tool -- Using the Projection Reports Tool -- Using the What-If Analysis Tool -- Using the Chart Wizard -- Refreshing Imported Data -- Rearranging and Modifying Imported Data -- Using the Starter Workbooks -- Building a Business Planning Workbook -- EasyRefresher: Financial Statements and Ratios -- Using the Business Planning Starter Workbook -- Understanding the Starter Workbook's Calculations -- Forecasting Inputs -- Balance Sheet -- Common Size Balance Sheet -- Income Statement -- Common Size Income Statement -- Cash Flow Statement -- Financial Ratios Table -- Customizing the Starter Workbook -- Changing the Number of Periods -- Ratio Analysis on Existing Financial Statements -- Calculating Taxes for a Current Net Loss Before Taxes -- Combining This Workbook with Other Workbooks -- Building a Profit Volume and Break-Even Analysis Workbook -- EasyRefresher: Profit Volume and Break-Even Analysis -- Using the Profit Volume and Break-Even Analysis Starter Workbook -- Understanding the Starter Workbook's Calculations -- Break-Even Analysis Forecast -- Profit Volume Forecast -- Common Size Profit Volume Forecast -- Interpreting the Profit Volume Charts and Chart Data -- Customizing the Starter Workbook -- Changing the Number of Volumes Tested -- Removing Forecasts from the Starter Workbook -- Adding Minimums and Maximums to the Profit Volume Forecast -- Charting Profit Volume Analysis Data -- Using the Profit Volume Area Chart -- Using the Break-Even Line Chart -- Forecasting Sales and Cost of Sales -- EasyRefresher: Sales and Cost of Sales Forecasting -- Using the Sales Forecasting Starter Workbook -- Understanding the Starter Workbook's Calculations -- Sales Forecast Schedule -- Cost Totals and Statistics -- Sales and Gross Margin Forecast -- Inventory Forecast -- Customizing the Starter Workbook -- Building a Capital Budgeting Workbook -- EasyRefresher: Cash Flow Forecasting and Analysis -- Using the Cash Flow Forecast and Analysis Starter Workbook -- Understanding the Starter Workbook's Calculations -- Cash Flow Forecasting Inputs -- Profit and Loss Statement -- Gain and Loss Statement -- Operating Cash Flow Statement -- Liquidation Cash Flow Statement -- Cash Flow Analysis -- Pretax Cash Flow Scenarios -- After-Tax Cash Flow Scenarios -- Customizing the Starter Workbook -- Changing the Number of Forecasting Periods -- Removing the Pretax Profitability and Liquidity Measures -- Removing the After-Tax Profitability and Liquidity Measures -- Combining This Workbook with Other Workbooks -- Building Amortization Schedules -- EasyRefresher: Amortizing Debt -- Using the Debt Amortization Starter Workbooks -- Understanding the Fixed Rate, Ordinary Annuity Amortization Starter Workbook -- Fixed Interest Rate Amortization Inputs -- Fixed Interest Rate Amortization Schedule -- Balloon Payment Schedule -- Understanding the Fixed Rate, Annuity Due Amortization Starter Workbook -- Fixed Interest Rate, Annuity Due
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Electronic spreadsheets.
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Electronic spreadsheets.
|
| Subject
|
:
|
EXCEL 2000.
|
| Subject
|
:
|
Microsoft Excel (Computer file)
|
|
|
:
|
Microsoft Excel (Computer file)
|
| Dewey Classification
|
:
|
005.369
|
| LC Classification
|
:
|
HF5548.4.M523N45275 1999
|
| NLM classification
|
:
|
ST 371 E91rvk
|
| |