Synopses & Reviews
Now readers can master the mathematical and spreadsheet skills most important to meet the demands of today's business world with the proven, practical dual approach in Burton/Shelton's BUSINESS MATH USING EXCEL, 2nd Edition. This book's unique presentation first teaches the traditional method of calculating and then presents the same math concepts using the functions of Microsoft Excel. The book's manageable sections, practical profiles and features and full-color design help readers build their math confidence and clearly see the practicality of what they're learning. Readers learn to create formulas and master the functions of the latest Excel 2010 while refining their high level math abilities and other skills that will help them succeed in the contemporary workplace.
Synopsis
Business Math Using Excel prepares users for the business world by incorporating math concepts using two approaches. The first approach uses the traditional method of calculating. The second approach teaches those same concepts using the functions of Excel. Today?s office workers are often challenged with Excel worksheets that include complex calculations that once were done using desktop calculators. Business Math Using Excel helps users create formulas and use the functions of Excel to make it the powerful application tool it is meant to be and to develop a high level of math skill.
About the Author
Sharon Burton is a professor in the Business Studies Division at Brookhaven College. In addition, she works in the Office of New Program Development, Dallas Community College District (DCCCD) in Farmer's Branch, Texas. Ms. Burton has more than 25 years of successful instructional experience in the community college environment. Most recently Ms. Burton has specialized in designing and teaching effective Internet courses, including business math, MS Office, and business writing. Ms. Burton earned her B.B.A. from Lamar University and her M.B.E. from University of North Texas. Nelda Shelton received her B.S. and M.B.E. degrees from the University of North Texas, Denton, Texas. She has taught full-time in the Business and Office Administration Departments of Tarrant County College, South Campus in Fort Worth, Texas. Ms. Shelton's teaching experience encompasses business math, business communications, office procedures, and introduction to accounting both in the classroom and distance learning via the Internet. She has worked part time for the U. S. Office of Personnel Management as a trainer and as an independent contractor. She has also served as a part-time instructor the Dallas County Community College District. Ms. Shelton has co-authored several successful texts in areas of business and office administration.
Table of Contents
Chapter 1. Basic Math Functions 1.1 Numbers 1.2 Addition 1.3 Subtraction 1.4 Multiplication 1.5 Division 1.6 Basic Math Operations and Excel Chapter 2. Fractions 2.1 Fractions and Mixed Numbers 2.2 Add and Subtract Fractions and Mixed Numbers 2.3 Multiply and Divide Fractions and Mixed Numbers Chapter 3. Percent 3.1 Introduction to Percents 3.2 Part, Rate, and Base 3.3 Percent of Increase and Decrease Chapter 4. Bank Services 4.1 The Checking Account 4.2 Bank Statement Reconciliation Chapter 5. Payroll 5.1 Gross Earnings 5.2 Gross Pay for Various Compensation Methods 5.3 Payroll Deductions 5.4 Employee's Earnings Record and Payroll Register Chapter 6. Taxes and Insurance 6.1 Property Tax and Property Tax Rate 6.2 State Unemplyment Tax, Federal Unemployment Tax, and Federal Income Tax 6.3 Health, Auto, Life, and Property Insurance Chapter 7. Purchasing Merchandise 7.1 The Purchasing Cycle 7.2 Cash Discounts 7.3 Trade Discounts 7.4 Series Discounts 7.5 Sales Tax Chapter 8. Markup and Markdown 8.1 Concepts Used in Pricing Merchandise 8.2 Selling Price 8.3 Markup Rate 8.4 Markdown Rate Chapter 9. Interest 9.1 Simple Interest 9.2 Notes and Interest Variables 9.3 Compound Interest Chapter 10. Consumer Credit and Mortgages 10.1 Open-End Credit 10.2 Closed-End Credit 10.3 Mortgage Loans Chapter 11. Annuities, Stocks, and Bonds 11.1 Annuities 11.2 Stocks 11.3 Bonds Chapter 12. Depreciation 12.1 Straight-Line Depreciation Method 12.2 Declining-Balance Method 12.3 Sum-of-the-Year's-Digits Method 12.4 Modified Accelerated Cost Recovery System (MACRS) Chapter 13. Financial Statements 13.1 Income Statement 13.2 Balance Sheet 13.3 Financial Ratios Chapter 14. Business Statistics 14.1 Measures of Central Tendency: Mean, Median, and Mode 14.2 Frequency Distributions and Graphs 14.3 Measures of Dispersion Student Progress Record Index