Office Computation with Excel Applications

- Chapter 1 Introduction and Home Row Keys for the Ten-Key Calculator
- Introduction
- What are these devices and their uses in offices?
- Ten-Key Calculator
- The Numeric Keypad
- Microsoft Excel
- What are the Advantages, Disadvantages, and Limitations of Each?
- Introduction to the Ten-Key Calculator
- What Is the Correct Finger Position for Each?
- Home Row Keys and Correct Finger Placement
- Touch Method and Home Row Key Indicator
- Correct Posture for Keying on the Ten-Key Calculator
- Preparing for Work
- Finger Placement
- Home Row Key Practice Exercise DrillsÔÇöTen-Key Calculator
- Fingers used for Other Keys
- Finger Position/Placement for 7, 8, and 9 Keys
- Finger Position for 1, 2, and 3 Keys and the 0, 00, and Decimal Keys
- Finger Position for Arithmetic Keys
- Ten-Key Speed Development Drills
- Chapter 2 Basic Math Functions and Operations for the Ten-Key Calculator
- Number Placement
- Finding Place Value of Whole Numbers
- Practice
- Find the Place Value of the Following Numbers
- Rounding Whole Numbers
- Practice
- Rounding Whole Numbers
- Fractions
- Parts of Fractions
- Types of Fractions
- Converting Fractions
- Decimals
- Rounding Numbers with Decimals
- Practice
- Rounding Decimal Numbers
- Addition
- Add-Mode
- Corrections
- Addition with Decimals (More Than Two Digits)
- Subtraction
- Subtraction with Decimals
- Corrections
- Credit Balances
- Other Functions Used with Addition and Subtraction on the Ten-Key Calculator
- Non-Add Key
- Subtotal Key
- Multiplication
- Multiplication with Decimals
- Percent Key
- Constant Multiplication
- Accumulative Multiplication
- Division
- Division with Decimals
- Constant Division
- Accumulative Division
- Conversions of Fractions to Decimals for Use in Math Problems
- Chapter 3 Home Row Key DrillsÔÇöNumeric Keypad on the Computer
- Introduction to the Ten-Key Calculator
- What Is the Correct Finger Position for Each?
- Home Row Keys and Correct Finger Placement
- Touch Method and Home Row Key Indicator
- Correct Posture for Keying on the Ten-Key Calculator
- Preparing for Work
- Finger Placement
- Home Row Key Practice Exercise DrillsÔÇöTen-Key Calculator
- Fingers Used for Other Keys
- Finger Position for 7, 8, 9, Division, and Multiplication Keys
- Finger Position for 1, 2, 3, Decimal, Plus, and Minus Keys
- Introduction to the Program Calculator
- Ten-Key Speed Development Drills
- Chapter 4 Basic Math Operations for the Numeric Keypad
- Number Placement, Decimals, and Rounding
- To Open the Computer Electronic Calculator
- Addition
- Corrections
- Addition with Decimals
- Subtraction
- Subtraction with Decimals
- Credit Balances
- Multiplication
- Multiplication with Decimals
- Percent Key
- Constant Multiplication
- Accumulative Multiplication
- Division
- Division with Decimals
- Constant Division
- Accumulative Division
- Chapter 5 Basic Math Calculations
- Rounding Numbers
- Converting a Fraction to a Decimal
- Proofreading Numbers
- Percentage Formula
- Discounts
- Markups
- Chapter 6 Basic Excel Concepts
- Ribbon
- Using Formulas in Excel
- Using Functions in Excel
- Using the AutoSum Function in Excel Spreadsheets
- Using the Average Function in Excel Spreadsheets
- Using the Maximum Function in Excel Spreadsheets
- Using the Minimum Function in Excel Spreadsheets
- Chapter 7 Business-Specific Topics
- Medical Office Administrative Assistants (MOAAs)
- Office Administrative Assistants
- Chapter 8 Basic Business Applications
- Installment Loans
- Insurance Premiums
- Straight-Line Depreciation
- Declining Balance Depreciation
- Example for Declining Depreciation Method
- First Year
- Second Year
- Third Year
- Fourth Year
- Fifth Year
- Chapter 9 Using Excel 2019 for Business Documents
- Invoices
- Inventory Valuation
- Income Statement
- Check Register
- Bank Statement Reconciliation
- Chapter 10 Assignments Johnson Realty Simulation
- Job Description
- Assignments
- Transaction 1
- Transaction 2
- Transaction 3
- Transaction 4
- Transaction 5
- Transaction 6
- Johnson Realty Quiz
- Chapter 11 Assignments Smith Family Care Simulation
- Job Description
- About the Medical Practice
- Transaction 1
- Transaction 2
- Transaction 3
- Transaction 4
- Transaction 5
- Transaction 6
- Transaction 7
- Transaction 8
- Smith Family Care Quiz