عنوان

MBA's guide to Microsoft Excel 2000 :

0967298105

9780967298108

b703445

MBA's guide to Microsoft Excel 2000 :

[Book]

the essential Excel reference for business professionals /

Stephen L. Nelson.

Redmond, WA :

Redmond Technology Press,

©1999.

xxv, 463 pages :

illustrations ;

24 cm +

1 computer optical disc (4 3/4 in.)

Disc containers starter and sample workbooks.

Includes index.

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

0

0

Microsoft Excel (Computer file)

Microsoft Excel (Computer file)

Business-- Computer programs.

Electronic spreadsheets.

Business-- Computer programs.

Electronic spreadsheets.

EXCEL 2000.

Nelson, Stephen L.,1959-

20201207185444.0

[Book]

Y